mybatis dialectclass分页示例

最新推荐文章于 2024-12-11 09:30:27 发布

xiebinyuxyz

最新推荐文章于 2024-12-11 09:30:27 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏：学习参考资料

本文链接：https://blog.youkuaiyun.com/xiebinyuxyz/article/details/51074450

学习参考资料专栏收录该内容

23 篇文章

订阅专栏

本文详细介绍了如何使用MyBatis和Spring框架进行分页查询存入记录的操作，包括参数设置、SQL语句编写及异常处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mybatis:

<select id="queryDeposit" parameterType="com.coactsoft.cfp.entity.Deposit"
resultType="com.coactsoft.cfp.entity.Deposit">
select FID as id, FAPPLYTIME as applyTime, FCURRENCY as currency,
FAMOUNT as amount, FARRIVALAMOUNT as arrivalAmount, FSTATUS as status
from tdeposit
where 1
<if test="currency != '0'.toString()">
and FCURRENCY = #{currency}
</if>
<if test="status != '0'.toString()">
and FSTATUS = #{status}
</if>
</select>

Dao:

/**
* 分页查询存入记录
* @param deposit
* @param bounds
* @return
*/
PageList<Deposit> queryDeposit(Deposit deposit, PageBounds bounds);

logic:

@Path("/queryDeposit")
@POST
public ResponseData<List<Deposit>> queryDeposit(@FormParam("currency")String currency, @FormParam("status")String status, @FormParam("start")String start, @FormParam("count")String count) {
Deposit deposit = new Deposit();
deposit.setCurrency(Integer.parseInt(currency));
deposit.setStatus(Integer.parseInt(status));
SqlSession session = null;
try {
session = SessionFactory.get().openSession();
List<Deposit> pl = session.getMapper(FundsDao.class).queryDeposit(deposit,
new PageBounds(Integer.parseInt(start)/Integer.parseInt(count) + 1, Integer.parseInt(count)));
return ResponseData.ok(((PageList<Deposit>) pl).getPaginator().getTotalCount(), pl);
} catch (Exception e) {
LOGGER.error("查询存入记录出错", e);
} finally {
session.close();
}
return null;
}