Retrieve column names from java.sql.ResultSet

by

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.

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. Connection pooling options with JDBC: DBCP vs C3P0 [closed]
  3. ClassNotFoundException com.mysql.jdbc.Driver [duplicate]
  4. Efficient way to do batch INSERTS with JDBC
  5. Java: Insert multiple rows into MySQL with PreparedStatement
  6. Is it possible to specify the schema when connecting to postgres with JDBC?
  7. Named parameters in JDBC [duplicate]
  8. Get query from java.sql.PreparedStatement [duplicate]
  9. How does a PreparedStatement avoid or prevent SQL injection?
  10. ResultSet to Pagination
  11. Closing JDBC Connections in Pool
  12. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  13. How to get a value from the last inserted row? [duplicate]
  14. How to enable logging for SQL statements when using JDBC
  15. SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  16. Difference between Oracle jdbc driver classes?
  17. Writing a large resultset to an Excel file using POI
  18. Retrieve an Image stored as BLOB on a MYSQL DB
  19. UNIX socket implementation for Java? [closed]
  20. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  21. Spring-Boot: How do I set JDBC pool properties like maximum number of connections?
  22. mysql prepared statement error: MySQLSyntaxErrorException
  23. Call an Oracle function from Java
  24. How to get the number of columns from a JDBC ResultSet?
  25. Resultset To List
  26. How do you enforce foreign key constraints in SQLite through Java?
  27. Why do we use a DataSource instead of a DriverManager?
  28. Do I need to close ‘PreparedStatement’? [closed]
  29. Database independence through JDBC in java
  30. java.sql.SQLException: No database selected – why?

Leave a Comment