-- 生成controller代码
-- 根据下面代码样本,构建生成代码的SQL脚本
//1,xxxx统计
@ResponseBody
@RequestMapping(value = "/xxxxCount", method = RequestMethod.GET)
public xxxxEntity xxxx(){
return xxxxServiceImpl.xxxx();
}
-- select * from caogao_stu_teacher_to_create_table;
-- select * from java_code_script;
-- 生成controller 代码:
select
t2.entity_name,
GROUP_CONCAT(
concat(
'\r\n\/**\r\n* ',
t2.table_comment2,
'\r\n*\/\r\n',
'@ResponseBody\r\n',
'@RequestMapping(value = "\/',
t2.xml_select_id,
'", method = RequestMethod.GET)\r\n',
'public ',
t2.entity_name,
' ',
t2.xml_select_id,
'(){\r\n\treturn ',
t2.impl,
t2.xml_select_id,
'();\r\n}'
)
) as entity_script
from (
select distinct
t3.table_name,
t3.entity_name,
t3.xml_select_id,
t3.table_comment2,
case when t3.model_name like '%xxxx%' then 'teacherxxxxServiceimpl.'
when t3.model_name like '%xxxx%' then 'studentxxxxServiceImpl.'
when t3.model_name like '%xxxx%' then 'schoolxxxxServiceImpl.'
else '-- ' end as impl
from caogao_stu_teacher_to_create_table t3
where model_name = 'xxxx'
) t2
group by t2.entity_name