java - 如何通过MySql DB上的Spring Jdbc模板在获取列表中应用限制和偏移量

Question

需要在 MySql DB 上使用 jdbc 模板对选择查询应用限制和偏移。

String query = "SELECT *from loaquesform F inner join loainfo N inner join loa_approval A on F.loaId = N.loaId and N.loaId = A.loaId where loaStatus IN (?) LIMIT ?, ? order by loaId desc;"

LoaFormList = userJdbcTemplateMysql.query(query,
                            new BeanPropertyRowMapper(LoaFormWithSrv.class),
                            new Object[]{loaStatusCriteria.getLoaStatus(),loaStatusCriteria.getLimit(), 
                                loaStatusCriteria.getOffset()});

我正在使用 limit 和 offset =10 调用此程序

我遇到以下错误 -

> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near ''10', '10' order by loaId desc' at line 1

Answer 1

排序依据 needs to be preceded通过 LIMIT 子句:

String query = 
   "SELECT * from loaquesform F inner join loainfo N inner join loa_approval A on F.loaId = N.loaId and N.loaId = A.loaId where loaStatus IN (?) order by loaId desc LIMIT ?, ?;"