springboot使用 mybatis 连接 MySQL

1. 创建好springboot项目 导入相关的依赖包

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.12</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.xmlunit</groupId>
            <artifactId>xmlunit-core</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
    </dependencies>

2. 项目结构
   
3. 在yml或properties中填写相关的数据库连接参数

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/waylon?serverTimezone=GMT%2B8&useSSL=true
    username: root
    password: 123456

mybatis:
  mapper-locations: classpath:mapper/*.xml

4. 在 application中填写 @MapperScan (“xxx.xxx.xxx.xxx”)到对应 映射文件interface类的package
5. 在mapper包下创建 interface 并添加注解 @Mapper 和@Repository
   
6. 这时 mapper包下的接口类与配置yml文件里的

mybatis:
  mapper-locations: classpath:mapper/*.xml

对应的路径上互相对应

mapper包下的接口类和配置mapper下的xml 命名必须相同
7. 编写配置mapper下的.xml文件
文件头：

<?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.waylon.mysql2.mapper.UserLoginMapper">
    <select id="queryAll" resultType="com.waylon.mysql2.pojo.UserLogin">
        select * from userlogin
    </select>

    <insert id="add" parameterType="com.waylon.mysql2.pojo.UserLogin">
        insert into userlogin values (#{username},#{password})
    </insert>

    <select id="queryByName" resultType="com.waylon.mysql2.pojo.UserLogin">
        select * from userlogin where username = #{username}
    </select>

</mapper>

mapper接口

@Mapper
@Repository
public interface UserLoginMapper {
    //查询
    public List<UserLogin> queryAll();
    //添加数据
    public int add(UserLogin userLogin);
    //根据用户名查询数据
    public UserLogin queryByName(String username);
}

8. test
   这是直接在controller 下就可以直接使用mapper 查找数据库（不规范）