(1) 错误:Illegal operation on empty result set.
解决:把
rs.next();
managerLayer = rs.getInt("layer");
改成while (rs.next()) {managerLayer = rs.getInt("layer");}
(2)错误:No operations allowed after statement closed.
解决:把所有的db.close();去掉;
(3)textchange方法:
解决:
fu = new JTextField(8);
fu.getDocument().addDocumentListener(new TextDocumentListener());
fu.setBounds(401, 93, 90, 21);
p.add(fu);
private void updateDestText() {
if (fu.getText() != null) {
String fathernode = fu.getText();
dt.setText(Finan_DBOperate.selectManagerLayer(db, fathernode) + "");
}
}
class TextDocumentListener implements DocumentListener {
public void insertUpdate(DocumentEvent e) {
updateDestText();
}
public void removeUpdate(DocumentEvent e) {
updateDestText();
}
public void changedUpdate(DocumentEvent e) {
updateDestText();
}
}