Question

谁能帮我解决：Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:

连接数据库时出现的错误、数据库是SQL server 2008的 、代码如下 ：

import java.*;
import java.lang.*;
import java.sql.*;

public class SqlDemo {

public static void main(String[] args) throws Exception
{

//声明连接，SQL语句执行对象和结果集变量
java.sql.Connection conn = null;
java.sql.Statement stmt = null;
java.sql.ResultSet rs = null;

//加载数据库驱动程序
//Driver Classname=com.microsoft.jdbc.sqlserver.SQLServerDriver
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//创建连接
//url=jdbc:microsoft:sqlserver://COMMONOR-02A84C:1433
//Properties
//Password=
//DatabaseName=pubs
//User=sa
//计算机名要根据实际情况更改
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master;User=sa;Password=1");
//创建SQL语句对象
stmt = conn.createStatement();
//执行SQL语句
stmt.execute("select * from dbo.Users");
//取得结果集
rs = stmt.getResultSet();
//打印结果
while (rs.next()) {
System.out.println(rs.getString("UserID") + " - " +
rs.getString("UserName") + " - " +
rs.getString("UserPW"));
}

rs.close(); //关闭结果集
stmt.close(); //关闭sql语句执行类
conn.close(); //关闭数据库联接类
}
}

Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master;User=sa;Password=1
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at SqlDemo.main(SqlDemo.java:25)
那个已经改好了
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master;User=sa1");
改为
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=master","sa","");
却出现这样的问题;
Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: 驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接。错误:“RSA premaster secret error”。

Answer 1

DB 连接问题

把这句：
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master;User=sa;Password=1");
修改成下面的
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=master","User=sa","Password=1");

Answer 2

看看build-path 看看数据库驱动jar是否引入了

Answer 3

2008，没用过。。。

Answer 4

貌似驱动的lib包版本有问题啊

Answer 5

驱动问题 需要jar包