public UrgeVerifyInfo mapRow(ResultSet rs, int rowNum) throws SQLException {
UrgeVerifyInfo t = new UrgeVerifyInfo();
t.setId(rs.getString("ID"));
t.setTaskid(rs.getString("TASKID"));
t.setUid(rs.getString("UID"));
t.setUserrealname(rs.getString("USERREALNAME"));
t.setUsertype(rs.getString("USERTYPE"));
t.setRegistreason(rs.getString("REGISTREASON"));
t.setRemark(rs.getString("REMARK"));
t.setRecord(rs.getString("RECORD"));
t.setOwner(rs.getString("REALNAME"));
t.setUserid(rs.getString("USERID"));
String utype = rs.getString("UTYPE");
if (utype != null) {
t.setUtype(UrgeType.enumOf(utype));
}
String urgestatus = rs.getString("URGESTATUS");
if (urgestatus != null) {
t.setUrgestatus(UrgeStatus.enumOf(urgestatus));
}
t.setUsername(rs.getString("USERNAME"));
t.setRegdate(rs.getTimestamp("REGDATE"));
t.setLastlogindate(rs.getTimestamp("LASTLOGINDATE"));
t.setBuynum(rs.getInt("BUYNUM"));
t.setSellnum(rs.getInt("SELLNUM"));
t.setAuthnum(rs.getInt("AUTHNUM"));
t.setVerifynum(rs.getInt("VERIFYNUM"));
t.setLastverifydate(rs.getTimestamp("LASTVERIFYDATE"));
t.setCompanyType(CompanyType.getText(rs.getString("COMPANYTYPE")));
t.setAuthStatus(AuthRecordStatus.getText(rs.getString("AUTHSTATUS")));
t.setPassAmount(rs.getString("AMOUNT"));
return t;
}
/* (non-Javadoc)
* @see org.springframework.jdbc.core.RowMapper#mapRow(java.sql.ResultSet, int)
*/
@Override
public TUrgeVerify mapRow(ResultSet rs, int rowNum) throws SQLException {
// TODO Auto-generated method stub
TUrgeVerify t = new TUrgeVerify();
t.setUid(rs.getString("UID"));
t.setUtype(UrgeType.enumOf(rs.getString("UTYPE")));
t.setUrgestatus(UrgeStatus.enumOf(rs.getString("URGESTATUS")));
t.setCreater(rs.getString("CREATER"));
t.setCreatetime(rs.getTimestamp("CREATETIME"));
t.setUpdater(rs.getString("UPDATER"));
t.setUpdatetime(rs.getTimestamp("UPDATETIME"));
t.setCid(rs.getString("CID"));
t.setUsertype(rs.getString("USERTYPE"));
t.setRegistreason(rs.getString("REGISTREASON"));
t.setRemark(rs.getString("REMARK"));
t.setRecord(rs.getString("RECORD"));
t.setOwner(rs.getString("REALNAME"));
return t;
}
