把以前的SSH项目导入eclipse,结果java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO),而数据库连接成功、密码也一致。
测试:
package test;
import java.sql.Connection;
import java.sql.DriverManager;
public class testlink {
public static void main(String args[])
{
String url = "jdbc:mysql://localhost/music";
String driver = "com.mysql.jdbc.Driver";
try{
Class.forName(driver);
}catch(Exception e){
System.out.println("无法加载驱动");
}
try {
Connection con = DriverManager.getConnection(url,"root","123456");
if(!con.isClosed())
System.out.println("success");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
结果:
无法加载驱动
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/music
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.testlink.main(testlink.java:19)
加上mysql-connector-java 的jar包,success。