MyBatis动态拼接sql一、if标签二、foreach标签三、sql标签

101 阅读 0 评论 67 点赞

我是靠谱客的博主要减肥冰淇淋，这篇文章主要介绍MyBatis动态拼接sql一、if标签二、foreach标签三、sql标签，现在分享给大家，希望可以做个参考。

一、if标签

复制代码

1
2
3
4
5
6
7
8
9
<select id="selectByMoney" resultType="demo.entity.User">
select * from t_user
<where>
<if test="money != null and money != ''">
and money>1000
</if>
</where>
</select>

二、foreach标签

复制代码

1
2
3
4
5
6
7
8
9
<select id="selectUserByIds" resultType="demo.entity.User">
select * from t_user
<where>
<foreach collection="ids" open="and id in(" item="id" separator="," close=")">
#{id}
</foreach>
</where>
</select>

三、sql标签

复制代码

1
2
3
4
<sql id="sql_temp">
select id ,user_name, passwd, money from t_user
</sql>

复制代码

1
2
3
<select id="login" resultType="demo.entity.User">
<include refid="sql_temp"></include> where user_name=#{userName} and passwd=#{passwd}
</select>