Springboot整合mybatis

创建实体类

使用了lombok的注解。自动生成了get/set方法和有参无参构造。

package com.zhang.pojo;

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

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private int id;
    private String name;
    private String pwd;
}

创建接口

package com.zhang.mapper;

import com.zhang.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;

import java.util.List;

@Mapper //mybatis注解，标注这是一个mapper
@Component //注册到spring容器中
public interface UserMapper {
    List<User> listUser();

    int addUser(User user);
}

如果觉得每写一个接口就要加一个注解会很麻烦，可以在程序的主入口加上注解

package com.zhang;

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

@SpringBootApplication
@MapperScan("com.zhang.mapper")//这个包下的mapper都会被识别
public class DemoApplication {

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

}

 

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.zhang.mapper.UserMapper">
 <select id="listUser" resultType="User">
     select * from user
 </select>
    <insert id="addUser" parameterType="User">
        insert into user(id,name,pwd)
        values (#{id},#{name},#{pwd})
    </insert>
</mapper>

 

链接数据库和整合mybatis

application.yaml文件

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=true
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456
    type: com.alibaba.druid.pool.DruidDataSource
    initialSize: 8
    maxWait: 1000
    filters: stat,wall,log4j
#整合mybatis
mybatis:
  #<typeAliases>
  #     <package name="com.zhang.pojo"/>
  # </typeAliases>
  type-aliases-package: com.zhang.pojo  #实体类的包别名
  #<mappers>
  #        <mapper class="com.zhang.mapper.UserMapper"/>
  # </mappers>
  mapper-locations: classpath:mybatis/mapper/*.xml #映射器的位置

Controller加测试

package com.zhang.conntroller;

import com.zhang.mapper.UserMapper;
import com.zhang.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;

@RestController
public class JDBCController {
    @Autowired
    UserMapper userMapper;

    @RequestMapping("/userList")
    public List<User> queryList(){
        List<User> users = userMapper.listUser();
        return users;
    }
}

测试结果

 项目结构