| | |
| | | <id column="ne_id" property="id" jdbcType="BIGINT"/> |
| | | <result column="ne_provider_id" property="providerId" jdbcType="BIGINT"/> |
| | | <result column="ne_title" property="title" jdbcType="VARCHAR"/> |
| | | <result column="ne_content" property="content" jdbcType="INTEGER"/> |
| | | <result column="ne_content" property="content" jdbcType="VARCHAR"/> |
| | | <result column="ne_type" property="type" jdbcType="VARCHAR"/> |
| | | <result column="ne_read" property="read" jdbcType="BOOLEAN"/> |
| | | <result column="ne_state" property="state" jdbcType="INTEGER"/> |
| | |
| | | ne_read, ne_state, ne_creator_id, ne_create_time, |
| | | ne_updator_id, ne_update_time) |
| | | values (#{id,jdbcType=BIGINT}, #{providerId,jdbcType=BIGINT}, #{title,jdbcType=VARCHAR}, |
| | | #{content,jdbcType=INTEGER}, #{type,jdbcType=VARCHAR}, #{read,jdbcType=BOOLEAN}, |
| | | #{content,jdbcType=VARCHAR}, #{type,jdbcType=VARCHAR}, #{read,jdbcType=BOOLEAN}, |
| | | #{state,jdbcType=INTEGER}, #{creatorId,jdbcType=BIGINT}, |
| | | #{createTime,jdbcType=TIMESTAMP}, #{updatorId,jdbcType=BIGINT}, |
| | | #{updateTime,jdbcType=TIMESTAMP})</insert> |
| | |
| | | <if test="id != null">#{id,jdbcType=BIGINT},</if> |
| | | <if test="providerId != null">#{providerId,jdbcType=BIGINT},</if> |
| | | <if test="title != null">#{title,jdbcType=VARCHAR},</if> |
| | | <if test="content != null">#{content,jdbcType=INTEGER},</if> |
| | | <if test="content != null">#{content,jdbcType=VARCHAR},</if> |
| | | <if test="type != null">#{type,jdbcType=VARCHAR},</if> |
| | | <if test="read != null">#{read,jdbcType=BOOLEAN},</if> |
| | | <if test="state != null">#{state,jdbcType=INTEGER},</if> |
| | |
| | | <update id="updateByPrimaryKey" parameterType="com.ks.lijin.pojo.DO.LiJinProviderNotice">update tlj_provider_notice |
| | | set ne_provider_id = #{providerId,jdbcType=BIGINT}, |
| | | ne_title = #{title,jdbcType=VARCHAR}, |
| | | ne_content = #{content,jdbcType=INTEGER}, |
| | | ne_content = #{content,jdbcType=VARCHAR}, |
| | | ne_type = #{type,jdbcType=VARCHAR}, |
| | | ne_read = #{read,jdbcType=BOOLEAN}, |
| | | ne_state = #{state,jdbcType=INTEGER}, |
| | |
| | | <set> |
| | | <if test="providerId != null">ne_provider_id=#{providerId,jdbcType=BIGINT},</if> |
| | | <if test="title != null">ne_title=#{title,jdbcType=VARCHAR},</if> |
| | | <if test="content != null">ne_content=#{content,jdbcType=INTEGER},</if> |
| | | <if test="content != null">ne_content=#{content,jdbcType=VARCHAR},</if> |
| | | <if test="type != null">ne_type=#{type,jdbcType=VARCHAR},</if> |
| | | <if test="read != null">ne_read=#{read,jdbcType=BOOLEAN},</if> |
| | | <if test="state != null">ne_state=#{state,jdbcType=INTEGER},</if> |