Spring Boot集成Mybatis

第一、新建maven工程，修改pom.xml文件引入jar包
在pom.xml文件中增加如下配置

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

pom.xml的基本配置可参考：Spring Boot 2 入门案例
第二、编码
1.com.shi.dto.User.java

package com.shi.dto;
import java.io.Serializable;
/**
 * 实体类
 * @author shixiangcheng
 * 2019-09-08
 */
public class User implements Serializable{
	private static final long serialVersionUID = 1L;
	private Integer id;
	private String name;
	private String pwd;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
}

2.com.shi.web.controller.UserController.java

package com.shi.web.controller;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.shi.dto.User;
import com.shi.service.UserService;
/**
 * 示例
 * @author shixiangcheng
 * 2019-09-08
 */
@RestController
@RequestMapping("/user")
public class UserController {
	@Autowired
	private UserService userService;
	@RequestMapping("/queryList")
	public List<User> queryList(String name){
		System.out.println("name==="+name);
		return this.userService.queryList(name);
	}
}

3.com.shi.service.UserService.java

package com.shi.service;
import java.util.List;
import com.shi.dto.User;
/**
 * service接口
 * @author shixiangcheng
 * 2019-09-08
 */
public interface UserService{
	/**
	 * 根据名称查询列表
	 * @param name
	 * @return
	 */
	public List<User> queryList(String name);
}

4.com.shi.service.impl.UserServiceImpl.java

package com.shi.service.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.shi.dto.User;
import com.shi.mapper.UserMapper;
import com.shi.service.UserService;
/**
 * service接口实现类
 * @author shixiangcheng
 * 2019-09-08
 */
@Service("userService")
public class UserServiceImpl implements UserService {
	@Autowired
	private UserMapper userMapper;
	@Override
	public List<User> queryList(String name) {
		return this.userMapper.queryList(name);
	}
}

5.com.shi.mapper.UserMapper.java

package com.shi.mapper;
import java.util.List;
import com.shi.dto.User;
/**
 * DAO接口
 * @author shixiangcheng
 * 2019-09-08
 */
public interface UserMapper{
	/**
	 * 根据名称查询列表
	 * @param name
	 * @return
	 */
	public List<User> queryList(String name);
}

6.com.shi.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.shi.mapper.UserMapper">
	<select id="queryList" parameterType="java.lang.String" resultType="com.shi.dto.User">
		<![CDATA[  SELECT t.id id,t.name name FROM t_user t where t.name like '%${value}%'  ]]>
	</select>
</mapper>

7.resource下application.properties

spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/memberdb
spring.datasource.username=root
spring.datasource.password=1234
#打印sql语句
logging.level.com.shi.mapper=debug

8.com.shi.RunApplication.java

package com.shi;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
/**
 * SpringBoot 启动类(引导类)
 * @author shixiangcheng
 * 2019-09-08
 */
@SpringBootApplication//表面当前类是SpringBoot的引导类
@MapperScan(basePackages = "com.shi.mapper")
public class RunApplication {
	public static void main(String[] args) {
		System.out.println("start spring boot");
		SpringApplication.run(RunApplication.class, args);
	}
}

运行引导类，浏览器验证

欢迎大家积极留言交流学习心得，点赞的人最美丽，谢谢！