UC知道在myeclipse中用JDBC连Oracle的问题！急！
来源：百度知道 编辑：UC知道 时间：2024/05/09 20:11:01
已经将classes12导入了（－>build path－>add external archives－>导入了classes12.jar。）
程序入下：package JDBC;
import java.sql.*;
import java.util.*;
public class jdbc1 {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
String className ="oracle.jdbc.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:Y2J";
String user = "Y2J";
String password = "111111";
Connection conn = null;
try{
Class.forName(className);
conn = DriverManager.getConnection(url,user,password);
Statement st =conn.createStatement();
String sql = "select * from STUDENT";
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
System.out.println("id="+rs.getInt("A"));
}
}catch(Exception e){
System.out.println(e.getMessage());
程序入下：package JDBC;
import java.sql.*;
import java.util.*;
public class jdbc1 {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
String className ="oracle.jdbc.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:Y2J";
String user = "Y2J";
String password = "111111";
Connection conn = null;
try{
Class.forName(className);
conn = DriverManager.getConnection(url,user,password);
Statement st =conn.createStatement();
String sql = "select * from STUDENT";
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
System.out.println("id="+rs.getInt("A"));
}
}catch(Exception e){
System.out.println(e.getMessage());
String className ="oracle.jdbc.OracleDriver";
明显错误
建议：localhost换成具体IP地址
2、确认操作系统是否正确安装数据库驱动，可用改机器其它数据库工具连接测试是否能成功连接
你的classname写错了 应该是oracle.jdbc.driver.OracleDriver
确认驱动名，地址名，用户名，密码的写法。
把驱动名改正确后还有异常么？