根据表名查询表信息和根据表名查询表字段信息

@Mapper
public interface GeneratorDao {

    // 根据表名查询表信息
    Map<String,String> queryTable(String tableName);

    // 根据表名查询所有表字段信息
    List<Map<String,String>> queryColumns(String tableName);
}

 

 <!-- 根据表名查询表信息 -->
    <select id="queryTable" parameterType="java.lang.String" resultType="java.util.Map">
      SELECT
        TABLE_NAME AS tableName,
        ENGINE AS tableEngine,
        TABLE_COMMENT AS tableComment,
        CREATE_TIME AS createTime
      FROM
        INFORMATION_SCHEMA.TABLES
      WHERE
        TABLE_SCHEMA = (SELECT DATABASE())
      AND
        TABLE_NAME = #{tableName}
    </select>

    <!-- 根据表名查询表字段信息 -->
    <select id="queryColumns" parameterType="java.lang.String" resultType="java.util.Map">
        SELECT
          COLUMN_NAME AS columnName,
          DATA_TYPE AS dataType,
          COLUMN_COMMENT AS columnComment,
          COLUMN_KEY AS columnKey,
          EXTRA AS extra
        FROM
          INFORMATION_SCHEMA.COLUMNS
        WHERE
          TABLE_SCHEMA = (SELECT DATABASE())
        AND
          TABLE_NAME = #{tableName}
        ORDER BY
          ORDINAL_POSITION
    </select>