我这样执行的自定义sql，要怎么获取到结果值啊？求指教

@Inject
    @Reference
    private PayRefundService payRefundService;



Sql sql = Sqls.create("select count(*)" +
                "            from" +
                "            pay_refund" +
                "            where OrderId in" +
                "            (select OrderId from pay_order where agentId='" + agentId + "' and ifAgent='1')" +
                "            and ifSuccess='1'");
        Sql execute = payRefundService.execute(sql);

wendal

1楼•1929天前

设置回调

wendal

2楼•1929天前

把自定义SQL的文档看看嘛, 尽量不要把参数拼入sql, 很危险的

qq_d1f14d3c 3楼•1929天前

好哒，新入坑的学生小白，会多多学习的

qq_d1f14d3c 4楼•1929天前

@wendal 好哒，新入坑的学生小白，会多多学习的

qq_d1f14d3c 5楼•1929天前

@wendal

Sql sql = Sqls.create("select *" +
                "            from" +
                "            pay_refund" +
                "            where yhOrderId in" +
                "            (select yhOrderId from pay_order where agentId=@agentId and ifAgent='1')" +
                "            and ifSuccess='1'");
        sql.setVar("agentId",agentId);
        refundList = payRefundService.query(Cnd.where((SqlExpression) sql));

报这个错
java.lang.ClassCastException: org.nutz.dao.impl.sql.NutSql cannot be cast to org.nutz.dao.util.cri.SqlExpression
at cn.wizzer.app.web.modules.controllers.platform.pay.PayStatisticsController.orderData(PayStatisticsController.java:143)
at cn.wizzer.app.web.modules.controllers.platform.pay.PayStatisticsController$FM$orderData$254c05ef9d471bc2ecada6b6c92aeb7d.invoke(PayStatisticsController.java)

wendal

6楼•1929天前

再看2次文档

请先登陆