请注意,本文编写于 994 天前,最后修改于 938 天前,其中某些信息可能已经过时。
choose、when、otherwise 用于当某个条件出现时,选择一个。
<?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.xn2001.mapper.UserDao">
<insert id="save" useGeneratedKeys="true" keyProperty="id">
insert into user(id,name,age) values
(#{id},#{name},#{age})
</insert>
<insert id="insertForeach">
insert into user
(id,name,age) values
<foreach collection="list" item="item" index="index" separator=",">
(
#{item.id},
#{item.name},
#{item.age}
)
</foreach>
</insert>
<update id="updateUser" parameterType="com.xn2001.entity.User">
update user
<set>
<if test="name != null">
name = #{name},
</if>
<if test="age != null">
age = #{age}
</if>
</set>
where id = #{id}
</update>
<select id="selectById" resultType="com.xn2001.entity.User">
select * from user where id = #{id}
</select>
<select id="select" resultType="com.xn2001.entity.User">
select * from user
<where>
<if test="id != null">
id = #{id}
</if>
<if test="name != null">
and name = #{name}
</if>
<if test="age != null">
and age = #{age}
</if>
</where>
</select>
</mapper>
版权属于:乐心湖's Blog
本文链接:https://xn2001.com/archives/523.html
声明:博客所有文章除特别声明外,均采用 CC BY-SA 4.0 协议 ,转载请注明出处!