data.sql

很不错的一个超市管理的源代码。是一个大学生编的。您可以自己修改一下

insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('百事','add1','06124')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('长虹','add2','32564')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('青岛啤酒','add3','54876')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('蒙牛','add4','69875')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('徐福记','add5','23456')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('a','add1','06124')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('b','add2','32564')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('c','add3','54876')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('d牛','add4','69875')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('e','add5','23456')

insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('A1','address1','72531')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('A2','address2','75643')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('B1','address3','73689')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('B2','address4','78132')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('C1','address5','71359')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('D1','address55','725531')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('E2','address6','756343')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('F1','address7','731689')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('G2','address8','781632')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('H1','address9','713529')

insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch1',2,'1359','100',20,'1000001',1,'2005.3.10','2005.4.10','0','1','7','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch2',4,'280','40',20,'1000002',3,'2005.2.15','2005.3.15','0','1','8','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch3',150,'90','10',20,'1000003',105,'2005.5.10','2005.7.10','0','1','4','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch4',3500,'200','20',20,'1000004',2888,'2005.3.01','2005.5.31','0','1','8','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch6',12000,'80','10',20,'1000006',10000,'2005.7.01','2005.8.31','0','1','8','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch8',5,'2000','100',20,'1000008','0','1','7','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch9',50,'690','50',20,'1000009',38,'2005.3.10','2005.4.20','0','1','9','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch10',8,'2800','100',20,'1000010',6.5,'2005.5.10','2005.7.10','0','1','3','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch11',12,'15','50',20,'1000011','0','1','7','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch12',6,'1800','100',20,'1000012',4.5,'2005.5.10','2005.7.10','0','1','6','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch13',5,'2000','100',20,'1000013','0','0','9','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch15',8888,'300','50',20,'1000015',6999,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch16',60,'700','50',20,'1000016',55,'2005.6.01','2005.8.31','1','1','9','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch18',50,'900','100',20,'1000018',45,'2005.3.10','2005.5.30','1','1','7','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch19',8,'2000','150',20,'1000019','1','1','7','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch20',22,'500','100',20,'1000020',18,'2005.7.10','2005.8.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch21',2500,35,50,20,'1000021','1','1','8','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch22',55,'500','80',20,'1000022',50,'2005.6.10','2005.7.31','1','1','9','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch23',30,'1000','100',20,'1000023',26,'2005.6.10','2005.7.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch24',9,'1500','100',20,'1000024',6,'2005.8.10','2005.9.30','1','1','8','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch25',6,'2000','150',20,'1000025',5,'2005.6.10','2005.7.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch26',400,'500','50',20,'1000026','1','1','8','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch27',80,'300','50',20,'1000027',70,'2005.4.10','2005.5.15','1','1','7','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch28',280,'500','100',20,'1000028',260,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch29',48,'800','50',20,'1000029',40,'2005.6.10','2005.7.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch30',6888,'300','50',20,'1000030',5999,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch31',68,'800','100',20,'1000031',59,'2005.7.10','2005.8.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch32',9,'1300','100',20,'1000032',7,'2005.4.10','2005.7.31','1','1','9','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch33',80,'900','50',20,'1000033',68,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch35',2888,'300','50',20,'1000035',2000,'2005.6.10','2005.7.31','1','1','8','5')

insert Member(MemberCard,TotalCost,RegDate) values('2003007',2000,'2003.5.30')
insert Member(MemberCard,TotalCost,RegDate) values('2004007',1000,'2004.6.01')
insert Member(MemberCard,TotalCost,RegDate) values('2005135',5000,'2005.2.15')
insert Member(MemberCard,TotalCost,RegDate) values('2005246',1500,'2005.3.10')
insert Member(MemberCard,TotalCost,RegDate) values('2005357',6888,'2005.6.20')

insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.3.20','200',2)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('6','2005.3.25','1',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('8','2005.3.26','280',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('9','2005.3.22','50',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.4.20','68',2)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('16','2005.4.25','20',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.4.28','55',1.5)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.4.30','35',2)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('27','2005.5.15','20',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.6.20','10',2)

insert [User] values('Admin','21232F297A57A5A743894A0E4A801FC3',4)
insert [User] values('赖秋林','9D607A663F3E9B0A90C3C8D4426640DC',2)
insert [User] values('阿年','894F782A148B33AF1E39A0EFED952D69',3)
insert [User] values('凌聪','8A8BB7CD343AA2AD99B7D762030857A2',1)
insert [User] values('翁炎泉','693A9FDD4C2FD0700968FBA0D07FF3C0',1)

insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(200,'2003-3-20','2003007','凌聪')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(12000,'2003-3-25','','凌聪')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(40,'2004-3-26','2005135','')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(150,'2004-3-22','','凌聪')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(60,'2005-4-20','2005246','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(300,'2005-4-25','','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(200,'2005-4-28','2004007','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(90,'2005-8-15','2003007','')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(240,'2005-9-2','2005135','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(160,'2005-9-7','2003007','')