方法:
* getColumnCount()
获得 ResultSet 中的列数。
* getColumnName(int)
获得列名。
举例:
this.ps = this.conn.prepareStatement(sql);
if (params != null)
{
for (int i = 0; i < params.length; i++)
{
this.ps.setObject(i + 1, params[i]);
}
}
ArrayList<HashMap<String, Object>> arrayResult = new ArrayList<HashMap<String, Object>>();
ResultSet result = null;
try
{
result = this.ps.executeQuery();
ResultSetMetaData meta = result.getMetaData();
while (result.next())
{
HashMap<String, Object> row = new HashMap<String, Object>();
for (int i = 1; i <= meta.getColumnCount(); i++)
{
row.put(meta.getColumnName(i), result.getObject(i));
}
arrayResult.add(row);
}
}
finally
{
if (result != null)
{
result.close();
}
}
return arrayResult;