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 {
@Autowired
IUserService 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{
@Autowired
UserMapper userMapper;
@Override
public 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>