Retrieve column names from java sql ResultSet

Question

With java sql ResultSet is there a way to get a column s name as a String by using the column s index  I had a look through the API doc but I can t find anything

User · Answer

while  rs next         for  int j   1  j  lt  columncount  j             System out println  rsd getColumnName j           rs getString j

User · Answer

import java sql     public class JdbcGetColumnNames        public static void main String args              Connection con   null          Statement st   null          ResultSet rs   null           try               Class forName  com mysql jdbc Driver                con   DriverManager getConnection                       jdbc mysql   localhost 3306 komal    root    root                 st   con createStatement                 String sql    select   from person               rs   st executeQuery sql               ResultSetMetaData metaData   rs getMetaData                 int rowCount   metaData getColumnCount                 System out println  Table Name       metaData getTableName 2                System out println  Field   tDataType                 for  int i   0  i  lt  rowCount  i                      System out print metaData getColumnName i   1        t                    System out println metaData getColumnTypeName i   1                            catch  Exception e                System out println e                       Table Name   person Field   DataType id      VARCHAR cname   VARCHAR dob     DATE

User · Answer

The SQL statements that read data from a database query return the data in a result set  The SELECT statement is the standard way to select rows from a database and view them in a result set  The   java sql ResultSet   interface represents the result set of a database query    Get methods  used to view the data in the columns of the current row being pointed to by the cursor        Using MetaData of a result set to fetch the exact column count  ResultSet rs   stmt executeQuery  SELECT a  b  c FROM TABLE2    ResultSetMetaData rsmd   rs getMetaData    int numberOfColumns   rsmd getColumnCount    boolean b   rsmd isSearchable 1     http   docs oracle com javase 7 docs api java sql ResultSetMetaData html  and further more to bind it to data model table  public static void main String   args        Connection conn   null      Statement stmt   null      try             STEP 2  Register JDBC driver         Class forName  com mysql jdbc Driver               STEP 3  Open a connection         System out println  Connecting to a selected database               conn   DriverManager getConnection DB URL  USER  PASS           System out println  Connected database successfully                  STEP 4  Execute a query         System out println  Creating statement               stmt   conn createStatement             String sql    SELECT id  first  last  age FROM Registration           ResultSet rs   stmt executeQuery sql             STEP 5  Extract data from result set         while rs next                   Retrieve by column name             int id    rs getInt  id                int age   rs getInt  age                String first   rs getString  first                String last   rs getString  last                   Display values             System out print  ID      id               System out print    Age      age               System out print    First      first               System out println    Last      last                     rs close          catch SQLException se              Handle errors for JDBC         se printStackTrace          catch Exception e              Handle errors for Class forName         e printStackTrace          finally             finally block used to close resources         try               if stmt  null                  conn close              catch SQLException se                 do nothing         try               if conn  null                  conn close              catch SQLException se                se printStackTrace                end finally try        end try     System out println  Goodbye        end main   end JDBCExample   very nice tutorial here   http   www tutorialspoint com jdbc   ResultSetMetaData meta   resultset getMetaData        for a valid resultset object after executing query  Integer columncount   meta getColumnCount     int count   1      start counting from 1 always  String   columnNames   null   while columncount  lt  count        columnNames  i    meta getColumnName i      System out println  columnNames size        see the list and bind it to TableModel object  the to your jtbale setModel your table model

User · Answer

This question is old and so are the correct previous answers   But what I was looking for when I found this topic was something like this solution   Hopefully it helps someone      Loading required libraries     import java util    import java sql     public class MySQLExample     public void run String sql           JDBC driver name and database URL     String JDBC DRIVER    com mysql jdbc Driver       String DB URL    jdbc mysql   localhost demo           Database credentials     String USER    someuser      Fake of course      String PASS    somepass      This too       Statement stmt   null      ResultSet rs   null      Connection conn   null      Vector lt String gt  columnNames   new Vector lt String gt          try            Register JDBC driver       Class forName JDBC DRIVER             Open a connection       conn   DriverManager getConnection DB URL  USER  PASS             Execute SQL query       stmt   conn createStatement          rs   stmt executeQuery sql         if  rs    null            ResultSetMetaData columns   rs getMetaData            int i   0          while  i  lt  columns getColumnCount                i              System out print columns getColumnName i      t              columnNames add columns getColumnName i                      System out print   n             while  rs next                for  i   0  i  lt  columnNames size    i                  System out print rs getString columnNames get i                       t                           System out print   n                             catch  Exception e          System out println  Exception      e toString                finally         try           if  rs    null              rs close                      if  stmt    null              stmt close                      if  conn    null              conn close                      catch  Exception mysqlEx            System out println mysqlEx toString

User · Answer

I know  this question is already answered but probably somebody like me needs to access a column name from DatabaseMetaData by label instead of index   ResultSet resultSet   null  DatabaseMetaData metaData   null       try           metaData    connection getMetaData            resultSet   metaData getColumns null  null  tableName  null            while  resultSet next                 String name   resultSet getString  COLUMN NAME

