java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at QueryRecord.<init>(QueryRecord.java:12) at QueryRecord.main(QueryRecord.java:48) java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlsever://localhost:1433/db_test at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at QueryRecord.showRecord(QueryRecord.java:22) at QueryRecord.main(QueryRecord.java:49) Exception in thread "main" java.lang.NullPointerException at QueryRecord.showRecord(QueryRecord.java:39) at QueryRecord.main(QueryRecord.java:49) 刷新了以后报这个错误有没有人知道是什么意思?我驱动文件已经导进去了。
刚才发错了,是这个错误: java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlsever://localhost:1433/db_test at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at QueryRecord.showRecord(QueryRecord.java:22) at QueryRecord.main(QueryRecord.java:49) Exception in thread "main" java.lang.NullPointerException at QueryRecord.showRecord(QueryRecord.java:39) at QueryRecord.main(QueryRecord.java:49) 提示说这两个代码有问题:conn=DriverManager.getConnection(url,username,password); rs.close();
我照你说的改过了还报这个错误: com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at QueryRecord.showRecord(QueryRecord.java:22) at QueryRecord.main(QueryRecord.java:49) Exception in thread "main" java.lang.NullPointerException at QueryRecord.showRecord(QueryRecord.java:39) at QueryRecord.main(QueryRecord.java:49)
然后在Java程序中用URL字符串如“jdbc:odbc:sample”连数据库。因为ODBC桥是Java内置,连加载Driver类都不需要了。方便啊,嘎嘎。
然后写连接类
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at QueryRecord.<init>(QueryRecord.java:12)
at QueryRecord.main(QueryRecord.java:48)
java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlsever://localhost:1433/db_test
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at QueryRecord.showRecord(QueryRecord.java:22)
at QueryRecord.main(QueryRecord.java:49)
Exception in thread "main" java.lang.NullPointerException
at QueryRecord.showRecord(QueryRecord.java:39)
at QueryRecord.main(QueryRecord.java:49)
刷新了以后报这个错误有没有人知道是什么意思?我驱动文件已经导进去了。
java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlsever://localhost:1433/db_test
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at QueryRecord.showRecord(QueryRecord.java:22)
at QueryRecord.main(QueryRecord.java:49)
Exception in thread "main" java.lang.NullPointerException
at QueryRecord.showRecord(QueryRecord.java:39)
at QueryRecord.main(QueryRecord.java:49)
提示说这两个代码有问题:conn=DriverManager.getConnection(url,username,password);
rs.close();
jdbc:sqlserver://localhost:1437;databaseName=数据库名
com.microsoft.sqlserver.jdbc.SQLServerDriver
就可以了
//数据库驱动加载
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} //数据库连接
//数据库所开的默认端口是1433 dataname=数据库的名字
String url="jdbc:sqlserver://localhost:1433;databaseName=student";
//sa sa表示sqlserver 登陆的时候的用户名和密码 这个可以自己随意设置密码
Connection con=DriverManager.getConnection(url,"sa","sa");
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at QueryRecord.showRecord(QueryRecord.java:22)
at QueryRecord.main(QueryRecord.java:49)
Exception in thread "main" java.lang.NullPointerException
at QueryRecord.showRecord(QueryRecord.java:39)
at QueryRecord.main(QueryRecord.java:49)
是你的TCP/IP 协议没可有开起服务。
点开始-程序-SQLServer2005-配置工具-然后点那个小锤子
进入面板后
选择SQLEXPRESS的协议 找到TCP/IP (你的状态应该是已禁用)右键启用
再选择SQL SERVER2005服务 右侧找到 SQLSERVER(MSSQLSERVER) 先停止 再启动
就好了
我里面没你说的SQLEXPRESS的协议。
面板有3个选项
SQL SERVER2005服务和 SQL SERVER2005配置
SQL SERVER2005配置点开又有2个
第一个MSSQLSERVER的协议
第二个SQLEXPRESS的协议