先上源码:import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
public class DBHW {
public static void main(String[] args) {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException e) {}
try {
String url = "jdbc:Oracle:thin:@localhost:1158:orcl";
Connection con = DriverManager.getConnection(url,"scott","qyh");
Statement stmt =con.createStatement();
ResultSet rs=stmt.executeQuery("select * from STUDENT");
while(rs.next()){
System.out.println(rs.getString(1)+" "+rs.getString(2) +" "+rs.getFloat(3)+""+rs.getString(4)+""+rs.getString(5)+""+rs.getString(6)); }
rs.close();
stmt.close();
} catch (SQLException ex) {
Logger.getLogger(DBHW.class.getName()).log(Level.SEVERE, null, ex);
}
}}
抛出了No suitable driver found for jdbc异常。
数据库服务已经启动。
Database Contro - orcl 的地址显示的是https://qyh-PC:1158/em所以我端口用的是1158
这个异常是什么问题呢?是没有引入什么包还是说我的端口找的不对?还是别的什么,愁死我了。google半天啥也没找到。帮帮忙吧
import java.util.logging.Level;
import java.util.logging.Logger;
public class DBHW {
public static void main(String[] args) {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException e) {}
try {
String url = "jdbc:Oracle:thin:@localhost:1158:orcl";
Connection con = DriverManager.getConnection(url,"scott","qyh");
Statement stmt =con.createStatement();
ResultSet rs=stmt.executeQuery("select * from STUDENT");
while(rs.next()){
System.out.println(rs.getString(1)+" "+rs.getString(2) +" "+rs.getFloat(3)+""+rs.getString(4)+""+rs.getString(5)+""+rs.getString(6)); }
rs.close();
stmt.close();
} catch (SQLException ex) {
Logger.getLogger(DBHW.class.getName()).log(Level.SEVERE, null, ex);
}
}}
抛出了No suitable driver found for jdbc异常。
数据库服务已经启动。
Database Contro - orcl 的地址显示的是https://qyh-PC:1158/em所以我端口用的是1158
这个异常是什么问题呢?是没有引入什么包还是说我的端口找的不对?还是别的什么,愁死我了。google半天啥也没找到。帮帮忙吧
还有你导入驱动包了没有??不要导入错了