java连不上mysql 在线等!!!!!!
public class ConnTest {
public static void main(String[] args) {
try {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:myql://localhost:3306/test";
String user = "root";
String password = "root";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url, user,password);
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from login_table");
while (rs.next()) {
String name = rs.getString("name");
System.out.println("name:"+name);
}
rs.close();
conn.close();
}
catch (Exception e) {
System.out.println("无法连接数据库");
e.printStackTrace();
System.out.println(e);
}
}
}
出错信息:
无法连接数据库
java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at addressbook.model.ConnTest.main(ConnTest.java:32)
是驱动的问题吗?
classpath: .;D:\Program Files\mysql-connector-java-3.0.7-stable-bin.jar