spring boot——spring boot的基本配置——spring boot整合mybatis——教程

忘是亡心i 2023-09-28 23:53 5阅读 0赞

![20d41cdf5676b15145ffd23a189c15e5.png][]

![444632aefb2b21205d85f61690136158.png][]

![55134511a6344ef00d45dfb95a6f61ba.png][]

第二步——修改pom.xml文件：

![1d42e04ffb49a23827df201ca95bebda.png][]

![1fa1b6d391772a13dbb78e016bea49d2.png][]

pom文件：

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.1.7.RELEASE</version>
            <relativePath/> 
        </parent>
        <groupId>com.ch</groupId>
        <artifactId>ch6_6</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>ch6_6</name>
        <description>Demo project for Spring Boot</description>
    
        <properties>
            <java.version>11</java.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.45</version>
                
            </dependency>
            
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.0</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

第三步——设置数据源信息——application.properties：

![e25882aa9b4f5660ad1f65055733d063.png][]

![c057e787918e8ddb43e3fb050ab2d9ab.png][]

server.servlet.context-path=/ch6_6
    ###
    ##数据源信息配置
    ###
    #数据库地址
    spring.datasource.url=jdbc:mysql://localhost:3306/springbootjpa?characterEncoding=utf8
    #数据库MySQL为8.x时，url为jdbc:mysql://localhost:3306/springbootjpa?useSSL=false&serverTimezone=Asia/Beijing&characterEncoding=utf-8
    #数据库用户名
    spring.datasource.username=root
    #数据库密码
    spring.datasource.password=root
    #数据库驱动
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    #数据库MySQL为8.x时，驱动类为com.mysql.cj.jdbc.Driver
    #设置包别名(在Mapper映射文件中直接使用实体类名)
    mybatis.type-aliases-package=com.ch.ch6_6.entity
    #告诉系统在哪里去找mapper.xml文件(映射文件)
    mybatis.mapperLocations=classpath:mappers/*.xml
    #在控制台输出SQL语句日志
    logging.level.com.ch.ch6_6.repository=debug
    #让控制器输出的JSON字符串格式更美观
    spring.jackson.serialization.indent-output=true

第四步——创建java实体类：

![914d85ecccc646bb3a0c688a684a3071.png][]

package com.ch.ch6_6.entity;
    public class MyUser {
        private Integer id;
        private String username;
        private String password;
        public Integer getId() {
            return id;
        }
        public void setId(Integer id) {
            this.id = id;
        }
        public String getUsername() {
            return username;
        }
        public void setUsername(String username) {
            this.username = username;
        }
        public String getPassword() {
            return password;
        }
        public void setPassword(String password) {
            this.password = password;
        }
    }

第五步——创建数据访问接口：

![b708b6960b415448c1a80b27d81f07eb.png][]

package com.ch.ch6_6.repository;
    import java.util.List;
    import org.apache.ibatis.annotations.Mapper;
    import com.ch.ch6_6.entity.MyUser;
    /**
     * MyBatis的Mapper映射接口
     */
    @Mapper
    public interface MyUserRepository {
        public List<MyUser> findAll();
    }

第六步——创建mapper映射文件：

![3a47f2366086e822b5ad8202b7874f44.png][]

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.ch.ch6_6.repository.MyUserRepository">
        <select id="findAll"  resultType="MyUser">
            select * from user 
        </select>
    </mapper>

第七步——创建业务层：

![7dc88a630fdfbe2ba4e8a3e81cd42d70.png][]

![97b36df66f556da7addeffc768c75e71.png][]

package com.ch.ch6_6.service;
    import java.util.List;
    import com.ch.ch6_6.entity.MyUser;
    public interface MyUserService {
        public List<MyUser> findAll(); }

package com.ch.ch6_6.service;
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.ch.ch6_6.entity.MyUser; import com.ch.ch6_6.repository.MyUserRepository; @Service public class MyUserServiceImpl implements MyUserService{ @Autowired private MyUserRepository myUserRepository; @Override public List<MyUser> findAll() { return myUserRepository.findAll(); } }

第八步——设置控制类：

![7d0aecdb2d823857e225c947a27f6189.png][]

package com.ch.ch6_6.controller;
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import com.ch.ch6_6.entity.MyUser;
    import com.ch.ch6_6.service.MyUserService;
    @RestController
    public class MyUserController {
        @Autowired
        private MyUserService myUserService;
        @RequestMapping("/findAll")
        public List<MyUser> findAll(){
            return myUserService.findAll();
        }
    }

第九步——设置扫描接口：

![b20f8beadd8ba748df164b1455ddb605.png][]

package com.ch.ch6_6;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    @SpringBootApplication
    //配置扫描MyBatis接口的包路径
    @MapperScan(basePackages={"com.ch.ch6_6.repository"})
    public class Ch66Application {
        public static void main(String[] args) {
            SpringApplication.run(Ch66Application.class, args);
        }
    }

第十步——浏览器访问：

