Getting the Column Names in a Result Set
try {
// Create a result set
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM my_table");
// Get result set meta data
ResultSetMetaData rsmd = rs.getMetaData();
int numColumns = rsmd.getColumnCount();
// Get the column names; column indices start from 1
for (int i=1; i<numColumns+1; i++) {
String columnName = rsmd.getColumnName(i);
// Get the name of the column's table name
String tableName = rsmd.getTableName(i);
}
} catch (SQLException e) {
}
it is very useful thanks men
nice! thank you
good
one useful code sample :)
nice !
need more explaination
Thanks a lot :)
This great, but how can you get the data type returned from an Access database using java?