public ArrayList> getDataTale2(String sql) throws SQLException {
ArrayList> dt=new ArrayList>();
sta =(SQLServerPreparedStatement)con.prepareStatement(sql);
rs=(SQLServerResultSet)sta.executeQuery();
SQLServerPreparedStatement stmt = (SQLServerPreparedStatement)con.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY );
ResultSet rset = stmt.executeQuery();
ResultSetMetaData rsmd = rset.getMetaData() ;
int columnCount = rsmd.getColumnCount();
ArrayList listNames=new ArrayList<>();
for (int c=0;c
String cName=rsmd.getColumnName(c+1);
listNames.add(cName);
}
dt.add(listNames);
while(rs.next()){
ArrayList list=new ArrayList<>();
for (int c=0;c
String cName=rsmd.getColumnName(c+1);