目录
一,mybatis动态sql
1.if:条件语句
2.foreach
imp代码层:
与xml代码对应mapper:
在biz层写入相应的代码:
进行测试:
结果
完整代码xml:
<select id="selectByIn" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
select
<include refid="Base_Column_List" />
from t_mvc_book
where bid in
<foreach collection="bookIds" open="(" close= ")" separator="," item="bid">
#{bid}
</foreach>
</select>
二,模糊查询
1.#{...}
mapper:
biz:
impl:
测试:
结果