更新數據需要commit


在查詢數據的時候，沒有報錯i，但就是無法顯示打印，最后發現rs.get()與數據庫中的字段不對應的原因
public List getMessage(String startRow,String num){
??????
??????String sql ="select* from message limit "+startRow+","+num;
??????Connection conn = this.session.connection();
??????List list1 = new ArrayList();
??????try {??
????PreparedStatement pstmt = conn.prepareStatement(sql);
????ResultSet rs = pstmt.executeQuery();
????while(rs.next()){
????Message message = new Message();
????message.setId(rs.getInt("id"));
????message.setName("華訊財經股客");
????message.setContent(rs.getString("content"));
????System.out.println(rs.getString("content"));
????String ip??= rs.getString("ip").substring(0, 8).concat("*");??
????message.setIp(ip);??
????message.setPoint(rs.getInt("point"));
????list1.add(message);
????}
????pstmt.close();
??
?? } catch (SQLException e) {
????// TODO Auto-generated catch block
????e.getStackTrace();
?? }
??????return list1;
???? }

jdbc出現的問題