Question

以下代码提示错误：java.sql.SQLException: No suitable driver

public class DBConnection {

// 使用第三方JDBC驱动类
private String DBDRIVER ="com.microsoft.sqlserver.jdbc.SQLServerDriver";

private String DBURL = "jdbc:jtds:sqlserver://127.0.0.1:1433;DataBaseName=EmployInfo";

private String DBUSER = "sa";

private String DBPASSWORD = "";

private Connection conn = null;

public DBConnection() {

try {
Class.forName(DBDRIVER);
this.conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
} catch (ClassNotFoundException e) {
System.out.println("*******error*******");
e.printStackTrace();

} catch (SQLException e) {
System.out.println("*****error*******");
e.printStackTrace();
}

}

public Connection getConnection() {
return this.conn;
}

public void close() {

try {
this.conn.close();
} catch (SQLException e) {
System.out.println("***error............****");
e.printStackTrace();
}

}

}

Answer 1

缺少sqlserver jdbc驱动程序的jar包，即包含com.microsoft.sqlserver.jdbc.SQLServerDriver 类的文件， 如果没有可以使用搜索引擎搜[sqlserver jdbc驱动]