Question

java.sql.SQLException: No suitable driver

java.sql.SQLException: No suitable driver

package com.model;
import javax.sql.*;
import java.sql.Connection;
import java.sql.SQLException;
//这个model 得到连接数据库
import java.sql.DriverManager;

public class ConnDB {
private Connection ct=null;
public Connection getConnection() throws SQLException{
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:microsoft:sqlserve://127.0.0.1:1433;databaseName=testdb","sa","");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return ct;

}
}

谁帮我看看怎么回事 ，jdbcjar包我也导了 为什么就不好使

Answer 1

ct=DriverManager.getConnection("jdbc:sqlserve://127.0.0.1:1433;databaseName=testdb","sa","");
换成这句试试

Answer 2

连接SQLServer的驱动配置有问题。

Answer 3

Class.forName里面的内容写错了，应该是
com.microsoft.sqlserver.jdbc.SQLServerDriver

Answer 4

很明显，驱动连接字符串写错了
正解：Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");