小船浆~ 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日
    • 展开全部

    悬赏问题

    • ¥15 求解 yolo算法问题
    • ¥15 虚拟机打包apk出现错误
    • ¥30 最小化遗憾贪心算法上界
    • ¥15 用visual studi code完成html页面
    • ¥15 聚类分析或者python进行数据分析
    • ¥15 三菱伺服电机按启动按钮有使能但不动作
    • ¥15 js,页面2返回页面1时定位进入的设备
    • ¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
    • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
    • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