{"id":1091,"date":"2020-07-16T11:48:01","date_gmt":"2020-07-16T03:48:01","guid":{"rendered":"http:\/\/diuut.com\/?p=1091"},"modified":"2020-07-16T11:48:03","modified_gmt":"2020-07-16T03:48:03","slug":"%e5%9f%ba%e4%ba%8ejpa%e7%9a%84%e5%88%86%e9%a1%b5%e6%8e%92%e5%ba%8f","status":"publish","type":"post","link":"https:\/\/diuut.com\/?p=1091","title":{"rendered":"\u57fa\u4e8eJPA\u7684\u5206\u9875\u6392\u5e8f"},"content":{"rendered":"\n<blockquote class=\"wp-block-quote\"><p>\u9700\u6c42\uff1a\u6392\u884c\u699c\u529f\u80fd\u9700\u8981\u5168\u8868\u4e2d\u6761\u4ef6\u67e5\u8be2\u5e76\u6392\u5e8f\uff0c\u53d6\u51fa\u524d20\u653e\u5165redis\u4e2d\u7684zset\u4f5c\u4e3a\u521d\u59cb\u6392\u884c\u699c<\/p><\/blockquote>\n\n\n\n<h4>\u65b9\u6cd5\u4e00: \u539f\u751fSql<\/h4>\n\n\n\n<p>\u5728\u63a5\u53e3\u4e2d\u5e26\u4e0a@query\u6ce8\u89e3\uff0c\u5728\u6ce8\u89e3\u53c2\u6570\u4e2d\u9644\u4e0asql\u8bed\u53e5\u5e76\u9884\u7559\u5360\u4f4d\u7b26\u5373\u53ef\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: java; title: ; notranslate\" title=\"\">\npublic interface TaskDao extends JpaRepository&lt;Task, Long&gt; {\n  @Query(&quot;select * from tb_task t where t.task_name = ?1 order by ?2&quot;, nativeQuery = true)\n  Task findByTaskName(String taskName,int chip);\n}\n<\/pre><\/div>\n\n\n<p>\u4e0d\u5efa\u8bae\u76f4\u63a5\u4f7f\u7528@query\uff0c\u56e0\u4e3a\u5927\u591a\u6570\u7b80\u5355\u529f\u80fd\u67e5\u8be2jpa\u672c\u8eab\u5df2\u7ecf\u81ea\u5e26\uff0c\u9664\u975e\u7279\u522b\u590d\u6742\u6216\u8005\u9700\u8981\u7279\u522b\u4f18\u5316\u7684sql\u67e5\u8be2\u624d\u6709\u5fc5\u8981\u4f7f\u7528\u8be5\u65b9\u6cd5<\/p>\n\n\n\n<h4> \u65b9\u6cd5\u4e8c: \u901a\u8fc7Pageable\u3001Sort\u7c7b<\/h4>\n\n\n\n<p>\u5728jpa\u7684findAll\u65b9\u6cd5\u4e2d\u63d0\u4f9b\u4e86\u5bf9\u4e8ePageable\u7c7b\u4e0eSort\u7c7b\u7684\u652f\u6301\uff0c\u5355\u72ec\u7684\u5206\u9875\u4e0e\u5355\u72ec\u7684\u6392\u5e8f\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528findAll\u65b9\u6cd5\u5229\u7528\u8fd9\u4e24\u4e2a\u7c7b\u4f5c\u4e3a\u6761\u4ef6\u8fdb\u884c\u67e5\u8be2\uff0c\u5982\u679c\u65e2\u9700\u8981\u6392\u5e8f\u53c8\u9700\u8981\u5206\u9875\uff0c\u53ef\u4ee5\u5728Pageable\u4e2d\u63d2\u5165Sort\u7c7b\u6765\u4f7f\u7528\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: java; title: ; notranslate\" title=\"\">\n    @Test\n    public void test() {\n        Sort sort=Sort.by(Sort.Direction.DESC,&quot;gold&quot;);\/\/\u6392\u5e8f\u89c4\u5219\uff0c\u6761\u4ef6\u5b57\u6bb5\u4e3alist\uff0c\u53ef\u4ee5\u591a\u4e2a\n        Pageable pageable=PageRequest.of(0,20,sort);\/\/\u5206\u9875\u8303\u56f4\uff0c\u6392\u5e8f\n        Page&lt;User&gt; userPage = userDao.findAll(pageable);\n        log.info(&quot;userPage:{}&quot;, userPage.getContent());\n    }\n<\/pre><\/div>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9700\u6c42\uff1a\u6392\u884c\u699c\u529f\u80fd\u9700\u8981\u5168\u8868\u4e2d\u6761\u4ef6\u67e5\u8be2\u5e76\u6392\u5e8f\uff0c\u53d6\u51fa\u524d20\u653e\u5165redis\u4e2d\u7684zset\u4f5c\u4e3a\u521d\u59cb\u6392\u884c\u699c \u65b9\u6cd5\u4e00: \u539f\u751fS<span class=\"more-button\"><a href=\"https:\/\/diuut.com\/?p=1091\" class=\"more-link\">view all . . .<span class=\"screen-reader-text\">\u57fa\u4e8eJPA\u7684\u5206\u9875\u6392\u5e8f<\/span><\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":1092,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/posts\/1091"}],"collection":[{"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/diuut.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1091"}],"version-history":[{"count":1,"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/posts\/1091\/revisions"}],"predecessor-version":[{"id":1093,"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/posts\/1091\/revisions\/1093"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/diuut.com\/index.php?rest_route=\/wp\/v2\/media\/1092"}],"wp:attachment":[{"href":"https:\/\/diuut.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/diuut.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/diuut.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}