大家好,我以前连接过SQL SERVER数据库,现在转ORACLE了,该怎么做 以前是将JDBC FOR SQL SERVER驱动放入TOMCAT的LIB目录中但转到ORACLE了,该如何做呢,第一步,还有请朋友们贴一段CONN的代码,感谢,呵可 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 一模一样的啊,把ojbdc14.jar或者其它驱动包放到你以前放置sql server驱动的地方,反正能找到驱动类就可以了 请问这个ojbdc14.jar文件在哪里下载,最新版本是多少,感谢 http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html我用的是JDK 1.5,里面全是1.4啊,我应该下载哪个,感谢 我用g:\oracle\ora90\jdbc\lib中的classes12.zip可以吗,是驱动吗, 可以,只是里面的JDBC接口旧一些,不过不影响使用,主要是有些接口没被实现,普通的操作足够用了 JDBC驱动在官方网站能下到,用Oracle9i或者10g的安装目录下的东西就可以了 <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%><%@ page import="java.sql.*"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Insert title here</title> </head> <body> <% try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url = "jdbc:oracle:thin:@localhost:1521:orcl"; String user = "system"; String password = "ghyghost"; Connection conn; conn = DriverManager.getConnection(url, user, password); Statement stmt; stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = "select * from system.first"; ResultSet rs = stmt.executeQuery(sql); System.out.println("value is :"); System.out.println(rs.getString(2)); conn.close(); } catch (Exception e) { System.out.println(e.getMessage()); } %> </body></html>------------------------------------Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))出错,怎么办? 找到答案了。<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%><%@ page import="java.sql.*"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Insert title here</title> </head> <body> <% try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url = "jdbc:oracle:thin:@localhost:1521:ghyghost"; String user = "system"; String password = "ghyghost"; Connection conn; conn = DriverManager.getConnection(url, user, password); Statement stmt; stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sql = "select * from first"; ResultSet rs = stmt.executeQuery(sql); rs.next(); System.out.println("value is :"); System.out.println(rs.getString(1)); conn.close(); } catch (Exception e) { System.out.println(e.getMessage()); } %> </body></html>改成上面的即可,,主要是: String url = "jdbc:oracle:thin:@localhost:1521:ghyghost";的改动和加了rs.next()这条语句,但如果不加这条语句,则莫名其妙输出一些乱七八糟的文字,,这点我感觉 没有SQL SERVER驱动好,,SQL SERVER如果没有NEXT()语句时,会提示你操作位置出错的信息。 java中YUV420转换为RGB525怎么修改呢? 缓存 java 求从数据库查询出表的结果,显示到JSP页面上的一段JAVA代码,多谢 怎样把java代码转为exe文件,谢谢 写java程序时..怎么用相对路径啊? 写入文件时..PrintWriter 为什么写不进的呢 做JAVA的说得俗一点就是用JSP做网站,还谈什么????? java怎样给一个int类型直接用二进制赋值? 编码转换问题 怎么从一个文件中内容写入到另一个文件 执行出错问题
我用的是JDK 1.5,里面全是1.4啊,我应该下载哪个,感谢
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:orcl"; String user = "system";
String password = "ghyghost";
Connection conn;
conn = DriverManager.getConnection(url, user, password); Statement stmt; stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE); String sql = "select * from system.first";
ResultSet rs = stmt.executeQuery(sql);
System.out.println("value is :");
System.out.println(rs.getString(2));
conn.close();
} catch (Exception e) {
System.out.println(e.getMessage());
}
%>
</body>
</html>
------------------------------------
Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
出错,怎么办?
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:ghyghost"; String user = "system";
String password = "ghyghost";
Connection conn;
conn = DriverManager.getConnection(url, user, password); Statement stmt; stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE); String sql = "select * from first";
ResultSet rs = stmt.executeQuery(sql);
rs.next();
System.out.println("value is :");
System.out.println(rs.getString(1));
conn.close();
} catch (Exception e) {
System.out.println(e.getMessage());
}
%>
</body>
</html>
改成上面的即可,,主要是: String url = "jdbc:oracle:thin:@localhost:1521:ghyghost";的改动和加了rs.next()这条语句,
但如果不加这条语句,则莫名其妙输出一些乱七八糟的文字,,这点我感觉 没有SQL SERVER驱动好,,SQL SERVER如果没有NEXT()语句时,会提示你操作位置出错的信息。