SELECT * FROM jeesite_sys_dict WHERE id = #{id} SELECT * FROM jeesite_sys_dict WHERE del_flag = #{DEL_FLAG_NORMAL} AND type = #{type} AND description LIKE '%'||#{description}||'%' '%'+#{description}+'%' CONCAT('%', #{description}, '%') ORDER BY type, sort, update_date DESC SELECT * FROM jeesite_sys_dict WHERE del_flag = #{DEL_FLAG_NORMAL} ORDER BY type, sort, update_date DESC SELECT type FROM jeesite_sys_dict WHERE del_flag = #{DEL_FLAG_NORMAL} GROUP BY type ORDER BY type INSERT INTO jeesite_sys_dict( id, value, label, type, description, sort, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{value}, #{label}, #{type}, #{description}, #{sort}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE jeesite_sys_dict SET value = #{value}, label = #{label}, type = #{type}, description = #{description}, sort = #{sort}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE jeesite_sys_dict SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}