mysql 表转 java 实体 sql

SELECT
    concat(
        'private ',
        v.dataType,
        '  ',
        v.column_name,
        ';//',
        v.column_comment
    )
FROM
    (
        SELECT
            CASE
        WHEN (
            data_type = 'varchar'
            OR data_type = 'char'
            OR data_type = 'text'
            OR data_type = 'blob'
        ) THEN
            'String'
        WHEN data_type = 'int' THEN
            'int'
        WHEN data_type = 'double' THEN
            'double'
        END AS dataType,
        column_name,
        column_comment
    FROM
        information_schema. COLUMNS
    WHERE
        table_name = 'store'
    ) v

 https://mp.weixin.qq.com/s/hFXWzV6CNCu1_KozKDPH3g