public static SpotRefrenceMapper getMapper() {
return MAPPER;
}
public SpotRefrence mapRow(ResultSet rs, int rowNum) throws SQLException {
SpotRefrence sr = new SpotRefrence();
try {
sr.setId(rs.getLong(COLUMN_ID));
sr.setSpotId(rs.getLong(COLUMN_SPOTID));
sr.setSpotName(rs.getString(COLUMN_SPOTNAME));
sr.setSpotPortrait(rs.getString(COLUMN_SPOTPORTRAIT));
} catch (Exception e) {
}
try {
sr.setRefrenceId(rs.getLong(COLUMN_REFRENCEID));
sr.setRefrenceportrait(rs.getString(COLUMN_REFRENCEPORTRAIT));
sr.setRefrenceTitle(rs.getString(COLUMN_REFRENCETITLE));
sr.setRefrenceDigest(rs.getString(COLUMN_REFRENCEDIGEST));
sr.setRefrenceType(SpotRefrenceType.valueOf(rs
.getString(COLUMN_REFRENCETYPE)));
} catch (Exception e) {
}
try {
sr.setProviderId(rs.getLong(COLUMN_REFRENCEPROVIDERID));
sr.setProviderNikename(rs
.getString(COLUMN_REFRENCEPROVIDERNICKNAME));
sr.setProviderPortrait(rs
.getString(COLUMN_REFRENCEPROVIDERPORTRAIT));
sr.setProviderEmail(rs
.getString(COLUMN_REFRENCEPROVIDEREMAIL));
} catch (Exception e) {
}
try{
sr.setCreateTime(rs.getDate(COLUMN_CREATETIME));
sr.setUpdateTime(rs.getDate(COLUMN_UPDATETIME));
sr.setActivity(Activity.valueOf((rs.getString(COLUMN_ACTIVITY))));
}catch(Exception e){
}
return sr;
}