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 = '表名';