Question

java中连接数据库遇到的问题，求大神帮助啊，我的幸福~

import java.sql.*;

public class forName {
public static void main(String args[]){
Connection conn=null;
Statement state=null;
try{
System.out.println("ss");
Class.forName("oracle.jdbc.OracleDriver").newInstance();
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","oracle");
state=conn.createStatement();
ResultSet result=state.executeQuery("SELECT user,sysdate from dual");
result.next();
String user=result.getString("user");
Timestamp dateTime=result.getTimestamp("sysdate");
System.out.println("hi"+user+",the current date and time is " +dateTime);
result.close();
}
catch(SQLException e){
System.out.println("E "+e.getErrorCode());
System.out.println("E "+e.getMessage());

}
finally{
try{
if(state!=null){
state.close();
}
if(conn!=null){
conn.close();
}
}
catch(SQLException e){
System.out.println("E "+e.getErrorCode());
System.out.println("E "+e.getMessage());
}
}
}
}

Class.forName("oracle.jdbc.OracleDriver").newInstance(); 这句一直有红色下划线
回答对了追加分

Answer 1

你用drivermanager加载驱动试一下；
Drimanager.registerDriver(new oracle.jdbc.OracleDriver())