@Mapper
@Component
public interface CommonMapper {
    /**
     * 判斷表是否存在
     *
     * @param tableName 表名稱
     * @return 結果
     * @author yunnuo
     */
    @Select(" SELECT COUNT(*) as count FROM information_schema.TABLES WHERE table_name = #{tableName}")
    Integer existsTable(@Param("tableName") String tableName);
}

        <!-- 判斷表是否存在 --><select id="existsTable" parameterType="string" resultType="java.lang.Integer">
           SELECT COUNT(*) as count FROM information_schema.TABLES WHERE table_name = #{tableName}
        </select>

　　 @Test
    public void test3(){
        Integer integer = commonMapper.existsTable("data_20220601");
        System.out.println(integer);
    }