经典的jdbc连接数据库语句

public List<User> query() { 
 
    List<User> userList = new ArrayList<User>(); 
    String sql = "select * from User"; 
 
    Connection con = null; 
    PreparedStatement pst = null; 
    ResultSet rs = null; 
    try { 
         con = HsqldbUtil.getConnection(); 
         pst = con.prepareStatement(sql); 
         rs = pst.executeQuery(); 
  
         User user = null; 
         while (rs.next()) { 
  
             user = new User(); 
             user.setId(rs.getInt("id")); 
             user.setUserName(rs.getString("user_name")); 
             user.setBirth(rs.getDate("birth")); 
             user.setCreateDate(rs.getDate("create_date")); 
             userList.add(user); 
         } 
  
  
     } catch (SQLException e) { 
         e.printStackTrace(); 
     }finally{ 
         if(rs != null){ 
             try { 
                 rs.close(); 
             } catch (SQLException e) { 
                 e.printStackTrace(); 
             } 
         } 
         try { 
             pst.close(); 
         } catch (SQLException e) { 
             e.printStackTrace(); 
         } 
         try { 
             if(!con.isClosed()){ 
                 try { 
                     con.close(); 
                 } catch (SQLException e) { 
                     e.printStackTrace(); 
                 } 
             } 
         } catch (SQLException e) { 
             e.printStackTrace(); 
         } 
          
     } 
     return userList; 
} 

评论

4 楼 pengfeicao521 2013-01-11  

谢谢兄台指点，当初俺刚学jdbc的时候，写个比这个还喷血的语句

3 楼 King_XR 2013-01-07  

其实, 这段代码中, 有好多地方, 处理都是不好的. 比如说,N多个try(){}catch(){}.
所以我才那么说的, 兄台见谅哈

2 楼 pengfeicao521 2013-01-07  

兄台，可能是我表达不清，我的本意是，这是在orm未出现之前，通用的sql连接语句。也是初学jdbc者的必经之路！

1 楼 King_XR 2012-12-27  

这也能称为经典 ???