基于Java EE的停车场管理系统.zip

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[chewei]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[chewei]( [id] [int] IDENTITY(1,1) NOT NULL, [chewei_no] [nvarchar](50) NULL, [chewei_type] [nvarchar](50) NULL, [chewei_state] [nvarchar](50) NULL, [chewei_didian] [nvarchar](50) NULL, CONSTRAINT [PK_chewei] 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] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[reg]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[reg]( [id] [int] IDENTITY(1,1) NOT NULL, [username] [nvarchar](50) NULL, [password] [nvarchar](50) NULL, [chepaihao] [nvarchar](50) NULL, [jine] [nvarchar](50) NULL, [truename] [nvarchar](50) NULL, [tel] [nvarchar](50) NULL, [jianjie] [nvarchar](500) NULL, [quanxian] [nvarchar](50) NULL CONSTRAINT [DF_reg_quanxian] DEFAULT (N'会员'), [shijian] [datetime] NULL, CONSTRAINT [PK_reg] 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] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[weigui]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[weigui]( [id] [int] IDENTITY(1,1) NOT NULL, [username] [nvarchar](50) NULL, [chepaihao] [nvarchar](50) NULL, [states] [nvarchar](50) NULL, [shuoming] [nvarchar](500) NULL, CONSTRAINT [PK_weigui] 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] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[feiyong]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[feiyong]( [id] [int] IDENTITY(1,1) NOT NULL, [username] [nvarchar](50) NULL, [yonghu_type] [nvarchar](50) NULL, [zhifu_type] [nvarchar](50) NULL, [jine] [nvarchar](50) NULL, [beizhu] [nvarchar](500) NULL, [shijian] [datetime] NULL, CONSTRAINT [PK_feiyong] 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] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[login]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[login]( [id] [int] IDENTITY(1,1) NOT NULL, [username] [nvarchar](50) NULL, [password] [nvarchar](50) NULL, CONSTRAINT [PK_login] 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] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[gg]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[gg]( [id] [int] IDENTITY(1,1) NOT NULL, [Gg_titile] [nvarchar](100) NULL, [Gg_neirong] [nvarchar](500) NULL, [shijian] [datetime] NULL, CONSTRAINT [PK_gg] 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] END