报错上说 Oracle cannot be resolved to a type,求高人指点代码如下:第四行的 new oracle 处报的错
public class lianjie {
public Connection getConnection(){
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
java.sql.DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url="jdbc:subProtocol:subName://localhost:8080;DatabaseName=s4";
Connection conn=java.sql.DriverManager.getConnection(url,"t4","t4");
return conn;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
}
}
public class lianjie {
public Connection getConnection(){
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
java.sql.DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url="jdbc:subProtocol:subName://localhost:8080;DatabaseName=s4";
Connection conn=java.sql.DriverManager.getConnection(url,"t4","t4");
return conn;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
}
}
==================================
1)jar包里面有这个驱动类吗?,点进去找到了吗?
2)这个驱动是这个版本的Oracle的吗?
3)数据库是在你本机,"t4","t4",确定可以登陆进去吗?
java.sql.DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
为什么注册两次驱动?
确实不对,格式完全不对jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL要这种格式才对啊
一般这样写的: Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String name = "name";
String pwd = "pwd";
Connection con=DriverManager.getConnection(url,name,pwd);
去掉试试
java.sql.DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());