ID,TITLE, CONTENT,URL, FORWORD,IS_NEEDSEND,IS_READ, CREATE_DATE,READ_DATE,SEND_TYPE, USER,REMARK,SEND_RESULT ID, USERNAME, PASSWORD, TOKEN, DISPLAY_NAME, DISPLAY_PICTURE, CREATED_ON, EXT_OPEN_ID, EXT_NAME, EXT_TYPE, LOCATION, BABY_NICKNAME, BABY_DOB, BABY_GENDER, STATUS_ SELECT FROM USER WHERE 1=1 AND USERNAME LIKE CONCAT('%',#{params.username},'%') limit ${recordBegin},${pageSize} limit ${pageSize} SELECT COUNT(ID) FROM USER WHERE 1=1 AND USERNAME LIKE CONCAT('%',#{username},'%') SELECT FROM ( SELECT ID,TITLE, CONTENT,URL,FORWORD,IS_NEEDSEND,IS_READ,CREATE_DATE,READ_DATE,SEND_TYPE, (SELECT USERNAME FROM USER WHERE ID = a.user) USER,REMARK,SEND_RESULT FROM MESSAGE a ) a WHERE 1=1 AND TITLE LIKE CONCAT('%',#{params.title},'%') AND USER LIKE CONCAT('%',#{params.username},'%') = DATE_FORMAT(#{params.beginDate},'%Y-%m-%d')]]> ORDER BY CREATE_DATE DESC,USER LIMIT ${recordBegin},${pageSize} LIMIT ${pageSize} SELECT COUNT(1) FROM MESSAGE WHERE 1=1 AND TITLE LIKE CONCAT('%',#{title},'%') = DATE_FORMAT(#{beginDate},'%Y-%m-%d')]]> UPDATE MESSAGE TITLE=#{title}, CONTENT=#{content}, URL=#{url}, FORWORD=#{forword}, IS_NEEDSEND=#{is_needsend}, IS_READ=#{is_read}, CREATE_DATE=#{create_date}, READ_DATE=#{read_date}, SEND_TYPE=#{send_type}, USER=#{user}, REMARK=#{remark}, SEND_RESULT=#{send_result} WHERE ID=#{id} INSERT INTO MESSAGE ( TITLE, CONTENT,URL, FORWORD,IS_NEEDSEND,IS_READ, CREATE_DATE,READ_DATE,SEND_TYPE, USER,REMARK,SEND_RESULT ) VALUES ( #{title},#{content},#{url},#{forword},#{is_needsend},#{is_read}, #{create_date},#{read_date},#{send_type},#{user}, #{remark},#{send_result} ) SELECT FROM MESSAGE WHERE USER IS NULL ORDER BY CREATE_DATE DESC SELECT FROM MESSAGE WHERE ID = #{id} SELECT FROM MESSAGE WHERE USER=#{userid} ORDER BY CREATE_DATE DESC SELECT COUNT(1) FROM message where is_read = #{1} and user=#{0}