我第一次用sql server 2005,做一个学生管理程序
但是连接sql server 2005时总是提示为: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 p1.Connector.<init>(Connector.java:8)
at p1.Connector.main(Connector.java:30)我的代码为:import java.sql.Connection;
import java.sql.DriverManager;
public class Connector {
public static Connection conection = null;
public Connector(){
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conection = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=student ","sa","");
// conection = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.1.43:1433;DatabaseName=DB_Student ","sa","");
System.out.println("数据库操作成功,祝贺你"); }catch(java.lang.ClassNotFoundException classnotfound){
classnotfound.printStackTrace();
}catch(java.sql.SQLException sql){
sql.printStackTrace();
}
}
// private void closeCon(){
// try {
// conection.close();
// } catch (Exception e) {
// // TODO: handle exception
// }
public static void main(String []args){
Connector con=new Connector();
}
}
但是连接sql server 2005时总是提示为: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 p1.Connector.<init>(Connector.java:8)
at p1.Connector.main(Connector.java:30)我的代码为:import java.sql.Connection;
import java.sql.DriverManager;
public class Connector {
public static Connection conection = null;
public Connector(){
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conection = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=student ","sa","");
// conection = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.1.43:1433;DatabaseName=DB_Student ","sa","");
System.out.println("数据库操作成功,祝贺你"); }catch(java.lang.ClassNotFoundException classnotfound){
classnotfound.printStackTrace();
}catch(java.sql.SQLException sql){
sql.printStackTrace();
}
}
// private void closeCon(){
// try {
// conection.close();
// } catch (Exception e) {
// // TODO: handle exception
// }
public static void main(String []args){
Connector con=new Connector();
}
}
解决方案 »
- J2SE的综合练习
- 如何在websphere 上 配置ssl,双向认证?请教了
- 请问如何把 NetBeans 编写的程序生成一个可以执行的文件
- 新手请教数组问题~!!
- //急急急,关于数组的一个小问题,等待解决.
- 请大家帮小弟看看,关于\r和\n 的一句代码怎么也不明白
- 返回一个数组的问题 大家帮我看看
- 请问如何看JAVA的帮助文档啊~!!!!!!!!
- 收集应用JAVA程序访问 Berkeley DB 的资料!急!
- 连接SQL Server数据库,出现Operation failed. DataSet is not open错误!
- TCP服务器程序 出现的错误
- 这个 JDK 程序 错了 求纠正!!!! 恳请高手们指点
那你就去找sql server对应的jar包.
mssqlserver.jar
msutil.jar
完事了按F5刷新下
java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=student
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at p1.Connector.<init>(Connector.java:10)
at p1.Connector.main(Connector.java:31)
改成conection = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=student ","sa","");然后看看,保证2005的JDBC驱动已经加到classpath
com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。该用户与可信 SQL Server 连接无关联。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at p1.Connector.<init>(Connector.java:10)
at p1.Connector.main(Connector.java:32)