获取其他数据库中数据结构

resultSet.getString(3) 获取表的名称

String url="jdbc:mysql://"+url+":"+port+"/"+dataName;
Connection con = (Connection) DriverManager.getConnection(url, name, psd);
		if(con!=null)//连接成功
			{
				    Statement statement = con.createStatement(); 
			   	    dbmd = con.getMetaData();
				    ResultSet resultSet = dbmd.getTables(null, null, "%", null);
				    while (resultSet.next()) {
					DataTableInfo table=new DataTableInfo();
					//获取表名
					table.setDataTableName(resultSet.getString(3));
					lintTableList.add(table);

					String tableName=resultSet.getString(3);
					ResultSet result=null;
					//获取此表下所有列
					result = statement.executeQuery("select * from "+tableName+" limit 0");
					ResultSetMetaData metadata = (ResultSetMetaData) result.getMetaData();
					for(int i=1;i<=metadata.getColumnCount();i++)
					{
						DataColumnInfo column=new DataColumnInfo();
						column.setDataColumnName(metadata.getColumnName(i));
						list2.add(column);
					}

				}statement.close();
			    con.close(); 
			}
			else{
				
				return null;
			}