* @return A populated UserBean
*
* @throws SQLException
*/
protected static UserBean populate(ResultSet rs) throws SQLException {
UserBean valueObject = new UserBean();
valueObject.setId((String)rs.getObject(1));
valueObject.setGroupid((String)rs.getObject(2));
valueObject.setFirstname((String)rs.getObject(3));
valueObject.setLastname((String)rs.getObject(4));
valueObject.setTitle((Integer)rs.getObject(5));
valueObject.setEmail((String)rs.getObject(6));
valueObject.setAddress1((String)rs.getObject(7));
valueObject.setAddress2((String)rs.getObject(8));
valueObject.setPhone1((String)rs.getObject(9));
valueObject.setPhone2((String)rs.getObject(10));
valueObject.setPassword((String)rs.getObject(11));
valueObject.setChangepassword((Integer)rs.getObject(12));
valueObject.setTspassword((java.sql.Timestamp)rs.getObject(13));
valueObject.setStatus((Integer)rs.getObject(14));
valueObject.setTscreated((java.sql.Timestamp)rs.getObject(15));
valueObject.setTsupdated((java.sql.Timestamp)rs.getObject(16));
valueObject.setTslastlogin((java.sql.Timestamp)rs.getObject(17));
valueObject.setCreatedby((String)rs.getObject(18));
valueObject.setUpdatedby((String)rs.getObject(19));
valueObject.setCentreid((String)rs.getObject(20));
valueObject.setOwningcentre((String)rs.getObject(21));
valueObject.setLanguageid((String)rs.getObject(22));
valueObject.setTslastviewedsystemmessage((java.sql.Timestamp)rs.getObject(23));
valueObject.setHelpstatus((Integer)rs.getObject(24));
valueObject.setListboxmode((Integer)rs.getObject(25));
valueObject.setCollation((String)rs.getObject(26));
valueObject.setLogincentre((Integer)rs.getObject(27));
return valueObject;
}