Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(query); ResultSetMetaData rsmd = rs.getMetaData(); int columnsNumber = rsmd.getColumnCount();
ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM TABLE2"); ResultSetMetaData rsmd = rs.getMetaData(); int columnCount = rsmd.getColumnCount(); // The column count starts from 1 for (int i = 1; i <= columnCount; i++ ) { String name = rsmd.getColumnName(i); // Do stuff with name }
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; }
private Iterator<QueryRow> getResultData(final ResultSet resultSet) throws SQLException { Collection<QueryRow> result = new LinkedList<>(); while (resultSet.next()) { List<Object> rowData = new ArrayList<>(columnLabelAndIndexMap.size()); for (int columnIndex = 1; columnIndex <= resultSet.getMetaData().getColumnCount(); columnIndex++) { rowData.add(resultSet.getObject(columnIndex)); } result.add(new QueryRow(rowData)); } return result.iterator(); }
@Override public E handle(ResultSet rs) throws SQLException { final ResultSetMetaData meta = rs.getMetaData(); final int columnCount = meta.getColumnCount(); return rs.next() ? HandleHelper.handleRow(columnCount, meta, rs, this.elementBeanType) : null; } }
@ExpectWarning("SQL") public void test0noloop(ResultSet rs) throws SQLException { ResultSetMetaData rsmd = rs.getMetaData(); int numCols = rsmd.getColumnCount(); if (numCols > 0) { String s = rs.getString(0); // error: first column is 1 System.out.println(s); } }
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);
public Object[] getData() throws SQLException { final int dataColumnCount = resultSet.getMetaData().getColumnCount() - (COL_DATA - 1); final Object[] data = new Object[dataColumnCount]; for (int i = 0; i < dataColumnCount; i++) { data[i] = resultSet.getObject(COL_DATA + i); } return data; }
private void printResultSetMetaData(ResultSet rs) throws SQLException { ResultSetMetaData metadata = rs.getMetaData(); System.out.println("Metadata:"); for (int i = 0; i < metadata.getColumnCount(); i++) { String metaStr = metadata.getCatalogName(i + 1) + " " + metadata.getColumnClassName(i + 1) + " " + metadata.getColumnDisplaySize(i + 1) + " " + metadata.getColumnLabel(i + 1) + " " + metadata.getColumnName(i + 1) + " " + metadata.getColumnType(i + 1) + " " + metadata.getColumnTypeName(i + 1) + " " + metadata.getPrecision(i + 1) + " " + metadata.getScale(i + 1) + " " + metadata.getSchemaName(i + 1) + " " + metadata.getTableName(i + 1); System.out.println(metaStr); } } }
ResultSetMetaData metaData = resultSet.getMetaData(); int count = metaData.getColumnCount(); for (int i = 1; i <= count; i++) { if (metaData.getColumnName(i).equals(desiredColumnName)) { // Whatever you want to do here. } }
public List resultSetToArrayList(ResultSet rs) throws SQLException{ ResultSetMetaData md = rs.getMetaData(); int columns = md.getColumnCount(); ArrayList list = new ArrayList(50); while (rs.next()){ HashMap row = new HashMap(columns); for(int i=1; i<=columns; ++i){ row.put(md.getColumnName(i),rs.getObject(i)); } list.add(row); } return list; }
@Override public Entity handle(ResultSet rs) throws SQLException { final ResultSetMetaData meta = rs.getMetaData(); final int columnCount = meta.getColumnCount(); return rs.next() ? HandleHelper.handleRow(columnCount, meta, rs) : null; } }
@ExpectWarning("SQL") public void test0(ResultSet rs) throws SQLException { ResultSetMetaData rsmd = rs.getMetaData(); int numCols = rsmd.getColumnCount(); for (int i = 0; i < numCols; i++) { System.out.print("i = [" + i + "] "); String s = rs.getString(i); System.out.println(s); } }
private Set<String> getColumnNames(ResultSet res) { try { Set<String> columnNames = new HashSet<>(); ResultSetMetaData meta = res.getMetaData(); int numCol = meta.getColumnCount(); for (int i = 1; i < numCol + 1; i++) { columnNames.add(meta.getColumnLabel(i).toLowerCase()); } return columnNames; } catch (Exception e) { throw new IllegalStateException("Fail to get column names"); } }
public static void createColumnIfNotExist(Connection conn) throws SQLException { ResultSetMetaData metaData = conn.createStatement().executeQuery("SELECT * FROM STAGES").getMetaData(); for (int i = 1; i <= metaData.getColumnCount(); i++) { String columnName = metaData.getColumnName(i); if (columnName.toLowerCase().equals("artifactsdeleted")) { return; } } conn.createStatement().executeUpdate("ALTER TABLE STAGES ADD COLUMN `ARTIFACTSDELETED` Boolean DEFAULT FALSE NOT NULL"); } }
@Test(expected = TypeMismatchDataAccessException.class) // SPR-16483 public void doesNotUseConversionService() throws SQLException { SingleColumnRowMapper<LocalDateTime> rowMapper = SingleColumnRowMapper.newInstance(LocalDateTime.class, null); ResultSet resultSet = mock(ResultSet.class); ResultSetMetaData metaData = mock(ResultSetMetaData.class); given(metaData.getColumnCount()).willReturn(1); given(resultSet.getMetaData()).willReturn(metaData); given(resultSet.getObject(1, LocalDateTime.class)) .willThrow(new SQLFeatureNotSupportedException()); given(resultSet.getTimestamp(1)).willReturn(new Timestamp(0)); rowMapper.mapRow(resultSet, 1); }
/** * Implementation of ResultSetCallbackHandler. * Work out column size if this is the first row, otherwise just count rows. * <p>Subclasses can perform custom extraction or processing * by overriding the {@code processRow(ResultSet, int)} method. * @see #processRow(java.sql.ResultSet, int) */ @Override public final void processRow(ResultSet rs) throws SQLException { if (this.rowCount == 0) { ResultSetMetaData rsmd = rs.getMetaData(); this.columnCount = rsmd.getColumnCount(); this.columnTypes = new int[this.columnCount]; this.columnNames = new String[this.columnCount]; for (int i = 0; i < this.columnCount; i++) { this.columnTypes[i] = rsmd.getColumnType(i + 1); this.columnNames[i] = JdbcUtils.lookupColumnName(rsmd, i + 1); } // could also get column names } processRow(rs, this.rowCount++); }
@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; }
@Override protected void resultSetOpenAfter(ResultSetProxy resultSet) { if (resultSetOpenAfterLogEnable && isResultSetLogEnabled()) { try { StringBuffer buf = new StringBuffer(); buf.append("{conn-"); buf.append(resultSet.getStatementProxy().getConnectionProxy().getId()); buf.append(", "); buf.append(stmtId(resultSet)); buf.append(", rs-"); buf.append(resultSet.getId()); buf.append("}"); String resultId = buf.toString(); resultSetLog(resultId + " open"); buf.append(" Header: ["); ResultSetMetaData meta = resultSet.getMetaData(); for (int i = 0, size = meta.getColumnCount(); i < size; ++i) { if (i != 0) { buf.append(", "); } buf.append(meta.getColumnName(i + 1)); } buf.append("]"); resultSetLog(buf.toString()); } catch (SQLException ex) { resultSetLogError("logging error", ex); } } }
public List<Map> selectByParams(String sql, List params) throws SQLException { List<Map> list = new ArrayList<> (); int index = 1; pstmt = conn.prepareStatement(sql); if (null != params && !params.isEmpty()) { for (int i = 0; i < params.size(); i ++) { pstmt.setObject(index++, params.get(i)); } } rs = pstmt.executeQuery(); ResultSetMetaData metaData = rs.getMetaData(); int colsLen = metaData.getColumnCount(); while (rs.next()) { Map map = new HashMap(colsLen); for (int i = 0; i < colsLen; i ++) { String columnName = metaData.getColumnName(i + 1); Object columnValue = rs.getObject(columnName); if (null == columnValue) { columnValue = ""; } map.put(columnName, columnValue); } list.add(map); } return list; }