代码生成器专题（准备一）：获取数据库表信息

1、引入hutool工具类 

        <!-- Mysql驱动包 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
            <scope>runtime</scope>
        </dependency>
        
        <!--hutool工具类-->
        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-all</artifactId>
            <version>${hutool.version}</version>
        </dependency>

2、测试代码编写

    @SneakyThrows
    public static void main(String[] args){
        HikariDataSource dataSource = new HikariDataSource();
        dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/cx-master?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&zeroDateTimeBehavior=convertToNull&useSSL=false");
        dataSource.setUsername("yonghuming");
        dataSource.setPassword("mima");
        Db db = new Db(dataSource);
        List<Entity> query = db.query("select table_name tableName, engine, table_comment tableComment, create_time createTime from information_schema.tables where table_schema = (select database())  order by create_time desc");
        Console.error(query);
        dataSource.close();
    }

3、测试结果