/** Deletes a single row in the project_phases table. */ public void delete(ProjectPhasesPk pk) throws ProjectPhasesDaoException { long t1 = System.currentTimeMillis(); // declare variables final boolean isConnSupplied = (userConn != null); Connection conn = null; PreparedStatement stmt = null; try { // get the user-specified connection or get a connection from the ResourceManager conn = isConnSupplied ? userConn : ResourceManager.getConnection(); System.out.println("Executing " + SQL_DELETE + " with PK: " + pk); stmt = conn.prepareStatement(SQL_DELETE); stmt.setInt(1, pk.getIdprojectPhases()); int rows = stmt.executeUpdate(); long t2 = System.currentTimeMillis(); System.out.println(rows + " rows affected (" + (t2 - t1) + " ms)"); } catch (Exception _e) { _e.printStackTrace(); throw new ProjectPhasesDaoException("Exception: " + _e.getMessage(), _e); } finally { ResourceManager.close(stmt); if (!isConnSupplied) { ResourceManager.close(conn); } } }
/** Updates a single row in the project_phases table. */ public void update(ProjectPhasesPk pk, ProjectPhases dto) throws ProjectPhasesDaoException { long t1 = System.currentTimeMillis(); // declare variables final boolean isConnSupplied = (userConn != null); Connection conn = null; PreparedStatement stmt = null; try { // get the user-specified connection or get a connection from the ResourceManager conn = isConnSupplied ? userConn : ResourceManager.getConnection(); System.out.println("Executing " + SQL_UPDATE + " with DTO: " + dto); stmt = conn.prepareStatement(SQL_UPDATE); int index = 1; stmt.setInt(index++, dto.getIdprojectPhases()); stmt.setString(index++, dto.getName()); stmt.setString(index++, dto.getDescription()); stmt.setDate( index++, dto.getStartDate() == null ? null : new java.sql.Date(dto.getStartDate().getTime())); stmt.setDate( index++, dto.getEndDate() == null ? null : new java.sql.Date(dto.getEndDate().getTime())); if (dto.isStatusNull()) { stmt.setNull(index++, java.sql.Types.INTEGER); } else { stmt.setInt(index++, dto.getStatus()); } if (dto.isProjectIdNull()) { stmt.setNull(index++, java.sql.Types.INTEGER); } else { stmt.setInt(index++, dto.getProjectId()); } stmt.setInt(8, pk.getIdprojectPhases()); int rows = stmt.executeUpdate(); reset(dto); long t2 = System.currentTimeMillis(); System.out.println(rows + " rows affected (" + (t2 - t1) + " ms)"); } catch (Exception _e) { _e.printStackTrace(); throw new ProjectPhasesDaoException("Exception: " + _e.getMessage(), _e); } finally { ResourceManager.close(stmt); if (!isConnSupplied) { ResourceManager.close(conn); } } }
/** * Returns the rows from the project_phases table that matches the specified primary-key value. */ public ProjectPhases findByPrimaryKey(ProjectPhasesPk pk) throws ProjectPhasesDaoException { return findByPrimaryKey(pk.getIdprojectPhases()); }