try {
conn = DbPoolConnection.getInstance().getReadConnection();
stat = conn.createStatement();
rs = stat.executeQuery("select * from user_info where user_name in(" + userBuffer.toString() + ")");
while (rs.next()) {
UserInfo userInfo = new UserInfo();
userInfo.setId(rs.getInt("id"));
userInfo.setCreateTime(rs.getTimestamp("create_time"));
userInfo.setUserPassword(rs.getString("password"));
userInfo.setLastLoginTime(rs.getTimestamp("last_login_time"));
userInfo.setNickName(rs.getString("nick_name"));
userInfo.setUserName(rs.getString("user_name"));
userInfo.setUserRole(UserRole.valueOf(rs.getString("user_role")));
userInfo.setUserStat(UserStat.valueOf(rs.getString("user_stat")));
userInfo.setPicId(rs.getString("pic_id"));
allUserMap.put(rs.getString("user_name"), userInfo);
}
} catch (Exception e) {
e.printStackTrace();