ResultSet rs = stmt.executeQuery("SELECT * FROM TABLENAME");
ResultSetMetaData md = rs.getMetaData();
for (int i = 1; i <= md.getColumnCount(); i++){
System.out.println(md.getColumnName(i));
}
public String[] getColumnNames(String tblName) {
String[] arr = null;
String query = "Select * from " + tblName;
ResultSet rs = null;
try {
rs = getObjekte(query); //Methode für die Abfrage, query ist die SQL-Abfrage
ResultSetMetaData rsmd = rs.getMetaData();
arr = new String[rsmd.getColumnCount()];
for (int i = 0; i < rsmd.getColumnCount(); i++) {
arr[i] = rsmd.getColumnName(i);
}
} catch (SQLException ex) {
Logger.getLogger(DBConn.class.getName()).log(Level.SEVERE, null, ex);
}
return arr;
}
>Exception occurred in target VM: Column index out of range.
Select * From Information_Schema.Columns