[語法] Criteria JPA 語法

[airhong (艾爾洪斯)]

您好
我想寫SELECT SUM(cevecoin) FROM coin where clid="ABC";

但一直都沒辦法成功 可以幫我看看嗎? 謝謝
code如下

        @Override
        public Integer SumCoin(String Clid) {
                CriteriaBuilder builder =getSession().getCriteriaBuilder();
                CriteriaQuery<CoinBean> criteria =builder.createQuery(CoinBean.class);
                Root<CoinBean> root = criteria.from(CoinBean.class);
                builder.sum(root.get("Clid"));
                return
                getSession().createQuery(criteria).getSingleResult().getCevecoin();
        }

--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 118.163.218.98 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/java/M.1604391934.A.196.html