SpringBoot+Mybatis整合入门（一）

SpringBoot+Mybatis 四步整合

第一步 添加依赖

springBoot+Mybatis相关依赖

	<!--springBoot相关-->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.9.RELEASE</version>
    </parent>

    <!--约定版本-->
    <properties>
        <mybatis-spring-boot>1.2.0</mybatis-spring-boot>
        <mysql-connector>5.1.39</mysql-connector>
    </properties>

    <dependencies>
        <!--springBoot相关-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!--mybatis相关-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>${mybatis-spring-boot}</version>
        </dependency>

        <!--mysql驱动相关-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql.version}</version>
        </dependency>

        <!--pojo实用小插件-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <!--依赖不传递-->
            <optional>true</optional>
        </dependency>
    </dependencies>

第二步 配置文件 （src/main/resources/application.yml）

server:
  # 服务端口
  port: 8081

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/springcloud-mybatis
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver

# Mybatis 配置
mybatis:
  typeAliasesPackage: com.fame.entity
  mapperLocations: classpath:mapper/*.xml

# 打印sql
logging:
  level:
     # 配置mapper接口的包路径
     com.fame.mapper : debug

第三步 创建Mybatis Mapper接口、Mapper.xml 以及 Entity

Mapper接口

public interface UserMapper {

	/**
	 * 用户列表查询
	 * 
	 * @return 用户信息列表
	 */
	List<User> findAll();

	/**
	 * 新增用户信息
	 * 
	 * @param user 用户信息
	 */
	void add(User user);

	/**
	 * 通过ID获取用户信息
	 * 
	 * @param id 用户ID
	 * @return 用户信息
	 */
	User get(Long id);

	/**
	 * 修改用户信息
	 *
	 * @param user 用户信息
	 */
	void update(User user);

	/**
	 * 删除用户信息
	 * 
	 * @param id 用户ID
	 */
	void delete(long id);
}

UserMapper.xml（src/main/resources/mapper/UserMapper.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.fame.mapper.UserMapper">
    <resultMap id="BaseResultMap" type="com.fame.entity.User">
        <id column="id" property="id" jdbcType="BIGINT"/>
        <result column="age" property="age" jdbcType="INTEGER"/>
        <result column="password" property="password" jdbcType="VARCHAR"/>
        <result column="username" property="username" jdbcType="VARCHAR"/>
    </resultMap>

    <sql id="Base_Column_List">
    id, age, password, username
  </sql>
    <insert id="add" parameterType="com.fame.entity.User">
        INSERT INTO sys_user(
            <if test="id != null and id != '' ">id,</if>
            <if test="age != null and age != ''">age,</if>
            <if test="password != null and password != ''">password,</if>
            <if test="username != null and username != ''">username</if>
        )VALUES (
            <if test="id != null and id != '' ">#{id},</if>
            <if test="age != null and age != ''">#{age},</if>
            <if test="password != null and password != ''">#{password},</if>
            <if test="username != null and username != ''">#{username}</if>
        )
    </insert>

    <update id="update" parameterType="com.fame.entity.User">
        UPDATE sys_user
        <set>
            <if test="age != null and age != '' ">age = #{age},</if>
            <if test="password != null and password != ''">password = #{password},</if>
            <if test="username != null and username != ''">username = #{username}</if>
        </set>
        WHERE id = #{id}
    </update>

    <delete id="delete" parameterType="java.lang.Long">
        DELETE FROM sys_user WHERE id = #{id}
    </delete>

    <select id="findAll" resultMap="BaseResultMap" parameterType="com.fame.entity.User">
        SELECT
        <include refid="Base_Column_List"/>
        FROM sys_user
    </select>

    <select id="get" parameterType="java.lang.Long" resultMap="BaseResultMap">
        SELECT
        <include refid="Base_Column_List"/>
        FROM sys_user
        WHERE id = #{id}
    </select>

</mapper>

Entity

@Data
// 开启链式编程
@Accessors(chain = true)
public class User implements Serializable {
	private static final long serialVersionUID = -6510879035056033993L;

	private Long id;
	private Integer age;
	private String password;
	private String username;
}

第四步 创建Application启动类

如果是直接创建springboot项目可忽略这一步，我是直接创建的一个Maven项目进行整合。

注意:加入注解@MapperScan进行mapper接口扫描

@SpringBootApplication
// mapper 接口类扫描包配置
@MapperScan("com.fame.mapper")
public class MybatisApplication {
	public static void main(String[] args) {
		SpringApplication.run(MybatisApplication.class, args);
	}
}

这样就整合完成，可以创建接口进行单元测试了

UserController

@RequestMapping("/user")
@RestController
public class UserController {

	@Autowired
	private UserMapper userMapper;

	/**
	 * 查询用户列表
	 */
	@GetMapping("/list")
	public List<User> list() {
		List<User> userList = userMapper.findAll();
		System.out.println(userList);
		return userList;
	}

	/**
	 * 通过ID获取用户信息
	 */
	@GetMapping("/get")
	public User get() {
		return userMapper.get(8L);
	}

	/**
	 * 新增用户信息
	 */
	@PostMapping("/add")
	public void add() {
		User user = new User().setUsername("大白一号").setPassword("dabaiyihao").setAge(22);
		userMapper.add(user);
	}

	/**
	 * 修改用户信息
	 */
	@PutMapping("/update")
	public void update() {
		User user = userMapper.get(1L);
		user.setUsername("大白修改操作");
		userMapper.update(user);
	}

    /**
     * 删除用户信息
     */
    @DeleteMapping("/delete")
	public void delete() {
	    userMapper.delete(9L);
	}

}