Question

java连不上sql2005,已经导入sqljdbc.jar，求解释啊

package pkg;

import java.sql.*;

public class Main{
public static void main(String[] args) {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=testzyp11";
String userName = "sa";
String userPwd = "901125";
Connection dbConn =null;

try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("连接成功!");
}
catch (Exception e)
{
System.out.println("数据库连接失败！");
e.printStackTrace();
}
}
}
报错原因：
java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=testzyp11
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at pkg.Main.main(Main.java:15)
数据库连接失败！

Answer 1

这个还是没有找到你的数据库驱动你在检查一下

追问

String url="jdbc:microsoft:sqlserver://hostname:1433;DatabaseName = BookID";
这一句直接写成：
String url="jdbc:sqlserver://localhost:1433;database = BookID";就行了!
找到满意答案了 分就给你了

Answer 2

把防火墙关了