DB_51aspx/Database_Data.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

USE [Database_Data]
GO
/****** Object:  Table [dbo].[tUser]    Script Date: 08/30/2016 17:34:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tUser](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[username] [nvarchar](51) NULL,
	[userpassword] [nvarchar](50) NULL,
	[userrname] [nvarchar](50) NULL,
	[usertel] [nvarchar](50) NULL,
	[useraddr] [nvarchar](255) NULL,
	[userclass] [int] NULL,
 CONSTRAINT [PK_ST_tUser] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[tUser] ON
INSERT [dbo].[tUser] ([ID], [username], [userpassword], [userrname], [usertel], [useraddr], [userclass]) VALUES (4, N'admin', N'admin', N'管理员', N'18722592937', N'安徽安庆', 2)
INSERT [dbo].[tUser] ([ID], [username], [userpassword], [userrname], [usertel], [useraddr], [userclass]) VALUES (7, N'123', N'123', N'fujun', N'15620942991', N'天津科技大学', 1)
INSERT [dbo].[tUser] ([ID], [username], [userpassword], [userrname], [usertel], [useraddr], [userclass]) VALUES (8, N'456', N'456', N'dongyang', N'18722592628', N'天津科技大学', 1)
INSERT [dbo].[tUser] ([ID], [username], [userpassword], [userrname], [usertel], [useraddr], [userclass]) VALUES (9, N'fujun', N'fujun', N'傅军', N'13866002878', N'天津市河西区大沽南路1038号', 1)
SET IDENTITY_INSERT [dbo].[tUser] OFF
/****** Object:  Table [dbo].[tProduct]    Script Date: 08/30/2016 17:34:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tProduct](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[productname] [nvarchar](51) NULL,
	[productprice] [int] NULL,
	[productpic] [nvarchar](50) NULL,
	[productinfo] [ntext] NULL,
	[productclass] [nvarchar](50) NULL,
	[prolibnow] [int] NULL,
 CONSTRAINT [PK_ST_tProduct] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[tProduct] ON
INSERT [dbo].[tProduct] ([ID], [productname], [productprice], [productpic], [productinfo], [productclass], [prolibnow]) VALUES (52, N'nano 8', 1088, N'nano.jpg', N'苹果公司出品，超级人性化设计，完美音质的mp3播放器', N'MP3', 0)
INSERT [dbo].[tProduct] ([ID], [productname], [productprice], [productpic], [productinfo], [productclass], [prolibnow]) VALUES (53, N'尼康d90', 10000, N'尼康d90.png', N'尼康d90，超高性价比。', N'数码相机', 0)
INSERT [dbo].[tProduct] ([ID], [productname], [productprice], [productpic], [productinfo], [productclass], [prolibnow]) VALUES (54, N'戴尔灵越15R-1816', 5400, N'戴尔灵越15R-1816.png', N'年轻人潮牌。', N'笔记本电脑', 0)
INSERT [dbo].[tProduct] ([ID], [productname], [productprice], [productpic], [productinfo], [productclass], [prolibnow]) VALUES (55, N'乐视TV·超级电视', 6999, N'乐视TV·超级电视.png', N'乐视TV·超级电视，强大功能。', N'电视', 0)
INSERT [dbo].[tProduct] ([ID], [productname], [productprice], [productpic], [productinfo], [productclass], [prolibnow]) VALUES (56, N'海尔XQB75-S9288', 3699, N'海尔XQB75-S9288.png', N'拥有7.5kg洗涤容积，外观设计大气时尚，采用智能记忆洗功能，性能强劲。', N'洗衣机', 0)
INSERT [dbo].[tProduct] ([ID], [productname], [productprice], [productpic], [productinfo], [productclass], [prolibnow]) VALUES (57, N'　伊莱克斯冰箱EHC3507WA', 2699, N'伊莱克斯冰箱EHC3507WA.png', N'伊莱克斯冰箱EHC3507WA沿袭欧式简约之风，硬朗外观辅以时尚宽门设计，演绎非凡气度，带来质感明快的视觉感受，尽显专属于你的时尚品位。
', N'冰箱', 0)
INSERT [dbo].[tProduct] ([ID], [productname], [productprice], [productpic], [productinfo], [productclass], [prolibnow]) VALUES (58, N'格力优雅', 5688, N'格力优雅.png', N'格力优雅，完美自然', N'空调', 0)
INSERT [dbo].[tProduct] ([ID], [productname], [productprice], [productpic], [productinfo], [productclass], [prolibnow]) VALUES (59, N'Smartisan T1', 3150, N'Smartisan T1.jpg', N'锤子科技第一部手机产品，具有很强的人机交互设计，超强的人性化设计。', N'手机', 0)
SET IDENTITY_INSERT [dbo].[tProduct] OFF
/****** Object:  Table [dbo].[tProClass]    Script Date: 08/30/2016 17:34:10 ******/
SET ANSI_NULLS ON