pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, length);
ResultSet rs = pstmt.executeQuery();
totalUserPvList = new ArrayList<TotalUserPv>();
while(rs.next()){
TotalUserPv totalUserPv = new TotalUserPv();
totalUserPv.setNick(rs.getString(1));
totalUserPv.setQueryCnt(rs.getInt(2));
totalUserPv.setDepartment(String.valueOf(rs.getString(3)));
totalUserPvList.add(totalUserPv);
}
LOG.info(pstmt.toString());
pstmt.close();
conn.close();