MySQL-特殊查询

查询表、列、数据

项目结构

代码

package com.hdb.bigdata.portal.pc.table.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hdb.bigdata.portal.pc.table.entity.BiKhFcbEmployeeIdcardNum;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;
import java.util.Map;

@Mapper
@Component
@DS("slave_4")
public interface BiKhFcbEmployeeIdcardNumMapper extends BaseMapper<BiKhFcbEmployeeIdcardNum> {

    @Select("select table_name from information_schema.tables where table_schema='bigdata_write'; ")
    List<Map<String, Object>> tableList();

    @Delete("TRUNCATE TABLE ${table};")
    Long empty(@Param("table") String table);

    @Select("SELECT COUNT(*) FROM ${table}")
    Long queryTotal(@Param("table") String table);

    @Select("SELECT * FROM  ${table} LIMIT #{startRowNum},#{pageSize};")
    List<Map<String, Object>> pageMaps(@Param("table") String table, @Param("startRowNum") Integer startRowNum, @Param("pageSize") Integer pageSize);

    @Select("select distinct column_name from information_schema.columns where table_name = #{table};")
    List<String> columns(@Param("table") String table);
}