{"id":392,"date":"2017-07-04T20:50:34","date_gmt":"2017-07-04T12:50:34","guid":{"rendered":"http:\/\/www.dd-home.top\/?p=392"},"modified":"2017-07-04T20:50:34","modified_gmt":"2017-07-04T12:50:34","slug":"jpa-hibernate-%e6%9f%a5%e8%af%a2%e7%bb%93%e6%9e%9c%e8%bd%ac%e5%8c%96%e6%88%90%e5%af%b9%e8%b1%a1","status":"publish","type":"post","link":"https:\/\/www.dd-home.top\/?p=392","title":{"rendered":"JPA hibernate \u67e5\u8be2\u7ed3\u679c\u8f6c\u5316\u6210\u5bf9\u8c61"},"content":{"rendered":"<p><!--more--><\/p>\n<pre>@Override\npublic QueryResult&lt;CustomerWatchItem&gt; getCustomerScrollData(int firstResult, int maxresult, String wherejpql, Object[] queryParams, LinkedHashMap&lt;String, String&gt; orderby) {\n    QueryResult qr = new QueryResult();\n    String sql=\"SELECT o.watchTimeStr,o.watchTime,o.statue,o.name,o.number,db.fx10mins,db.fs10mins,db1.benzhanqiya,db2.qiwen,db2.ludianwendu,db2.xiangduishidu,db3.tenmins,db4.xiaoshijiangyuliang FROM db_m_watchitem o LEFT JOIN db_m_watchitem_wind db ON o.id = db.data_id LEFT JOIN db_m_watchitem_pressure db1 ON o.id = db1.data_id LEFT JOIN db_m_watchitem_temhum db2 ON o.id=db2.data_id LEFT JOIN db_m_watchitem_visible db3 ON o.id=db3.data_id LEFT JOIN db_m_watchitem_dre db4 ON o.id=db4.data_id \";\n    Query query = this.em.createNativeQuery(sql + (wherejpql != null &amp;&amp; !\"\".equals(wherejpql.trim())?\"where \" + wherejpql:\"\") + buildOrderby(orderby));\n    setQueryParams(query, queryParams);\n    <span style=\"text-decoration: underline; font-family: verdana, geneva, sans-serif;\">query.unwrap(SQLQuery.class).setResultTransformer(Transformers.aliasToBean( CustomerWatchItem.class));<\/span>\n    if(firstResult != -1 &amp;&amp; maxresult != -1) {\n        query.setFirstResult(firstResult).setMaxResults(maxresult);\n    }\n\n    qr.setResultlist(query.getResultList());\n    query = this.em.createQuery(\"select count(\"+getCountField(this.entityClass)+\") from \" + getEntityName(this.entityClass) + \" o \" + (wherejpql != null &amp;&amp; !\"\".equals(wherejpql.trim())?\"where \" + wherejpql:\"\"));\n    setQueryParams(query, queryParams);\n    qr.setTotalrecord(((Long)query.getSingleResult()).longValue());\n    return qr;\n}\n\n<\/pre>\n<p>\u6ce8\u610f\u7684\u662f,\u5fc5\u987b\u5bf9\u67e5\u8be2\u51fa\u6765\u7684\u7ed3\u679c\u63d0\u4f9bgetset\u65b9\u6cd5,\u5426\u5219\u5f02\u5e38<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-392","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=392"}],"version-history":[{"count":0,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/392\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}