# 学校相关操作(增删改)
```
新增操作
{
"op": "sp_UpdateSchool",
"params": [
{
"schoolIdx": 0,
"name": "测试学校一",
"type": "3",
"address": "浙江省杭州市西湖区",
"contact_phone": "13300008888",
"account_name": "zhangsn",
"account_password": "e10adc3949ba59abbe56e057f20f883e",
"status": "1"
}
]
}
1）params：{学校id、学校名称、类型、学校地址、联系人电话、账号、密码、状态}
2）对象中的schoolIdx 固定为0
3）对象中的type 学校类型（0幼儿园 1小学 2初学 3高中 4大学 5其他）
```
```
修改操作
{
"op": "sp_UpdateSchool",
"params": [
{
"schoolIdx": 0,
"name": "测试学校一",
"type": "3",
"address": "浙江省杭州市西湖区",
"contact_phone": "13300008888",
"account_name": "zhangsn",
"account_password": "e10adc3949ba59abbe56e057f20f883e",
"status": "1"
}
]
}
1） params: 对象中的schoolIdx 为schoolId
```
```
删除操作
{
"op": "sp_UpdateSchool",
"params": [
{
"schoolIdx": 101,
"status": "0"
}
]
}
```
```
success
{
"rc": 0,
"msg": "操作成功",
}
```
```
error
{
"rc": 1,
"msg": "数据库操作异常",
}
{
"rc": 2,
"msg": "参数错误",
}
```
