一个关于JBuilder连接SQL问题!
蓝色流星 2006-02-27 02:09:30 我的数据库是SQL Server 2000+sp4;操作系统是xp sp2;
在jbuilder9下连接数据库
import java.sql.*;
public class DataClass {
public static void main(String[] args) {
String Drivername="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL="jdbc:microsoft.sqlServer://localhost:1433;DataName=card";
String UserName="sa";
String PassWord="";
Connection SqlCon;
try{
Class.forName(Drivername);
SqlCon = DriverManager.getConnection(dbURL,UserName,PassWord);
System.out.println("success connection");
}catch(Exception e){e.printStackTrace();}
}
}
运行后:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at data.DataClass.main(DataClass.java:14)
请前辈指教!谢谢!