Exemplo n.º 1
0
  public void addEntries(final Collection<Entry> batch) throws IOException {
    if (batch.size() == 0) {
      return;
    }
    final Entry entry0 = batch.getElementAt(0);
    final String table_name = this.sql_table_name;
    final List<String> keys = Collections.newList();
    final String stm = "INSERT INTO " + table_name + " " + this.paramString(entry0, keys, "(", ")");
    final MySQLConnection connection = this.db.obtainConnection();
    connection.checkIsOpen();
    try {
      final Connection mysql_connection = connection.getConnection();

      final PreparedStatement statement = mysql_connection.prepareStatement(stm);
      for (int b = 0; b < batch.size(); b++) {
        final Entry entry = batch.getElementAt(b);
        for (int i = 0; i < keys.size(); i++) {
          final String key = keys.getElementAt(i);
          // final String value = entry.getValue(key);
          final String value = entry.getValue(key);
          statement.setString(i + 1, value);
        }
        statement.addBatch();
      }
      statement.executeBatch();
    } catch (final SQLException e) {
      e.printStackTrace();
      throw new IOException(e);
    } finally {
      this.db.releaseConnection(connection);
    }
  }
Exemplo n.º 2
0
  private Entry readEntry(final ResultSet result, final Collection<String> columns)
      throws SQLException {
    final Entry entry = this.newEntry();

    final int N = columns.size();
    for (int i = 0; i < N; i++) {
      final String key = columns.getElementAt(i);
      final String value = result.getString(i + 1);
      entry.set(this.schema, this.schema.indexOf(key), value);
    }
    return entry;
  }
Exemplo n.º 3
0
  private String paramString(
      final Entry entry,
      final List<String> keys,
      final String bracketLeft,
      final String bracketRight)
      throws IOException {
    final MySQLTableSchema schema = this.getSchema();
    final Collection<String> colums = schema.getColumns();

    for (int i = 0; i < colums.size(); i++) {
      final String key = colums.getElementAt(i);
      final String value = entry.getValue(key);
      if (value != null) {
        keys.add(key);
      }
    }
    final String schemaString = JUtils.wrapSequence(keys, keys.size(), bracketLeft, bracketRight);

    return schemaString + " VALUES " + JUtils.wrapSequence((i) -> "?", keys.size(), "(", ")");
  }