示例#1
0
 /*
  * (non-Javadoc)
  *
  * @see org.cuny.sensors.dao.IDao#update(java.lang.Object)
  */
 @Override
 public RawFile update(RawFile obj) throws Exception {
   RawFile old = get(obj.getId());
   this.jdbcTemplate.update(
       "update "
           + TABLE_NAME
           + " set "
           + FILE_NAME
           + " = ?, "
           + FILE_SIZE
           + " = ?, "
           + DATASET_COUNT
           + " = ?, "
           + SENSOR_COUNT
           + " = ?, "
           + RECORD_COUNT
           + " = ?, "
           + BUILDING
           + " = ?,"
           + CAMPUS
           + " = ?,"
           + STATUS
           + " = ?,"
           + NOTES
           + "  = ? where "
           + ID
           + " = ?",
       obj.getFilename(),
       obj.getFileSize(),
       obj.getDatasetCount(),
       obj.getSensorCount(),
       obj.getRecordCount(),
       obj.getBuilding(),
       obj.getCampus(),
       obj.getStatus().toString(),
       obj.getNotes(),
       obj.getId());
   return old;
 }
示例#2
0
 /*
  * (non-Javadoc)
  *
  * @see org.cuny.sensors.dao.IDao#remove(java.lang.Object)
  */
 @Override
 public RawFile remove(RawFile obj) throws Exception {
   RawFile old = get(obj.getId());
   this.jdbcTemplate.update("delete from " + TABLE_NAME + " where " + ID + " = ?", obj.getId());
   return old;
 }