代码内容
String jpql="FROM Finance ORDER BY ? DESC";
Query query = em.createQuery(jpql);
query.setParameter(1,"price");
query.setFirstResult(0);
query.setMaxResults(7);
List<Finance>finances=query.getResultList();
for (Finance finance:finances){
System.out.println(finance);
}
查询结果
Hibernate: select finance0_.id as id1_0_, finance0_.abrasives as abrasive2_0_, finance0_.arrears as arrears3_0_, finance0_.customer as customer4_0_, finance0_.deliverydate as delivery5_0_, finance0_.orderdate as orderdat6_0_, finance0_.price as price7_0_, finance0_.remarks as remarks8_0_, finance0_.state as state9_0_ from finance finance0_ order by ? DESC limit ?
Finance{id=1, customer='15', price=6, abrasives=7, orderdate=2021-10-13 00:00:00.0, deliverydate=2021-10-04 00:00:00.0, state='null', arrears=null, remarks='55', workers=}
Finance{id=2, customer='3', price=3, abrasives=3, orderdate=2021-07-18 00:00:00.0, deliverydate=2021-10-14 00:00:00.0, state='null', arrears=null, remarks='33', workers=}
Finance{id=3, customer='221', price=2, abrasives=null, orderdate=null, deliverydate=null, state='null', arrears=null, remarks='null', workers=}
Finance{id=4, customer='null', price=7, abrasives=null, orderdate=null, deliverydate=null, state='null', arrears=null, remarks='null', workers=}
Finance{id=5, customer='null', price=null, abrasives=null, orderdate=null, deliverydate=null, state='null', arrears=null, remarks='null', workers=}
Finance{id=6, customer='null', price=null, abrasives=null, orderdate=null, deliverydate=null, state='null', arrears=null, remarks='null', workers=}
Finance{id=7, customer='null', price=null, abrasives=null, orderdate=null, deliverydate=null, state='null', arrears=null, remarks='null', workers=}