target/classes/mapperxml/EasNoticeMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jubilantz.mappers.EasNoticeMapper">

    <resultMap id="BaseResultMap" type="com.jubilantz.entity.EasNotice">
        <id column="id" jdbcType="INTEGER" property="id" />
        <result column="title" jdbcType="VARCHAR" property="title" />
        <result column="author" jdbcType="VARCHAR" property="author" />
        <result column="content" jdbcType="VARCHAR" property="content" />
        <result column="type" jdbcType="INTEGER" property="type" />
        <result column="releasedate" jdbcType="DATE" property="releasedate" />
    </resultMap>
    <sql id="Base_Column_List">
    id, title, author, content, type, releasedate
    </sql>
    <insert id="addNotice" parameterType="com.jubilantz.entity.EasNotice">
    insert into eas_notice (id, title, author,content, type, releasedate)
        values (
        #{id,jdbcType=INTEGER}, #{title,jdbcType=VARCHAR}, #{author,jdbcType=VARCHAR},
        #{content,jdbcType=VARCHAR}, #{type,jdbcType=INTEGER}, CURDATE()
      )
    </insert>
    <update id="updateNotice" parameterType="com.jubilantz.entity.EasNotice">
        update eas_notice
        <set>
            <if test="title != null">
                title = #{title,jdbcType=VARCHAR},
            </if>
            <if test="author != null">
                author = #{author,jdbcType=VARCHAR},
            </if>
            <if test="content != null">
                content = #{content,jdbcType=VARCHAR},
            </if>
            <if test="type != null">
                type = #{type,jdbcType=INTEGER},
            </if>
            releasedate = CURDATE(),
        </set>
        where id = #{id,jdbcType=INTEGER}
    </update>
    <delete id="deleteNotice" parameterType="com.jubilantz.entity.EasNotice">
        delete from eas_notice
        where id = #{id,jdbcType=INTEGER}
    </delete>
    <delete id="deleteNoticeList">
        delete
        from eas_notice
        where id in
        <foreach collection="list" item="id" separator="," open="(" close=")" >
            #{id,jdbcType=INTEGER}
        </foreach>
    </delete>

    <!--    大于等于:&gt;=-->
    <!--    小于等于:&lt;=-->
    <select id="getCountByType" resultType="java.lang.Integer">
        select count(*)
        from eas_notice
        where type &lt;= #{type, jdbcType=INTEGER}