#读取表字段生成对应的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=