@Override public ResultSet getGeneratedKeys() throws SQLException { return targetStatement.getGeneratedKeys(); }
@Override public ResultSet getGeneratedKeys() throws SQLException { return statement.getGeneratedKeys(); }
@Override public ResultSet getGeneratedKeys() throws SQLException { return delegate.getGeneratedKeys(); }
private long getGeneratedKey(final Statement statement) throws SQLException { ResultSet resultSet = statement.getGeneratedKeys(); return resultSet.next() ? resultSet.getLong(1) : 0L; }
private long getGeneratedKey(final Statement statement) throws SQLException { ResultSet resultSet = statement.getGeneratedKeys(); return resultSet.next() ? resultSet.getLong(1) : 0L; }
@Override public ResultSet getGeneratedKeys() throws SQLException { Preconditions.checkState(1 == routedStatements.size()); return routedStatements.iterator().next().getGeneratedKeys(); }
Statement stmt = db.prepareStatement(query, Statement.RETURN_GENERATED_KEYS); numero = stmt.executeUpdate(); ResultSet rs = stmt.getGeneratedKeys(); if (rs.next()){ risultato=rs.getInt(1); }
long key = -1L; PreparedStatement preparedStatement = connection.prepareStatement(YOUR_SQL_HERE, PreparedStatement.RETURN_GENERATED_KEYS); preparedStatement.setXXX(index, VALUE); preparedStatement.executeUpdate(); ResultSet rs = preparedStatement.getGeneratedKeys(); if (rs.next()) { key = rs.getLong(1); }
String SQL = ""; //whatever my String is PreparedStatement ps = connection.prepareStatement(SQL, Statement.RETURN_GENERATED_KEYS); ps.setString(1, "value"); //Other necessary ps.setXXX() methods //now update ps.executeUpdate(); ResultSet rs = ps.getGeneratedKeys();
PreparedStatement stmt = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS); // ... ResultSet res = stmt.getGeneratedKeys(); while (res.next()) System.out.println("Generated key: " + res.getInt(1));
PreparedStatement pstmt = conn.prepareStatement(Query, Statement.RETURN_GENERATED_KEYS); pstmt.executeUpdate(); ResultSet keys = pstmt.getGeneratedKeys(); keys.next(); key = keys.getInt(1);
void readGeneratedKeys(int index, Statement statement) throws SQLException { if (generatedResultReader != null) { try (ResultSet results = statement.getGeneratedKeys()) { generatedResultReader.read(index, results); } } } }
PreparedStatement preparedStatement = connect.prepareStatement("INSERT into employee (time, name) VALUES (?,?)", Statement.RETURN_GENERATED_KEYS); preparedStatement.setTimestamp(1, new java.sql.Timestamp(new java.util.Date().getTime())); preparedStatement.setString(2, "Test"); preparedStatement.executeUpdate(); ResultSet tableKeys = preparedStatement.getGeneratedKeys(); tableKeys.next(); int autoGeneratedID = tableKeys.getInt(1);
@Override public void run() throws Exception { stmt.getGeneratedKeys(); } });
public void create(User user) throws SQLException { try ( Connection connection = dataSource.getConnection(); PreparedStatement statement = connection.prepareStatement(SQL_INSERT, Statement.RETURN_GENERATED_KEYS); ) { statement.setString(1, user.getName()); statement.setString(2, user.getPassword()); statement.setString(3, user.getEmail()); // ... int affectedRows = statement.executeUpdate(); if (affectedRows == 0) { throw new SQLException("Creating user failed, no rows affected."); } try (ResultSet generatedKeys = statement.getGeneratedKeys()) { if (generatedKeys.next()) { user.setId(generatedKeys.getLong(1)); } else { throw new SQLException("Creating user failed, no ID obtained."); } } } }
/** {@inheritDoc} */ @Override public ResultSet getGeneratedKeys() throws SQLException { ResultSet resultSet = delegate.getGeneratedKeys(); if (proxyResultSet == null || ((ProxyResultSet) proxyResultSet).delegate != resultSet) { proxyResultSet = ProxyFactory.getProxyResultSet(connection, this, resultSet); } return proxyResultSet; }
@Override public ResultSet getGeneratedKeys() throws SQLException { Optional<GeneratedKey> generatedKey = getGeneratedKey(); if (returnGeneratedKeys && generatedKey.isPresent()) { return new GeneratedKeysResultSet(routeResult.getGeneratedKey().getGeneratedKeys().iterator(), generatedKey.get().getColumn().getName(), this); } if (1 == getRoutedStatements().size()) { return getRoutedStatements().iterator().next().getGeneratedKeys(); } return new GeneratedKeysResultSet(); }
@Override public final ResultSet getGeneratedKeys() throws SQLException { checkOpen(); try { ResultSet rs = stmt.getGeneratedKeys(); DruidPooledResultSet poolableResultSet = new DruidPooledResultSet(this, rs); addResultSetTrace(poolableResultSet); return poolableResultSet; } catch (Throwable t) { throw checkException(t); } }
@Override public ResultSet getGeneratedKeys() throws SQLException { Optional<GeneratedKey> generatedKey = getGeneratedKey(); if (preparedStatementExecutor.isReturnGeneratedKeys() && generatedKey.isPresent()) { return new GeneratedKeysResultSet(routeResult.getGeneratedKey().getGeneratedKeys().iterator(), generatedKey.get().getColumn().getName(), this); } if (1 == preparedStatementExecutor.getStatements().size()) { return preparedStatementExecutor.getStatements().iterator().next().getGeneratedKeys(); } return new GeneratedKeysResultSet(); }
@Override public ResultSetProxy statement_getGeneratedKeys(StatementProxy statement) throws SQLException { if (this.pos < filterSize) { return nextFilter().statement_getGeneratedKeys(this, statement); } ResultSet resultSet = statement.getRawObject().getGeneratedKeys(); if (resultSet == null) { return null; } return new ResultSetProxyImpl(statement, resultSet, dataSource.createResultSetId(), statement.getLastExecuteSql()); }