我正在尝试将数据库中的一些值插入到ArrayList中 . 我猜方法showMeeting()存在一些问题 . 希望你们能理解从控制台获得的一些消息 .
public ArrayList showMeeting() {
ArrayList output = new ArrayList();
try {
Class.forName(driverName).newInstance();
con = DriverManager.getConnection(url + dbName, userName, password);
try {
Statement st = con.createStatement();
String meetID = "SELECT meetID FROM Meeting";
ResultSet rs = st.executeQuery(meetID);
while(rs.next()){
output.add(rs.toString());
}
} catch (SQLException s) {
System.out.println("Wrong sql-query");
}
con.close();
} catch (Exception e) {
e.printStackTrace();
}
return output;
}
public static void main(String[] args) {
InteractWithDatabase2 test = new InteractWithDatabase2();
ArrayList meetID = test.showMeeting();
String meetings = "";
for (int i = 0; i
meetings += meetID.get(i) + "\n";
}
System.out.println(meetings);
}
当我试图在Eclipse中运行它时,我收到此消息:
java.lang.ClassNotFoundException:java.net.URLClassLoader $ 1.run(URLClassLoader.java:202)中的java.lang.Class文件中的java.security.AccessController.doPrivileged(Native Method)中的java.lang.ClassNotFoundException:com.mysql.jdbc.Driver (URLClassLoader.java:190)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)at no.ntnu.fp.model.InteractWithDatabase2.visMoter(InteractWithDatabase2.java:107) at no.ntnu.fp.model.InteractWithDatabase2.main(InteractWithDatabase2.java:127)