Esempio n. 1
0
  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;
  }
Esempio n. 2
0
  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;
  }