public HashMap getAllColumnsNameInTable(String tableName){
HashMap tableColumnMap = new HashMap();
ArrayList columnNameList = new ArrayList();
ArrayList columnTypeList =new ArrayList(); try{
DataSource ds = getDBDataSource();
Connection con = getConnection(ds);
Statement statmt = con.createStatement();
ResultSet rs; String queryString = "Select * from " + tableName;
//System.out.println(systemQueryString);
try{
rs = statmt.executeQuery(queryString);
ResultSetMetaData rsMeta = rs.getMetaData();
for(int i =1; i<=rsMeta.getColumnCount(); i++){
columnNameList.add(rsMeta.getColumnName(i));
columnTypeList.add(rsMeta.getColumnTypeName(i));
}
//return rs.getString("name");
rs.close() ;
}catch(Exception ee){System.out.println(ee.getMessage());};
statmt.close();
con.close();
}catch(Exception se){System.out.println(se.getMessage());};
tableColumnMap.put("columnNameList", columnNameList);
tableColumnMap.put("columnTypeList", columnTypeList);
return tableColumnMap;
}
HashMap tableColumnMap = new HashMap();
ArrayList columnNameList = new ArrayList();
ArrayList columnTypeList =new ArrayList(); try{
DataSource ds = getDBDataSource();
Connection con = getConnection(ds);
Statement statmt = con.createStatement();
ResultSet rs; String queryString = "Select * from " + tableName;
//System.out.println(systemQueryString);
try{
rs = statmt.executeQuery(queryString);
ResultSetMetaData rsMeta = rs.getMetaData();
for(int i =1; i<=rsMeta.getColumnCount(); i++){
columnNameList.add(rsMeta.getColumnName(i));
columnTypeList.add(rsMeta.getColumnTypeName(i));
}
//return rs.getString("name");
rs.close() ;
}catch(Exception ee){System.out.println(ee.getMessage());};
statmt.close();
con.close();
}catch(Exception se){System.out.println(se.getMessage());};
tableColumnMap.put("columnNameList", columnNameList);
tableColumnMap.put("columnTypeList", columnTypeList);
return tableColumnMap;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货