a.id AS "id", a.year AS "year", a.code AS "code", a.level AS "level" SELECT FROM sys_code_groomer a WHERE a.id = #{id} SELECT FROM sys_code_groomer a ORDER BY ${page.orderBy} SELECT FROM sys_code_groomer a ORDER BY ${page.orderBy} INSERT INTO sys_code_groomer( id, year, code, level ) VALUES ( #{id}, #{year}, #{code}, #{level} ) UPDATE sys_code_groomer SET year = #{year}, code = #{code}, level = #{level} WHERE id = #{id} DELETE FROM sys_code_groomer WHERE id = #{id} select id,year,code,level FROM sys_code_groomer where year = #{year} and level=#{level} UPDATE sys_code_groomer SET code=#{code} WHERE id=#{id}