简介

一个提供通用增删改查的工具包，无需任何代码，引入db2map包，传递「表名称」作为参数，即可使用增删改查接口。

技术栈

springboot
mybatis
mysql（生产用，已测试）、h2（默认演示版本）

线上体验

http://47.97.42.66:8080/index.html

接口测试地址

http://localhost:8080/swagger-ui.html

相关参数

获取唯一ID

GET http://localhost:8080/map/id

根据ID获取详情

POST http://localhost:8080/map/getById Content-Type: application/json

{
    "tableName": "user",
    "id": "1"
}

保存

POST http://localhost:8080/map/save Content-Type: application/json

{
    "tableName": "user",
    "objectMap": {
        "id": "1",
        "role_id": "1",
        "name": "用户1"
    }
}

批量保存（使用的是先删除后插入实现）

POST http://localhost:8080/map/saveList Content-Type: application/json

{
    "tableName": "user",
    "list":[
        {
            "id": "1",
            "role_id": "1",
            "name": "用户1"
        },
        {
            "id": "2",
            "role_id": "1",
            "name": "用户2"
        }
    ]
}

查询列表

POST http://localhost:8080/map/list Content-Type: application/json

{
    "tableName": "user"
}

分页查询列表

POST http://localhost:8080/map/page?pageNum=1&pageSize=2&orderByColumn=id&isAsc=desc Content-Type: application/json

{
    "tableName": "user"
}

根据ID删除数据

POST http://localhost:8080/map/removeByIds Content-Type: application/json

{
    "tableName": "user",
    "ids": ["1","2"]
}

数据库查看

WBB访问地址：http://localhost:8080/h2

Driver Class: org.h2.Driver
JDBC URL: jdbc:h2:mem:test
User Name: sa
Password:123456

未来规划

在此基础上开发一个低代码平台，包含：表单定义、工作流、报表等功能。