rs=st.executeQuery(sql2);
i=1;
List user = new ArrayList();
while(rs.next())
{
TSBaseUser baseUser = new TSBaseUser();
baseUser.setId(i+"");
baseUser.setUserKey(rs.getString("userkey"));
baseUser.setStatus(rs.getShort("status"));
baseUser.setRealName(rs.getString("realname"));
baseUser.setUserName(rs.getString("username"));
baseUser.setPassword(rs.getString("password"));
baseUser.setActivitiSync(rs.getShort("activitisync"));
user.add(baseUser);
i++;
}
root.put("baseuser", user);