1.pom文件中添加依赖,版本号自己控制
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.19</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.21</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.3.1</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus</artifactId>
<version>3.3.1</version>
</dependency>
2.以User表为例,controller如下所示
package com.yuhan.demo.controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
/**
* @author yuhan
* @since 2020-03-30
*/
@RestController
@RequestMapping("/user")
public class UserController {
}
3.service如下所示
package com.yuhan.demo.service;
import com.baomidou.mybatisplus.extension.service.IService;
import com.yuhan.demo.entity.User;
/**
* @author yuhan
* @since 2020-03-30
*/
public interface IUserService extends IService<User> {
}
4.serviceImpl如下所示
package com.yuhan.demo.service.impl;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.yuhan.demo.entity.User;
import com.yuhan.demo.mapper.UserMapper;
import com.yuhan.demo.service.IUserService;
import org.springframework.stereotype.Service;
/**
* @author yuhan
* @since 2020-03-30
*/
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService {
}
5.mapper如下所示
package com.yuhan.demo.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yuhan.demo.entity.User;
import org.springframework.stereotype.Component;
/**
* @author yuhan
* @since 2020-03-30
*/
@Component
public interface UserMapper extends BaseMapper<User> {
}
6.实体类如下所示
package com.yuhan.demo.entity;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import java.io.Serializable;
/**
* @author yuhan
* @since 2020-03-30
*/
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("user")
public class User implements Serializable {
private static final long serialVersionUID = 1L;
@TableId("id")
private Long id;
@TableField("username")
private String username;
@TableField("password")
private String password;
}
7.mapper.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.yuhan.demo.mapper.UserMapper">
</mapper>
Finish!