/** * CSV出力用モデルを生成 * * @param rs ResultSet * @return created TcdCsvModel * @throws SQLException SQL実行例外 */ private TcdCsvModel __getTcdCsvFromRs(ResultSet rs) throws SQLException { TcdCsvModel bean = new TcdCsvModel(); bean.setUsrSid(rs.getInt("USR_SID")); bean.setUserName(rs.getString("USI_SEI") + " " + rs.getString("USI_MEI")); bean.setTcdDate(UDate.getInstanceTimestamp(rs.getTimestamp("TCD_DATE"))); bean.setTcdIntime(rs.getTime("TCD_INTIME")); bean.setTcdOuttime(rs.getTime("TCD_OUTTIME")); bean.setTcdStrikeIntime(rs.getTime("TCD_STRIKE_INTIME")); bean.setTcdStrikeOuttime(rs.getTime("TCD_STRIKE_OUTTIME")); bean.setTcdBiko(rs.getString("TCD_BIKO")); bean.setTcdStatus(rs.getInt("TCD_STATUS")); bean.setTcdHolkbn(rs.getInt("TCD_HOLKBN")); bean.setTcdHolother(rs.getString("TCD_HOLOTHER")); bean.setTcdHolcnt(rs.getBigDecimal("TCD_HOLCNT")); bean.setTcdChkkbn(rs.getInt("TCD_CHKKBN")); bean.setTcdSoukbn(rs.getInt("TCD_SOUKBN")); bean.setTcdLockFlg(rs.getInt("TCD_LOCK_FLG")); bean.setTcdAuid(rs.getInt("TCD_AUID")); bean.setTcdAdate(UDate.getInstanceTimestamp(rs.getTimestamp("TCD_ADATE"))); bean.setTcdEuid(rs.getInt("TCD_EUID")); bean.setTcdEdate(UDate.getInstanceTimestamp(rs.getTimestamp("TCD_EDATE"))); return bean; }