SpringBoot整合MyBatis

点击上方 Java老铁，并选择 设为星标

优质文章和资料会及时送达

一、建表

1.建表语句

create table if not exists student(
    id int(10) primary key Auto_Increment,
    stu_name varchar(10) not null ,
    sex char(2) not null ,
    age int(10) not null
);

2.插入数据

insert into student(stu_name, sex, age) values ("阿萌","女",30);
insert into student(stu_name, sex, age) values ("阿辙","男",50);

二、创建Maven项目

1.父工程

pom.xml

<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.1.RELEASE</version>
        <relativePath/>
    </parent>


    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>


    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

2.创建子项目springBoot-myBatis

pom.xml

<dependencies>


        <!--mybatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.0.1</version>
        </dependency>


        <!--jdbc的启动器，默认使用HikariCP连接池-->
        <!--<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>-->


        <!-- Druid连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>


        <!--mysql数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>


    </dependencies>

3.在资源目录下创建application.yml配置文件

server:
  port: 9001 #端口
spring:
  application:
    name: springBoot-myBatis #服务名
  datasource: #连接池四大参数
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/springbootdemo?characterEncoding=utf-8&useSSL=false
    username: root
    password: root
    druid:
      initial-size: 1 #初始化连接数
      min-idle: 1 #最小空闲连接
      max-active: 20 #最大活动连接
      test-on-borrow: true #获取连接时测试是否可用
      stat-view-servlet:
        allow: true #监控页面启动
mybatis:
  type-aliases-package: com.eu.demo.pojo  #别名扫描
  mapper-locations: classpath:mapper/*.xml  #加载配置文件
  configuration:
    map-underscore-to-camel-case: true  #开启驼峰式命名

4.编写pojo

package com.eu.demo.pojo;


public class Student {


    private Integer id;
    private String stuName;
    private String sex;
    private Integer age;


    public Integer getId() {
        return id;
    }


    public void setId(Integer id) {
        this.id = id;
    }


    public String getStuName() {
        return stuName;
    }


    public void setStuName(String stuName) {
        this.stuName = stuName;
    }


    public String getSex() {
        return sex;
    }


    public void setSex(String sex) {
        this.sex = sex;
    }


    public Integer getAge() {
        return age;
    }


    public void setAge(Integer age) {
        this.age = age;
    }
}

5.编写dao

@Repository
public interface StudentMapper {


    List<Student> findAll();
}

6.编写mapper

在资源目录下创建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.eu.demo.dao.StudentMapper">
    <select id="findAll" resultType="com.eu.demo.pojo.Student">
        select *from student
    </select>
</mapper>

7.编写service

@Service
public class StudentService {


    @Autowired
    private StudentMapper studentMapper;


    public List<Student> findAll(){
        return studentMapper.findAll();
    }
}

8.编写controller

@RequestMapping("/students")
@RestController
public class StudentController {


    @Autowired
    private StudentService studentService;


    @GetMapping
    public List<Student> getStudents(){
        return studentService.findAll();
    }
}

9.编写启动类

@MapperScan("com.eu.demo.dao")
@SpringBootApplication
public class MyBatisApplication {


    public static void main(String[] args) {
        SpringApplication.run(MyBatisApplication.class);
    }
}

10.项目结构

11.启动测试

关注我

获取更多
Java干货

原创文章

视频资料

技术交流群