我的遍历代码是这样Stringselected=e.getActionCommand();//TODO自动生成的方法存根StringURL="jdbc:mysql://localhost:3306/java_database";Stringsql="select*fromscorewhereworkID...
我的遍历代码是这样
String selected=e.getActionCommand();// TODO 自动生成的方法存根
String URL = "jdbc:mysql://localhost:3306/java_database";
String sql="select * from score where workID='"+
comboBox1.getSelectedItem()+"'";
//String sql="select * from score";
System.out.println("success");
ArrayList ar=new ArrayList();
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e2) {
// TODO 自动生成的 catch 块
e2.printStackTrace();
}
try {
connection = DriverManager.getConnection(URL,"root","zxcvbnm");
stmt=connection.createStatement();
} catch (SQLException e1) {
// TODO 自动生成的 catch 块
e1.printStackTrace();
}
if(selected.equals("计算")){
try {
ResultSet rs=stmt.executeQuery(sql);
rs.first();
while (!rs.isLast()){
ar.add(rs.getInt(7));
if (rs.next()) {
rs.next();
}else {
return;
}
};
if (rs.last()) {
ar.add(rs.getInt(7));
}
System.out.println(ar);
} catch (SQLException e1) {
// TODO 自动生成的 catch 块
e1.printStackTrace();
}
通不过,提示
java.sql.SQLException: Illegal operation on empty result set.
但是我用下面一条sql
//String sql="select * from score";
就通过,我字段是有的,我通过写死字段来遍历也遍历不了,求大神回答
通不过的时候是运行到了
ar.add(rs.getInt(7));
展开