连接数据库出现No suitable driver怎么办?
sqlserver_db.java(javaBean)
package sqlserver;
import java.sql.*;
public class sqlserver_db{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:SQLServer_test";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
public void sqlserver_db(){
try{
Class.forName(sDBDriver);
System.out.println("success");
}
catch(java.lang.ClassNotFoundException e){
System.err.println("Class sqlserver_db not found!"+e.getMessage());
}
}
public ResultSet executeQuery(String sql){
rs = null;
try{
conn = DriverManager.getConnection(sConnStr,"sa","");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql){
try
{
conn = DriverManager.getConnection(sConnStr,"sa","");
stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("aq.executeUpdate:"+ex.getMessage());
}
}
}
//调用javaBean
//test_diaoyong.java
package sqlserver;
import java.sql.*;
import java.io.*;
public class test_diaoyong{
public test_diaoyong(){}
public static void main(String args[]){
try{
System.out.println("success");
sqlserver_db test = new sqlserver_db() ;
ResultSet rs = test.executeQuery("select * from user_info ");
while(rs.next()){
System.out.println("TestName:"+rs.getString("name"));
}
rs.close();
System.out.println("success");
}
catch(Exception ex) {
System.err.println(ex.getMessage());
}
}
}
希望诸位高人指点迷津,感激中..........