Skip to content

Commit 61f0e7c

Browse files
Update README.md
1 parent ce94fc1 commit 61f0e7c

File tree

1 file changed

+18
-4
lines changed
  • APIJSON-Java-Server/APIJSONDemo-RawSQL

1 file changed

+18
-4
lines changed
Lines changed: 18 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,21 @@
1-
# APIJSONDemo
1+
## 使用
2+
https://github.com/Tencent/APIJSON/issues/510#issuecomment-1445774929
23

3-
APIJSON + SpringBoot 初级使用的最简单 Demo
4+
## 数据库配置
5+
```sql
46

5-
### 运行
7+
INSERT INTO `Document` (`id`, `debug`, `userId`, `testAccountId`, `version`, `name`, `type`, `url`, `request`, `apijson`, `sqlauto`, `standard`, `header`, `date`, `detail`) VALUES (5, 0, 1, 0, 0, '执行sql语句', 'JSON', '/router/get/RawUserList', '{}', '{\n \"@datasource\": \"master\",\n \"paramName\": [\"name\",\"state\",\"page\",\"count\"],\n \"tag\": \"RawUserList\",\n \"rawData()\": \"rawSQL(paramName)\",\n \"removeKeys+()\": \"removeKeys(paramName)\"\n}', 'SELECT * FROM `user` where `username` LIKE concat(?,\'%\') and state = ? and deleted != 1 limit ?,?', NULL, NULL, '2023-02-27 10:30:56', NULL);
68

7-
右键 DemoApplication > Run As > Java Application
9+
10+
INSERT INTO `request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`)
11+
VALUES (302, 0, 1, 'GET', 'RawUserList', '{}', 'router raw sql 测试', '2023-02-27 10:34:21');
12+
13+
14+
INSERT INTO `function` (`id`, `debug`, `userId`, `type`, `name`, `returnType`, `arguments`, `demo`, `detail`, `version`, `tag`, `methods`, `date`, `appId`, `return`, `language`)
15+
VALUES (37, 0, '0', 0, 'rawSQL', 'Object', 'paramName', '{\"paramName\": [\"paramName\"]}', '远程函数执行sql语句', 0, NULL, NULL, '2023-02-24 16:55:38', NULL, NULL, NULL);
16+
17+
18+
INSERT INTO `function` (`id`, `debug`, `userId`, `type`, `name`, `returnType`, `arguments`, `demo`, `detail`, `version`, `tag`, `methods`, `date`, `appId`, `return`, `language`) VALUES (17, 0, '0', 0, 'removeKeys', 'void', 'keys', '{\"keys\": \"tag,aa\"}', '(低代码平台需要) 控制response返回字段', 0, NULL, NULL, '2022-12-02 11:46:23', NULL, NULL, NULL);
19+
20+
21+
```

0 commit comments

Comments
 (0)