public List getDataSet(String str1,String str2,String str3,int str4,int str5,String str6){
List dataList = new ArrayList<Object>();
Connection connection = getConn();
ResultSet rs = null;
try{
CallableStatement proc = connection.prepareCall("{call procGetDeviceStateInfo(?,?,?,?,?,?)}");
// 设置输入参数 '','','',-1,1, '1'
proc.setString(1,str1);
proc.setString(2,str2);
proc.setString(3,str3);
proc.setInt(4,str4);
proc.setInt(5,str5);
proc.setString(6,str6);
proc.execute();
// 取出存储过程的结果集
boolean hasResult = true;
/*while (hasResult) {
rs = proc.getResultSet();
while(rs.next()) {
System.out.println("第一个字段值为:"+rs.getString(1));
}
hasResult = proc.getMoreResults();
}*/
while (hasResult){
rs = proc.getResultSet();
ResultSetMetaData rsmd=(ResultSetMetaData) rs.getMetaData();
List<Map<String,Object>> list=new ArrayList<Map<String,Object>>();
while(rs.next()){
Map<String,Object> map=new HashMap<String,Object>();//每行记录放到一个
for(int i=1;i<=rsmd.getColumnCount();i++){
map.put(rsmd.getColumnName(i), rs.getObject(i));
}
list.add(map);
System.err.println("list.size()"+list.size());
}
dataList.add(list);
System.err.println("dataList.size()"+dataList.size());
hasResult = proc.getMoreResults();
}
connection.close();
}catch (SQLException e){
e.printStackTrace();
}
return dataList;
}
List dataList = new ArrayList<Object>();
Connection connection = getConn();
ResultSet rs = null;
try{
CallableStatement proc = connection.prepareCall("{call procGetDeviceStateInfo(?,?,?,?,?,?)}");
// 设置输入参数 '','','',-1,1, '1'
proc.setString(1,str1);
proc.setString(2,str2);
proc.setString(3,str3);
proc.setInt(4,str4);
proc.setInt(5,str5);
proc.setString(6,str6);
proc.execute();
// 取出存储过程的结果集
boolean hasResult = true;
/*while (hasResult) {
rs = proc.getResultSet();
while(rs.next()) {
System.out.println("第一个字段值为:"+rs.getString(1));
}
hasResult = proc.getMoreResults();
}*/
while (hasResult){
rs = proc.getResultSet();
ResultSetMetaData rsmd=(ResultSetMetaData) rs.getMetaData();
List<Map<String,Object>> list=new ArrayList<Map<String,Object>>();
while(rs.next()){
Map<String,Object> map=new HashMap<String,Object>();//每行记录放到一个
for(int i=1;i<=rsmd.getColumnCount();i++){
map.put(rsmd.getColumnName(i), rs.getObject(i));
}
list.add(map);
System.err.println("list.size()"+list.size());
}
dataList.add(list);
System.err.println("dataList.size()"+dataList.size());
hasResult = proc.getMoreResults();
}
connection.close();
}catch (SQLException e){
e.printStackTrace();
}
return dataList;
}