、目录1. 开发背景 (2)2. 功能描述 (2)3. 业务流程分析 (2)4. 数据流程分析 (4)4.1、数据流程图 (4)4.2、数据字典 (6)5. 概念模型设计 (9)6. 逻辑模型设计和优化 (10)7. 物理设计和实施 (10)8. 应用程序设计（前台） (17)9. 课程设计心得体会 (20)1.开发背景当今社会科技、文化高速发展。
企业为追求高效率，纷纷实现了数字化和专业化。
为了更好的管理饭店里的大小信息。
我们开发了饭店点菜系统，为饭店的人员管理，订桌管理和点菜管理提供科学、简便、效率的服务。
2. 功能描述经过调研及分析，饭店点菜系统主要完成以下功能：1. 服务员信息的管理：查询、增、删、改2. 菜单信息的管理：查询、增、删、改3. 厨师信息的管理：查询、增、删、改4. 房间信息的管理：查询、增、删、改5. 餐桌信息的管理：查询、增、删、改6. 前台定桌：顾客可以根据自己的需求，选择不同型号的房间或大厅7. 房间/大厅点菜：服务员按照用户需求为其点菜并提交菜单给厨房8. 厨师和菜的分组：厨师和菜分别分组，每组厨师和一组菜一一对应，该组每位厨师会做该组所有的菜。
（本条目位置）9. 厨师做菜管理：厨师可以获得自己的待做菜单，并对已做的菜进行标记10. 上菜管理：服务员对已上菜和待上菜进行管理11. 结帐服务：审核菜单，协助顾客结帐4.1、数据流程图1、顶层2、第二层1．0）查询订桌3.0）点菜4.0）做菜6.0）结账4.2、数据字典（根据编号对数据流程图中的各元素如数据流、数据存储、外部实体和处理逻辑进行细节描述）（1）数据流的描述（2）处理逻辑的描述（3）数据存储的描述（4）外部实体的描述1、数据项5. 概念模型设计根据系统数据流图和数据字典，得出系统的总体概念模型（E-R）如下：6. 逻辑模型设计和优化(1)数据库中存储结构（下划线为主键）表名：服务员信息表表名：厨师信息表表名：菜谱信息表（菜号：菜系号+类型+编号）表名：房间信息表（房号：01+层数+编号）表名：餐桌信息表(餐桌号:02+00+编号)表名：客人信息表表名：点菜菜单信息表表名：厨师做菜信息表表名：上菜管理信息表表名：上菜管理信息表7. 物理设计和实施（根据第6部分优化后的逻辑模式使用create table命令写出各关系模式的创建语句）create database hotel;create table waiter(ID char(4) primary key,Position varchar(10) not null check(Position in('普通服务员','经理')),Name varchar(10) not null,Sex char(2) not null check (Sex in ('男','女')),)create trigger tri_waiter_ID_lengthon waiterfor insert,updateasbeginif exists(select * from inserted where len(ID)!=4)beginRAISERROR ('ID必须为4位长的字符串.' , 16, 1) WITH NOWAIT ROLLBACK TRANSACTIONendendcreate trigger tri_waiter_IDon waiterfor insert,updateasdeclare @ID char(4)beginselect @ID=ID from insertedif exists(select * from kitchener where ID = @ID)beginRAISERROR ('ID与kitchener表重复！.' , 16, 1) WITH NOWAIT ROLLBACK TRANSACTIONendendcreate table kitchener(ID char(4) primary key ,Position varchar(10) not null check(Position in('普通厨师','厨师长')), Name varchar(10) not null,Sex char(2) not null check (Sex in ('男','女')),FoodStyle_1 varchar(8) not null,FoodStyle_2 varchar(8) not null,FoodStyle_3 varchar(8) not null,FoodStyle_4 varchar(8) not null,FoodStyle_5 varchar(8) not null)create trigger tri_kitchener_ID_lengthon kitchenerfor insert,updateasbeginif exists(select * from inserted where len(ID)!=4)beginRAISERROR ('ID必须为4位长的字符串.' , 16, 1) WITH NOWAIT ROLLBACK TRANSACTIONendendcreate trigger tri_kitchener_IDon kitchenerfor insert,updateasdeclare @ID char(4)beginselect @ID=ID from insertedif exists(select * from waiter where ID = @ID)beginRAISERROR ('ID与waiter表重复！.' , 16, 1) WITH NOW AIT ROLLBACK TRANSACTIONendendcreate table menu(FName varchar(30) not null,--菜名FNum char(7) primary key,--菜号: 菜系号+类型+编号FoodStyle varchar(8)not null,--菜系;Price float not null,--价格FTime tinyint not null--做菜时间)create trigger tri_menu_FNum_lengthon menufor insert,updateasbeginif exists(select * from inserted where len(FNum)!=7)beginRAISERROR ('FNum必须为7位长的数字字符串.' , 16, 1) WITH NOW AIT ROLLBACK TRANSACTIONendendcreate table room(RNum char(5) primary key,--餐桌号:1+层数+编号(10101)RState char(4) not null check (RState in ('空闲','有客','禁用')),--状态(0;空闲；1：正在做；2：下班Rc tinyint not null,--桌子数RSpace tinyint not null,--可容纳人数RCharge float not null--费用)create table tables(TNum char(5) primary key,--餐桌号:2+层数+编号(20101)TState char(4) not null check (TState in ('空闲','有客','禁用')),--状态(空闲,有客，禁用）TSpace tinyint not null,--可容纳人数TCharge float not null--费用)select * from waiterselect * from kitchenerinsert into waiter values('0001','普通服务员','李四','男')insert into waiter values('0002','普通服务员','张三','男')insert into waiter values('0003','经理','王五','女')insert into kitchener values('0005','普通厨师','胡八','男','川菜','null','null','null','null')insert into kitchener values('0004','普通厨师','李泉','男','川菜','粤菜','鲁菜','null','null')insert into kitchener values('0006','厨师长','吴青','男','川菜','粤菜','鲁菜','东北菜','江浙菜')insert into menu values('酸辣土豆丝','0101551','川菜','18','10')insert into menu values('醋溜土豆丝','0301552','鲁菜','18','10')insert into menu values('双鱼茄子','0201553','粤菜','30','23')insert into room values('10101','空闲','1','8','20')insert into room values('10102','空闲','1','8','20')insert into room values('10104','空闲','1','8','20')insert into room values('10105','空闲','1','8','20')insert into room values('10106','空闲','1','8','20')insert into room values('10107','空闲','1','8','20')insert into room values('10108','空闲','1','8','20')insert into room values('10109','空闲','1','8','20')insert into room values('10110','空闲','1','8','20')insert into room values('10111','空闲','1','8','20')insert into room values('10112','空闲','1','8','20')insert into room values('10113','空闲','1','8','20')insert into room values('10114','空闲','1','8','20')insert into room values('10115','空闲','1','8','20')insert into room values('10116','空闲','1','8','20')insert into room values('10117','空闲','1','8','20')insert into room values('10118','空闲','1','8','20')insert into room values('10119','空闲','1','8','20')insert into room values('10120','空闲','1','8','20')insert into room values('10121','空闲','1','8','20')insert into room values('10122','空闲','1','8','20')insert into room values('10123','空闲','1','8','20')insert into room values('10124','空闲','1','8','20')/*declare @i int --变义变量@iset @i = 1 --初始化@i为1while @i < 30 --如果@i小于100,这里改成100万即是插入100万条记录begin ------------------insert into reg (name,content,email,http) values('Jack','this is my......','sun@','')set @i = @i + 1end ----------------------批量插入*/insert into tables values('20101','空闲','8','10')insert into tables values('20102','空闲','8','10')insert into tables values('20103','空闲','8','10')insert into tables values('20104','空闲','8','10')insert into tables values('20105','空闲','8','10')insert into tables values('20106','空闲','8','10')insert into tables values('20107','空闲','8','10')insert into tables values('20109','空闲','8','10')insert into tables values('20110','空闲','8','10')insert into tables values('20111','空闲','8','10')insert into tables values('20112','空闲','8','10')insert into tables values('20113','空闲','8','10')update roomset rc=2 ,rspace=16where rnum in ('10118','10120','10123')update tablesset tspace=16where tnum in ('20107')8. 应用程序设计（前台）（前台应用程序设计,所使用的编程语言、开发环境，增、删、改、查等主要功能的实现）package com.jluzh.orderSystem;import java.awt.*;import java.awt.event.*;import ng.String;import javax.swing.*;public class AccountsFrame extends JFrame{JTextArea accountsText;JButton yesButton,noButton;OrderFrame orderFrame;public AccountsFrame(final OrderFrame orderFrame){this.orderFrame=orderFrame;this.setSize(340,450);this.setTitle("账单查询");this.setResizable(false);this.setLayout(null);accountsText=new JTextArea();JScrollPane sp=new JScrollPane(accountsText);sp.setBounds(20, 20, 300, 300);this.add(sp);yesButton=new JButton("结账");yesButton.setBounds(50, 350, 80, 30);this.add(yesButton);noButton=new JButton("返回");noButton.setBounds(200, 350, 80, 30);this.add(noButton);yesButton.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){if(JOptionPane.showConfirmDialog(null, "你确定要结账么？")==0){ dispose();accountsText.setText("");orderFrame.stateBox.setEnabled(true);orderFrame.foodText.setEnabled(false);orderFrame.addButton.setEnabled(false);orderFrame.accountsButton.setEnabled(false);orderFrame.clearButton.setEnabled(false);orderFrame.deleteButton.setEnabled(false);orderFrame.stateBox.setSelectedIndex(0);orderFrame.epanel.setBackground(Color.gray);orderFrame.epanel.setState("空置");orderFrame.epanel.stateLabel.setText("空置");orderFrame.foodText.setText("");orderFrame.tableOrder.clearAll();}}});noButton.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){dispose();accountsText.setText("");}});}public void run(MyTable table){int rowCount=table.getModel().getRowCount();double sumAll=0;double sumReal=0;accountsText.append("已经上的菜："+"\n\n");for(int i=0;i<rowCount;i++){if(((String)table.getModel().getValueAt(i, 3)).equals("已上")){accountsText.append((String)table.getModel().getValueAt(i, 0)+" ");accountsText.append((String)table.getModel().getValueAt(i, 1)+" ");accountsText.append((String)table.getModel().getValueAt(i, 2)+" ");accountsText.append("\n");sumAll=sumAll+Double.parseDouble((String)table.getModel().getValueAt(i, 2));sumReal=sumReal+Double.parseDouble((String)table.getModel().getValueAt(i, 2));}}accountsText.append("——————————————\n");accountsText.append("未上的菜："+"\n\n");for(int i=0;i<rowCount;i++){if(!((String)table.getModel().getValueAt(i, 3)).equals("已上")){accountsText.append((String)table.getModel().getValueAt(i, 0)+" ");accountsText.append((String)table.getModel().getValueAt(i, 1)+" ");accountsText.append((String)table.getModel().getValueAt(i, 2)+" ");accountsText.append("\n");}}accountsText.append("——————————————\n");accountsText.append("正在做的菜："+"\n\n");for(int i=0;i<rowCount;i++){if(!((String)table.getModel().getValueAt(i, 3)).equals("正做")){accountsText.append((String)table.getModel().getValueAt(i, 0)+" ");accountsText.append((String)table.getModel().getValueAt(i, 1)+" ");accountsText.append((String)table.getModel().getValueAt(i, 2)+" ");accountsText.append("\n");sumAll=sumAll+Double.parseDouble((String)table.getModel().getValueAt(i, 2));}}accountsText.append("——————————————\n");accountsText.append("服务费："+orderFrame.chargeText.getText()+"\n");accountsText.append("杂项费："+"\n");sumAll=sumAll+Double.parseDouble(orderFrame.chargeText.getText());sumReal=sumReal+Double.parseDouble(orderFrame.chargeText.getText());accountsText.append("——————————————\n");accountsText.append("应付费用："+sumAll+"\n");accountsText.append("实付费用："+sumReal+"\n");this.show();}}9. 课程设计心得体会在调试的过程当中，学会了很多自己不知道的知识，比如说，学会了用栈进行表达式求值，和学会了许多新函数的使用，在学习这些知识的过程当中，也遇到了相当多的问题，很多函数都不知道，也总会出现不必要的操作。
