@Override public String getColumnLabel(final int columnIndex) throws SQLException { return resultSet.getMetaData().getColumnLabel(columnIndex); } }
private Multimap<String, Integer> getMetaData(final ResultSetMetaData resultSetMetaData) throws SQLException { Multimap<String, Integer> result = HashMultimap.create(); for (int columnIndex = 1; columnIndex <= resultSetMetaData.getColumnCount(); columnIndex++) { result.put(resultSetMetaData.getColumnLabel(columnIndex), columnIndex); } return result; }
public static List<Map<String,?>> extractResults(ResultSet resultSet) throws SQLException { List<Map<String,?>> results = new ArrayList<Map<String, ?>>(); while ( resultSet.next() ) { Map<String,Object> row = new HashMap<String, Object>(); for ( int i = 1; i <= resultSet.getMetaData().getColumnCount(); i++ ) { row.put( resultSet.getMetaData().getColumnLabel( i ), resultSet.getObject( i ) ); results.add( row ); } } return results; } }
@Override public String toString() { try { ResultSetMetaData rsMetaData = rs.getMetaData(); StringBuilder sb = new StringBuilder(); for (int i = 1; i <= rsMetaData.getColumnCount(); i++) { if (i > 1) { sb.append(","); } sb.append(rsMetaData.getColumnLabel(i).toLowerCase()); sb.append("="); sb.append(rs.getObject(i)); } return sb.toString(); } catch (Exception e) { return "Unavailable: " + e.getMessage(); } } }
assertTrue( "DatabaseMetaData.getColumns(...) returned no rows", columns.next() ); columns.getMetaData().getColumnLabel( 5 ), equalTo( "DATA_TYPE" ) ); equalTo( Types.VARCHAR ) ) ); } while ( columns.next() );
protected CatoDataObject nextDataObject() throws Exception { if (!this.rset.next()) { return null; } CatoDataObject dataObject = this.createDataObject(); for (int i = 1; i < this.rsetmd.getColumnCount() + 1; i++) { dataObject.setValue(this.rsetmd.getColumnLabel(i), this.rset.getObject(i)); } return dataObject; }
public ResultSetRecordSet(final ResultSet rs, final RecordSchema readerSchema) throws SQLException { this.rs = rs; moreRows = rs.next(); this.schema = createSchema(rs, readerSchema); rsColumnNames = new HashSet<>(); final ResultSetMetaData metadata = rs.getMetaData(); for (int i = 0; i < metadata.getColumnCount(); i++) { rsColumnNames.add(metadata.getColumnLabel(i + 1)); } }
/** * Returns the name of all the columns present in the specified {@link ResultSet} * * @param rs the {@link ResultSet} to get the column names of * @return list of all the column names in {@code rs} (will contain duplicates if multiple columns have the same name) * @throws SQLException See {@link ResultSet#getMetaData()}, {@link ResultSetMetaData#getColumnCount()}, * and {@link ResultSetMetaData#getColumnLabel(int)} */ public static List<String> getColumnNames(ResultSet rs) throws SQLException { final ResultSetMetaData metadata = rs.getMetaData(); final int count = metadata.getColumnCount(); final List<String> columnNames = new ArrayList<>(count); for (int i = 0; i < count; ++i) { columnNames.add(metadata.getColumnLabel(i + 1).toLowerCase()); } return columnNames; }
if (resultSet.next()) { ResultSetMetaData rsmd = resultSet.getMetaData(); int i = 2; for (; i <= numMaxValueColumns + 1; i++) { String resultColumnName = (StringUtils.isNotEmpty(rsmd.getColumnLabel(i)) ? rsmd.getColumnLabel(i) : rsmd.getColumnName(i)).toLowerCase(); String fullyQualifiedStateKey = getStateKey(tableName, resultColumnName, dbAdapter); String resultColumnCurrentMax = statePropertyMap.get(fullyQualifiedStateKey);
@Override public int getColumnCount() throws SQLException { int result = 0; for (int columnIndex = 1; columnIndex <= resultSetMetaData.getColumnCount(); columnIndex++) { if (!DerivedColumn.isDerivedColumn(resultSetMetaData.getColumnLabel(columnIndex))) { result++; } } return result; }
private int[] findMaxLength(ResultSet resultSet) throws SQLException { ResultSetMetaData rsmd = resultSet.getMetaData(); int columnCount = rsmd.getColumnCount(); int[] columnSizes = new int[columnCount + 1]; for (int i = 1; i <= columnCount; i++) { columnSizes[i] = Math.max(columnSizes[i], rsmd.getColumnLabel(i).length()); } while (resultSet.next()) { for (int i = 1; i <= columnCount; i++) { String value = resultSet.getString(i); if (value != null) columnSizes[i] = Math.max(columnSizes[i], value.length()); } } resultSet.beforeFirst(); return columnSizes; }
private static List<String> getColumnNames(ResultSet rs, UnaryOperator<String> caseChange) throws SQLException { // important: ordered and unique Set<String> columnNames = new LinkedHashSet<>(); ResultSetMetaData meta = rs.getMetaData(); int columnCount = meta.getColumnCount(); for (int i = 0; i < columnCount; i++) { String columnName = meta.getColumnName(i + 1); String alias = meta.getColumnLabel(i + 1); String name = caseChange.apply(alias == null ? columnName : alias); boolean added = columnNames.add(name); if (!added) { throw new RuntimeException("column " + name + " appeared twice in this resultset!"); } } return new ArrayList<>(columnNames); } }
dbMetadata.getColumns( null, "INFORMATION_SCHEMA", "COLUMNS", "ORDINAL_POSITION" ); assertTrue( "DatabaseMetaData.getColumns(...) returned no rows", columns.next() ); columns.getMetaData().getColumnLabel( 6 ), equalTo( "TYPE_NAME" ) );
List<Map<String, Object>> rows = new ArrayList<Map<String, Object>>(); ResultSetMetaData metaData = resultSet.getMetaData(); int columnCount = metaData.getColumnCount(); while (resultSet.next()) { Map<String, Object> columns = new LinkedHashMap<String, Object>(); for (int i = 1; i <= columnCount; i++) { columns.put(metaData.getColumnLabel(i), resultSet.getObject(i)); } rows.add(columns); }
public static List<Map<String, Object>> executeQuery(Connection conn, String sql, List<Object> parameters) throws SQLException { List<Map<String, Object>> rows = new ArrayList<Map<String, Object>>(); PreparedStatement stmt = null; ResultSet rs = null; try { stmt = conn.prepareStatement(sql); setParameters(stmt, parameters); rs = stmt.executeQuery(); ResultSetMetaData rsMeta = rs.getMetaData(); while (rs.next()) { Map<String, Object> row = new LinkedHashMap<String, Object>(); for (int i = 0, size = rsMeta.getColumnCount(); i < size; ++i) { String columName = rsMeta.getColumnLabel(i + 1); Object value = rs.getObject(i + 1); row.put(columName, value); } rows.add(row); } } finally { JdbcUtils.close(rs); JdbcUtils.close(stmt); } return rows; }
this.resultSet = resultSet; try { this.rowSetMetaData = new ResultSetWrappingSqlRowSetMetaData(resultSet.getMetaData()); ResultSetMetaData rsmd = resultSet.getMetaData(); if (rsmd != null) { int columnCount = rsmd.getColumnCount(); this.columnLabelMap = new HashMap<>(columnCount); for (int i = 1; i <= columnCount; i++) { String key = rsmd.getColumnLabel(i);
private static List<String> getMapKeys(ResultSetMetaData meta, UnaryOperator<String> caseChange) throws SQLException { // important: ordered, not sorted, and unique Set<String> names = new LinkedHashSet<>(); int columnCount = meta.getColumnCount(); for (int i = 0; i < columnCount; i++) { String columnName = meta.getColumnName(i + 1); String columnLabel = meta.getColumnLabel(i + 1); String key = columnLabel == null ? columnName : columnLabel; String renamedKey = caseChange.apply(key); boolean added = names.add(renamedKey); if (!added) { throw new RuntimeException(String.format("map key \"%s\" (from column \"%s\") appears twice in this resultset!", renamedKey, key)); } } return new ArrayList<>(names); } }
public Collection<Permission> executePermissionsQuery() throws SQLException, ClassNotFoundException { List<Permission> result = new LinkedList<>(); if (query != null) { try { try (ResultSet resultSet = statement.executeQuery()) { ResultSetMetaData resultMetaData = resultSet.getMetaData(); while (resultSet.next()) { LinkedHashMap<String, Long> map = new LinkedHashMap<>(); for (int i = 1; i <= resultMetaData.getColumnCount(); i++) { String label = resultMetaData.getColumnLabel(i); map.put(label, resultSet.getLong(label)); } result.add(new Permission(map)); } } } finally { statement.close(); connection.close(); } } return result; }
/** * 获得结果集的所有列名 * * @param rs 结果集 * @return 列名数组 * @throws DbRuntimeException SQL执行异常 */ public static String[] getColumnNames(ResultSet rs) throws DbRuntimeException { try { ResultSetMetaData rsmd = rs.getMetaData(); int columnCount = rsmd.getColumnCount(); String[] labelNames = new String[columnCount]; for (int i = 0; i < labelNames.length; i++) { labelNames[i] = rsmd.getColumnLabel(i + 1); } return labelNames; } catch (Exception e) { throw new DbRuntimeException("Get colunms error!", e); } }
private int getIndexForName(String parameterName) throws SQLException { try { checkClosed(); if (namedParameters == null) { ResultSetMetaData meta = getCheckedMetaData(); int columnCount = meta.getColumnCount(); HashMap<String, Integer> map = new HashMap<>(columnCount); for (int i = 1; i <= columnCount; i++) { map.put(meta.getColumnLabel(i), i); } namedParameters = map; } Integer index = namedParameters.get(parameterName); if (index == null) { throw DbException.getInvalidValueException("parameterName", parameterName); } return index; } catch (Exception e) { throw logAndConvert(e); } }