CREATE TABLE `goods` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`price` varchar(255) NOT NULL,
`introduction` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
CREATE TABLE `orders` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`ordername` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`orderdate` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
CREATE TABLE `user` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
部分接口举例
| 字段 |
说明 |
| username |
用户名 |
| password |
密码 |
{
"username":"test",
"password":"123456"
}
注意：
- json格式传递，content-type:application/json
- table_name测试的时候修改一下，重名会提示错误信息
{
"msg": "ok",
"code": "200"
}
- 接口简介：查询所有商品的详情信息
- Type：GET
- URL：
无
| 字段 |
说明 |
| name |
商品名称 |
| price |
价格 |
| introduction |
商品介绍 |
[
{
"name": "folks",
"price": "20",
"introduction": "很好用"
},
{
"name": "plates",
"price": "20",
"introduction": "好用"
}
]
- 接口简介：通过商品名字查找商品详情
- Type：GET
- URL：
| 字段 |
说明 |
| name |
商品名称 |
| price |
价格 |
| introduction |
商品介绍 |
[
{
"name": "folks",
"price": "20",
"introduction": "很好用"
}
]
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent