MyBatis之动态SQL

 

<mapper namespace="mapper.ICategory">

    

    <select id="selectAll" resultType="pojo.Category">

        SELECT

            id,

            name

        FROM category

    </select>

    <insert id="insert" parameterType="pojo.Category">

        INSERT INTO category (name) VALUES (#{name})

    </insert>



    <select id="selectlike" resultType="pojo.Category">

        SELECT * FROM category WHERE id>2

        <if test="name !=null">

            <bind name="_name" value="'%'+name+'%'"></bind>

            AND name LIKE #{_name}

        </if>

  

--      相当于swich case



        <choose>

            <when test="">



            </when>

            <otherwise>



            </otherwise>

        </choose>

    </select>

    <!--动态添加SQL语句-->

    <update id="XXX">

        UPDATE category

        <set>

            <if test="name!=null">ename=#{ename},</if>

        </set>

        WHERE id=#{id}

    </update>

    

    <delete id="delete">

        delete from user where id IN

        # 如果foreach操作数组或集合时，collection根据传入对象决定是array或list，与参数名无关

        # public void delete(int[] id);

        <foreach collection="array" item="id" open="(" separator="," close=")">

            #{id}

        </foreach>

    </delete>

</mapper>