# 學校相關操作(增刪改)
```
新增操作
{
"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": "參數錯誤",
}
```
