RowMapper<WmsExpensesSettleEntity> rowMapper1=newBeanPropertyRowMapper<WmsExpensesSettleEntity>(WmsExpensesSettleEntity.class);List<WmsExpensesSettleEntity> list= jdbcTemplate.query(s+where +" and (bill_orderno ='' or bill_orderno = null) order by create_date Desc", rowMapper1);