RowMapper<WmsExpensesSettleEntity> rowMapper1=new BeanPropertyRowMapper<WmsExpensesSettleEntity>(WmsExpensesSettleEntity.class);
List<WmsExpensesSettleEntity> list= jdbcTemplate.query(s+where + " and (bill_orderno =‘‘ or bill_orderno = null) order by create_date Desc", rowMapper1);
jdbcTemplate查询结果为对象list
标签：cte query ttl lis 查询 new template row order by