1.pom.xml(除创建项目之外需要添加的依赖如下)
<dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-spring-boot3-starter</artifactId> <version>3.5.5</version> </dependency>
<dependency> <groupId>com.mysql</groupId> <artifactId>mysql-connector-j</artifactId> <scope>runtime</scope> </dependency>
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency>
2.application.properties
spring.datasource.url=jdbc:mysql://localhost:3306/springboot spring.datasource.username=root spring.datasource.password=3121384913 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
3.文件主体(主体结构如下)
《1》use实体类
@Data @TableName("tb_customer") public class User { @TableId private int id; @TableField("jobNo") private String jobNo; private String name; private String department; }
《2》mapper层
@Mapper public interface UserMapper extends BaseMapper<User> { }
《3》controller层
@RestController public class UserController { @Autowired private UserMapper userMapper; @GetMapping("/getAll") public List getAll(){ List<User> users = userMapper.selectList(null); return users; } }