Getting the Column Names in a Result Set : ResultSetMetaData « Database SQL JDBC « Java






  1. Java
  2. Database SQL JDBC
  3. ResultSetMetaData

Getting the Column Names in a Result Set

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; publicclass Main { publicstaticvoid main(String[] argv) throws Exception { String driverName = "com.jnetdirect.jsql.JSQLDriver"; Class.forName(driverName); String serverName = "127.0.0.1"; String portNumber = "1433"; String mydatabase = serverName + ":" + portNumber; String url = "jdbc:JSQLConnect://" + mydatabase; String username = "username"; String password = "password"; Connection connection = DriverManager.getConnection(url, username, password); Statement stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM mysql_all_table"); ResultSetMetaData rsmd = rs.getMetaData(); int numColumns = rsmd.getColumnCount(); for (int i = 1; i < numColumns + 1; i++) { String columnName = rsmd.getColumnName(i); String tableName = rsmd.getTableName(i); } } }








Related examples in the same category

1.Create Custom RowSet MetaData
2.Get ResultSet Metadata
3.Get Table Schema Name From ResultSet Metadata
4.Get Table Name From ResultSet Metadata
5.ResultSet Metadata from Oracle Driver
close