手写简易- SpringBoot项目整合mybatis

1.创建spring boot项目

2.在pom.xml 文件中添加依赖

<!--mybatis依赖-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.0</version>
        </dependency>

        <!--mysql db连接-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!--连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.14</version>
        </dependency>

        <!--热部署-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>

        <!-- lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.16.20</version>
            <scope>provided</scope>
        </dependency>

3.配置项目jdk

4.application.yml

#端口号
server:
  port: 8099

spring:
  #服务名称
  application:
    name: springboot-01

  #数据库配置
  datasource:
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/pk?useSSL=false&serverTimezone=UTC&characterEncoding=utf-8&allowPublicKeyRetrieval=true
    driver-class-name: com.mysql.cj.jdbc.Driver

#指定mybatis映射文件的路径
mybatis:
 #数据表映射配置文件路径
  mapper-locations: classpath:mapper/*.xml
  #数据表映射实体类路径
  type-aliases-package: com/example/springboot01/pojo

5.数据库表设计

表中添加数据

6.代码结构

7.启动器

package com.example.springboot01;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.example.springboot01.dao")
public class Springboot01Application {

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

}

8. pojo类

package com.example.springboot01.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Rank implements Serializable {

    private Integer id;
    private String name;
    private BigDecimal bonus;
    private Date created;
    private Date modified;
}

9. dao类

package com.example.springboot01.dao;

import com.example.springboot01.pojo.Rank;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface RankDao {

    List<Rank> findAll();
}

10.RankMapper.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.example.springboot01.dao.RankDao">
    <select id="findAll" resultType="com.example.springboot01.pojo.Rank">
        select * from rank
    </select>
</mapper>

11.service 类

package com.example.springboot01.service;

import com.example.springboot01.dao.RankDao;
import org.springframework.beans.factory.annotation.Autowired;

public class RankService {

    List<Rank> findAll();

}

12.RankServiceImpl实现类

package com.example.springboot01.service.Impl;

import com.example.springboot01.dao.RankDao;
import com.example.springboot01.pojo.Rank;
import com.example.springboot01.service.RankService;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.List;
@Service
public class RankServiceImpl implements RankService {
    @Autowired
    private RankDao rankDao;

    @Override
    public List<Rank> findAll() {
        return rankDao.findAll();
    }
}

13. controller

package com.example.springboot01.controller;

import com.example.springboot01.service.RankService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class RankController {

    @Autowired
    private RankService rankService;

    @ResponseBody
    @RequestMapping("/test")
    public String getRanks(){
        return rankService.findAll().toString();

    }


}

14.结果