/**
* 查询用户列表
* @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"));
行不行?