MyBatis 获取数据库所有表名，判断表是否存在

╰+攻爆jí腚メ 2022-10-15 06:59 383阅读 0赞

### 1 Maven依赖 ###

<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter</artifactId>
    			<version>2.1.3</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>8.0.19</version>
    		</dependency>

### 2 CommonMapper.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.dao.CommonRepository">
    
        <select id="getTableNameList" resultType="java.lang.String">
            select table_name from information_schema.tables where TABLE_SCHEMA=(select database())
            <if test="tableNameList !=null and tableNameList.size() > 0">
                and table_name in
                <foreach collection="tableNameList" item="item" separator="," open="(" close=")">
                    #{item}
                </foreach>
            </if>
        </select>
    </mapper>

### 3 CommonRepository ###

package com.dao;
    
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    
    import java.util.List;
    
    @Mapper
    public interface CommonRepository {
    
        /**
         * 获取当前数据库表名
         *
         * @param tableNameList 表名列表
         * @return
         */
        List<String> getTableNameList(@Param("tableNameList") List<String> tableNameList);
    }

### 4 获取数据库所有表名 ###

/**
         * 获取数据库所有表名
         *
         * @return
         */
        public List<String> getAllTableNameList(){
            commonRepository.getTableNameList(null);
        }

### 5 判断表是否存在 ###

/**
         * 判断表是否存在
         *
         * @param tableNameList 表名列表
         * @return
         */
        public List<String> getTableNameList(List<String> tableNameList){
            commonRepository.getTableNameList(tableNameList);
        }