我是一只小菜,初学java,近日突然想试试在类里调用SQL server2005 JDBC,JDBC驱动是在http://www.microsoft.com/downloads/details.aspx?FamilyID=E22BC83B-32FF-4474-A44A-22B6AE2C4E17&displaylang=zh-cn下的,安装后里面就一个jar包(sqljdbc.jar),可看别人说的都是3个包(Msbase.jar,Msutil.jar,Mssqlserver.jar ),此偶之纳闷1。偶愚笨,写的java类如下
import java.io.*;
import java.sql.*;
import java.lang.*;
import com.microsoft.sqlserver.jdbc.SQLServerDriver;public class Test {
private static void print(){
System.out.println("Start!!");
DB();
System.out.println("End!!");
}
public static void main(String[] args) {
print();
}
public static void DB(){
try{
Connection con;
Statement stmt;
ResultSet rs; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();  
System.out.println("driver is ok"); String dbUrl="microsoft:sqlserver:jdbc://localhost:1433;DatabaseName =JC";
String dbUser="sa";
String dbPwd="nex00@dhc"; con=DriverManager.getConnection(dbUrl,dbUser,dbPwd);
System.out.println("conection is ok"); stmt=con.createStatement();
stmt.executeUpdate("INSERT INTO books(id,name,title,price)Values('999','Tom','Tomcat',''44.5)");
rs=stmt.executeQuery("SELECT id,name,title,price from books");
System.out.println("OK");
while(rs.next()){
String col1=rs.getString(1);
String col2=rs.getString(2);
String col3=rs.getString(3);
String col4=rs.getString(4);
System.out.println("--"+col1+"--"+col2+"--"+col3+"--"+col4+"--");
} stmt.executeUpdate("DELETE FROM books WHERE id='999'"); rs.close();
stmt.close();
con.close();
}
catch(ClassNotFoundException e){
System.out.println(e.getMessage());
}
catch(Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}
一运行到con=DriverManager.getConnection(dbUrl,dbUser,dbPwd);,提示错误如下:
Start!!
driver is ok
No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Test.DB(Test.java:73)
at Test.print(Test.java:54)
at Test.main(Test.java:58)
偶是小菜,8鸡到咋么解决了。恳求各位前辈指教!!!!!!谢谢,谢谢啦!