How to get the number of columns from a JDBC ResultSet?

by

You can get columns number from ResultSetMetaData:

Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();

int columnsNumber = rsmd.getColumnCount();

More Related Contents:

  1. How do I get the size of a java.sql.ResultSet?
  2. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  3. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  4. JDBC driver throws “ResultSet Closed” exception on empty ResultSet
  5. JDBC ResultSet get columns with table alias
  6. Execute anonymous pl/sql block and get resultset in java
  7. ResultSet: Retrieving column values by index versus retrieving by label
  8. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  9. How to get row count using ResultSet in Java?
  10. How do I get the row count in JDBC?
  11. Convert a Result Set from SQL Array to Array of Strings
  12. Efficient way to do batch INSERTS with JDBC
  13. What is the actual use of Class.forName(“oracle.jdbc.driver.OracleDriver”) while connecting to a database?
  14. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  15. java.sql.SQLException: Exhausted Resultset
  16. CSV parsing in Java – working example..? [closed]
  17. Parsing CSV in java
  18. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  19. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  20. oracle.jdbc.driver.OracleDriver ClassNotFoundException
  21. Populating jTable using database data
  22. How to simulate a DB for testing (Java)?
  23. Cannot find Main Class in File Compiled With Ant
  24. Using a prepared statement and variable bind Order By in Java with JDBC driver
  25. ResultSet: Exception: set type is TYPE_FORWARD_ONLY — why?
  26. Reading CSV File In Android App
  27. Resultset To List
  28. How do you enforce foreign key constraints in SQLite through Java?
  29. How to connect to a remote MySQL database with Java?
  30. How to get jdbc connection from hibernate session? [duplicate]

Leave a Comment