mysql来获得数据库的所有表-优快云博客

本文链接：https://blog.youkuaiyun.com/iteye_12456/article/details/82333903

本文介绍了通过Java程序获取MySQL数据库中所有表名的两种方法：一是利用JDBC的metadata元数据；二是执行SQL命令show tables。这两种方法各有特点，前者更为标准但实现较为复杂，后者简单直接但可能包含视图。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

方法一：使用metadata元数据


	public String[] getTableArray() {
		Connection conn = null;
		ResultSet rs = null;
		ArrayList<String> tbList = new ArrayList<String>();  
		String[] tables = null;
		try {
			conn = connectionUtil.getConnection();
			DatabaseMetaData meta = conn.getMetaData();
			rs = meta.getTables(null,meta.getUserName(),null,new String[]{"TABLE"});
			while(rs.next()){
				tbList.add(rs.getString(3));         
			}
			tables = new String[tbList.size()];
			tbList.toArray(tables);
		} catch (SQLException e) {
			logger.error(e);
		} catch(Exception e){
			logger.error(e);
		} finally {
			try{
				if(null != conn){
					conn.close();
				}
			}catch(Exception e){
				logger.error(e);
			}
		}

		return tables;
	}

方法二：使用命令show tables;缺点：它会把视图也查出来


         private static final String COMMON_SPLIT_STR = ",";
	public String[] getTableArray() {
		String sql = "show tables";
		Connection conn = null;
		Statement sta = null;
		ResultSet rs = null;
		StringBuffer tableNameStr = new StringBuffer();
		try {
			conn = connectionUtil.getConnection();
			sta = conn.createStatement();
			rs = sta.executeQuery(sql);
			while (rs.next()) {
				tableNameStr.append(rs.getString(1)).append(COMMON_SPLIT_STR);
			}
		} catch (SQLException e) {
			logger.error(e);
		} catch(Exception e){
			logger.error(e);
		} finally {
			connectionUtil.closeConnection(conn, sta, rs);
		}

		return tableNameStr.toString().split(COMMON_SPLIT_STR);
	}