基于SSM框架的医疗就诊管理系统,模块有病人,医生,就诊,挂号,药品,检查 写出五个存储过程
时间: 2024-05-16 22:14:12 浏览: 19
1. 添加病人信息存储过程:
```
CREATE PROCEDURE addPatient
@name varchar(20),
@age int,
@gender varchar(2),
@phone varchar(11),
@address varchar(50)
AS
INSERT INTO patient(name, age, gender, phone, address)
VALUES (@name, @age, @gender, @phone, @address)
```
2. 添加医生信息存储过程:
```
CREATE PROCEDURE addDoctor
@name varchar(20),
@age int,
@gender varchar(2),
@phone varchar(11),
@title varchar(20),
@department varchar(20)
AS
INSERT INTO doctor(name, age, gender, phone, title, department)
VALUES (@name, @age, @gender, @phone, @title, @department)
```
3. 添加就诊信息存储过程:
```
CREATE PROCEDURE addTreatment
@patient_id int,
@doctor_id int,
@symptom varchar(50),
@diagnosis varchar(50),
@treatment varchar(100)
AS
INSERT INTO treatment(patient_id, doctor_id, symptom, diagnosis, treatment)
VALUES (@patient_id, @doctor_id, @symptom, @diagnosis, @treatment)
```
4. 添加挂号信息存储过程:
```
CREATE PROCEDURE addRegistration
@patient_id int,
@doctor_id int,
@registration_time datetime,
@fee decimal(10, 2)
AS
INSERT INTO registration(patient_id, doctor_id, registration_time, fee)
VALUES (@patient_id, @doctor_id, @registration_time, @fee)
```
5. 添加药品信息存储过程:
```
CREATE PROCEDURE addMedicine
@name varchar(20),
@price decimal(10, 2),
@manufacturer varchar(50),
@description varchar(100)
AS
INSERT INTO medicine(name, price, manufacturer, description)
VALUES (@name, @price, @manufacturer, @description)
```
以上存储过程仅为示例,具体实现可能需要根据实际需求进行修改。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)