您的当前位置：首页使用sql生成表对应的CRUD语句和表对应java实体类的实例变量

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

来源：保捱科技网

该sql运行于mysql 无 SELECTCONCAT('SELECT ',GROUP_CONCAT(COLUMN_NAME),' FROM ',TABLE_NAME)FROMinformation_schema. COLUMNSWHERETABLE_NAME = 'worker'; 其中表名为worker SELECTCONCAT("UPDATE worker SET ",GROUP_CONCAT(COLUMN_NAME,"= ()")," WHERE

该sql运行于mysql <无> $velocityCount-->

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' ;