时间:2021-07-01 10:21:17 帮助过:6人阅读
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