mybatis 嵌套
- 作者: 凹凸欧巴
- 来源: 51数据库
- 2020-10-02
1.写一个普通查询语句
<select id="byDeptIdCondition" ..>
SELECT t1.userId,t1.userName from user
</select>
2.嵌套
<dynamic prepend="and">
<include refid="byDeptIdCondition"/>
where 1=1//其他sql语句 注意命名空间
</dynamic>
望采纳
<select id="byDeptIdCondition" ..>
SELECT t1.userId,t1.userName from user
</select>
2.嵌套
<dynamic prepend="and">
<include refid="byDeptIdCondition"/>
where 1=1//其他sql语句 注意命名空间
</dynamic>
望采纳
推荐阅读
