Question

java 将数据库表连接到 JTable 总是报错

import java.sql.*;
import javax.swing.*;

public class CreatTable1 {
private ResultSet res;
public CreatTable1() {}

public void tableSelect(String tablename) {
Connection conn = null;
Statement statement = null;
try {
conn = DBConnection.testConnection();
statement = conn.createStatement();
res = statement.executeQuery("select *from " +tablename);
res.last();
while(res.next()) {
int id = res.getInt(1);
String name = res.getString(2);
boolean part = res.getBoolean(3);
String special = res.getString(4);
String course = res.getString(5);
System.out.print(String.valueOf(id) + name + String.valueOf(part) + special + course +"\n");
}
} catch(Exception e) {
e.printStackTrace();
}

}

public static void main(String[] args) {
CreatTable1 table = new CreatTable1();
table.tableSelect("Teacher");
}
}

运行后报错：Result set type is TYPE_FORWARD_ONLY
然后改为 statement = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);后 又报错String index out of range: -1 怎么回事啊

Answer 1

res.last();之后就是最后一条了,所以报错啊