mysql表结构转为java实体类

SELECT
    CONCAT("/**\r","* ",a.COLUMN_COMMENT,"\r*/\r",'private ', (CASE 
    WHEN a.DATA_TYPE ='int' THEN 'Integer '
    WHEN a.DATA_TYPE ='VARCHAR' THEN 'String '
    WHEN a.DATA_TYPE= 'datetime' THEN 'Date '
    else 'null '
    END
),COLUMN_NAME ,";") COLUMN_NAME 
FROM
    information_schema.COLUMNS  a
WHERE
    table_name = '表名';