IntelliJ IDEA springboot + mybatis整合（一）

1.自行百度安装mysql，并启动mysql服务,
2.用navicat创建mydatabase数据库，tb_user表，写入两条记录，如下图

3.创建springboot项目，如下图：

选择四个依赖

创建项目目录，删除application.properties,创建application.yml

application.yml 注意type-aliases-package属性不要配置错了，

server:
  port: 8081
spring:
  #数据库连接配置
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    username: root
    password: 123456

#mybatis的相关配置
mybatis:
  #mapper配置文件
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.mybatis.demo.entity
  #开启驼峰命名
  configuration:
    map-underscore-to-camel-case: true

目录结构如下：

添加实体类 User.java

package com.mybatis.demo.entity;

import lombok.Data;

import java.io.Serializable;

@Data
public class User implements Serializable {
    private Long id;//编号
    private String username;//用户名
    private String password;//密码
}

添加 UserMapper.java

package com.mybatis.demo.mapper;

import com.mybatis.demo.entity.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UserMapper {
    List<User> findAll();
}

DemoApplication类中添加扫描mapper注解
@MapperScan(“com.mybatis.demo.mapper”)

添加UserMapper.xml 注意下面代码中namespace不要配置错了，

<?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.mybatis.demo.mapper.UserMapper">
    <select id="findAll" resultType="com.mybatis.demo.entity.User">
        SELECT * FROM tb_user
    </select>
</mapper>

4.开始写测试方法，自动生成测试类



测试代码UserMapperTest.java：

package com.mybatis.demo.mapper;

import com.mybatis.demo.entity.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

import static org.junit.jupiter.api.Assertions.*;

@SpringBootTest
class UserMapperTest {
    @Autowired
    UserMapper userMapper;

    @Test
    void findAll() {
        List<User> list = userMapper.findAll();
        System.out.println(list);
    }
}

结果如下：

下一篇：IntelliJ IDEA springboot + mybatis整合（二）