# fast-curd

**Repository Path**: ichiva_admin/fast-curd

## Basic Information

- **Project Name**: fast-curd
- **Description**: 本项目可0代码实现对数据表的增删改查+增删表
- **Primary Language**: Java
- **License**: MulanPSL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-12-29
- **Last Updated**: 2022-06-06

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# fast-curd
    0代码实现数据库各表的curd接口,方便前端快速开始开发.
    同时开发者应该清楚,这只是个开始.
## 快速开始
- 1.用户实现全局配置AbstractGlobalConfigImpl
```dtd
public class CurdConfigImpl extends AbstractGlobalConfigImpl {

    static final String DRIVER = "com.mysql.cj.jdbc.Driver";
    static final String URL = "jdbc:mysql://localhost:3306/curd?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC";
    static final String USER = "root";
    static final String PASS = "root";


    @Override
    protected String getPassword() {
        return PASS;
    }

    @Override
    protected String getUser() {
        return USER;
    }

    @Override
    protected String getUrl() {
        return URL;
    }

    @Override
    protected String getDriver() {
        return DRIVER;
    }
}
```
- 2.编写对外控制器
```dtd
@RequestMapping("/curd")
@RestController
public class CurdController {

    private final Curd curd;

    @Autowired
    public CurdController(GlobalConfig config) {
        this.curd = config.getCurd();
    }

    @PostMapping("insert")
    public Object insert(@RequestBody String request){
        return curd.insert(request);
    }

    @PostMapping("delete")
    public Object delete(@RequestBody String request){
        return curd.delete(request);
    }

    @PostMapping("update")
    public Object update(@RequestBody String request){
        return curd.update(request);
    }

    @PostMapping("select")
    public Object select(@RequestBody String request){
        return curd.select(request);
    }

}
```

可以开始了!

## 实现详情
- 1.定义接口

数据操作接口
```dtd
public interface Curd {
    /**
     * 插入
     * @param request
     * @return
     */
    boolean insert(String request);

    /**
     * 删除
     * @param request
     * @return
     */
    boolean delete(String request);

    /**
     * 修改
     * @param request
     * @return
     */
    boolean update(String request);

    /**
     * 查询
     * @param request
     * @return
     */
    List<Map<String, Object>> select(String request);
}
```
数据定义接口
```dtd
public interface Definition {
    /**
     * 建表
     * @param request
     * @return
     */
    boolean create(String request);

    /**
     * 删除表
     * @param request
     * @return
     */
    boolean drop(String request);
}
```