STS连接数据库SQL2014

关键字：数据库 更新时间：2020-12-19 06:20:59 116次访问

Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc.sqlserver://127.0.0.1:1433;DatabaseName=school
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at 练习.test.main(test.java:13)

1, 连接URL格式出现了问题(Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/XX","root","XXXX") 

2, 驱动字符串出错(com.mysql.jdbc.Driver) 

3, Classpath中没有加入合适的mysql_jdbc驱动 

4, 尝试着将mysql-connector-java-xxx.jar的jar包加入jre的lib/ext目录

相关标签：数据库