SQL 元数据 工具类

SQL语句参考博客：https://hcshow.blog.csdn.net/article/details/104271739

工具类

public class DBUtil{
    /**
     * 获取数据表中所有的列的名字
     * @param database
     * @param table
     * @return
     * @throws SQLException
     */
    public static String[] getTableColumns(String database, String table) throws SQLException {
        String sql = "select group_concat(column_name) from information_schema.COLUMNS   where table_schema= ? and table_name=?";
        QueryRunner queryRunner = new QueryRunner(TransactionManager.getDataSource());
        String columns = queryRunner.query(sql, new ScalarHandler(), database, table);
        String[] res = columns.split(",");
        return res;
    }

    /**
     * 获取数据库中所有的表的名字
     * @param database
     * @return
     * @throws SQLException
     */
    public static String[] getTableNames(String database) throws SQLException {
        String sql = "SELECT GROUP_CONCAT(TABLE_NAME) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ? ORDER BY create_time DESC";
        QueryRunner queryRunner = new QueryRunner(TransactionManager.getDataSource());
        String columns = queryRunner.query(sql, new ScalarHandler(), database);
        String[] res = columns.split(",");
        return res;
    }

    public static void main(String[] args) throws SQLException {
        String database = "db_credits";
        String table = "tb_user";
        String[] res = getTableColumns(database, table);
        System.out.println(Arrays.toString(res));

        String[] res2 = getTableNames(database);
        System.out.println(Arrays.toString(res2));
    }
}