ResultSetMetaData rsmd = rs.getMetaData();//rs为查询结果集
rsmd.getColumnName(i)
这两句是关键代码
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query);
/** getColumnCount 是列名的数量 **/
ResultSetMetaData rsmd = rs.getMetaData();//rs为查询结果集
int count = rsmd.getColumnCount();
/**
* 将查询结果集放进HashMap<Integer, StudentBean>, list添加封装好的map,
* 返回List
*/
while (rs.next())
{
map = new HashMap<String, String>();
for (int i = 1; i <= count; i++)
{
String columnName = rsmd.getColumnName(i);//getColumnName()函数取得列名,
map.put(columnName, rs.getString(columnName));