Java中如何把数据库中查询到的多条数据读出来

Question

急求帮助!在Java语言中，如何把数据库中查询到的多条数据读出来。。。。。。。。。。。。

Answer 1

 List<User> list = new ArrayList<User>();
        DataBaseConnection conn =new  DataBaseConnection();
        String sql = "select * from user order by userid desc limit ?,?";
        try {
            PreparedStatement ps = conn.getConnection().prepareStatement(sql);
            ps.setInt(1, (page-1) * User.PAGE_SIZE);
            ps.setInt(2, User.PAGE_SIZE);
            ResultSet rs = ps.executeQuery();
            while(rs.next()){
                User user = new User();
                user.setUserid(rs.getInt("userid"));
                user.setUsername(rs.getString("username"));
                user.setPassword(rs.getString("password"));
                list.add(user);
            }
            rs.close();
            ps.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;