Posted on 2011-12-05 22:14
哈希 閱讀(1226)
評論(0) 編輯 收藏 所屬分類:
Js and Jquery 常用總結
好久沒用List去保存一個JDBC查詢結果,查詢出來的ResultSet只執行了一次,然后就報NullPointException。明明數據庫中有數據,就是執行不了第二次,一到把對象添加到list上面就直接報異常,郁悶了半天。
- public List<Terminal> getTerm(String user){
- List<Terminal> termlist= null;
-
-
- try {
- con = DBPool.getPool().getConnection();
- ps =con.prepareStatement("select * from gps_termcodetable where kh_user=?");
- ps.setString(1, user);
- rs = ps.executeQuery();
- while(rs.next()){
- Terminal term = new Terminal();
- String number = rs.getString("hm_number");
- String nick = rs.getString("mc_nick");
- term.setZhNumber(number);
- term.setLisence(rs.getString("mc_nick"));
- termlist.add(term);
- }
- rs.close();
- ps.close();
- con.close();
- } catch (SQLException ex) {
- Logger.getLogger(GetTerminal.class.getName()).log(Level.SEVERE, null, ex);
- }
- return termlist;
- }
public List<Terminal> getTerm(String user){
List<Terminal> termlist= null;//這里出現問題,沒有new一個List
//改為List<Terminal> termlist= new ArrayList();,
//new一個ArrayList就沒事了,日,以前初學的時候也得過這種問題...汗
try {
con = DBPool.getPool().getConnection();
ps =con.prepareStatement("select * from gps_termcodetable where kh_user=?");
ps.setString(1, user);
rs = ps.executeQuery();
while(rs.next()){
Terminal term = new Terminal();
String number = rs.getString("hm_number");
String nick = rs.getString("mc_nick");
term.setZhNumber(number);
term.setLisence(rs.getString("mc_nick"));
termlist.add(term);
}
rs.close();
ps.close();
con.close();
} catch (SQLException ex) {
Logger.getLogger(GetTerminal.class.getName()).log(Level.SEVERE, null, ex);
}
return termlist;
}
后面才發現沒有new一個ArrayList,郁悶了,還犯這種錯誤,久了沒用也會生疏