Пример #1
0
 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;
 }
Пример #2
0
 /* (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;
 }