{"id":1763,"date":"2025-09-08T19:39:31","date_gmt":"2025-09-08T11:39:31","guid":{"rendered":"https:\/\/zero-zl.cn\/?p=1763"},"modified":"2025-09-08T19:39:32","modified_gmt":"2025-09-08T11:39:32","slug":"04-springboot3%e6%95%b4%e5%90%88mybatis%e5%ae%9e%e7%8e%b0%e6%95%b0%e6%8d%ae%e5%ba%93%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/zero-zl.cn\/index.php\/2025\/09\/08\/04-springboot3%e6%95%b4%e5%90%88mybatis%e5%ae%9e%e7%8e%b0%e6%95%b0%e6%8d%ae%e5%ba%93%e6%93%8d%e4%bd%9c\/","title":{"rendered":"04.Springboot3\u6574\u5408MyBatis\u5b9e\u73b0\u6570\u636e\u5e93\u64cd\u4f5c"},"content":{"rendered":"\n

\u65b0\u5efa\u6570\u636e\u5e93<\/h2>\n\n\n\n

\u914d\u7f6e\u5b57\u7b26\u96c6\u548c\u7f16\u7801<\/h3>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n

\u65b0\u5efa\u8868\u7ba1\u7406\u5458\u8868admin<\/h3>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n

admin\u8868\u7ed3\u6784<\/p>\n\n\n\n

CREATE TABLE `admin` (\n  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',\n  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '\u8d26\u53f7',\n  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '\u5bc6\u7801',\n  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '\u540d\u79f0',\n  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '\u624b\u673a\u53f7',\n  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '\u90ae\u7bb1',\n  PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='\u7ba1\u7406\u5458\u4fe1\u606f';<\/code><\/pre>\n\n\n\n
\u8bbe\u7f6eusername\u552f\u4e00<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
Spring Boot\u96c6\u6210Mybatis<\/h2>\n\n\n\n
\u5728pom.xml\u91cc\u9762\u6dfb\u52a0Mysql\u548cMyBatis\u4f9d\u8d56<\/p>\n\n\n\n
<dependency>\n    <groupId>com.mysql<\/groupId>\n    <artifactId>mysql-connector-j<\/artifactId>\n    <scope>runtime<\/scope>\n<\/dependency>\n\n<dependency>\n    <groupId>org.mybatis.spring.boot<\/groupId>\n    <artifactId>mybatis-spring-boot-starter<\/artifactId>\n    <version>3.0.3<\/version>\n<\/dependency><\/code><\/pre>\n\n\n\n
Spring Boot\u914d\u7f6e\u6570\u636e\u5e93\u548cMybatis<\/h2>\n\n\n\n
application.yml\u91cc\u7684\u914d\u7f6e<\/h3>\n\n\n\n
#\u6570\u636e\u5e93\u914d\u7f6e\nspring:\n  datasource:\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql:\/\/127.0.0.1:3306\/demodb?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&allowMultiQueries=true&useSSL=false&allowPublicKeyRetrieval=true\n    username: root\n    password: root\n#\u914d\u7f6emybatis\u5b9e\u4f53\u548cxml\u6620\u5c04\nmybatis:\n  #xml\u6620\u5c04\n  mapper-locations: classpath:mapper\/*.xml\n  configuration:\n    #\u914d\u7f6e\u65e5\u5fd7\n    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\n    map-underscore-to-camel-case: true    #\u628a\u6570\u636e\u5e93\u4e0b\u5212\u7ebf\u6620\u5c04\u4e3a\u9a7c\u5cf0\uff0ccategory_id -> categoryId<\/code><\/pre>\n\n\n\n
classpath\uff1a\u8868\u793aresource\u7684\u76ee\u5f55\uff0c\u4ecemapper\u91cc\u626b\u63cf\u6240\u4ee5.xml\u7ed3\u5c3e\u7684\u6587\u4ef6<\/strong><\/p>\n\n\n\n
\u521b\u5efa\u5b9e\u4f53\u7c7bAdmin<\/h3>\n\n\n\n
entity\/Admin.java<\/p>\n\n\n\n
package org.example.springdemo.entity;\n\n\/**\n * \u7ba1\u7406\u5458\u4fe1\u606f\n *\/\npublic class Admin {\n    private Integer id;\n    private String username;\n    private String password;\n    private String user;\n    private String phone;\n    private String email;\n\n    public Integer getId() {\n        return id;\n    }\n\n    public void setId(Integer id) {\n        this.id = id;\n    }\n\n    public String getUsername() {\n        return username;\n    }\n\n    public void setUsername(String username) {\n        this.username = username;\n    }\n\n    public String getPassword() {\n        return password;\n    }\n\n    public void setPassword(String password) {\n        this.password = password;\n    }\n\n    public String getUser() {\n        return user;\n    }\n\n    public void setUser(String user) {\n        this.user = user;\n    }\n\n    public String getPhone() {\n        return phone;\n    }\n\n    public void setPhone(String phone) {\n        this.phone = phone;\n    }\n\n    public String getEmail() {\n        return email;\n    }\n\n    public void setEmail(String email) {\n        this.email = email;\n    }\n}\n<\/code><\/pre>\n\n\n\n
\u521b\u5efamapper\u6587\u4ef6\u5939\u5b58\u653exml\u6587\u4ef6<\/h3>\n\n\n\n
resources\/mapper\/AdminMapper.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n        PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"org.example.springdemo.mapper.AdminMapper\">\n\n    <select id=\"selectAll\" resultType=\"org.example.springdemo.entity.Admin\">\n        select * from `admin` order by id desc\n    <\/select>\n\n<\/mapper><\/code><\/pre>\n\n\n\n
\u521b\u5efamapper\u63a5\u53e3\u5c42<\/h3>\n\n\n\n
mapper\/AdminMapper.java<\/p>\n\n\n\n
package org.example.springdemo.mapper;\n\nimport org.example.springdemo.entity.Admin;\n\nimport java.util.List;\n\npublic interface AdminMapper {\n\n    List<Admin> selectAll();\n\n}\n<\/code><\/pre>\n\n\n\n
\u5728\u542f\u52a8\u7c7b\u91cc\u9762 \u626b\u63cf\u63a5\u53e3\u5c42<\/h3>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
Mapper\u63a5\u53e3\u548cMapper.xml\u7684\u5173\u7cfb<\/h2>\n\n\n\n
Mapper\u5b9a\u4e49\u63a5\u53e3\u65b9\u6cd5<\/strong><\/p>\n\n\n\n
Mapper.xml\u91cc\u9762\u5b9e\u73b0\u65b9\u6cd5\uff08SQL\u8bed\u53e5\u5b9e\u73b0\uff09<\/strong><\/p>\n\n\n\n
\u8fde\u63a5\u6570\u636e\u5e93\u5199\u4e00\u4e2a\u67e5\u8be2\u63a5\u53e3<\/h2>\n\n\n\n
Controller\/AdminController.java<\/h3>\n\n\n\n
package org.example.springdemo.controller;\n\nimport jakarta.annotation.Resource;\nimport org.example.springdemo.common.Result;\nimport org.example.springdemo.entity.Admin;\nimport org.example.springdemo.service.AdminService;\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.RequestMapping;\nimport org.springframework.web.bind.annotation.RestController;\n\nimport java.util.List;\n\n@RestController\n@RequestMapping(\"\/admin\")\npublic class AdminController {\n\n    @Resource\n    AdminService adminService;\n\n    @GetMapping(\"\/selectAll\")   \/\/\u5b8c\u6574\u7684\u8bf7\u6c42\u8def\u5f84\u4e3a\uff1ahttp:\/\/localhost:9999\/admin\/selectAll\n    public Result selectAll()\n    {\n        List<Admin> adminList = adminService.selectAll();\n        return Result.success(adminList);\n    }\n\n}\n<\/code><\/pre>\n\n\n\n
Service\/AdminService.java<\/h3>\n\n\n\n
package org.example.springdemo.service;\n\nimport jakarta.annotation.Resource;\nimport org.example.springdemo.entity.Admin;\nimport org.example.springdemo.exception.CustomerException;\nimport org.example.springdemo.mapper.AdminMapper;\nimport org.springframework.stereotype.Service;\n\nimport java.util.List;\n\n@Service\npublic class AdminService {\n\n    @Resource\n    AdminMapper adminMapper;\n\n    public String admin(String name) {\n        if (\"admin\".equals(name)) {\n            return \"admin\";\n        }else {\n            throw new CustomerException(\"\u8d26\u53f7\u9519\u8bef\");\n        }\n    }\n\n    public List<Admin> selectAll() {\n        return adminMapper.selectAll();\n    }\n}\n<\/code><\/pre>\n\n\n\n
Mapper\/AdminMapper.java<\/h3>\n\n\n\n
package org.example.springdemo.mapper;\n\nimport org.example.springdemo.entity.Admin;\n\nimport java.util.List;\n\npublic interface AdminMapper {\n\n    List<Admin> selectAll();\n\n}<\/code><\/pre>\n\n\n\n
resources\/mapper\/AdminMapper.xml<\/h3>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n        PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"org.example.springdemo.mapper.AdminMapper\">\n\n    <select id=\"selectAll\" resultType=\"org.example.springdemo.entity.Admin\">\n        select * from `admin` order by id desc\n    <\/select>\n\n<\/mapper><\/code><\/pre>\n\n\n\n
\u6d4b\u8bd5\u67e5\u8be2\u63a5\u53e3<\/h2>\n\n\n\n
\u91cd\u65b0\u542f\u52a8spring boot\u9879\u76ee\uff0c\u6d4f\u89c8\u5668\u8bbf\u95eehttp:\/\/localhost:9999\/admin\/selectAll<\/a><\/p>\n\n\n\n
\"\"<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"
\u65b0\u5efa\u6570\u636e\u5e93 \u914d\u7f6e\u5b57\u7b26\u96c6\u548c\u7f16\u7801 \u65b0\u5efa\u8868\u7ba1\u7406\u5458\u8868admin admin\u8868\u7ed3\u6784 \u8bbe\u7f6eusername\u552f\u4e00 Sprin […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[114,102],"tags":[],"class_list":["post-1763","post","type-post","status-publish","format-standard","hentry","category-spring-boot3vue3","category-102"],"_links":{"self":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts\/1763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1763"}],"version-history":[{"count":1,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts\/1763\/revisions"}],"predecessor-version":[{"id":1769,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts\/1763\/revisions\/1769"}],"wp:attachment":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}