/** Updates a single row in the SessionSexualRelationshipType table. */ @Transactional public void update(SessionSexualRelationshipTypePk pk, SessionSexualRelationshipType dto) throws SessionSexualRelationshipTypeDaoException { jdbcTemplate.update( "UPDATE " + getTableName() + " SET sessionSexualRelationshipTypeId = ?, sessionReference = ?, sexualRelationshipTypeId = ?, dateCreated = ?, createdBy = ?, dateModified = ?, modifiedBy = ?, status = ? WHERE sessionSexualRelationshipTypeId = ?", dto.getSessionSexualRelationshipTypeId(), dto.getSessionReference(), dto.getSexualRelationshipTypeId(), dto.getDateCreated(), dto.getCreatedBy(), dto.getDateModified(), dto.getModifiedBy(), dto.getStatus(), pk.getSessionSexualRelationshipTypeId()); }
/** * Method 'mapRow' * * @param rs * @param row * @throws SQLException * @return SessionSexualRelationshipType */ public SessionSexualRelationshipType mapRow(ResultSet rs, int row) throws SQLException { SessionSexualRelationshipType dto = new SessionSexualRelationshipType(); dto.setSessionSexualRelationshipTypeId(rs.getLong(1)); dto.setSessionReference(rs.getString(2)); dto.setSexualRelationshipTypeId(rs.getLong(3)); if (rs.wasNull()) { dto.setSexualRelationshipTypeIdNull(true); } dto.setDateCreated(rs.getTimestamp(4)); dto.setCreatedBy(rs.getString(5)); dto.setDateModified(rs.getTimestamp(6)); dto.setModifiedBy(rs.getString(7)); dto.setStatus(rs.getInt(8)); if (rs.wasNull()) { dto.setStatusNull(true); } return dto; }
/** * Method 'insert' * * @param dto * @return SessionSexualRelationshipTypePk */ @Transactional public SessionSexualRelationshipTypePk insert(SessionSexualRelationshipType dto) { jdbcTemplate.update( "INSERT INTO " + getTableName() + " ( sessionSexualRelationshipTypeId, sessionReference, sexualRelationshipTypeId, dateCreated, createdBy, dateModified, modifiedBy, status ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? )", dto.getSessionSexualRelationshipTypeId(), dto.getSessionReference(), dto.isSexualRelationshipTypeIdNull() ? null : dto.getSexualRelationshipTypeId(), dto.getDateCreated(), dto.getCreatedBy(), dto.getDateModified(), dto.getModifiedBy(), dto.isStatusNull() ? null : dto.getStatus()); return dto.createPk(); }