在一个数据库查询中,怎么获取select * from table 中的列名??

[flowerbacket]

在一个数据库查询中,怎么获取select * from table 中的列名??

[luckyfanjian]

元数据！就可以！

[pleonheart]

什么是元数据？

[joyrush]

ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM TABLE2");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
boolean b = rsmd.isSearchable(1);

[flowerbacket]

我要输出

a, b , c

还有当 sql = SELECT * FROM TABLE2的时候. 把其他也输出..

怎么写?

[flowerbacket]

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) {
}

[flowerbacket]

我懂拉..~~..