我的系统:windows xp(sp2)
sdk: jsdk1.4.2_10,环境变量已设好
IDE:eclipse
jdbc驱动是:ojdbc14.jar
我的源代码:
public class DataOracle { public static void main(String[] args) {
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle.thin:@" + "127.0.0.1" + ":" + "2030" + ":" +
"ora92";
String username = "scott";
String password = "tiger";
showEmployeeTable(driver,url,username,password);
}
public static void showEmployeeTable(String driver,
String url,
String username,
String password){
try{
Class.forName(driver);
Connection connection =
DriverManager.getConnection(url,username,password);
System.out.println("Employees\n" + "=========");
Statement statement = connection.createStatement();
String query =
"SELECT * FROM emp";
ResultSet resultSet = statement.executeQuery(query);
while(resultSet.next()){
System.out.print(resultSet.getString("EMPNO") + " ");
System.out.println(resultSet.getString("JOB"));
}
connection.close();
}catch(ClassNotFoundException cnfe){
System.err.println("Error loading driver: " +cnfe);
}catch(SQLException sqle){
System.err.println("Error with connection: " + sqle);
}
}
}
驱动能注册成功,但在连接时出错,显示错误是:
Error with connection: java.sql.SQLException: No suitable driver
sdk: jsdk1.4.2_10,环境变量已设好
IDE:eclipse
jdbc驱动是:ojdbc14.jar
我的源代码:
public class DataOracle { public static void main(String[] args) {
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle.thin:@" + "127.0.0.1" + ":" + "2030" + ":" +
"ora92";
String username = "scott";
String password = "tiger";
showEmployeeTable(driver,url,username,password);
}
public static void showEmployeeTable(String driver,
String url,
String username,
String password){
try{
Class.forName(driver);
Connection connection =
DriverManager.getConnection(url,username,password);
System.out.println("Employees\n" + "=========");
Statement statement = connection.createStatement();
String query =
"SELECT * FROM emp";
ResultSet resultSet = statement.executeQuery(query);
while(resultSet.next()){
System.out.print(resultSet.getString("EMPNO") + " ");
System.out.println(resultSet.getString("JOB"));
}
connection.close();
}catch(ClassNotFoundException cnfe){
System.err.println("Error loading driver: " +cnfe);
}catch(SQLException sqle){
System.err.println("Error with connection: " + sqle);
}
}
}
驱动能注册成功,但在连接时出错,显示错误是:
Error with connection: java.sql.SQLException: No suitable driver
^ 这里应是 ':'
你还是用oracle.jdbc.OracleDriver这个驱动吧
scott用户只要不是锁定就行,查自己的表不需要特意设权限
默认端口1521
检查一下以上
端口号我查了我的是2030。
我又单步调试了一下,发现能注册驱动,但在执行连接语句
DriverManager.getConnection(url,username,password);时就执行不下去了,也没有报错,
就停在这句语句了。
请大家帮帮忙!