UC知道MyEclipse与Oracle的JDBC连接问题
来源：百度知道 编辑：UC知道 时间：2024/05/27 20:00:53
源程序：
package emp;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBCTest {
public static void main(String[] args) {
try {
Class.forName("Oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
Connection conn = DriverManager.getConnection(url, "scott",
"tiger");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from dept");
while (rs.next()) {
System.out.print("deptNO: " + rs.getInt(1));
System.out.print("\tDeptName: " + rs.getString(2));
System.out.print("\tLoc: " + rs.getString(3));
rs.close();
stmt.close();
conn.close();
}
}
package emp;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBCTest {
public static void main(String[] args) {
try {
Class.forName("Oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
Connection conn = DriverManager.getConnection(url, "scott",
"tiger");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from dept");
while (rs.next()) {
System.out.print("deptNO: " + rs.getInt(1));
System.out.print("\tDeptName: " + rs.getString(2));
System.out.print("\tLoc: " + rs.getString(3));
rs.close();
stmt.close();
conn.close();
}
}
貌似仁兄的 Class.forName("Oracle.jdbc.driver.OracleDriver");
第一个Oracle的以大写开头了，应该小写。
导入classes12.jar包试试看。
另外，
把String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
换成String url = "jdbc:oracle:thin:@localhost:1521:orcl";
这个写法上应该没问题，估计是jar包问题。
楼主把加载驱动的那句改成Class.forName("oracle.jdbc.driver.OracleDriver");试试；你原先的那句话把“oracle”给大写了。
你把.jar文件放在那里了?