Question

java连接mysql出错，不知道哪里出问题了。在线等。

public void conn() {
String url="jdbc:mysql://localhost:3306/myweb";
// URL指向要访问的数据库名mytest
String driver = "com.mysql.jdbc.Driver";
try {
Class.forName(driver);
}catch (Exception e) {
System.out.println("加载出错");
e.printStackTrace();
}try{
con=DriverManager.getConnection(url, "root", "111111");
st=con.createStatement();
rSet=st.executeQuery("select * from test");
con.close();
st.close();
if (rSet!=null) {
rSet.close();
}
System.out.println("yes");
} catch (Exception e) {
// TODO: handle exception
System.out.println("no");
e.printStackTrace();
}
}
错误
加载出错
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at Test.DBhelp.conn(DBhelp.java:23)
at Test.DBhelp.main(DBhelp.java:13)
no
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/myweb
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at Test.DBhelp.conn(DBhelp.java:28)
at Test.DBhelp.main(DBhelp.java:13)

Answer 1

从你的错误信息可以看出，你没有将mysql的驱动包导入到你的项目中去，从网上下载一个mysql驱动包，然后复制粘贴到项目工程下面。

Answer 2

查看你的mysql数据库是否开启。

Answer 3

没有导入mysql包，导致找不到mysql驱动类