SELECT
CONCAT("/**\r","* “,a.COLUMN_COMMENT,”\r*/\r",'private ', (CASE
WHEN a.DATA_TYPE =‘int’ THEN 'int ’
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 = ‘表名’;
Mysql (生成Java 实体类代码)
最新推荐文章于 2023-06-02 11:23:16 发布