SELECT COUNT(*) AS total FROM t_ddhive_table124
protected PrestoResultDTO resultSetToList(ResultSet rs) throws SQLException {
PrestoResultDTO prestoResultList = new PrestoResultDTO();
List<Object[]> objectList = new ArrayList<>();
ResultSetMetaData rsmd = rs.getMetaData();
int colCount = rsmd.getColumnCount();
List<String> columnList = new ArrayList<>();
for(int i=1;i<=colCount;i++)
{
columnList.add(rsmd.getColumnName(i));
}
Object[] obj;
//显示表格内容
while(rs.next())
{
obj = new Object[colCount];
for(int i=1;i<=colCount;i++)
{
obj[i-1] = rs.getString(i);
}
objectList.add(obj);
}
prestoResultList.setColumns(columnList);
prestoResultList.setDatas(objectList);
//prestoResultList.setTotalCount(objectList.size());
log.debug("DataSourceTypeStrategyServiceImpl resultSetToList,结果大小{}",objectList.size());
return prestoResultList;
}
数据条数2W+,count按理只有一条数据行,不太明白为什么rs.next()会卡死