jcgl.sql

商场管理DELPHI代码主要是描述商场商品的进货入库出库以及资金进出等功能

drop table Class
delete from Class
where Deptno='0201'

drop table Dept
DROP TABLE Yonghu
DROP TABLE Jiaocai
DROP TABLE Caiwu

CREATE TABLE Yonghu(Username CHAR(20) NOT NULL,
Passwords CHAR(10), 
Quanxian char(2) NOT NULL)

INSERT INTO Yonghu
VALUES('weiqi409','111111','0')
INSERT INTO Yonghu
VALUES('jianzhong404','222222','0')
INSERT INTO Yonghu
VALUES('user','333333','1')




CREATE TABLE Jiaocai (Jcno CHAR(10) NOT NULL,
Jcname CHAR(40) NOT NULL,
Cbs CHAR(40),Author CHAR (40),
Cbtime char(15),
Ccnum INT,
Rktime char(15),
Jcprice MONEY NOT NULL,
PRIMARY KEY(Jcno))

DELETE From Jiaocai
WHERE Jcno=001001
INSERT INTO Jiaocai
VALUES('001001','高等数学','高等教育出版社','同济大学','2000-4',645,'2002-8-30',15.50)
INSERT INTO Jiaocai
VALUES('001002','经济学数学基础','四川人民出版社','龚德恩','1998-12',750,'2002-8-30',14.50)
INSERT INTO Jiaocai
VALUES('001003','线性代数','清华大学出版社','居余马','1998-12',800,'2002-7-25',16.00)
INSERT INTO Jiaocai
VALUES('001004','概率论','清华出版社','余建中','2001-6',576,'2002-8-30',13.90)
INSERT INTO Jiaocai
VALUES('001005','运筹学通论','中国人民大学出版社','魏权龄等','2003-3',712,'2002-8-30',15.00)
INSERT INTO Jiaocai
VALUES('001006','计算方法引论','高等教育出版社','徐萃薇','2000-6',650,'2003-9-1',16.00)
INSERT INTO Jiaocai
VALUES('001007','离散数学','清华大学出版社','麦庆龙','2001-6',600,'2003-9-1',19.00)

INSERT INTO Jiaocai
VALUES('001008','综合数学','华夏出版社','维多利亚','1998-6',560,'2003-9-1',20.00)
INSERT INTO Jiaocai
VALUES('001009','数学建模教程','人民文学出版社','莱昂纳多','1999-5',720,'2003-9-1',24.40)



