laboratorymanagesystem.sql

构造实验室管理系统的原代码,功能相当完善,请多多点饥

INSERT INTO YH VALUES('051714212','051714212','0','0','')

INSERT INTO YH VALUES('051714213','051714213','0','0','')

INSERT INTO YH VALUES('051714214','051714214','0','0','')

INSERT INTO YH VALUES('051714215','051714215','0','0','')

INSERT INTO YH VALUES('051714216','051714216','0','0','')

INSERT INTO YH VALUES('051714217','051714217','0','0','')

INSERT INTO YH VALUES('051714218','051714218','0','0','')

INSERT INTO YH VALUES('051714219','051714219','0','0','')

INSERT INTO YH VALUES('051714220','051714220','0','0','')

INSERT INTO YH VALUES('051714221','051714221','0','0','')

INSERT INTO YH VALUES('051714223','051714223','0','0','')

INSERT INTO YH VALUES('051714224','051714224','0','0','')

INSERT INTO YH VALUES('051714225','051714225','0','0','')

INSERT INTO YH VALUES('051714226','051714226','0','0','')

INSERT INTO YH VALUES('051714227','051714227','0','0','')

INSERT INTO YH VALUES('051714228','051714228','0','0','')

INSERT INTO YH VALUES('051714229','051714229','0','0','')

INSERT INTO YH VALUES('051714230','051714230','0','0','')

INSERT INTO YH VALUES('051714231','051714231','0','0','')

INSERT INTO YH VALUES('051714232','051714232','0','0','')

INSERT INTO YH VALUES('051714233','051714233','0','0','')

INSERT INTO YH VALUES('051714234','051714234','0','0','')

INSERT INTO YH VALUES('051714235','051714235','0','0','')

INSERT INTO YH VALUES('051714236','051714236','0','0','')

INSERT INTO YH VALUES('170001','170001','1','0','')

INSERT INTO YH VALUES('170002','170002','1','0','')

INSERT INTO YH VALUES('170003','170003','1','0','')

INSERT INTO YH VALUES('170004','170004','1','0','')

INSERT INTO YH VALUES('170005','170005','1','0','')

INSERT INTO YH VALUES('170006','170006','1','0','')

INSERT INTO YH VALUES('170007','170007','1','0','')

INSERT INTO YH VALUES('170008','170008','1','0','')

INSERT INTO YH VALUES('170009','170009','1','0','')

INSERT INTO YH VALUES('170010','170010','1','0','')

INSERT INTO YH VALUES('170011','170011','1','0','')

INSERT INTO YH VALUES('170012','170012','1','0','')

INSERT INTO YH VALUES('170013','170013','1','0','')

INSERT INTO YH VALUES('170014','170014','1','0','')

INSERT INTO YH VALUES('170015','170015','1','0','')

INSERT INTO YH VALUES('170016','170016','1','0','')

INSERT INTO YH VALUES('170017','170017','1','0','')

INSERT INTO YH VALUES('170018','170018','1','0','')

INSERT INTO YH VALUES('170019','170019','1','0','')

INSERT INTO YH VALUES('170020','170020','1','0','')

INSERT INTO YH VALUES('170021','170021','1','0','')

INSERT INTO YH VALUES('170022','170022','1','0','')

INSERT INTO YH VALUES('170023','170023','1','0','')

INSERT INTO YH VALUES('170024','170024','1','0','')

INSERT INTO YH VALUES('170025','170025','1','0','')

INSERT INTO YH VALUES('170026','170026','1','0','')

INSERT INTO YH VALUES('170027','170027','1','0','')

INSERT INTO YH VALUES('170028','170028','1','0','')

INSERT INTO YH VALUES('170029','170029','1','0','')

INSERT INTO YH VALUES('170030','170030','1','0','')

INSERT INTO YH VALUES('170031','170031','1','0','')

INSERT INTO YH VALUES('170032','170032','1','0','')

INSERT INTO YH VALUES('170033','170033','1','0','')

INSERT INTO YH VALUES('170034','170034','1','0','')

INSERT INTO YH VALUES('170035','170035','1','0','')

INSERT INTO YH VALUES('170036','170036','1','0','')

INSERT INTO YH VALUES('170037','170037','1','0','')

INSERT INTO YH VALUES('170038','170038','1','0','')

INSERT INTO YH VALUES('170039','170039','1','0','')

INSERT INTO YH VALUES('170040','170040','1','0','')

INSERT INTO YH VALUES('170041','170041','1','0','')

INSERT INTO YH VALUES('170042','170042','1','0','')

INSERT INTO YH VALUES('170043','170043','1','0','')

INSERT INTO YH VALUES('170044','170044','1','0','')

INSERT INTO YH VALUES('170045','170045','1','0','')

INSERT INTO YH VALUES('170046','170046','1','0','')

INSERT INTO YH VALUES('170047','170047','1','0','')

INSERT INTO YH VALUES('170048','170048','1','0','')

INSERT INTO YH VALUES('170049','170049','1','0','')

INSERT INTO YH VALUES('170050','170050','1','0','')

INSERT INTO YH VALUES('170051','170051','1','0','')

