ResultSet result = sta.executeQuery(sqlStr);
ResultSetMetaData reMeta = result.getMetaData();
int columnCount = reMeta.getColumnCount();
HashMap signRecord = null;
String columnName = null;
while(result.next())
{
signRecord = new HashMap();
for(int i=1;i<=columnCount;i++)
{
columnName = reMeta.getColumnName(i);
signRecord.put(columnName,result.getObject(i));
}
resultList.add(signRecord);
}
result.close();
ResultSetMetaData reMeta = result.getMetaData();
int columnCount = reMeta.getColumnCount();
HashMap signRecord = null;
String columnName = null;
while(result.next())
{
signRecord = new HashMap();
for(int i=1;i<=columnCount;i++)
{
columnName = reMeta.getColumnName(i);
signRecord.put(columnName,result.getObject(i));
}
resultList.add(signRecord);
}
result.close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货