mapper.xml

<?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.cy.sys.dao.UserDao">

    <sql id="col">
        id,name,age,sex,birthday
    </sql>

    <insert id="insertUser" parameterType="User">
        insert into user
                (name,age,sex,birthday)
            values
                (#{name},#{age},#{sex},#{birthday})
    </insert>

    <delete id="deleteById">
        delete from user
            <where>
                <if test="id!='' and id!=null">
                    id = #{id}
                </if>
                or 1=2
            </where>
    </delete>

    <select id="selectUser" resultType="User">
        select <include refid="col"></include> from user
    </select>

    <update id="updateUser" parameterType="User">
        update from user
            <set>
                name=#{name},age=#{age},sex=#{sex},birthday=#{birthday}
            </set>
            <where>
                id = #{id}
            </where>
    </update>

	<delete id="deleteById"><!--(1,2,3,4,5)-->
        <!--foreach 用于迭代一个数组或集合-->
        delete from sys_notices
        <where>
            <if test="ids!=null and ids.length>0">
                id in
                <foreach collection="ids" open="(" close=")" separator=","
                         item="id">
                    #{id}
                </foreach>
            </if>
            or 1=2
        </where>
    </delete>

    <select id="selectNotices" parameterType="com.cy.pj.sys.pojo.SysNotice" resultType="com.cy.pj.sys.pojo.SysNotice">
        select * from sys_notices
            <where>
                <if test="type!=null and type!=''"> type=#{type} </if>
                <if test="title!=null and title!=''"> and title like concat("%",#{title},"%") </if>
                <if test="modifiedUser!=null and modifiedUser!=''"> and modifiedUser like concat("%",#{modifiedUser},"%")</if>
            </where>
            order by createdTime desc
    </select>

</mapper>