CREATE TRIGGER insert_patient
ON patient
AFTER INSERT
AS
update bed set patientid=b.id from bed a,inserted b
where a.room = b.room and a.bed = b.bed
go
CREATE TRIGGER update_patient
ON patient
AFTER update
AS
update bed set patientid=b.id from bed a,inserted b
where a.room = b.room
go
CREATE TRIGGER insert_patient
ON patient
AFTER delete
AS
update bed set patientid=null from bed a,deleted b
where a.room = b.room
go
医院信息管理系统 java 图形化界面
5星 · 超过95%的资源 需积分: 33 42 浏览量
2011-01-24
09:51:33
上传
评论 8
收藏 1.24MB RAR 举报 
医院信息管理系统 java 图形化界面 （152个子文件） 
9.bmp 1.47MB 2.bmp 1.39MB 3.bmp 1.37MB 1.bmp 997KB 11.bmp 946KB 4.bmp 799KB 8.bmp 763KB 5.bmp 607KB 6.bmp 597KB 7.bmp 552KB 12.bmp 298KB 10.bmp 197KB
ConceptualDataModel_Hospital.cdb 68KB ConceptualDataModel_Hospital.cdm 68KB ManageEmployer.class 15KB ManagePatient.class 14KB ManageInstrument.class 11KB ManageDrug.class 11KB ManageSalary.class 10KB ManageAdmin.class 9KB SearchEmployer.class 8KB AddAdmin.class 7KB loginjframe.class 7KB AdminFrame.class 6KB MyJFrame.class 6KB EmployerModel.class 5KB PatientModel.class 4KB InstrumentModel.class 4KB AdminModel.class 4KB DrugModel.class 4KB SalaryModel.class 3KB Employer.class 3KB DeptModel.class 2KB Title.class 2KB Patient.class 2KB DBHelp.class 2KB TableModel.class 2KB ComboModel.class 2KB BedModel.class 1KB EmployerTableFrame.class 1KB BedTableFrame.class 1KB SalaryTableFrame.class 1KB InstrumentTableFrame.class 1KB PatientTableFrame.class 1KB DrugTableFrame.class 1KB Instrument.class 1KB Drug.class 1KB StringHelp.class 1KB Admin.class 1KB Salary.class 914B Bed.class 890B ManageInstrument$5.class 859B ManageInstrument$1.class 859B ManageInstrument$4.class 859B ManageInstrument$3.class 859B ManageInstrument$2.class 859B SearchEmployer$3.class 803B ManageEmployer$2.class 803B ManageEmployer$1.class 803B ManageEmployer$5.class 803B ManageEmployer$4.class 803B SearchEmployer$2.class 803B SearchEmployer$1.class 803B ManageEmployer$7.class 803B ManageEmployer$6.class 803B SearchEmployer$4.class 803B ManageEmployer$3.class 803B ManageAdmin$2.class 794B ManageAdmin$1.class 794B ManageAdmin$3.class 794B ManagePatient$4.class 790B ManagePatient$2.class 790B ManagePatient$1.class 790B ManagePatient$6.class 790B ManagePatient$3.class 790B ManagePatient$5.class 790B ManagePatient$8.class 790B ManagePatient$7.class 790B loginjframe$3.class 788B loginjframe$1.class 788B loginjframe$2.class 788B AdminFrame$2.class 787B AdminFrame$1.class 787B ManageDrug$3.class 781B ManageDrug$5.class 781B ManageDrug$4.class 781B ManageDrug$2.class 781B ManageDrug$1.class 781B ManageSalary$4.class 777B ManageSalary$5.class 777B ManageSalary$1.class 777B ManageSalary$6.class 777B ManageSalary$2.class 777B ManageSalary$3.class 777B AddAdmin$1.class 773B AddAdmin$2.class 773B Dept.class 685B loginjframe$4.class 560B .classpath 474B Thumbs.db 50KB共 152 条
- 1
- 2
- 1
- 2
- 3
前往页