For IntelliJ IDEA and
Android Studio


private void myMethod () {ResultSet r =
PreparedStatement ps;ps.executeQuery()
Statement stmt;stmt.executeQuery(sql)
Statement statement;statement.getResultSet()
- AI code suggestions by Codota
}
private <T> T queryAndGet(String sql, int columnIndex) { try (Statement statement = connection.createStatement()) { ResultSet rs = statement.executeQuery(sql); if (!rs.next()) return null; byte[] bytes = rs.getBytes(columnIndex); return deserialize(bytes); } catch (SQLException e) { throw new RuntimeException(e); } }
private byte[] fetch() { try { prep.setInt(2, seq++); ResultSet rs = prep.executeQuery(); if (rs.next()) { return rs.getBytes(1); } return null; } catch (SQLException e) { throw DbException.convert(e); } }
public Xid[] recover(int flag) throws XAException { return recover(this.underlyingConnection, flag); }
protected void getBatchedGeneratedKeys(java.sql.Statement batchedStatement) throws SQLException { synchronized (checkClosed().getConnectionMutex()) { if (this.retrieveGeneratedKeys) { java.sql.ResultSet rs = null; try { rs = batchedStatement.getGeneratedKeys(); while (rs.next()) { this.batchedGeneratedKeys.add(new ByteArrayRow(new byte[][] { rs.getBytes(1) }, getExceptionInterceptor())); } } finally { if (rs != null) { rs.close(); } } } } }
/** * Compute split-per-shard (separate split for each shard). */ private BucketShards compute() throws SQLException { if (!resultSet.next()) { return endOfData(); } UUID shardUuid = uuidFromBytes(resultSet.getBytes("shard_uuid")); Set<String> nodeIdentifiers; OptionalInt bucketNumber = OptionalInt.empty(); if (bucketToNode != null) { int bucket = resultSet.getInt("bucket_number"); bucketNumber = OptionalInt.of(bucket); nodeIdentifiers = ImmutableSet.of(getBucketNode(bucket)); } else { List<Integer> nodeIds = intArrayFromBytes(resultSet.getBytes("node_ids")); nodeIdentifiers = getNodeIdentifiers(nodeIds, shardUuid); } ShardNodes shard = new ShardNodes(shardUuid, nodeIdentifiers); return new BucketShards(bucketNumber, ImmutableSet.of(shard)); }
String imageName = request.getPathInfo().substring(1); // Returns "foo.png". try (Connection connection = dataSource.getConnection(); PreparedStatement statement = connection.prepareStatement(SQL_FIND)) { statement.setString(1, imageName); try (ResultSet resultSet = statement.executeQuery()) { if (resultSet.next()) { byte[] content = resultSet.getBytes("content"); response.setContentType(getServletContext().getMimeType(imageName)); response.setContentLength(content.length);
/** * Compute split-per-bucket (single split for all shards in a bucket). */ private BucketShards computeMerged() throws SQLException { if (resultSet.isAfterLast()) { return endOfData(); } if (first) { first = false; if (!resultSet.next()) { return endOfData(); } } int bucketNumber = resultSet.getInt("bucket_number"); ImmutableSet.Builder<ShardNodes> shards = ImmutableSet.builder(); do { UUID shardUuid = uuidFromBytes(resultSet.getBytes("shard_uuid")); int bucket = resultSet.getInt("bucket_number"); Set<String> nodeIdentifiers = ImmutableSet.of(getBucketNode(bucket)); shards.add(new ShardNodes(shardUuid, nodeIdentifiers)); } while (resultSet.next() && resultSet.getInt("bucket_number") == bucketNumber); return new BucketShards(OptionalInt.of(bucketNumber), shards.build()); }
@Override public List<StatusType> getInactiveStatusesSince(DateTime timestamp, @Nullable Integer maxNumStatuses) { return getConnector().retryWithHandle( handle -> { final Query<Map<String, Object>> query = createInactiveStatusesSinceQuery(handle, timestamp, maxNumStatuses); return query .map( (ResultSetMapper<StatusType>) (index, r, ctx) -> { try { return getJsonMapper().readValue( r.getBytes("status_payload"), getStatusType() ); } catch (IOException e) { log.makeAlert(e, "Failed to parse status payload") .addData("entry", r.getString("id")) .emit(); throw new SQLException(e); } } ).list(); } ); }
private synchronized void extractDefaultValues() throws SQLException { java.sql.DatabaseMetaData dbmd = this.getConnection().getMetaData(); this.defaultColumnValue = new byte[this.getMetadata().getFields().length][]; java.sql.ResultSet columnsResultSet = null; for (Map.Entry<String, Map<String, Map<String, Integer>>> dbEntry : this.databasesUsedToTablesUsed.entrySet()) { for (Map.Entry<String, Map<String, Integer>> tableEntry : dbEntry.getValue().entrySet()) { String tableName = tableEntry.getKey(); Map<String, Integer> columnNamesToIndices = tableEntry.getValue(); try { columnsResultSet = dbmd.getColumns(this.catalog, null, tableName, "%"); while (columnsResultSet.next()) { String columnName = columnsResultSet.getString("COLUMN_NAME"); byte[] defaultValue = columnsResultSet.getBytes("COLUMN_DEF"); if (columnNamesToIndices.containsKey(columnName)) { int localColumnIndex = columnNamesToIndices.get(columnName).intValue(); this.defaultColumnValue[localColumnIndex] = defaultValue; } // else assert? } } finally { if (columnsResultSet != null) { columnsResultSet.close(); columnsResultSet = null; } } } } }
PreparedStatement prep = prepare(sql); prep.setLong(1, block); ResultSet rs = prep.executeQuery(); if (!rs.next()) { throw DbException.get(ErrorCode.IO_EXCEPTION_1, "Missing lob entry, block: " + block) byte[] buffer = rs.getBytes(2); if (compressed != 0) { buffer = compress.expand(buffer);
protected void getBatchedGeneratedKeys(int maxKeys) throws SQLException { synchronized (checkClosed().getConnectionMutex()) { if (this.retrieveGeneratedKeys) { java.sql.ResultSet rs = null; try { if (maxKeys == 0) { rs = getGeneratedKeysInternal(); } else { rs = getGeneratedKeysInternal(maxKeys); } while (rs.next()) { this.batchedGeneratedKeys.add(new ByteArrayRow(new byte[][] { rs.getBytes(1) }, getExceptionInterceptor())); } } finally { this.isImplicitlyClosingResults = true; try { if (rs != null) { rs.close(); } } finally { this.isImplicitlyClosingResults = false; } } } } }
try { connection = connectionProvider.getConnection(); try (PreparedStatement preparedStatement = connection.prepareStatement(sqlQuery)) { if (queryTimeoutSecs > 0) { preparedStatement.setQueryTimeout(queryTimeoutSecs); try (ResultSet resultSet = preparedStatement.executeQuery()) { List<List<Column>> rows = Lists.newArrayList(); while (resultSet.next()) { ResultSetMetaData metaData = resultSet.getMetaData(); int columnCount = metaData.getColumnCount(); Class columnJavaType = Util.getJavaType(columnType); if (columnJavaType.equals(String.class)) { row.add(new Column<String>(columnLabel, resultSet.getString(columnLabel), columnType)); } else if (columnJavaType.equals(Integer.class)) { row.add(new Column<Integer>(columnLabel, resultSet.getInt(columnLabel), columnType)); row.add(new Column<Boolean>(columnLabel, resultSet.getBoolean(columnLabel), columnType)); } else if (columnJavaType.equals(byte[].class)) { row.add(new Column<byte[]>(columnLabel, resultSet.getBytes(columnLabel), columnType)); } else if (columnJavaType.equals(Long.class)) { row.add(new Column<Long>(columnLabel, resultSet.getLong(columnLabel), columnType));
PreparedStatement prep = prepare(sql); prep.setLong(1, block); ResultSet rs = prep.executeQuery(); if (rs.next()) { boolean compressed = rs.getInt(1) != 0; byte[] compare = rs.getBytes(2); if (compressed == (compressAlgorithm != null) && Arrays.equals(b, compare)) { blockExists = true;
result = getCurrentResultSet().getDouble(columnIndex); } else if (String.class == type) { result = getCurrentResultSet().getString(columnIndex); } else if (BigDecimal.class == type) { result = getCurrentResultSet().getBigDecimal(columnIndex); } else if (byte[].class == type) { result = getCurrentResultSet().getBytes(columnIndex); } else if (Date.class == type) { result = getCurrentResultSet().getDate(columnIndex);
while (results.next()) { TypeDescriptor typeDesc = new TypeDescriptor(results.getString("Type"), results.getString("Null")); byte[][] rowVal = new byte[8][]; rowVal[0] = null; // SCOPE is not used rowVal[1] = results.getBytes("Field"); // COLUMN_NAME rowVal[2] = Short.toString((short) typeDesc.mysqlType.getJdbcType()).getBytes(); // DATA_TYPE rowVal[3] = s2b(typeDesc.mysqlType.getName()); // TYPE_NAME
while (results.next()) { String keyType = results.getString("Key"); byte[][] rowVal = new byte[8][]; rowVal[0] = Integer.toString(java.sql.DatabaseMetaData.bestRowSession).getBytes(); rowVal[1] = results.getBytes("Field"); String type = results.getString("Type"); int size = stmt.getMaxFieldSize(); int decimals = 0;
while (rs.next()) { RowDataPacket curRow = new RowDataPacket(colunmCount); for (int i = 0; i < colunmCount; i++) { int j = i + 1; if(MysqlDefs.isBianry((byte) fieldPks.get(i).type)) { curRow.add(rs.getBytes(j)); } else if(fieldPks.get(i).type == MysqlDefs.FIELD_TYPE_DECIMAL || fieldPks.get(i).type == (MysqlDefs.FIELD_TYPE_NEW_DECIMAL - 256)) { // field type is unsigned byte sc.getCharset())); } else { curRow.add(StringUtil.encode(rs.getString(j), sc.getCharset()));