/** * 查询用户列表 * @return userList */ public ArrayList<Object> seleteUserList() { initDb(); PreparedStatement pst = null; ResultSet rs = null; ArrayList<Object> userList = null; try { String sql = "SELECT user_id,user_name FROM usertable WHERE user_display = 1"; pst = con.prepareStatement(sql); rs = pst.executeQuery(); userList = new ArrayList<Object>(); while (rs.next()) { Integer userId = rs.getInt("user_id"); String userName = rs.getString("user_name"); UserVo uv = new UserVo(); uv.setUserId(userId); uv.setUserName(userName); userList.add(uv); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { rs.close(); pst.close(); con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return userList; }
还是以代码为例:
1. ArrayList<Object>后面的object什么意思?去掉行不行?
2.根据10行和15行,将10行改为ArrayList<object> userList = new ArrayList<object>();删除15行,行不行?
3.20和21行,改为
uv.setUserId(rs.getInt("user_id"));
uv.setUserName(rs.getString("user_name"));
行不行?