{"id":4018,"date":"2024-08-20T11:55:17","date_gmt":"2024-08-20T03:55:17","guid":{"rendered":"https:\/\/qaqaq.top\/?p=4018"},"modified":"2024-08-20T14:14:56","modified_gmt":"2024-08-20T06:14:56","slug":"mybatis-plus%e5%88%86%e9%a1%b5%e6%8f%92%e4%bb%b6","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=4018","title":{"rendered":"MyBatis-Plus\u5206\u9875\u63d2\u4ef6"},"content":{"rendered":"\n

\u5206\u9875\u63d2\u4ef6<\/h2>\n\n\n\n

MyBatis Plus\u81ea\u5e26\u5206\u9875\u63d2\u4ef6\uff0c\u53ea\u8981\u7b80\u5355\u7684\u914d\u7f6e\u5373\u53ef\u5b9e\u73b0\u5206\u9875\u529f\u80fd<\/p>\n\n\n\n

1\u3001\u6dfb\u52a0\u914d\u7f6e\u7c7b<\/h3>\n\n\n\n
@Configuration\n\/\/\u626b\u63cfmapper\u63a5\u53e3\u6240\u5728\u7684\u5305\n@MapperScan(\"top.qaqaq.mybatisplus.mapper\")\npublic class MyBatisPlusConfig {\n\n    @Bean\n    public MybatisPlusInterceptor mybatisPlusInterceptor() {\n        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();\n        \/\/\u6dfb\u52a0\u5206\u9875\u63d2\u4ef6\n        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));\n        return interceptor;\n    }\n\n}<\/code><\/pre>\n\n\n\n
2\u3001\u6d4b\u8bd5<\/h3>\n\n\n\n
    \/\/\u5206\u9875\u76f8\u5173\u6570\u636e\u83b7\u53d6\n    @Test\n    public void testPage() {\n        Page<User> page = new Page<>(1, 3);\n        userMapper.selectPage(page, null);\n        \/\/\u83b7\u53d6\u5f53\u524d\u9875\u6570\u636e getRecords()\n        System.out.println(page.getRecords());\n        \/\/\u83b7\u53d6\u603b\u9875\u6570 getPages()\n        System.out.println(page.getPages());\n        \/\/\u83b7\u53d6\u603b\u8bb0\u5f55\u6570 getTotal()\n        System.out.println(page.getTotal());\n        \/\/\u662f\u5426\u6709\u4e0b\u4e00\u9875 hasNext()\n        System.out.println(page.hasNext());\n        \/\/\u662f\u5426\u6709\u4e0a\u4e00\u9875 hasPrevious()\n        System.out.println(page.hasPrevious());\n    }<\/code><\/pre>\n\n\n\n
xml\u81ea\u5b9a\u4e49\u5206\u9875<\/h2>\n\n\n\n
1\u3001UserMapper\u4e2d\u5b9a\u4e49\u63a5\u53e3\u65b9\u6cd5<\/h3>\n\n\n\n
    \/**\n     * \u901a\u8fc7\u5e74\u9f84\u67e5\u8be2\u7528\u6237\u4fe1\u606f\u5e76\u5206\u9875\n     * @param page MyBatis-Plus\u6240\u63d0\u4f9b\u7684\u5206\u9875\u5bf9\u8c61\uff0c\u5fc5\u987b\u4f4d\u4e8e\u7b2c\u4e00\u4e2a\u53c2\u6570\u7684\u4f4d\u7f6e\n     * @param age\n     * @return\n     *\/\n    Page<User> selectPageVo(@Param(\"page\") Page<User> page, @Param(\"age\") Integer age);<\/code><\/pre>\n\n\n\n
2\u3001UserMapper.xml\u4e2d\u7f16\u5199SQL<\/h3>\n\n\n\n
    <!--Page<User> selectPageVo(@Param(\"page\") Page<User> page, @Param(\"age\") Integer age);-->\n    <select id=\"selectPageVo\" resultType=\"User\">\n        select uid, user_name, age, email from t_user where age > #{age}\n    <\/select><\/code><\/pre>\n\n\n\n
3\u3001\u6d4b\u8bd5<\/h3>\n\n\n\n
    \/\/\u81ea\u5b9a\u4e49\u5206\u9875\u529f\u80fd\n    @Test\n    public void testPageVo() {\n        Page<User> page = new Page<>(1, 3);\n        userMapper.selectPageVo(page, 20);\n        \/\/\u83b7\u53d6\u5f53\u524d\u9875\u6570\u636e getRecords()\n        System.out.println(page.getRecords());\n        \/\/\u83b7\u53d6\u603b\u9875\u6570 getPages()\n        System.out.println(page.getPages());\n        \/\/\u83b7\u53d6\u603b\u8bb0\u5f55\u6570 getTotal()\n        System.out.println(page.getTotal());\n        \/\/\u662f\u5426\u6709\u4e0b\u4e00\u9875 hasNext()\n        System.out.println(page.hasNext());\n        \/\/\u662f\u5426\u6709\u4e0a\u4e00\u9875 hasPrevious()\n        System.out.println(page.hasPrevious());\n    }<\/code><\/pre>\n\n\n\n
\u6ce8<\/h3>\n\n\n\n
application.yaml\u4e2d\u9700\u6dfb\u52a0\u5982\u4e0b\u4ee3\u7801<\/p>\n\n\n\n
mybatis-plus:\n  # \u914d\u7f6e\u7c7b\u578b\u522b\u540d\u6240\u5bf9\u5e94\u7684\u5305\n  type-aliases-package: top.qaqaq.mybatisplus.pojo<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u5206\u9875\u63d2\u4ef6 MyBatis Plus\u81ea\u5e26\u5206\u9875\u63d2\u4ef6\uff0c\u53ea\u8981\u7b80\u5355\u7684\u914d\u7f6e\u5373\u53ef\u5b9e\u73b0\u5206\u9875\u529f\u80fd 1\u3001\u6dfb\u52a0\u914d\u7f6e\u7c7b 2\u3001\u6d4b\u8bd5 xm […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[165],"tags":[183],"class_list":["post-4018","post","type-post","status-publish","format-standard","hentry","category-mybatisplus-","tag-mybatisplus"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/4018"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4018"}],"version-history":[{"count":4,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/4018\/revisions"}],"predecessor-version":[{"id":4023,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/4018\/revisions\/4023"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}