jcgl.sql

来自「商场管理DELPHI代码主要是描述商场商品的进货入库出库以及资金进出等功能」· SQL 代码 · 共 631 行 · 第 1/2 页

VALUES('04010101','01经济法（1）班',42,'0401')
INSERT INTO Class
VALUES('04010102','01经济法（2）班',42,'0401')
INSERT INTO Class
VALUES('04010201','02经济法（1）班',42,'0401')
INSERT INTO Class
VALUES('04010202','02经济法（2）班',42,'0401')
INSERT INTO Class
VALUES('04010301','03经济法（1）班',42,'0401')
INSERT INTO Class
VALUES('04010302','03经济法（2）班',42,'0401')
INSERT INTO Class
VALUES('04010401','04经济法（1）班',42,'0401')
INSERT INTO Class
VALUES('04010402','04经济法（2）班',42,'0401')

INSERT INTO Class
VALUES('04020101','01律师（1）班',42,'0402')
INSERT INTO Class
VALUES('04020102','01律师（2）班',42,'0402')
INSERT INTO Class
VALUES('04020201','02律师（1）班',42,'0402')
INSERT INTO Class
VALUES('04020202','02律师（2）班',42,'0402')
INSERT INTO Class
VALUES('04020301','03律师（1）班',42,'0402')
INSERT INTO Class
VALUES('04020302','03律师（2）班',42,'0402')
INSERT INTO Class
VALUES('04020401','04律师（1）班',42,'0402')
INSERT INTO Class
VALUES('04020402','04律师（2）班',42,'0402')


INSERT INTO Class
VALUES('04030101','01行管（1）班',38,'0403')
INSERT INTO Class
VALUES('04030102','01行管（2）班',38,'0403')
INSERT INTO Class
VALUES('04030201','02行管（1）班',38,'0403')
INSERT INTO Class
VALUES('04030202','02行管（2）班',38,'0403')
INSERT INTO Class
VALUES('04030301','03行管（1）班',38,'0403')
INSERT INTO Class
VALUES('04030302','03行管（2）班',38,'0403')
INSERT INTO Class
VALUES('04030401','04行管（1）班',38,'0403')
INSERT INTO Class
VALUES('04030402','04行管（2）班',38,'0403')



INSERT INTO Class
VALUES('05010101','01英语（1）班',40,'0501')
INSERT INTO Class
VALUES('05010102','01英语（2）班',40,'0501')
INSERT INTO Class
VALUES('05010103','01英语（3）班',40,'0501')
INSERT INTO Class
VALUES('05010201','02英语（1）班',40,'0501')
INSERT INTO Class
VALUES('05010202','02英语（2）班',40,'0501')
INSERT INTO Class
VALUES('05010203','02英语（3）班',40,'0501')
INSERT INTO Class
VALUES('05010301','03英语（1）班',40,'0501')
INSERT INTO Class
VALUES('05010302','03英语（2）班',40,'0501')
INSERT INTO Class
VALUES('05010303','03英语（3）班',40,'0501')
INSERT INTO Class
VALUES('05010401','04英语（1）班',40,'0501')
INSERT INTO Class
VALUES('05010402','04英语（2）班',40,'0501')
INSERT INTO Class
VALUES('05010403','04英语（3）班',40,'0501')


CREATE TABLE Dept(Deptno char(8),Deptname char(40),PRIMARY KEY(Deptno))

INSERT INTO Dept
VALUES('0101','经济学院经济学专业')
INSERT INTO Dept
VALUES('0201','会计学院会计学专业')
INSERT INTO Dept
VALUES('0301','信息学院信息管理专业')
INSERT INTO Dept
VALUES('0302','信息学院电子商务专业')
INSERT INTO Dept
VALUES('0303','信息学院计算机专业')
INSERT INTO Dept
VALUES('0304','信息学院统计学专业')
INSERT INTO Dept
VALUES('0401','法学院经济法专业')
INSERT INTO Dept
VALUES('0402','法学院律师专业')
INSERT INTO Dept
VALUES('0403','法学院行政管理专业')
INSERT INTO Dept
VALUES('0501','外国语学院英语专业')



CREATE TABLE Caiwu(
 Cno char(8) Not Null,
 Cname char(40),
 Cpre_money int,
 Yue int,
 primary key(Cno))
INSERT INTO Caiwu
VALUES('01010101','01经济学（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010102','01经济学（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010103','01经济学（3）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010201','02经济学（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010202','02经济学（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010203','02经济学（3）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010301','03经济学（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010302','03经济学（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010303','03经济学（3）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010401','04经济学（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010402','04经济学（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('01010403','04经济学（3）班',5000,5000)

INSERT INTO Caiwu
VALUES('02010101','01会计（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010102','01会计（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010103','01会计（3）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010201','02会计（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010202','02会计（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010203','02会计（3）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010301','03会计（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010302','03会计（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010303','03会计（3）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010401','04会计（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010402','04会计（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('02010403','04会计（3）班',5000,5000)


INSERT INTO Caiwu
VALUES('03010101','01信息（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03010102','01信息（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03010201','02信息（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03010202','02信息（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03010301','03信息（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03010302','03信息（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03010401','04信息（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03010402','04信息（2）班',5000,5000)

INSERT INTO Caiwu
VALUES('03020102','01电子商务（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03020101','01电子商务（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03020202','02电子商务（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03020201','02电子商务（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03020302','03电子商务（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03020301','03电子商务（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03020402','04电子商务（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03020401','04电子商务（1）班',5000,5000)


INSERT INTO Caiwu
VALUES('03030101','01计算机科学与技术（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03030102','01计算机科学与技术（2）班',50000,50000)
INSERT INTO Caiwu
VALUES('03030201','02计算机科学与技术（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03030202','02计算机科学与技术（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03030301','03计算机科学与技术（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03030302','03计算机科学与技术（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03030401','04计算机科学与技术（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03030402','04计算机科学与技术（2）班',5000,5000)


INSERT INTO Caiwu
VALUES('03040101','01统计（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03040102','01统计（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03040201','02统计（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03040202','02统计（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03040301','03统计（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03040302','03统计（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('03040401','04统计（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('03040402','04统计（2）班',5000,5000)

INSERT INTO Caiwu
VALUES('04010101','01经济法（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04010102','01经济法（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('04010201','02经济法（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04010202','02经济法（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('04010301','03经济法（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04010302','03经济法（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('04010401','04经济法（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04010402','04经济法（2）班',5000,5000)

INSERT INTO Caiwu
VALUES('04020101','01律师（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04020102','01律师（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('04020201','02律师（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04020202','02律师（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('04020301','03律师（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04020302','03律师（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('04020401','04律师（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04020402','04律师（2）班',5000,5000)


INSERT INTO Caiwu
VALUES('04030101','01行管（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04030102','01行管（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('04030201','02行管（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04030202','02行管（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('04030301','03行管（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04030302','03行管（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('04030401','04行管（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('04030402','04行管（2）班',5000,5000)



INSERT INTO Caiwu
VALUES('05010101','01英语（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010102','01英语（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010103','01英语（3）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010201','02英语（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010202','02英语（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010203','02英语（3）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010301','03英语（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010302','03英语（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010303','03英语（3）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010401','04英语（1）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010402','04英语（2）班',5000,5000)
INSERT INTO Caiwu
VALUES('05010403','04英语（3）班',5000,5000)

select *from Yonghu
select *from Jiaocai
select *from Class
select *from Dept
select *from Caiwu