insertdata.sql

一个基于swing组件的java程序

--添加院系
insert into department values('001','软件学院');
insert into department values('002','电信学院');
insert into department values('003','外语学院');
insert into department values('004','管理学院');
insert into department values('005','建筑学院');
insert into department values('006','化工学院');
insert into department values('007','机械学院');
insert into department values('008','自动化学院');
insert into department values('009','动力学院');
insert into department values('010','船舶学院');
insert into department values('011','体育学院');
insert into department values('012','人文学院');
--添加学生
insert into student values('200501005','曹操','男','001','1');
insert into student values('200501006','吕布','男','001','1');
insert into student values('200501007','貂禅','女','001','1');

insert into student values('200502015','杨过','男','002','1');
insert into student values('200502016','小龙女','女','002','1');
insert into student values('200502017','程英','女','002','1');

insert into student values('200503023','双儿','女','003','1');
insert into student values('200503024','沐剑萍','女','003','1');
insert into student values('200503025','方仪','女','003','1');
insert into student values('200503026','苏荃','女','003','1');

insert into student values('200504034','周芷若','女','004','1');
insert into student values('200504035','鹤比翁','男','004','1');
insert into student values('200504036','鹿仗客','男','004','1');
insert into student values('200504037','张三丰','男','004','1');

insert into student values('200505044','郑宏','男','005','1');
insert into student values('200505045','袁军','男','005','1');

insert into student values('200506051','张小凡','男','006','1');
insert into student values('200506052','林惊羽','男','006','1');
insert into student values('200506053','田灵儿','女','006','1');

insert into student values('200507086','华子','男','007','1');
insert into student values('200507087','灵杉','女','007','1');
insert into student values('200507088','露露','女','007','1');

insert into student values('200508097','三井','男','008','1');
insert into student values('200508098','采子','女','008','1');

insert into student values('200509101','赵智杰','男','009','1');
insert into student values('200509102','阿比','男','009','1');
insert into student values('200509103','小新','男','009','1');

insert into student values('200510116','滕堂静','女','010','1');
insert into student values('200510117','青和','男','010','1');
insert into student values('200510118','小优','女','010','1');

insert into student values('200511121','乔峰','男','011','1');
insert into student values('200511122','段誉','男','011','1');
insert into student values('200511123','虚竹','男','011','1');

insert into student values('200512131','杨玉环','女','012','1');
insert into student values('200512132','唐玄宗','男','012','1');
insert into student values('200512133','高力士','男','012','1');
--添加课程
insert into course values('10001','工科数学','5');
insert into course values('10002','概率论','3');
insert into course values('10003','线性代数','4');
insert into course values('10004','大学物理','3');
insert into course values('10005','大学英语','4');
insert into course values('10006','离散数学','3');
insert into course values('10007','马克思主义哲学','2');
insert into course values('10008','毛泽东思想概论','2');
insert into course values('10009','邓小平理论','2');
insert into course values('10010','马克思主义政治经济学','2');
insert into course values('10011','计算机网络','3');
insert into course values('10012','编译原理','4');
insert into course values('10013','计算机文化基础','3');
insert into course values('10014','C++编程','5');
insert into course values('10015','数据结构','5');
insert into course values('10016','面向对象程序设计','3');
insert into course values('10017','软件工程','1');
insert into course values('10018','人工智能','2');