select * from smbms_bill
where
productName =#{productName}
and providerId =#{providerId}
and isPayment =#{isPayment}
limit startindex=#{startindex},pageSize=#{pageSize}
出现
Cause: java.sql.SQLSyntaxErrorException: Undeclared variable: startindex
是因为数据库没有startindex,当然也没有pageSize
改成这样就行了
select * from smbms_bill where productName =#{productName} and providerId =#{providerId} and isPayment =#{isPayment} limit #{startindex},#{pageSize}