springboot实现整合jfinal增删改查
时间: 2023-09-16 12:16:20 浏览: 48
首先需要在pom.xml文件中添加jfinal和jfinal-ext依赖:
```xml
<dependency>
<groupId>com.jfinal</groupId>
<artifactId>jfinal</artifactId>
<version>4.9.12</version>
</dependency>
<dependency>
<groupId>com.jfinal</groupId>
<artifactId>jfinal-ext</artifactId>
<version>4.9.12</version>
</dependency>
```
然后,在Spring Boot中配置JFinal:
```java
@Configuration
public class JFinalConfig {
@Bean
public JFinalPlugin jFinalPlugin() {
DruidPlugin druidPlugin = new DruidPlugin("jdbc:mysql://localhost:3306/db", "username", "password");
ActiveRecordPlugin activeRecordPlugin = new ActiveRecordPlugin(druidPlugin);
activeRecordPlugin.addMapping("table", "id", Model.class);
return new JFinalPlugin(druidPlugin, activeRecordPlugin);
}
}
```
其中,“table”是数据库表名。
接下来,我们可以定义一个Controller来进行增删改查操作:
```java
@RestController
@RequestMapping("/demo")
public class DemoController {
@Autowired
private JFinalPlugin jFinalPlugin;
@GetMapping("/{id}")
public Object getById(@PathVariable("id") Integer id) {
jFinalPlugin.start();
Model model = Model.findById("table", id);
jFinalPlugin.stop();
return model;
}
@PostMapping
public Object add(@RequestBody Model model) {
jFinalPlugin.start();
model.save();
jFinalPlugin.stop();
return "success";
}
@PutMapping
public Object update(@RequestBody Model model) {
jFinalPlugin.start();
model.update();
jFinalPlugin.stop();
return "success";
}
@DeleteMapping("/{id}")
public Object delete(@PathVariable("id") Integer id) {
jFinalPlugin.start();
Model.deleteById("table", id);
jFinalPlugin.stop();
return "success";
}
}
```
其中,getById方法根据id查询数据,add方法添加数据,update方法更新数据,delete方法删除数据。
最后,启动Spring Boot应用程序,访问相应的API即可进行增删改查操作。