import java.sql.*;public class aa {
public static void main(String[] args) throws SQLException,ClassNotFoundException {
String user = "root";
String pwd = "";
// 设定url
String myjdbc = "jdbc:mysql://localhost:3306/movie";
// 加载mysql驱动
Class.forName("com.mysql.jdbc.Driver");
// 创建连接会话
Connection myConnection = DriverManager.getConnection(myjdbc, user, pwd);
// 创建语句块对象
Statement Myoperation = myConnection.createStatement();
// 获取结果集对象
ResultSet record = Myoperation.executeQuery("SELECT * FROM vote");
while (record.next()) {
// 输出结果集对象
System.out.println(record.getString("item") + ","
+ record.getInt("c"));
}
// 关闭结果集
try {
if (record != null)
record.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (myConnection != null)
myConnection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
怎么一直显示错误Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
public static void main(String[] args) throws SQLException,ClassNotFoundException {
String user = "root";
String pwd = "";
// 设定url
String myjdbc = "jdbc:mysql://localhost:3306/movie";
// 加载mysql驱动
Class.forName("com.mysql.jdbc.Driver");
// 创建连接会话
Connection myConnection = DriverManager.getConnection(myjdbc, user, pwd);
// 创建语句块对象
Statement Myoperation = myConnection.createStatement();
// 获取结果集对象
ResultSet record = Myoperation.executeQuery("SELECT * FROM vote");
while (record.next()) {
// 输出结果集对象
System.out.println(record.getString("item") + ","
+ record.getInt("c"));
}
// 关闭结果集
try {
if (record != null)
record.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (myConnection != null)
myConnection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
怎么一直显示错误Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
有时候jar包,会因为硬盘坏道的关系丢失数据,用WinRar打开试试,如果能打开,证明Jar包没问题
额,你的驱动包是不是放在lib下面的啊,myeclipse不需要build path。
我用的7.5+的MyEclipse只要放到你的WEB-INF/lib文件夹下就可以自动build的了。
6.5的需要手动build~~
好像,忘记了~~~
--signature--------------------
http://www.lunwenwa.com/