public void updateRecord(VersionManifest match, VersionManifest update) throws DBIException { try { this.open(); this.updateRecordFromMapQuery(match.createMap(), update.createMap()); this.close(); } catch (SQLException e) { throw new DBIException( e); // create a generic DBIException from this SQLException and throw it } }
private List<VersionManifest> findFromMapQuery(Map<String, String> map) throws SQLException { if (conn.isClosed()) throw new SQLException("Connection is closed, cannot find record"); String where = ""; String col; String[] values = new String[map.size()]; Iterator<String> colIter = map.keySet().iterator(); for (int i = 0; i < map.size(); i++) { col = colIter.next(); values[i] = map.get(col); where += col + " = ?"; if (i < map.size() - 1) where += " AND "; } String query = "SELECT * FROM " + config.get(CONFIG_TABLENAME) + " WHERE " + where; PreparedStatement stmt = this.conn.prepareStatement(query); for (int i = 0; i < values.length; i++) { stmt.setString(i + 1, values[i]); } ResultSet rs = stmt.executeQuery(); List<VersionManifest> mpvList = VersionManifest.fromResultSet(rs); rs.close(); return mpvList; }
public void addRecord(VersionManifest vm) throws DBIException { try { this.open(); this.addRecordFromMapQuery(vm.createMap()); this.close(); } catch (SQLException e) { throw new DBIException( e); // create a generic DBIException from this SQLException and throw it } }
public List<VersionManifest> find(VersionManifest vm) throws DBIException { List<VersionManifest> results; try { this.open(); results = this.findFromMapQuery(vm.createMap()); this.close(); } catch (SQLException e) { throw new DBIException( e); // create a generic DBIException from this SQLException and throw it } return results; }
private List<VersionManifest> findAllQuery() throws SQLException { if (conn.isClosed()) throw new SQLException("Connection is closed, cannot find records"); String query = "SELECT * FROM " + config.get(CONFIG_TABLENAME); PreparedStatement stmt = this.conn.prepareStatement(query); ResultSet rs = stmt.executeQuery(); List<VersionManifest> mpvList = VersionManifest.fromResultSet(rs); rs.close(); return mpvList; }