苦求JAVA连接sql2005

来源：百度知道 编辑：UC知道 时间：2024/05/27 08:43:10
import java.sql.*;
public class Conn {
Connection con;
public Connection getConnection(){
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch(Exception e)
{};

try{
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;database=library;user=sa;password=");
System.out.println("ok");
}catch(SQLException e){
e.printStackTrace();
}
return con;
}
public static void main(String[] args) {
Conn c=new Conn();
c.getConnection();
}
}

我想连接library数据库，SQL的登陆模式用SA，有密码，JDBC的驱动也下好了，用上面的代码会出现如下的错误信息，该怎么办？急！
java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;database=library;user=sa;password=
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.wsy.Conn.getConnection(Conn.java:12)

把你下的那个驱动程序放在你的工程目录的LIB文件夹下面。

import java.sql.*;
public class UserInfo {
private final String dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //连接sql数据库的方法
private final String url = "jdbc:sqlserver://localhost:1433;databaseName=WEB";
private final String userName = "sa";
private final String password = "123456";
private Connection con = null;

public UserInfo() {
try {
Class.forName(dbDriver).newInstance(); //加载数据库驱动
}
catch (Exception ex) {
System.out.println("数据库加载失败");
}
}

//创建数据库连接
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url, userName, password);
con.setAutoCommit(true);

}
catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
}
return true;
}