${tabletop}${objectNameUpper}
<#list fieldList as var>
${var[0]},
${objectNameUpper}_ID,
PARENT_ID,
NAME
<#list fieldList as var>
${r"#{"}${var[0]}${r"}"},
${r"#{"}${objectNameUpper}_ID${r"}"},
${r"#{"}PARENT_ID${r"}"},
${r"#{"}NAME${r"}"}
insert into
(
) values (
)
delete from
where
${objectNameUpper}_ID = ${r"#{"}${objectNameUpper}_ID${r"}"}
update
set
<#list fieldList as var>
<#if var[3] == "是">
${var[0]} = ${r"#{"}${var[0]}${r"}"},
NAME = ${r"#{"}NAME${r"}"},
${objectNameUpper}_ID = ${objectNameUpper}_ID
where
${objectNameUpper}_ID = ${r"#{"}${objectNameUpper}_ID${r"}"}