Java版本15.0.2,sqljdbc版本9.2,官方显示支持java15,测试程序显示加载驱动成功,连接数据库失败
源码
import java.sql.*;
public class Test {
private static Connection dbConn = null;
public static void main(String[] args) {
String dbURL = "jdbc:microsoft.sqlserver://localhost:1433;DatabaseName=root";
try {
//1.加载驱动
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("加载驱动成功!");
//2.连接
dbConn = DriverManager.getConnection(dbURL, "root", "SSSS");
System.out.println("连接数据库成功!");
String sql="select * from people";
PreparedStatement statement=null;
statement=dbConn.prepareStatement(sql);
ResultSet res=null;
res=statement.executeQuery();
while(res.next()){
String title=res.getString("name");
System.out.println(title);
}
}catch(Exception e) {
e.printStackTrace();
System.out.println("连接数据库失败!");
}
}
}
运行结果截图