读书人

把结果集封装成list 遇到有关问题了 高

发布时间: 2012-01-13 22:43:29 作者: rapoo

把结果集封装成list 遇到问题了 高手看看怎么办

Java code
public List<Admin> getAllAdmin() {        Connection conn = null;        PreparedStatement ps = null;        ResultSet rs = null;        List<Admin> adminList = new ArrayList<Admin>();        int count = 0;        try {            conn = JdbcUtil.getConnection();            String sql = "select id,adminid,adminname,password,time from admin";            ps = conn.prepareStatement(sql);            rs = ps.executeQuery();            Admin[] adminArr = new Admin[]{};            while (rs.next()) {                //todo            }        }catch (SQLException e) {            e.printStackTrace();            }        return adminList;    }


[解决办法]
Java code
public List<Admin> getAllAdmin() {        Connection conn = null;        PreparedStatement ps = null;        ResultSet rs = null;        List<Admin> adminList = new ArrayList<Admin>();        int count = 0;        try {            conn = JdbcUtil.getConnection();            String sql = "select id,adminid,adminname,password,time from admin";            ps = conn.prepareStatement(sql);            rs = ps.executeQuery();                        while (rs.next()) {              Admin admin = new Admin();          admin.setId(rs.getString(1)) ;                admin.setAdminid(rs.getString(2)) ;                admin.setAdminname(rs.getString(3)) ;              admin.setPassword(rs.getString(4)) ;                admin.setTime(rs.getString(5)) ;                 adminList.add(admin);            }        }catch (SQLException e) {            e.printStackTrace();            }        return adminList;    } 

读书人网 >J2EE开发

热点推荐