a.id AS "id", a.content AS "content", a.read_date AS "readDate", a.read_flag AS "readFlag", a.type AS "type", a.user_id AS "user.id", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.create_date AS "createDate", a.remarks AS "remarks", a.del_flag AS "delFlag", a.create_by AS "createBy.id" SELECT FROM sys_remind a WHERE a.id = #{id} SELECT FROM sys_remind a a.del_flag = #{DEL_FLAG_NORMAL} AND a.content LIKE '%'||#{content}||'%' '%'+#{content}+'%' concat('%',#{content},'%') AND a.read_flag = #{readFlag} AND a.user_id = #{user.id} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM sys_remind a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO sys_remind( id, content, read_date, read_flag, type, user_id, update_by, update_date, create_date, remarks, del_flag, create_by ) VALUES ( #{id}, #{content}, #{readDate}, #{readFlag}, #{type}, #{user.id}, #{updateBy.id}, #{updateDate}, #{createDate}, #{remarks}, #{delFlag}, #{createBy.id} ) UPDATE sys_remind SET content = #{content}, read_date = #{readDate}, read_flag = #{readFlag}, type = #{type}, user_id = #{user.id}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE sys_remind SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE sys_remind SET read_date = #{readDate}, read_flag = #{readFlag}, update_by = #{user.id}, update_date = #{updateDate} WHERE user_id = #{user.id}