INSERT INTO YH VALUES('170052','170052','1','0','')

INSERT INTO YH VALUES('170053','170053','1','0','')

INSERT INTO YH VALUES('170054','170054','1','0','')

INSERT INTO YH VALUES('170055','170055','1','0','')

INSERT INTO YH VALUES('170056','170056','1','0','')

--学生表插入数据
INSERT INTO XS VALUES('051714201','白玉群','051714201',0,'0517142','051714201','','15072713580','',null)

INSERT INTO XS VALUES('051714202','陈昌元','051714202',1,'0517142','051714202','','','',null)

INSERT INTO XS VALUES('051714203','陈红军','051714203',1,'0517142','051714203','','15072636644','',null)

INSERT INTO XS VALUES('051714204','陈阳武','051714204',1,'0517142','051714204','','','',null)

INSERT INTO XS VALUES('051714205','陈云峰','051714205',1,'0517142','051714205','','','',null)

INSERT INTO XS VALUES('051714206','邓安静','051714206',0,'0517142','051714206','','','',null)

INSERT INTO XS VALUES('051714207','邓金双','051714207',1,'0517142','051714207','','15971265380','',null)

INSERT INTO XS VALUES('051714208','冯静','051714208',0,'0517142','051714208','','15826822717','',null)

INSERT INTO XS VALUES('051714209','龚学','051714209',1,'0517142','051714209','','','',null)

INSERT INTO XS VALUES('051714210','郭瑞','051714210',1,'0517142','051714210','[e-mail]','13797216156','409974187',null)

INSERT INTO XS VALUES('051714211','侯玉','051714211',0,'0517142','051714211','','13733494951','',null)

INSERT INTO XS VALUES('051714212','胡龙威','051714212',1,'0517142','051714212','','15971268296','',null)

INSERT INTO XS VALUES('051714213','胡倩','051714213',0,'0517142','051714213','','','',null)

INSERT INTO XS VALUES('051714214','胡正梅','051714214',0,'0517142','051714214','','15971188718','',null)

INSERT INTO XS VALUES('051714215','黄陈程','051714215',1,'0517142','051714215','','15826827318','',null)

INSERT INTO XS VALUES('051714216','蒋桂芳','051714216',0,'0517142','051714216','','','',null)

INSERT INTO XS VALUES('051714217','蒋寅','051714217',1,'0517142','051714217','','13469792503','',null)

INSERT INTO XS VALUES('051714218','李攀','051714218',1,'0517142','051714218','','13789996394','',null)

INSERT INTO XS VALUES('051714219','刘双勇','051714219',1,'0517142','051714219','','','',null)

INSERT INTO XS VALUES('051714220','刘小荣','051714220',0,'0517142','051714220','','13469791240','',null)

INSERT INTO XS VALUES('051714221','梅汇','051714221',1,'0517142','051714221','','13477716262','',null)

INSERT INTO XS VALUES('051714223','汪家亮','051714223',1,'0517142','051714223','','','',null)

INSERT INTO XS VALUES('051714224','王进','051714224',1,'0517142','051714224','','13986488463','',null)

INSERT INTO XS VALUES('051714225','吴浩','051714225',1,'0517142','051714225','','','',null)

INSERT INTO XS VALUES('051714226','吴品忠','051714226',1,'0517142','051714226','','15971221730','',null)

INSERT INTO XS VALUES('051714227','夏磊','051714227',1,'0517142','051714227','','13469790298','',null)

INSERT INTO XS VALUES('051714228','徐云','051714228',1,'0517142','051714228','','15971261401','',null)

INSERT INTO XS VALUES('051714229','徐正','051714229',1,'0517142','051714229','','13797135240','',null)

INSERT INTO XS VALUES('051714230','闫婷婷','051714230',0,'0517142','051714230','','15971204045','',null)

INSERT INTO XS VALUES('051714231','杨石','051714231',1,'0517142','051714231','','','',null)

INSERT INTO XS VALUES('051714232','杨义挺','051714232',1,'0517142','051714232','','15826827337','',null)

INSERT INTO XS VALUES('051714233','张娅','051714233',0,'0517142','051714233','','','',null)

INSERT INTO XS VALUES('051714234','张玉莲','051714234',0,'0517142','051714234','','','',null)

INSERT INTO XS VALUES('051714235','赵明明','051714235',0,'0517142','051714235','','','',null)

INSERT INTO XS VALUES('051714236','邹玉华','051714236',0,'0517142','051714236','','','',null)

--教师表插入数据
INSERT INTO JS VALUES('170001','陈传红','170001','1','','13797147254','','','17')

INSERT INTO JS VALUES('170002','陈建新','170002','1','','13972660258','2345516','','17')

INSERT INTO JS VALUES('170004','陈晓文','170004','1','','13971975886','2824827','','17')

INSERT INTO JS VALUES('170008','胡中亚','170008','1','','13797133501','2345803','','17')

INSERT INTO JS VALUES('170012','焦家林','170012','1','','13871855163','2345946','','17')

INSERT INTO JS VALUES('170019','卢军','170019','1','','15807290505','2345016','','17')

