手写简易- SpringBoot项目整合mybatis

        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.2.0
        

        
        
            mysql
            mysql-connector-java
        

        
        
            com.alibaba
            druid
            1.1.14
        

        
        
            org.springframework.boot
            spring-boot-devtools
            runtime
            true
        

        
        
            org.projectlombok
            lombok
            1.16.20
            provided
        

#端口号
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

表中添加数据

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);
    }

}

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;
}

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 findAll();
}

    
        select * from rank
    

package com.example.springboot01.service;

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

public class RankService {

    List findAll();

}

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 findAll() {
        return rankDao.findAll();
    }
}

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();

    }


}