这是我简单写的程序
import java.sql.*;
public class oracleTest { /**
* @param args
*/
public oracleTest(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(Exception e){
e.printStackTrace();
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
String strSQL="select * from users";
try{
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.4:1521:student", "system", "system");
Statement stm=con.createStatement();
ResultSet rs=stm.executeQuery(strSQL);
while(rs.next()){
System.out.print(rs.getString(1));
}
}
catch(Exception e){
e.printStackTrace();
}
}}
这是提示的错误
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at oracleTest.main(oracleTest.java:20)
提示这个错误是什么意思啊 ?????
import java.sql.*;
public class oracleTest { /**
* @param args
*/
public oracleTest(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(Exception e){
e.printStackTrace();
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
String strSQL="select * from users";
try{
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.4:1521:student", "system", "system");
Statement stm=con.createStatement();
ResultSet rs=stm.executeQuery(strSQL);
while(rs.next()){
System.out.print(rs.getString(1));
}
}
catch(Exception e){
e.printStackTrace();
}
}}
这是提示的错误
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at oracleTest.main(oracleTest.java:20)
提示这个错误是什么意思啊 ?????
if(ClassPath添加了驱动包){
System.out.println("Sorry~i can‘t help you! ")
}
else{
方法1:将这个包添加到你的环境变量中去,或者在ide中导入!
}
}
else{
方法2:去下载oracle对应的jdbc驱动包!
}
//Oracle 10g 下的路径是:×:\oracle\product\10.1.0\Db_1\jdbc\lib\classes12.jar路过,接分。
)就没有执行,在main 函数中 得到连接前加入 oracleTest ot = new oracleTest ();
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at oracleTest.main(oracleTest.java:20)郁闷!!!
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.4:1521:student", "system", "system"); 这句话引起的,看看数据库启动没,数据库服务器的地址和端口对不对。而且你为什么没有关闭连接,可能运行几次就会有问题。