spring boot 整合mybatis

1. pom.xml 引入mybatis-spring-boot-starter

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

 

1. 新建实体类pojo

com.dgx.dgx.pojo

package com.dgx.dgx.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Tt {

    private  String w;
}

 

需要引入

@Data
@NoArgsConstructor
@AllArgsConstructor

<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
</dependency>

 

3新建mapper接口包，并写接口方法

com.dgx.dgx.mapper

 

@Mapper
@Repository

package com.dgx.dgx.mapper;

import com.dgx.dgx.pojo.Tt;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface TtMapper {
    List<Tt> queryTtList();

    int addTt(Tt tt);

    int delTt(String w);
}

 

 

4.resources 新建  mybatis/mapper/xxxxmapper.xml

1. <?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.dgx.dgx.mapper.TtMapper">
   
       <select id="queryTtList" resultType="Tt">
           select * from tt
       </select>
   
       <insert id="addTt" parameterType="Tt">
           insert into tt (w) values (#{w})
       </insert>
   
       <delete id="delTt" parameterType="String">
   
           delete from  tt where w=#{w}
       </delete>
   
   </mapper>

 

5.application.yaml配置指定 xxxmapper.xml路径

 

mybatis:
  type-aliases-package: com.dgx.dgx.pojo
  mapper-locations: classpath:mybatis/mapper/*.xml

 

 

 

 

6. controller直接注入mapper 后调用实现

@Autowired
TtMapper ttMapper;

 

@GetMapping("/queryTtList")
public List<Tt> queryTtList(){
    List<Tt> ttList=ttMapper.queryTtList();
    return ttList;
}