基于j2ee的电影院订票系统

基于j2ee的电影院订票系统内容摘要：

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 代码实现 搭建系统框架 本系统采用了 spring、 hibernate、 struts 的 3 重结构设计，此设计有条理方便系统的具体管理。 文件配置结构如下： 图 10 文件结构图 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 ! 监听器 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。