JavaScript MySQL实现超市管理系统【优质毕业设计、课程设计项目】.zip

CREATE TABLE [dbo].[xiaoshouyuanxinxi] ( [ID] [int] IDENTITY (1, 1) NOT NULL ,[gonghao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[mima] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[xingming] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[shenfenzhenghao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[xingbie] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[dianhua] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[beizhu] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,[addtime] [datetime] DEFAULT (getdate()) ) ON [PRIMARY] GO insert into xiaoshouyuanxinxi(gonghao,mima,xingming,shenfenzhenghao,xingbie,dianhua,beizhu) select top 1 gonghao,'001',xingming,shenfenzhenghao,xingbie,dianhua,'abc' from yuangongxinxi order by newid(); insert into xiaoshouyuanxinxi(gonghao,mima,xingming,shenfenzhenghao,xingbie,dianhua,beizhu) select top 1 gonghao,'001',xingming,shenfenzhenghao,xingbie,dianhua,'abc' from yuangongxinxi order by newid(); insert into xiaoshouyuanxinxi(gonghao,mima,xingming,shenfenzhenghao,xingbie,dianhua,beizhu) select top 1 gonghao,'001',xingming,shenfenzhenghao,xingbie,dianhua,'abc' from yuangongxinxi order by newid(); insert into xiaoshouyuanxinxi(gonghao,mima,xingming,shenfenzhenghao,xingbie,dianhua,beizhu) select top 1 gonghao,'001',xingming,shenfenzhenghao,xingbie,dianhua,'abc' from yuangongxinxi order by newid(); insert into xiaoshouyuanxinxi(gonghao,mima,xingming,shenfenzhenghao,xingbie,dianhua,beizhu) select top 1 gonghao,'001',xingming,shenfenzhenghao,xingbie,dianhua,'没问题' from yuangongxinxi order by newid(); insert into xiaoshouyuanxinxi(gonghao,mima,xingming,shenfenzhenghao,xingbie,dianhua,beizhu) select top 1 gonghao,'001',xingming,shenfenzhenghao,xingbie,dianhua,'无' from yuangongxinxi order by newid(); insert into xiaoshouyuanxinxi(gonghao,mima,xingming,shenfenzhenghao,xingbie,dianhua,beizhu) select top 1 gonghao,'001',xingming,shenfenzhenghao,xingbie,dianhua,'ok' from yuangongxinxi order by newid(); insert into xiaoshouyuanxinxi(gonghao,mima,xingming,shenfenzhenghao,xingbie,dianhua,beizhu) select top 1 gonghao,'001',xingming,shenfenzhenghao,xingbie,dianhua,'暂无' from yuangongxinxi order by newid();