Springboot整合mybatis简洁版

结构

 

添加的依赖

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.1.3</version>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
	</dependencies>

application.properties配置文件

spring.datasource.driver-class-name = com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://192.168.56.105:3306/qq?useSSL=false&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=Root@123
mybatis.type-aliases-package=com.qq.demo2.entity
mybatis.mapper-locations=classpath:mappers/*.xml

实体类

package com.qq.demo2.entity;

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

@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
    private int id;
    private String name;
    private String age;
    private boolean sex;
}

mapper接口

package com.qq.demo2.mapper;

import com.qq.demo2.entity.User;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper {
    int addUser(User user);
}

mapper.xml

id自增，无需传参

<?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.qq.demo2.mapper.UserMapper">

    <insert id="addUser" parameterType="com.qq.demo2.entity.User" useGeneratedKeys="true" keyProperty="id">
        insert into user(name,age,sex) values (#{name},#{age},#{sex})
    </insert>

</mapper>

测试类

    @Test
    public void toTest() {
        User user = new User();
        user.setName("kk");
        user.setAge("27");
        user.setSex(false);
        userLoginMapper.addUser(user);

    }