使用sql生成表对应的CRUD语句和表对应java实体类的实例变量

SELECT
	CONCAT(
	'SELECT ',
	GROUP_CONCAT(COLUMN_NAME),
	' FROM ',
	TABLE_NAME
	)
FROM
	information_schema. COLUMNS
WHERE
	TABLE_NAME = 'worker'; 
其中 表名为worker 

SELECT
	CONCAT(
	"UPDATE worker SET ",
	GROUP_CONCAT(
	COLUMN_NAME,
	"= ()"
	),
	" WHERE Id = "
	)
FROM
	information_schema. COLUMNS
WHERE
	TABLE_NAME = 'worker';

SELECT
 CONCAT(
 'INSERT INTO worker( ',
 GROUP_CONCAT(COLUMN_NAME),
 ') VALUES (',
 GROUP_CONCAT(
 CONCAT('()')
 ),
 ')'
 )
FROM
 information_schema. COLUMNS
WHERE
 TABLE_NAME = 'worker' ;

SELECT
 CONCAT(
 'private ',
 (
 CASE
 WHEN DATA_TYPE = 'varchar' THEN 'String '
 WHEN DATA_TYPE = 'datetime' THEN
 'Date '
 WHEN DATA_TYPE = 'int' THEN
 'int '
	 WHEN DATA_TYPE = 'float' THEN
 'float '
 END
 ),
 COLUMN_NAME,' ;	//',COLUMN_COMMENT
 )
FROM
 information_schema. COLUMNS
WHERE TABLE_NAME = 'worker' ;