我以经把sqljdbc.jar 文件复制到\jre1.6.0_03\lib\ext 目录下了 连接是的sql server 2005
但运行下面的程序public class Test {
public static void main(String[] srg) {
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";//加载JDBC驱动
String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=java ";//连接服务器和数据库sample
String userName = "sa"; //默认用户名
String userPwd = "123456 "; //密码
Connection dbConn;
try {
Class.forName(driverName);
} catch (ClassNotFoundException ex) {
System.err.println(ex);
}
try { dbConn=DriverManager.getConnection( dbURL,"sa","");
System.out.println( "成功 "); } catch (Exception e) {
System.err.println(e);
}
}
}
出现异常
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriverjava.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;DatabaseName=java
这是怎么回事啊?
但运行下面的程序public class Test {
public static void main(String[] srg) {
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";//加载JDBC驱动
String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=java ";//连接服务器和数据库sample
String userName = "sa"; //默认用户名
String userPwd = "123456 "; //密码
Connection dbConn;
try {
Class.forName(driverName);
} catch (ClassNotFoundException ex) {
System.err.println(ex);
}
try { dbConn=DriverManager.getConnection( dbURL,"sa","");
System.out.println( "成功 "); } catch (Exception e) {
System.err.println(e);
}
}
}
出现异常
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriverjava.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;DatabaseName=java
这是怎么回事啊?
java -cp .;XXXXXX\jre1.6.0_03\lib\ext\sqljdbc.jar Test或者在系统的环境变量里,把它加到 CLASSPATH 里面