- Java code
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class test { public static void main(String[] args) { String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=UserForChat"; //String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; //String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JSP1"; String userName = "sa"; // 默认用户名 String userPwd = "xiaoguo"; // 密码 try { Class.forName(driverName); Connection dbConn = DriverManager.getConnection(dbURL, userName, userPwd); System.out.println("连接成功！"); // 如果连接成功，控制台输出“连接成功！” Connection con = DriverManager.getConnection("jdbc:","", ""); // 创建一个可执行的SQL描述 Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM UserMsg"); } catch (Exception e) { //System.out.println("连接失败！"); e.printStackTrace(); } }}连接成功！
java.sql.SQLException: No suitable driver found for jdbc:
at java.sql.DriverManager.getConnection(DriverManager.java:604)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at test.main(test.java:20)
求解决方案
------解决方案--------------------
重复发帖，driver名称跟你的jar包不匹配，com.microsoft.sqlserver.jdbc.SQLServerDriver改成"com.microsoft.jdbc.sqlserver.SQLServerDriver
------解决方案--------------------
异常报的很明显啊，没有可用的数据库驱动包，应该是你的驱动名写错了
------解决方案--------------------
Connection con = DriverManager.getConnection("jdbc:","", "");
楼主 这句有问题吧 你上面不是有dbCon了吗 还用这个创建Statement? 明显写法也不对啊。