1、添加依赖
<!--mysql数据库--><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.49</version></dependency><!--mybatis-plus--><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.5.10.1</version></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.18.16</version></dependency>
2、Controller
import com.sh.system.entity.User;
import com.sh.system.service.IUserService;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import javax.annotation.Resource;
import java.util.List;@RestController
@RequestMapping("/user")
public class UserController {@AutowiredIUserService userService;@GetMapping("/list")public List<User> searchUser(){return userService.listUser();}
}
3、Entity
@Data
@TableName("user")
public class User {private String id;private String name;
}
4、Service
import com.baomidou.mybatisplus.extension.service.IService;
import com.sh.system.entity.User;
import org.springframework.stereotype.Service;import java.util.List;public interface IUserService extends IService<User> {List<User> listUser();
}
import com.baomidou.mybatisplus.extension.conditions.query.QueryChainWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.sh.system.entity.User;
import com.sh.system.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import javax.annotation.Resource;
import java.util.List;
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService{@AutowiredUserMapper userMapper;@Overridepublic List<User> listUser() {return this.list();}
}
5、Mapper
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sh.system.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;@Mapper
// 可以不写该注解
// 在XXXApplication加注解@MapperScan("com.*.*.mapper")
public interface UserMapper extends BaseMapper<User> {
}
// 可以不写该注解
// 在XXXApplication加注解@MapperScan(“com...mapper”)
<?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.sh.system.mapper.UserMapper"></mapper>