数据库表和表结构查询

public List getTableType() {
  List list1 = new ArrayList();
  List<TableName> list2 = new ArrayList<TableName>();
  
  Connection conn = null;
  ResultSet rs = null;
  PreparedStatement ps = null;
  try {

   List<TableName> getName = getTabelName();
   if (getName.size() > 0) {
    conn = getconnection();
    for (int i = 0; i < getName.size(); i++) {
     
     TableName tn = getName.get(i);
     String sql = "SELECT * FROM "+tn.getTableName();
    
     ps = conn.prepareStatement(sql);
     rs=ps.executeQuery();
     ResultSetMetaData meta=rs.getMetaData();
     int col=meta.getColumnCount();
     for(int j=1;j<col+1;j++){
        TableName t = new TableName();
        t.setTableID(meta.getColumnName(j));
        t.setTableType(meta.getColumnTypeName(j));
        t.setTableLength((meta.getColumnDisplaySize(j))+"");
        System.out.println(t.getTableLength());
        list2.add(t);
     }
     list1.add(list2);
    }

   }

  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   try {
    if (ps != null)
     ps.close();
    if (rs != null)
     rs.close();
    if (conn != null)
     conn.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
  return list1;
 }