INSERT INTO Jiaocai
VALUES('002001','大学英语读写教程（第一册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-
1',29.00)
INSERT INTO Jiaocai
VALUES('002002','大学英语读写教程（第二册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-
1',28.00)
INSERT INTO Jiaocai
VALUES('002003','大学英语读写教程（第三册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-
1',29.00)
INSERT INTO Jiaocai
VALUES('002004','大学英语读写教程（第四册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-
1',27.00)
INSERT INTO Jiaocai
VALUES('002005','大学英语听说教程（第一册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-
1',14.00)
INSERT INTO Jiaocai
VALUES('002006','大学英语听说教程（第二册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-
1',15.00)
INSERT INTO Jiaocai
VALUES('002007','大学英语听说教程（第三册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-
1',13.00)
INSERT INTO Jiaocai
VALUES('002008','大学英语听说教程（第四册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-
1',14.00)
INSERT INTO Jiaocai
VALUES('002009','大学英语练习册（第一册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-1',17.00)
INSERT INTO Jiaocai
VALUES('002010','大学英语练习册（第二册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-1',17.00)
INSERT INTO Jiaocai
VALUES('002011','大学英语练习册（第三册）','高等教育出版社','上海交通大学','2000-6',900,'2002-9-1',17.00)
INSERT INTO Jiaocai
VALUES('002012','大学英语练习册（第四册）','高等教育出版社','上海交通大学','2000-6',900,'2003-9-1',17.00)


INSERT INTO Jiaocai
VALUES('004001','马克思主义哲学','浙江人民出版社','钱强天','2002-6',500,'2003-9-1',20.50)
INSERT INTO Jiaocai
VALUES('004002','大学生思想道德修养','中国人民出版社','马主应','1999-6',550,'2003-9-1',29.60)
INSERT INTO Jiaocai
VALUES('004003','政治经济学','中国人民出版社','魏其','2001-3',600,'2003-9-1',27.00)
INSERT INTO Jiaocai
VALUES('004004','毛泽东思想概论','浙江人民出版社','王威严','2000-6',500,'2001-9-1',19.00)
INSERT INTO Jiaocai
VALUES('004005','邓小平理论','浙江人民出版社','施向奎','1999-5',550,'2003-9-1',23.00)
INSERT INTO Jiaocai
VALUES('004006','世界政治经济和国际关系','中国人民出版社','陈小微译','2001-9',400,'2003-9-1',32.00)
INSERT INTO Jiaocai
VALUES('004007','西方经济学','人民教育出版社','季浩冉','2000-4',400,'2003-9-1',28.50)
INSERT INTO Jiaocai
VALUES('004008','社会学','华夏出版社','王力宏','1998-6',560,'2003-9-1',20.00)
INSERT INTO Jiaocai
VALUES('004009','中国传统文化','人民文学出版社','钟汉良','1999-5',560,'2003-9-1',24.40)
INSERT INTO Jiaocai
VALUES('004010','公共关系学','江苏教育出版社','梁静茹','2001-5',560,'2003-9-1',40.50)
INSERT INTO Jiaocai
VALUES('004011','心理学','北京出版社','林志颖','2002-8',560,'2003-9-1',30.50)




INSERT INTO Jiaocai
VALUES('005001','计算机应用概论','电子工业出版社','赵伟博','2002-6',720,'2000-9-1',25.90)
INSERT INTO Jiaocai
VALUES('005002','电路与电子技术','哈尔滨工业出版社','郑元畅','2000-6',900,'2003-9-1',30.00)
INSERT INTO Jiaocai
VALUES('005003','高级程序设计','机械工业出版社','贾静雯','2000-6',900,'2003-9-1',31.60)
INSERT INTO Jiaocai
VALUES('005004','数字逻辑','清华大学出版社','谢霆锋','2000-6',900,'2003-9-1',28.50)
INSERT INTO Jiaocai
VALUES('005005','计算机组成与系统组成','人民邮电出版社','谢霆锋','2001-6',500,'2003-9-1',35.50)
INSERT INTO Jiaocai
VALUES('005006','数字逻辑','高等教育出版社','苏有朋','1998-6',765,'2003-9-1',36.50)
INSERT INTO Jiaocai
VALUES('005007','汇编语言程序设计','江苏教育出版社','刘若英','2002-6',500,'2003-9-1',50.00)
INSERT INTO Jiaocai
VALUES('005008','算法与数据结构','高等教育出版社','赵雅芝','1999-6',500,'2003-9-1',25.50)
INSERT INTO Jiaocai
VALUES('005009','通信原理概论','复旦大学出版社','周渝民','1998-6',500,'2003-9-1',23.00)
INSERT INTO Jiaocai
VALUES('005010','操作系统','上海教育出版社','周笔畅','1997-6',500,'2003-9-1',28.00)
INSERT INTO Jiaocai
VALUES('005011','计算机网络','大连理工大学出版社','钟欣桐','2002-6',506,'2003-9-1',19.50)
INSERT INTO Jiaocai
VALUES('005012','数据库原理','高等教育出版社','谭咏麟','2001-6',560,'2003-9-1',36.50)
INSERT INTO Jiaocai
VALUES('005013','微机接口技术','长江文艺出版社','金素妍','2001-6',560,'2003-9-1',23.50)
INSERT INTO Jiaocai
VALUES('005014','编译原理','大连理工大学出版社','裴勇俊','2001-6',560,'2003-9-1',26.30)
INSERT INTO Jiaocai
VALUES('005015','人机接口与计算机图形学','同济大学出版社','姜东元','2001-6',560,'2003-9-1',33.20)
INSERT INTO Jiaocai
VALUES('005016','面向对象程序设计','高等教育出版社','全智贤','2001-6',560,'2003-9-1',52.50)
INSERT INTO Jiaocai
VALUES('005017','C++程序设计','同济大学出版社','李贞贤','2001-6',560,'2003-9-1',19.00)
INSERT INTO Jiaocai
VALUES('005018','单片机中级教程','电子工业出版社','金来元','2001-6',560,'2003-9-1',28.00)
INSERT INTO Jiaocai
VALUES('005019','软件工程','机械工业出版社','金在元','2001-6',560,'2003-9-1',36.50)
INSERT INTO Jiaocai
VALUES('005020','电子商务概论','中国电力出版社','滨崎步','2001-6',560,'2003-9-1',26.50)
INSERT INTO Jiaocai
VALUES('005021','多媒体技术','中国水利水电出版社','张娜拉','2001-6',560,'2003-9-1',43.00)
INSERT INTO Jiaocai
VALUES('005022','计算机安全与保密','东北财经大学出版社','李美妍','2001-6',560,'2003-9-1',36.00)
INSERT INTO Jiaocai
VALUES('005023','计算机英语','中国水利水电出版社','林志颖','2001-6',560,'2003-9-1',34.50)
INSERT INTO Jiaocai
VALUES('005024','人工智能导论','中国水利水电出版社','言承旭','2001-6',560,'2003-9-1',29.50)
INSERT INTO Jiaocai
VALUES('005025','计算机维护','中国水利水电出版社','陈好','2001-6',560,'2003-9-1',18.00)
INSERT INTO Jiaocai
VALUES('005026','办公自动化','中国水利水电出版社','高圆圆','2001-6',560,'2003-9-1',30.00)
INSERT INTO Jiaocai
VALUES('005027','图象处理','中国水利水电出版社','林志玲','2001-6',560,'2003-9-1',27.00)
INSERT INTO Jiaocai
VALUES('005028','电子商务技术','中国水利水电出版社','飞儿乐团','2001-6',560,'2003-9-1',18.00)


INSERT INTO Jiaocai
VALUES('003001','西方经济学','江苏教育出版社','席琳狄翁','2001-5',528,'2003-9-1',40.50)
INSERT INTO Jiaocai
VALUES('003002','财政学','北京出版社','蔡依林','2002-8',560,'2003-9-1',30.50)
INSERT INTO Jiaocai
VALUES('003003','会计学','华夏出版社','王力宏','1998-6',570,'2003-9-1',20.00)
INSERT INTO Jiaocai
VALUES('003004','货币银行学','人民文学出版社','beyond','1999-5',800,'2003-9-1',24.40)
INSERT INTO Jiaocai
VALUES('003005','管理学','江苏教育出版社','霍建华','2001-5',920,'2003-9-1',40.50)
INSERT INTO Jiaocai
VALUES('003006','法律基础与经济学','北京出版社','李若彤','2002-8',871,'2003-9-1',30.50)




CREATE TABLE Class(Cno char(8) not null ,Cname char(40),Cnum int not null,Deptno char(8),primary key
(Cno))


INSERT INTO Class
VALUES('01010101','01经济学（1）班',40,'0101')
INSERT INTO Class
VALUES('01010102','01经济学（2）班',42,'0101')
INSERT INTO Class
VALUES('01010103','01经济学（3）班',42,'0101')
INSERT INTO Class
VALUES('01010201','02经济学（1）班',40,'0101')
INSERT INTO Class
VALUES('01010202','02经济学（2）班',42,'0101')
INSERT INTO Class
VALUES('01010203','02经济学（3）班',42,'0101')
INSERT INTO Class
VALUES('01010301','03经济学（1）班',40,'0101')
INSERT INTO Class
VALUES('01010302','03经济学（2）班',42,'0101')
INSERT INTO Class
VALUES('01010303','03经济学（3）班',42,'0101')
INSERT INTO Class
VALUES('01010401','04经济学（1）班',40,'0101')
INSERT INTO Class
VALUES('01010402','04经济学（2）班',42,'0101')
INSERT INTO Class
VALUES('01010403','04经济学（3）班',42,'0101')

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


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

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


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


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

INSERT INTO Class