![2de3c94099c2eedd67b588889f1fedf0.png][]

注意：一般注解不推荐使用：

![0aaec563298c6a74f1420c1d47ecabb8.png][]

========================================================================================

![47943c412de55345f04acee2e65d2b69.png][]

![396e9e4183f6e194fce3035947e0b7aa.png][]

![6cf3addf81f04f08b35caf4a21a6d666.png][]

![46a9db97f80d7ade80a590c8bb4055a3.png][]

![29b65104345781ca5e3bd295677147e6.png][]

![4960c067f8d77155d1cf3ff98cf2a151.png][]

![2369552499ca1fa6dd6058f4b4bfc53a.png][]

![17ee1d758b42fcb0f8aeef2b2fd395cf.png][]

[20d41cdf5676b15145ffd23a189c15e5.png]: https://img-blog.csdnimg.cn/img_convert/20d41cdf5676b15145ffd23a189c15e5.png
[444632aefb2b21205d85f61690136158.png]: https://img-blog.csdnimg.cn/img_convert/444632aefb2b21205d85f61690136158.png
[55134511a6344ef00d45dfb95a6f61ba.png]: https://img-blog.csdnimg.cn/img_convert/55134511a6344ef00d45dfb95a6f61ba.png
[1d42e04ffb49a23827df201ca95bebda.png]: https://img-blog.csdnimg.cn/img_convert/1d42e04ffb49a23827df201ca95bebda.png
[1fa1b6d391772a13dbb78e016bea49d2.png]: https://img-blog.csdnimg.cn/img_convert/1fa1b6d391772a13dbb78e016bea49d2.png
[e25882aa9b4f5660ad1f65055733d063.png]: https://img-blog.csdnimg.cn/img_convert/e25882aa9b4f5660ad1f65055733d063.png
[c057e787918e8ddb43e3fb050ab2d9ab.png]: https://img-blog.csdnimg.cn/img_convert/c057e787918e8ddb43e3fb050ab2d9ab.png
[914d85ecccc646bb3a0c688a684a3071.png]: https://img-blog.csdnimg.cn/img_convert/914d85ecccc646bb3a0c688a684a3071.png
[b708b6960b415448c1a80b27d81f07eb.png]: https://img-blog.csdnimg.cn/img_convert/b708b6960b415448c1a80b27d81f07eb.png
[3a47f2366086e822b5ad8202b7874f44.png]: https://img-blog.csdnimg.cn/img_convert/3a47f2366086e822b5ad8202b7874f44.png
[7dc88a630fdfbe2ba4e8a3e81cd42d70.png]: https://img-blog.csdnimg.cn/img_convert/7dc88a630fdfbe2ba4e8a3e81cd42d70.png
[97b36df66f556da7addeffc768c75e71.png]: https://img-blog.csdnimg.cn/img_convert/97b36df66f556da7addeffc768c75e71.png
[7d0aecdb2d823857e225c947a27f6189.png]: https://img-blog.csdnimg.cn/img_convert/7d0aecdb2d823857e225c947a27f6189.png
[b20f8beadd8ba748df164b1455ddb605.png]: https://img-blog.csdnimg.cn/img_convert/b20f8beadd8ba748df164b1455ddb605.png
[2de3c94099c2eedd67b588889f1fedf0.png]: https://img-blog.csdnimg.cn/img_convert/2de3c94099c2eedd67b588889f1fedf0.png
[0aaec563298c6a74f1420c1d47ecabb8.png]: https://img-blog.csdnimg.cn/img_convert/0aaec563298c6a74f1420c1d47ecabb8.png
[47943c412de55345f04acee2e65d2b69.png]: https://img-blog.csdnimg.cn/img_convert/47943c412de55345f04acee2e65d2b69.png
[396e9e4183f6e194fce3035947e0b7aa.png]: https://img-blog.csdnimg.cn/img_convert/396e9e4183f6e194fce3035947e0b7aa.png
[6cf3addf81f04f08b35caf4a21a6d666.png]: https://img-blog.csdnimg.cn/img_convert/6cf3addf81f04f08b35caf4a21a6d666.png
[46a9db97f80d7ade80a590c8bb4055a3.png]: https://img-blog.csdnimg.cn/img_convert/46a9db97f80d7ade80a590c8bb4055a3.png
[29b65104345781ca5e3bd295677147e6.png]: https://img-blog.csdnimg.cn/img_convert/29b65104345781ca5e3bd295677147e6.png
[4960c067f8d77155d1cf3ff98cf2a151.png]: https://img-blog.csdnimg.cn/img_convert/4960c067f8d77155d1cf3ff98cf2a151.png
[2369552499ca1fa6dd6058f4b4bfc53a.png]: https://img-blog.csdnimg.cn/img_convert/2369552499ca1fa6dd6058f4b4bfc53a.png
[17ee1d758b42fcb0f8aeef2b2fd395cf.png]: https://img-blog.csdnimg.cn/img_convert/17ee1d758b42fcb0f8aeef2b2fd395cf.png