第一、新建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);
}
}
运行引导类,浏览器验证
欢迎大家积极留言交流学习心得,点赞的人最美丽,谢谢!