springboot集成mybatis-plus

首先是导入依赖

<!-- druid 连接池 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>${druid.version}</version>
		</dependency>
		<!--mybatis-plus依赖 -->
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-boot-starter</artifactId>
			<version>${mybatis-plus.version}</version>
		</dependency>
		<!--mysql驱动-->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>

接着编写yml配置:

  #数据库配置
  datasource:
    type: com.zaxxer.hikari.HikariDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test1?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&allowMultiQueries=true
    username: xxx
    password: xxx
# mybaits-plus配置
mybatis-plus:
  # MyBatis Mapper所对应的XML文件位置
  mapper-locations: classpath:/mapper/*Mapper.xml

接着实体类：

@Data
@AllArgsConstructor
@Accessors(chain = true) //链式写法
@NoArgsConstructor
public class User extends Model<User> {
    private static final long serialVersionUID = 1L;
    private   Integer id;
    private   String userName;
    private   Integer age;

}

mapper类

public interface UserMapper  extends BaseMapper<User> {
}

注：在启动类上需加上注解@Mapperscan(“这里配置mapper路径”),如果不配置则会导致spring容器找不到我们mapper
mapper.xml

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.example.xx_biz.mapper.UserMapper">


</mapper>

service类

public interface UserService  extends IService<User> {

    //根据id获取用户信息
    public User getById(Integer userId);

    //查询所有用户
    public List<User> getQuerAll();
}

service实现类

@Service
public class UserServiceImpl extends ServiceImpl<UserMapper,User> implements  UserService {


    @Override
    public User getById(Integer userId) {
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.eq("id",userId);
        User user = this.baseMapper.selectOne(wrapper);
        return user;
    }

    @Override
    public List<User> getQuerAll() {
        return null;
    }
}

controller类:
/提供restFul风格的服务/

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

    @Autowired
    private UserService userService;

    @GetMapping("/getById")
    public User getById(@RequestParam("userId") Integer userId){
        return  userService.getById(userId);
    }


}

因为mybatis-plus里给我们封装了基本的增删改查，一般sql不需要我们手动去写使用它自带函数querwrapper实现就可以了