【正文】 偉，張瑞萍 .SQL Server 2020[M].北京：清華大學(xué)出版社， 2020： 358～370. [10]瞿中，吳渝，劉群，劉冰 .軟件工程 [M].北京：機(jī)械工業(yè)出版社， 2020： 11～ 20. [11]盧曉慶 .基于 Web 的交通旅游訂票系統(tǒng)的設(shè)計與實現(xiàn) [D].大連：大連理工大學(xué)， 2020. [12]趙曉霞 .基于 Java 的航空訂票系統(tǒng) [J].微計算機(jī)信息， 2020（ 18）： 7678. [13]Hess Ronald L， Rubin Ronald S， West Jr， Lawrence information systems as a marketing information system technology[J].Decision Support System， 2020， 38（ 2）：197212. 19 Cinema booking system based on J2EE Abstract:With the Inter thriving, many emerce matures, many of profit or nonprofit business, and even government agencies are also actively marketing the use of works or example, Taobao Mall, achieved in the online shop to sell goods and a series of services。reservation system 。studios。此外 ，本系的許多的同學(xué)也給予了我很多幫助 。 最重要的是，我認(rèn)識到了實踐的重要性，要把書本上的知識變成自己的必須通過自己的親身實踐。 本文基于 J2EE 所開發(fā)的電影訂票系統(tǒng)結(jié)構(gòu) 簡單 操作方便，由于現(xiàn)在的影院都已經(jīng)有了非常完善的售票系統(tǒng)，因此，此次所開發(fā)的電影訂票系統(tǒng)只需要向用戶提供影院方認(rèn)可的相關(guān)證明即可在影院前臺 ，利用影院已有的訂票系統(tǒng)選取座位，并領(lǐng) 到已定場次的 影票即可在影院欣賞電影。 Map request=(Map)().get(request)。) { Orderitem orderitem = (Orderitem)()。 (new Date())。 User user = (User)(user)。 (movieid, quantity)。 } else { return ERROR。 判斷是否登錄成功的 java 相 關(guān)代碼 片段 ： 16 //與數(shù)據(jù)庫中的數(shù)據(jù)對比，判斷是否有改數(shù)據(jù) public String execute() throws Exception{ User u = ((), ())。 數(shù)據(jù)流分析 圖 4 用戶總體數(shù)據(jù)流圖 5 4 資料庫設(shè)計 數(shù)據(jù)庫概念模型設(shè)計 根據(jù)系統(tǒng)需求分析，可以得出電影訂票系統(tǒng)系統(tǒng)的概念模型，如下 ER 圖所示： 圖 5 用戶信息 ER 圖 圖 6 影片信息 ER 圖 圖 7 訂單 ER 圖和訂單項 ER 圖 6 圖 8 實體間 ER 圖 資料結(jié)構(gòu) 數(shù)據(jù)庫關(guān)系圖 圖 9 數(shù)據(jù)庫詳細(xì)設(shè)計圖 7 數(shù)據(jù)庫編輯腳本 USE [movieDB] GO /****** Object: User [MVadmin] Script Date: 04/20/2020 20:59:12 ******/ CREATE USER [MVadmin] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo] GO /****** Object: Table [dbo].[movie] 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].[movie]( [movieid] [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 CHEC