小船浆~ 2021-10-23 10:27 采纳率: 70%
浏览 18
已结题

JPQL:想动态以某个字符串进行排序查询,但系统没报错也没排序

代码内容
                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=}



  • 写回答

0条回答 默认 最新

    报告相同问题?

    问题事件

    • 系统已结题 10月31日
    • 修改了问题 10月24日
    • 修改了问题 10月24日
    • 修改了问题 10月23日
    • 展开全部