{"id":2029,"date":"2023-04-01T20:21:00","date_gmt":"2023-04-01T12:21:00","guid":{"rendered":"https:\/\/www.appblog.cn\/?p=2029"},"modified":"2023-04-07T06:13:55","modified_gmt":"2023-04-06T22:13:55","slug":"spring-boot-integrate-mysql-mybatis-and-pagehelper-plugins","status":"publish","type":"post","link":"https:\/\/www.appblog.cn\/index.php\/2023\/04\/01\/spring-boot-integrate-mysql-mybatis-and-pagehelper-plugins\/","title":{"rendered":"Spring Boot\u96c6\u6210MySql\u3001MyBatis\u548cPageHelper\u63d2\u4ef6"},"content":{"rendered":"

\u914d\u7f6e\u6587\u4ef6<\/h2>\n

\u5728\u914d\u7f6e\u6587\u4ef6application.yml<\/code>\u4e2d\u914d\u7f6eMySql\u6570\u636e\u5e93\u8fde\u63a5\u6c60\u548cMybatis\u626b\u63cf\u5305\u4ee5\u53caPageHelper\u5206\u9875\u63d2\u4ef6<\/p>\n

<\/p>\n

server:\n  port: 8080\n  servlet:\n    context-path: \/\nspring:\n#  mvc:\n#    view:\n#      prefix: \/WEB-INF\/views\/\n#      suffix: .jsp\n  freemarker:\n    template-loader-path: classpath:\/templates\/\n  datasource:\n      type: com.alibaba.druid.pool.DruidDataSource\n      driverClassName: com.mysql.jdbc.Driver\n      url: jdbc:mysql:\/\/127.0.0.1:3306\/test?useUnicode=true&characterEncoding=utf8\n      username: root\n      password: ubuntu\n      initialSize: 5\n      minIdle: 5\n      maxActive: 20\n      # \u914d\u7f6e\u83b7\u53d6\u8fde\u63a5\u7b49\u5f85\u8d85\u65f6\u7684\u65f6\u95f4\n      maxWait: 60000\n      # \u914d\u7f6e\u95f4\u9694\u591a\u4e45\u624d\u8fdb\u884c\u4e00\u6b21\u68c0\u6d4b\uff0c\u68c0\u6d4b\u9700\u8981\u5173\u95ed\u7684\u7a7a\u95f2\u8fde\u63a5\uff0c\u5355\u4f4d\u662f\u6beb\u79d2\n      timeBetweenEvictionRunsMillis: 60000\n      # \u914d\u7f6e\u4e00\u4e2a\u8fde\u63a5\u5728\u6c60\u4e2d\u6700\u5c0f\u751f\u5b58\u7684\u65f6\u95f4\uff0c\u5355\u4f4d\u662f\u6beb\u79d2\n      minEvictableIdleTimeMillis: 30000\n      validationQuery: select 'x'\n      testWhileIdle: true\n      testOnBorrow: false\n      testOnReturn: false\n      # \u6253\u5f00PSCache\uff0c\u5e76\u4e14\u6307\u5b9a\u6bcf\u4e2a\u8fde\u63a5\u4e0aPSCache\u7684\u5927\u5c0f\n      poolPreparedStatements: true\n      maxPoolPreparedStatementPerConnectionSize: 20\n      # \u914d\u7f6e\u76d1\u63a7\u7edf\u8ba1\u62e6\u622a\u7684filters\uff0c\u53bb\u6389\u540e\u76d1\u63a7\u754c\u9762sql\u65e0\u6cd5\u7edf\u8ba1\uff0c'wall'\u7528\u4e8e\u9632\u706b\u5899\n      filters: stat,wall,log4j\n      # \u901a\u8fc7connectProperties\u5c5e\u6027\u6765\u6253\u5f00mergeSql\u529f\u80fd\uff1b\u6162SQL\u8bb0\u5f55\n      connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\n      # \u5408\u5e76\u591a\u4e2aDruidDataSource\u7684\u76d1\u63a7\u6570\u636e\n      useGlobalDataSourceStat: true\n\nmybatis:\n  # \u6307\u5b9a\u6620\u5c04\u6587\u4ef6\n  mapper-locations: classpath:mapper\/*.xml\n  # \u6307\u5b9aBean\u6240\u5728\u5305\n  type-aliases-package: cn.appblog.springboot.dao.entity\n\nmapper:\n  # \u591a\u4e2a\u63a5\u53e3\u65f6\u9017\u53f7\u9694\u5f00\n  mappers: cn.appblog.common.mybatis.BaseMapper\n  not-empty: false\n  identity: MYSQL\n  #identity: SQLSERVER\n\npagehelper:\n  helperDialect: MYSQL\n  reasonable: true\n  supportMethodsArguments: true\n  params: count=countSql\n<\/code><\/pre>\n
\u540c\u65f6\uff0c\u9700\u8981\u5728pom.xml\u4e2d\u6dfb\u52a0\u76f8\u5e94\u7684jar\u5305\u4f9d\u8d56<\/p>\n
<!-- mysql -->\n<!-- https:\/\/mvnrepository.com\/artifact\/mysql\/mysql-connector-java -->\n<dependency>\n    <groupId>mysql<\/groupId>\n    <artifactId>mysql-connector-java<\/artifactId>\n    <version>5.1.47<\/version>\n<\/dependency>\n<!-- mybatis -->\n<!-- https:\/\/mvnrepository.com\/artifact\/org.mybatis\/mybatis -->\n<dependency>\n    <groupId>org.mybatis<\/groupId>\n    <artifactId>mybatis<\/artifactId>\n    <version>3.5.0<\/version>\n<\/dependency>\n<!-- https:\/\/mvnrepository.com\/artifact\/org.mybatis.spring.boot\/mybatis-spring-boot-starter -->\n<dependency>\n    <groupId>org.mybatis.spring.boot<\/groupId>\n    <artifactId>mybatis-spring-boot-starter<\/artifactId>\n    <version>2.0.0<\/version>\n<\/dependency>\n\n<!--druid -->\n<!-- https:\/\/mvnrepository.com\/artifact\/com.alibaba\/druid -->\n<dependency>\n    <groupId>com.alibaba<\/groupId>\n    <artifactId>druid<\/artifactId>\n    <version>1.1.14<\/version>\n<\/dependency>\n<!-- https:\/\/mvnrepository.com\/artifact\/com.alibaba\/druid-spring-boot-starter -->\n<!--<dependency>-->\n    <!--<groupId>com.alibaba<\/groupId>-->\n    <!--<artifactId>druid-spring-boot-starter<\/artifactId>-->\n    <!--<version>1.1.10<\/version>-->\n<!--<\/dependency>-->\n<!-- https:\/\/mvnrepository.com\/artifact\/log4j\/log4j -->\n<dependency>\n    <groupId>log4j<\/groupId>\n    <artifactId>log4j<\/artifactId>\n    <version>1.2.17<\/version>\n    <scope>compile<\/scope>\n<\/dependency>\n<!-- https:\/\/mvnrepository.com\/artifact\/org.slf4j\/slf4j-api -->\n<dependency>\n    <groupId>org.slf4j<\/groupId>\n    <artifactId>slf4j-api<\/artifactId>\n    <version>1.7.26<\/version>\n<\/dependency>\n\n<!-- https:\/\/mvnrepository.com\/artifact\/tk.mybatis\/mapper-spring-boot-starter -->\n<dependency>\n    <groupId>tk.mybatis<\/groupId>\n    <artifactId>mapper-spring-boot-starter<\/artifactId>\n    <version>2.1.5<\/version>\n<\/dependency>\n\n<!-- https:\/\/mvnrepository.com\/artifact\/com.github.pagehelper\/pagehelper-spring-boot-starter -->\n<dependency>\n    <groupId>com.github.pagehelper<\/groupId>\n    <artifactId>pagehelper-spring-boot-starter<\/artifactId>\n    <version>1.2.10<\/version>\n<\/dependency>\n\n<!-- https:\/\/mvnrepository.com\/artifact\/org.springframework.boot\/spring-boot-starter-freemarker -->\n<dependency>\n    <groupId>org.springframework.boot<\/groupId>\n    <artifactId>spring-boot-starter-freemarker<\/artifactId>\n    <version>2.1.3.RELEASE<\/version>\n<\/dependency><\/code><\/pre>\n
\u7ee7\u627f\u901a\u7528mapper<\/h2>\n
\u901a\u7528\u63a5\u53e3mapper\uff1a\u6b64\u63a5\u53e3\u4e0d\u80fd\u88ab\u626b\u63cf\u5230\uff0c\u5426\u5219\u4f1a\u62a5\u9519\uff0c\u53ef\u4ee5\u5728application.yml\u4e2d\uff0c\u6392\u9664\u6b64\u5305\u7684\u626b\u63cf<\/p>\n
Mapper3\u63d0\u4f9b\u7684\u5168\u90e8\u7684\u65b9\u6cd5\uff0c\u53ef\u4ee5\u67e5\u770bMapper3\u901a\u7528\u63a5\u53e3\u5927\u5168<\/a><\/p>\n
package cn.appblog.common.mybatis;\n\nimport tk.mybatis.mapper.common.Mapper;\nimport tk.mybatis.mapper.common.MySqlMapper;\n\n\/**\n * \u7ee7\u627f\u81ea\u5df1\u7684Mapper\n * @param <T>\n *\/\npublic interface BaseMapper<T> extends Mapper<T>, MySqlMapper<T> {\n    \/\/FIXME \u7279\u522b\u6ce8\u610f\uff0c\u8be5\u63a5\u53e3\u4e0d\u80fd\u88ab\u626b\u63cf\u5230\uff0c\u5426\u5219\u4f1a\u51fa\u9519\n}<\/code><\/pre>\n
\u66f4\u65b0\u5165\u53e3\u4e3b\u6587\u4ef6\u5e76\u8bbe\u7f6edao\u8def\u5f84<\/h2>\n
\u6b64\u5904\u9700\u8981\u6ce8\u610f@MapperSca<\/code>\u7684\u5f15\u7528\uff0c\u8fd9\u91cc\u67092\u4e2a\u53ef\u5f15\u7528\u7684\u5305\uff0c\u5206\u522b\u662ftk.mybatis.spring.annotation.MapperScan;<\/code>\u548corg.mybatis.spring.annotation.MapperScan;<\/code>\u3002
\ntk.mybatis.spring.annotation.MapperScan<\/code>\u4e3aMybatis\u5e26\u7684mapper\u626b\u63cf\u6587\u4ef6\uff0corg.mybatis.spring.annotation.MapperScan<\/code>\u4e3aSpring\u81ea\u5e26\u7684\u626b\u63cf\u6587\u4ef6\uff0c\u5728\u4f4e\u7248\u672c\u7684Mybatis\u4e0a\uff0c2\u4e2a\u5305\u53ef\u4ee5\u968f\u610f\u4f7f\u7528\uff0c\u4f46\u662fSpring Boot 2+\u540e\uff0c\u589e\u52a0\u4e86\u4e00\u4e9b\u7279\u6027\uff0c\u5bfc\u81f4\u53ea\u80fd\u4f7f\u7528\u9ad8\u7248\u672c\u7684Mybatis\uff0c\u540c\u65f6Spring\u81ea\u5e26\u7684MapperScan\u4e5f\u65e0\u6cd5\u4f7f\u7528\uff0c\u6240\u4ee5\u4f7f\u7528Spring Boot 2+\u540e\uff0c\u9700\u8981\u5f15\u7528\u9ad8\u7248\u672c\u7684Mybatis\uff0c\u540c\u65f6\u8fd9\u91cc\u53ea\u80fd\u4f7f\u7528Mybatis\u7684MapperScan\u7684\u626b\u63cf\u5305\u3002Spring\u5728\u540e\u671f\u66f4\u65b0\u4e2d\uff0c\u5e94\u8be5\u4e5f\u4f1a\u4f7f\u5176\u80fd\u591f\u7528\u4e8eSpring Boot\u4e2d\u3002<\/p>\n
\u5728Application\u4e2d\uff0c\u4ee5\u6ce8\u89e3\u7684\u5f62\u5f0f\u8bbe\u7f6e\u626b\u63cf\u7684basepackage\uff0c\u53ef\u4ee5\u8bbe\u7f6e\u591a\u4e2a\uff0cdao\u53ef\u5728\u4e0d\u540c\u8def\u5f84\u3002<\/p>\n
@MapperScan(basePackages = {"cn.appblog.*.dao.*", "cn.appblog.*.dao"}, markerInterface = BaseMapper.class)<\/code><\/pre>\n
import cn.appblog.common.mybatis.BaseMapper;\nimport org.springframework.boot.SpringApplication;\nimport org.springframework.boot.autoconfigure.SpringBootApplication;\nimport org.springframework.boot.web.servlet.ServletComponentScan;\nimport tk.mybatis.spring.annotation.MapperScan;\n\n@ServletComponentScan\n@MapperScan(basePackages = {"cn.appblog.*.dao.*", "cn.appblog.*.dao"}, markerInterface = BaseMapper.class)\n@SpringBootApplication\npublic class SpringbootApplication {\n\n    public static void main(String[] args) {\n        SpringApplication.run(SpringbootApplication.class, args);\n    }\n\n}<\/code><\/pre>\n
\u540e\u53f0\u4ee3\u7801\uff0c\u63a7\u5236\u5c42->\u670d\u52a1\u5c42->\u63a5\u53e3<\/h2>\n
@Controller\n@RequestMapping(value = "\/test")\npublic class TestController {\n    @Autowired\n    private TestService testService;\n\n    @RequestMapping(value = "\/index")\n    public String list(ModelMap modelMap) {\n    \/\/public ModelAndView list(ModelMap modelMap) {\n        List<Test> list = testService.getList();\n        modelMap.put("list", list);\n        return "test\/index";\n        \/\/return new ModelAndView("test\/index", modelMap);\n    }\n}<\/code><\/pre>\n
@Service\npublic class TestService {\n    @Autowired\n    private TestMapper testMapper;\n\n    public List<Test> getList() {\n        Example example = new Example(Test.class);\n        example.setTableName("user");\n        Example.Criteria criteria = example.createCriteria();\n        criteria.andBetween("age", 10, 30);\n        return testMapper.selectByExample(example);\n    }\n}<\/code><\/pre>\n
public interface TestMapper extends BaseMapper<Test> {\n\n}<\/code><\/pre>\n
@Table(name = "user")\npublic class Test implements Serializable, IDynamicTableName {\n    private static final long serialVersionUID = -8709793124943394842L;\n\n    @Transient\n    private String dynamicTableName;\n    private String name;\n    private Integer age;\n\n    public String getName() {\n        return name;\n    }\n\n    public void setName(String name) {\n        this.name = name;\n    }\n\n    public Integer getAge() {\n        return age;\n    }\n\n    public void setAge(Integer age) {\n        this.age = age;\n    }\n\n    @Override\n    public String getDynamicTableName() {\n        return null;\n    }\n}<\/code><\/pre>\n
\u6700\u540e\u4e00\u4e2a\u7c7b\u4e3a\u5b9e\u4f53\u7c7b\uff0c\u5efa\u8bae\u5728\u5efa\u7acb\u5b9e\u4f53\u7c7b\u65f6\uff0c\u7edf\u4e00\u52a0\u4e0a@Table<\/code>\u6ce8\u89e3\uff0c\u65b9\u4fbf\u540e\u671fMybatis\u7684\u4f7f\u7528\uff0c\u540c\u65f6\u4e5f\u63d0\u9ad8\u4e86\u4ee3\u7801\u7684\u89c4\u8303\u6027\u3002\u5f53\u7136\uff0c\u5982\u679c\u6211\u4eec\u4f7f\u7528Mybatis\u7684\u4ee3\u7801\u751f\u6210\u5668\uff0c\u90a3\u4e48\u5747\u4f1a\u81ea\u52a8\u52a0\u4e0a\u6ce8\u89e3\u3002<\/p>\n
\u524d\u7aefftl\u4ee3\u7801<\/h2>\n
application.yml\u914d\u7f6e\uff1a<\/p>\n
spring:\n  freemarker:\n    template-loader-path: classpath:\/templates\/<\/code><\/pre>\n
pom.xml\u914d\u7f6e\uff1a<\/p>\n
<!-- https:\/\/mvnrepository.com\/artifact\/org.springframework.boot\/spring-boot-starter-freemarker -->\n<dependency>\n    <groupId>org.springframework.boot<\/groupId>\n    <artifactId>spring-boot-starter-freemarker<\/artifactId>\n    <version>2.1.3.RELEASE<\/version>\n<\/dependency><\/code><\/pre>\n
<!DOCTYPE html>\n<html>\n<head lang="en">\n    <title>Spring Boot Demo - FreeMarker<\/title>\n    <link href="\/css\/index.css" rel="stylesheet" \/>\n<\/head>\n<body>\n<table>\n    <#list list as user>\n        <tr>\n            <td>\u7b2c${user_index+1}\u4e2a\u7528\u6237<\/td>\n            <td>\u7528\u6237\u540d\uff1a${user.name}<\/td>\n            <td>\u5e74  \u9f84: ${user.age}<\/td>\n        <\/tr>\n    <\/#list>\n<\/table>\n<\/body>\n<\/html><\/code><\/pre>\n
\u9879\u76ee\u542f\u52a8<\/h2>\n
\u8bbf\u95ee\uff1ahttp:\/\/localhost:8080\/test\/index<\/a><\/p>\n
\n
\u6ce8\uff1a\u6b63\u5e38\u542f\u52a8\u5373\u53ef\uff0c\u4e00\u5b9a\u4e0d\u80fd\u4f7f\u7528spring-boot:run<\/code>\u542f\u52a8<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"
\u914d\u7f6e\u6587\u4ef6 \u5728\u914d\u7f6e\u6587\u4ef6application.yml\u4e2d\u914d\u7f6eMySql\u6570\u636e\u5e93\u8fde\u63a5\u6c60\u548cMybatis\u626b\u63cf\u5305\u4ee5\u53caPag […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,41],"tags":[],"class_list":["post-2029","post","type-post","status-publish","format-standard","hentry","category-mybatis","category-spring-boot"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/2029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/comments?post=2029"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/2029\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=2029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=2029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=2029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}