User · Answer

You can get this info from the ResultSet metadata  See ResultSetMetaData  e g    ResultSet rs   stmt executeQuery  SELECT a  b  c FROM TABLE2     ResultSetMetaData rsmd   rs getMetaData     String name   rsmd getColumnName 1     and you can get the column name from there  If you do  select x as y from table   then rsmd getColumnLabel   will get you the retrieved label name too

User · Answer

You can use the the ResultSetMetaData  http   java sun com javase 6 docs api java sql ResultSetMetaData html  object for that  like this   ResultSet rs   stmt executeQuery  SELECT   FROM table    ResultSetMetaData rsmd   rs getMetaData    String firstColumnName   rsmd getColumnName 1

User · Answer

U can get column name and value from resultSet getMetaData    This code work for me   Connection conn   null  PreparedStatement preparedStatement   null      try           Class forName  com mysql cj jdbc Driver            conn   MySQLJDBCUtil getConnection            preparedStatement   conn prepareStatement sql           if  params    null                for  int i   0  i  lt  params size    i                      preparedStatement setObject i   1  params get i  getSqlValue                               ResultSet resultSet   preparedStatement executeQuery                ResultSetMetaData md   resultSet getMetaData                while  resultSet next                      int counter   md getColumnCount                    String colName     new String counter                   Map lt String  Object gt  field   new HashMap lt  gt                     for  int loop   1  loop  lt   counter  loop                          int index   loop - 1                      colName index    md getColumnLabel loop                       field put colName index   resultSet getObject colName index                                       rows add field                                 catch  SQLException e            e printStackTrace          finally           if  preparedStatement    null                try                   preparedStatement close                 catch  Exception e1                    e1 printStackTrace                                    if  conn    null                try                   conn close                  catch  SQLException e                    e printStackTrace                                      return rows

User · Answer

SQLite 3   Using getMetaData      DatabaseMetaData md   conn getMetaData    ResultSet rset   md getColumns null  null   your table name   null    System out println  your table name    while  rset next          System out println   t    rset getString 4        EDIT  This works with PostgreSQL as well

User · Answer

In addition to the above answers  if you re working with a dynamic query and you want the column names but do not know how many columns there are  you can use the ResultSetMetaData object to get the number of columns first and then cycle through them   Amending Brian s code   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  lt   columnCount  i         String name   rsmd getColumnName i        Do stuff with name

User · Answer

When you need the column names  but do not want to grab entries   PreparedStatement stmt   connection prepareStatement  SHOW COLUMNS FROM  yourTable      ResultSet set   stmt executeQuery       store all of the columns names List lt String gt  names   new ArrayList lt  gt     while  set next      names add set getString  Field         NOTE  Only works with MySQL

User · Answer

Cyntech is right   Incase your table is empty and you still need to get table column names you can get your column as type Vector see the following   ResultSet rs   stmt executeQuery  SELECT a  b  c FROM TABLE2    ResultSetMetaData rsmd   rs getMetaData    int columnCount   rsmd getColumnCount     Vector lt Vector lt String gt  gt tableVector   new Vector lt Vector lt String gt  gt      boolean isTableEmpty   true  int col   0    while rs next                isTableEmpty   false     set to false since rs next has data  this means the table is not empty        if col    columnCount                          for int x   1 x  lt   columnCount x                      Vector lt String gt  tFields   new Vector lt String gt                       tFields add rsmd getColumnName x  toString                      tableVector add tFields                              col   columnCount                                if table is empty then get column names only   if isTableEmpty           for int x 1 x lt  colCount x                Vector lt String gt  tFields   new Vector lt String gt                 tFields add rsmd getColumnName x  toString                tableVector add tFields                       rs close     stmt close      return tableVector

User · Answer

If you want to use spring jdbctemplate and don t want to deal with connection staff  you can use following   jdbcTemplate query  select   from books   new RowCallbackHandler             public void processRow ResultSet resultSet  throws SQLException               ResultSetMetaData rsmd   resultSet getMetaData                for  int i   1  i  lt   rsmd getColumnCount    i                       String name   rsmd getColumnName i                      Do stuff with name

User · Answer

ResultSet rsTst   hiSession connection   prepareStatement queryStr  executeQuery     ResultSetMetaData meta   rsTst getMetaData    int columnCount   meta getColumnCount       The column count starts from 1  String nameValuePair       while  rsTst next          for  int i   1  i  lt  columnCount   1  i               String name   meta getColumnName i              Do stuff with name          String value   rsTst getString i      getObject 1           nameValuePair   nameValuePair   name        value                  nameValuePair   nameValuePair                   nameValuePair   nameValuePair          t

[java] Retrieve column names from java.sql.ResultSet

Examples related to java

Examples related to jdbc