INSERT INTO JS VALUES('170023','沈武英','170023','0','','15826878648','2345518','','17')

INSERT INTO JS VALUES('170024','凃俊英','170024','0','','13871885989','2345321','','17')

INSERT INTO JS VALUES('170027','王曙霞','170027','0','','13871889375','2345788','','17')

INSERT INTO JS VALUES('170028','魏文才','170028','1','','13035188866','2345513','','17')

INSERT INTO JS VALUES('170040','赵长军','170040','1','','13733476959','','','17')

INSERT INTO JS VALUES('170042','朱三元','170042','1','','13197383926','2345086','','17')

INSERT INTO JS VALUES('170044','叶从欢','170044','1','','13995897661','','','17')

INSERT INTO JS VALUES('170045','张凯兵','170045','1','','13986485715','','','17')

INSERT INTO JS VALUES('170046','谈怀江','170046','1','','13635811551','','','17')

INSERT INTO JS VALUES('170047','夏洪星','170047','1','','13477715779','2345778','','17')

INSERT INTO JS VALUES('170048','陈国志','170048','1','','13972660687','','','17')

INSERT INTO JS VALUES('170050','申鼎才','170050','1','','13871925896','','','17')

INSERT INTO JS VALUES('170052','李纪平','170052','1','','15826819072','','','17')

INSERT INTO JS VALUES('170054','李志敏','170054','1','','15072692167','','','17')

INSERT INTO JS VALUES('170056','赵惠子','170056','0','','15972322893','','','17')

--课程表插入数据
INSERT INTO KC VALUES('0001','网络工程',0)

INSERT INTO KC VALUES('0002','软件工程',0)

INSERT INTO KC VALUES('0003','编译原理',0)

INSERT INTO KC VALUES('0004','计算机图形学',0)

INSERT INTO KC VALUES('0005','信息安全概论',0)

--开课表插入数据
INSERT INTO KK VALUES('0001','170004',3,'jkx-1')

INSERT INTO KK VALUES('0002','170028',3,'教1楼309')

INSERT INTO KK VALUES('0003','170044',3,'教1楼309')

INSERT INTO KK VALUES('0004','170054',3,'jkx-4')

INSERT INTO KK VALUES('0005','170019',3,'jkx-4')

--开课班级表插入数据
INSERT INTO KKBJ VALUES(1,'0517141')

INSERT INTO KKBJ VALUES(1,'0517142')

INSERT INTO KKBJ VALUES(1,'0717124')

INSERT INTO KKBJ VALUES(2,'0517141')

INSERT INTO KKBJ VALUES(2,'0517142')

INSERT INTO KKBJ VALUES(2,'0717124')

INSERT INTO KKBJ VALUES(3,'0517141')

INSERT INTO KKBJ VALUES(3,'0517142')

INSERT INTO KKBJ VALUES(3,'0717124')

INSERT INTO KKBJ VALUES(4,'0517141')

INSERT INTO KKBJ VALUES(4,'0517142')

INSERT INTO KKBJ VALUES(4,'0717124')

INSERT INTO KKBJ VALUES(5,'0517141')

INSERT INTO KKBJ VALUES(5,'0517142')

INSERT INTO KKBJ VALUES(5,'0717124')

--实验室表插入数据
INSERT INTO SYS VALUES('基础实验室(一)','计算机中心一楼')

INSERT INTO SYS VALUES('基础实验室(二)','计算机中心一楼')

INSERT INTO SYS VALUES('基础实验室(三)','计算机中心二楼')

INSERT INTO SYS VALUES('开放实验室','计算机中心二楼')

INSERT INTO SYS VALUES('基础实验室(四)','计算机中心二楼')

INSERT INTO SYS VALUES('基础实验室(五)','计算机中心三楼')

INSERT INTO SYS VALUES('基础实验室(六)','计算机中心三楼')



--实验表插入数据
INSERT INTO SY VALUES('基本图形填充','0004','1','','','','2008-9-3','2008-9-17','','jkx-4')

INSERT INTO SY VALUES('DY的练习','0001','1','','','','2008-9-9','2008-9-23','','jkx-4')

INSERT INTO SY VALUES('交换机的基本配置','0001','2','','','','2008-9-23','2008-10-7','','jkx-4')

--实验上传表插入数据
INSERT INTO WJSC VALUES('2008-9-3','051714201','0001','','2008-9-3','基本图形填充','','','','')

INSERT INTO WJSC VALUES('2008-9-23','051714201','0003','','2008-9-23','交换机的基本配置','','','','')

--各班各学期上哪门课程
select 课程名,bj.班级号,开课学期 from kkbj,kk,kc,bj
   where kkbj.开课号=kk.开课号
      and kk.课程号=kc.课程号
        and kkbj.班级号=bj.班级号
           
create procedure class_course
as
select 课程名,bj.班级号,开课学期 
  from kkbj inner join kk
    on kkbj.开课号=kk.开课号 inner join kc
      on kc.课程号=kk.课程号 inner join bj
        on kkbj.班级号=bj.班级号

exec class_course