mysql读取表字段生成对应的java变量

#读取表字段生成对应的java变量,无初始值

例:String column ;// 注释

SELECT 

CONCAT('private ',(CASE 

WHEN (DATA_TYPE='CHAR'||DATA_TYPE='VARCHAR'||DATA_TYPE='LONGVARCHAR') THEN 'String' 

WHEN (DATA_TYPE='NUMERIC'||DATA_TYPE='DECIMAL') THEN 'BigDecimal'

WHEN DATA_TYPE='BIT' THEN 'boolean'

WHEN (DATA_TYPE='TINYINT'||DATA_TYPE='SMALLINT'||DATA_TYPE='INTEGER'||DATA_TYPE='INT') THEN 'int'

WHEN DATA_TYPE='BIGINT' THEN 'long'

WHEN DATA_TYPE='REAL' THEN 'float'

WHEN DATA_TYPE='DOUBLE' THEN 'double'

WHEN DATA_TYPE='DATE' THEN 'Date'

WHEN (DATA_TYPE='DATE'||DATA_TYPE='TIME'||DATA_TYPE='datetime'||DATA_TYPE='TIMESTAMP') THEN 'Date'

ELSE '-------------'

END),' ',column_name,';// ',column_comment)

FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA='fish' AND TABLE_NAME='yy_dayreport' 

 

#读取表字段生成对应的java变量,有初始值

例:String column = "";// 注释

SELECT 

CONCAT('private ',(CASE 

WHEN (DATA_TYPE='CHAR'||DATA_TYPE='VARCHAR'||DATA_TYPE='LONGVARCHAR') THEN 'String' 

WHEN (DATA_TYPE=