netbeans+oracle 加载驱动失败
大家帮个忙,我在使用netbeans 6.5 做j2se连接数据库oracle的时候,加载驱动的时候总是出现加载驱动失败,
具体如下:No suitable driver found for jdbc:oracle:thin:@localhost:1521:classdb
用editplus做了个测试程序测试用oracle.jdbc.driver.OracleDriver和jdbc:oracle:thin:@localhost:1521:classdb
能连接oracle。但在netbean中老是提示加载驱动失败。
我在“服务/数据库/驱动程序”成功连接上了Oracle(能看到数据库中的表)。
程序:
import java.sql.*;
public class Db {
public Connection conn=null;
public ResultSet rs=null;
private String DatabaseDriver="oracle.jdbc.driver.OracleDriver";
//DataSource 数据源名称DSN
private String url="jdbc:oracle:thin:@localhost:1521:classdb";
public Db(int i,String stu_xh)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(java.lang.ClassNotFoundException e){
System.err.println("加载驱动器有错误:"+e.getMessage( ));
}
switch(i)
{
case 1:
infoQuery(stu_xh);
break;
case 2:
scoreQuery(stu_xh);
break;
/* case 3:
infoModify(stu_xh);
break;
case 4:
scoreModify(stu_xh);
break;*/
}
}
public Db() {
try{
Class.forName(DatabaseDriver);
}catch(java.lang.ClassNotFoundException e){
System.err.println("加载驱动器有错误:"+e.getMessage( ));
}
}
private void CloseDataBase() {
try{
conn.close();
} catch(Exception end){
System.err.println("执行关闭Connection对象有错误:"+end.getMessage( ) );
}
}
//学生信息查询
public void infoQuery(String stu_xh) {
try{
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:classdb","Alex","zzs");
Statement stmt=conn.createStatement();
String sql="select xh,xm,xb,cssj,zy,zxf from xs where xh='"+stu_xh+"'";
rs=stmt.executeQuery(sql);
StudentInfo si=new StudentInfo(rs);
} catch(SQLException ex){
System.err.println(ex.getMessage() );
}
CloseDataBase();
}
//学生成绩查询
public void scoreQuery(String stu_xh) {
try{
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:classdb","Alex","zzs");
Statement stmt=conn.createStatement( );
String sql="select xm,kcm,cj from xs,kc,xs_kc where xs.xh=xs_kc.xh and xs_kc.kch=kc.kch and xs.xh='"+stu_xh+"'";//
stmt.executeQuery(sql);
} catch(SQLException ex){
System.err.println(ex.getMessage() );
}
CloseDataBase();
}
//学生信息修改
public void infoModify(String stu_xh,String modify_xh,String modify_xm,String modify_zym,String modify_xb,String modify_cssj,int modify_zxf,String modify_bz) {
try{
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:classdb","Alex","zzs");
Statement stmt=conn.createStatement( );
String sql="update xs set xh=modify_xh,xm=modify_xm,zym=modify_zym,xb=modify_xb,cssj=modify_cssj,zxf=modify_zxf,bz=modify_bz where xh='"+stu_xh+"' ";
stmt.executeUpdate(sql);
} catch(SQLException ex){
System.err.println(ex.getMessage() );
}
CloseDataBase();
}
//学生成绩录入
public void scoreModify(String stu_xh,String inputValue) {
try{
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:classdb","Alex","zzs");
Statement stmt=conn.createStatement( );
String sql="update xs_kc set cj=to_date('"+inputValue+"') where xh='"+stu_xh+"'";
stmt.executeUpdate(sql);
} catch(SQLException ex){
System.err.println(ex.getMessage() );
}
CloseDataBase();
}
public ResultSet query(String stu_xh){
try{
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:classdb","Alex","zzs");
Statement stmt=conn.createStatement();
String sql="select xh,xm,xb,cssj,zy,zxf from xs and xh='"+stu_xh+"'";
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println(ex.getMessage() );
}
CloseDataBase();
return rs;
}
}