id, type, title, content, create_time,sys_user_id,status select from cab_pub_mymessage where id = #{id,jdbcType=INTEGER} delete from cab_pub_mymessage where id = #{id,jdbcType=INTEGER} insert into cab_pub_mymessage (id, type, sys_user_id, title, content, create_time,status) values (#{id,jdbcType=INTEGER}, #{type,jdbcType=INTEGER}, #{sysUserId,jdbcType=INTEGER}, #{title,jdbcType=VARCHAR}, #{content,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP},#{status,jdbcType=INTEGER}) insert into cab_pub_mymessage id, type, sys_user_id, title, content, create_time, status, #{id,jdbcType=INTEGER}, #{type,jdbcType=INTEGER}, #{sysUserId,jdbcType=INTEGER}, #{title,jdbcType=VARCHAR}, #{content,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, #{status,jdbcType=INTEGER}, update cab_pub_mymessage type = #{type,jdbcType=INTEGER}, sys_user_id = #{sysUserId,jdbcType=INTEGER}, title = #{title,jdbcType=VARCHAR}, content = #{content,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=TIMESTAMP}, status = #{status,jdbcType=INTEGER}, where id = #{id,jdbcType=INTEGER} update cab_pub_mymessage set type = #{type,jdbcType=INTEGER}, sys_user_id = #{sysUserId,jdbcType=INTEGER}, title = #{title,jdbcType=VARCHAR}, content = #{content,jdbcType=VARCHAR}, create_time = #{createTime,jdbcType=TIMESTAMP}, status = #{status,jdbcType=INTEGER} where id = #{id,jdbcType=INTEGER} select id, type, title, content, create_time,sys_user_id ,status,u.user_name from cab_pub_mymessage c left join sys_user u on c.sys_user_id = u.user_id where 1=1 and type = #{type,jdbcType=INTEGER} and title like '%${title}%' order by create_time desc limit #{start,jdbcType=INTEGER},#{limit,jdbcType=INTEGER} select count(*) from cab_pub_mymessage where 1=1 and type = #{type,jdbcType=INTEGER} and title like '%${title}%' insert into cab_mymessage (type, user_id, title, content, create_time,isread,pub_id) values ( #{item.type,jdbcType=INTEGER}, #{item.userId,jdbcType=INTEGER}, #{item.title,jdbcType=VARCHAR}, #{item.content,jdbcType=VARCHAR}, #{item.createTime,jdbcType=TIMESTAMP},0, #{item.id,jdbcType=INTEGER})