Cause: java.sql.SQLSyntaxErrorException: ORA-00907: 缺失右括号

Question

select * from (select rownum r,c.* from cashAccount c where c.cashAccountName like '%'#{cashAccountName}'%' and rownum<=#{page}*#{pageSize})where r>=(#{page}-1)*#{pageSize}+1

select * from (select rownum r,c.* from cashAccount c where c.cashAccountName like "%"?"%"and rownum<=??)where r>=(?-1)?+1
Cause: java.sql.SQLSyntaxErrorException: ORA-00907: 缺失右括号

Answer 1

Sql存在语法问题，like 后面的字符串要用concat()函数进行拼接。