Springboot+mybatis-plus框架代码
时间: 2024-01-31 17:04:20 浏览: 35
好的,这是一个简单的使用 Spring Boot 和 MyBatis-Plus 框架的示例代码:
1. 首先需要在 pom.xml 中添加以下依赖:
```xml
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.3.1</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>3.4.3.1</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus</artifactId>
<version>3.4.3.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
```
2. 创建一个配置类 MybatisPlusConfig.java,配置 MyBatis-Plus 的分页插件和逻辑删除插件:
```java
@Configuration
public class MybatisPlusConfig {
@Bean
public PaginationInterceptor paginationInterceptor() {
PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
return paginationInterceptor;
}
@Bean
public ISqlInjector sqlInjector() {
return new LogicSqlInjector();
}
}
```
3. 创建一个实体类 User.java,使用 MyBatis-Plus 的注解来映射数据库表:
```java
@Data
@TableName("user")
public class User {
@TableId(type = IdType.AUTO)
private Long id;
private String name;
private Integer age;
@TableLogic
private Integer deleted;
}
```
4. 创建一个 Mapper 接口 UserMapper.java,使用 MyBatis-Plus 提供的 BaseMapper 接口来操作数据库:
```java
public interface UserMapper extends BaseMapper<User> {
}
```
5. 在 application.yml 中配置数据库连接信息:
```yaml
spring:
datasource:
url: jdbc:mysql://localhost:3306/test?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
username: root
password: root
driver-class-name: com.mysql.cj.jdbc.Driver
```
6. 在启动类 Application.java 上添加 @MapperScan 注解,扫描 Mapper 接口:
```java
@SpringBootApplication
@MapperScan("com.example.demo.mapper")
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
```
7. 编写 Controller 类 UserController.java,使用 UserMapper 接口来操作数据库:
```java
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserMapper userMapper;
@GetMapping("/{id}")
public User getUserById(@PathVariable Long id) {
return userMapper.selectById(id);
}
@PostMapping("/")
public String addUser(@RequestBody User user) {
userMapper.insert(user);
return "success";
}
@PutMapping("/")
public String updateUser(@RequestBody User user) {
userMapper.updateById(user);
return "success";
}
@DeleteMapping("/{id}")
public String deleteUser(@PathVariable Long id) {
userMapper.deleteById(id);
return "success";
}
}
```
以上就是一个简单的 Spring Boot + MyBatis-Plus 的示例代码,可以根据自己的需求进行扩展。