基于j2ee的電影院訂票系統(tǒng)(編輯修改稿)
2024-12-18 15:31 本頁面
【文章內(nèi)容簡介】 ovieid] [int] IDENTITY(1,1) NOT NULL, [moviename] [varchar](50) NOT NULL, [actor] [varchar](50) NOT NULL, [director] [varchar](50) NOT NULL, [price] [int] NOT NULL, [time] [nchar](10) NOT NULL, [showtime] [smalldatetime] NOT NULL, CONSTRAINT [PK_movie] PRIMARY KEY CLUSTERED ( [movieid] 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 ANSI_PADDING OFF GO /****** Object: Table [dbo].[userinfo] Script Date: 04/20/2020 20:59:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[userinfo]( [userid] [int] IDENTITY(1,1) NOT NULL, [username] [varchar](20) NOT NULL, [password] [varchar](20) NOT NULL, [money] [int] NULL, CONSTRAINT [PK_user] PRIMARY KEY CLUSTERED ( [userid] ASC 8 )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 ANSI_PADDING OFF GO /****** Object: Table [dbo].[orders] Script Date: 04/20/2020 20:59:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[orders]( [orderid] [int] IDENTITY(1,1) NOT NULL, [userid] [int] NOT NULL, [orderdate] [timestamp] NOT NULL, CONSTRAINT [PK_orders] PRIMARY KEY CLUSTERED ( [orderid] 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 /****** Object: Table [dbo].[orderitem] Script Date: 04/20/2020 20:59:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[orderitem]( [orderitemid] [int] IDENTITY(1,1) NOT NULL, [orderid] [int] NOT NULL, [movieid] [int] NOT NULL, [quantity] [int] NOT NULL, CONSTRAINT [PK_orderitem] PRIMARY KEY CLUSTERED ( [orderitemid] 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 /****** Object: ForeignKey [FK_orderitem_movie] Script Date: 04/20/2020 20:59:12 ******/ ALTER TABLE [dbo].[orderitem] WITH CHECK ADD CONSTRAINT [FK_orderitem_movie] FOREIGN KEY([movieid]) 9 REFERENCES [dbo].[movie] ([movieid]) GO ALTER TABLE [dbo].[orderitem] CHECK CONSTRAINT [FK_orderitem_movie] GO /****** Object: ForeignKey [FK_orderitem_orders] Script Date: 04/20/2020 20:59:12 ******/ ALTER TABLE [dbo].[orderitem] WITH CHECK ADD CONSTRAINT [FK_orderitem_orders] FOREIGN KEY([orderid]) REFERENCES [dbo].[orders] ([orderid]) GO ALTER TABLE [dbo].[orderitem] CHECK CONSTRAINT [FK_orderitem_orders] GO /****** Object: ForeignKey [FK_orders_user] Script Date: 04/20/2020 20:59:12 ******/ ALTER TABLE [dbo].[orders] WITH CHECK ADD CONSTRAINT [FK_orders_user] FOREIGN KEY([userid]) REFERENCES [dbo].[userinfo] ([userid]) GO ALTER TABLE [dbo].[orders] CHECK CONSTRAINT [FK_orders_user] GO 5 代碼實現(xiàn) 搭建系統(tǒng)框架 本系統(tǒng)采用了 spring、 hibernate、 struts 的 3 重結(jié)構(gòu)設(shè)計，此設(shè)計有條理方便系統(tǒng)的具體管理。 文件配置結(jié)構(gòu)如下： 圖 10 文件結(jié)構(gòu)圖 10 web 配置 代碼如下： ?xml version= encoding=UTF8? webapp version= xmlns= xmlns:xsi= xsi:schemaLocation= ! 過濾器 filter filternamestruts2/filtername filterclass/filterclass /filter filtermapping filternamestruts2/filtername urlpattern/*/urlpattern /filtermapping ! 監(jiān)聽器 listener listenerclass /listenerclass /listener listener listenerclass /listenerclass /listener ! 歡迎頁面 welefilelist welefile/welefile /welefilelist /webapp struts 配置 代碼如下： !DOCTYPE struts PUBLIC //Apache Software Foundation//DTD Struts Configuration ! 各頁面的 action 配置 struts include file=/ ! Configuration for the default package. package name=default extends=strutsdefault action name=register class=userAction method=register result name=success//result 11 /action action nam
公司管理相關(guān)推薦
鄂ICP備17016276號-1