MyBatis级联多条件分页查询
来源:互联网 发布:mac在windows截图 编辑:程序博客网 时间:2024/05/21 00:15
<!-- 通过多条件分页查询,返回数据集 -->
<select id="selectPageListUseDyc" parameterType="page" resultMap="articleResultMap" >
select a.article_id, a.title, a.img_url,a.article_type,a.add_time,a.like_num,a.content,a.markdown,b.user_id,
b.user_name,b.user_photo
FROM article a join user b on a.user_id = b.user_id
<where>
<if test="paramEntity.markdown!=null">and markdown like #{paramEntity.markdown}</if>
<if test="paramEntity.title!=null">and title like #{paramEntity.title}</if>
<if test="paramEntity.content!=null">and content like #{paramEntity.content}</if>
<if test="paramEntity.userId!=null">and a.user_id = #{paramEntity.userId}</if>
<if test="paramEntity.articleType!=null">and article_type = #{paramEntity.articleType}</if>
</where>
order by a.like_num DESC limit #{start},#{rows}
</select>
<select id="selectPageListUseDyc" parameterType="page" resultMap="articleResultMap" >
select a.article_id, a.title, a.img_url,a.article_type,a.add_time,a.like_num,a.content,a.markdown,b.user_id,
b.user_name,b.user_photo
FROM article a join user b on a.user_id = b.user_id
<where>
<if test="paramEntity.markdown!=null">and markdown like #{paramEntity.markdown}</if>
<if test="paramEntity.title!=null">and title like #{paramEntity.title}</if>
<if test="paramEntity.content!=null">and content like #{paramEntity.content}</if>
<if test="paramEntity.userId!=null">and a.user_id = #{paramEntity.userId}</if>
<if test="paramEntity.articleType!=null">and article_type = #{paramEntity.articleType}</if>
</where>
order by a.like_num DESC limit #{start},#{rows}
</select>
阅读全文
0 0
- MyBatis级联多条件分页查询
- Mybatis的条件分页查询
- MyBatis多条件分页查询,返回总记录数
- Mybatis+Oracle实现按条件分页查询
- Mybatis+Oracle实现按条件分页查询
- mybatis分页条件查询动态sql
- MyBatis多条件查询
- Mybatis 多条件查询
- mybatis(3)分页查询和条件分页查询
- yii 多条件查询,分页
- SSM分页、多条件查询
- JPA多条件查询+分页
- 用户分页多条件查询
- MyBatis 级联查询,一对一,一对多
- mybatis 级联查询
- mybatis特性--- 级联查询
- MyBatis 的级联查询
- mybatis级联查询
- Shell Cookbook
- Magic Numbers codeforces 628D 数位dp
- 实现批量删除(物理删除)
- Java多线程-实例解析
- 程序员职业素养 读书笔记
- MyBatis级联多条件分页查询
- CF Educational#21 Div2 E Solution
- week_three_jdbc
- MyBatis多条件分页查询,返回总记录数
- Android 笔记 进程间通信
- Matlab2014a编译jar/dll 出错Test checkout of feature 'Compiler' failed
- 平衡之查找之红黑树
- 数据结构-二叉树的前序、中序、后序遍历的递归和非递归实现
- Anaconda入门