在使用JdbcTemplate进行条件查询时没有返回数据,但是sql直接在数据库中执行是有数据返回的。
对应sql:SELECT count(1) FROM emp WHERE 1=1 and job like ? and deptno=?
对应参数数组:[%销售员%, 30]
对应sql:SELECT * FROM emp WHERE 1=1 and job like ? and deptno=? limit ?,?
对应参数数组:[%销售员%, 30, 0, 10]
结果:{"data":[],"result":"success","total_count":0} 说明程序没有报错,但是data为空。
部分代码:
@Override
public PageBean<Employee> page(Integer pageCode, Integer preCounts, Employee employee) throws Exception {
StringBuffer countPrefixSql = new StringBuffer("SELECT count(1) FROM emp ");
StringBuffer dataPrefixSql = new StringBuffe