Mybatis传值语法

最新推荐文章于 2024-04-19 16:40:48 发布

Albert__Lee

最新推荐文章于 2024-04-19 16:40:48 发布

阅读量321

点赞数

本文链接：https://blog.csdn.net/pospospos2007/article/details/48339637

版权

传一个参数简单：

@Select("SELECT * FROM loan_investor,loan WHERE loan_investor.investorUserId=#{investorUserId}"
+ " AND loan_investor.loanId=loan.loanId AND loan.status >=500 AND loan.status <700;")
public List<LoanInvestor> getRepayingLoanInvestorByUserId(
Integer investorUserId);

传多个参数时要使用@Param定义：

@Select("SELECT * FROM loan_investor WHERE leftTermCount > 0 AND status =200 LIMIT #{offset}, #{pagesize} ")

public List<LoanInvestor> getAllSellingCreditRightsListByPage(

@Param("offset") int offset, @Param("pagesize") int pageSize);