a.*, a.gen_table_id AS "genTable.id" SELECT FROM gen_scheme a WHERE a.id = #{id} SELECT FROM gen_scheme a WHERE a.del_flag = #{DEL_FLAG_NORMAL} AND a.name LIKE '%'||#{name}||'%' '%'+#{name}+'%' concat('%',#{name},'%') ORDER BY a.update_date DESC SELECT FROM gen_scheme a WHERE a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY a.update_date DESC INSERT INTO gen_scheme( id, name, category, package_name, module_name, sub_module_name, function_name, function_name_simple, function_author, gen_table_id, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{name}, #{category}, #{packageName}, #{moduleName}, #{subModuleName}, #{functionName}, #{functionNameSimple}, #{functionAuthor}, #{genTable.id}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE gen_scheme SET name = #{name}, category = #{category}, package_name = #{packageName}, module_name = #{moduleName}, sub_module_name = #{subModuleName}, function_name = #{functionName}, function_name_simple = #{functionNameSimple}, function_author = #{functionAuthor}, gen_table_id = #{genTable.id}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE gen_scheme SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}