餐桌预定
创建菜单表
sql
create table menu (
id int primary key auto_increment, #自增主键，作为菜谱编号(唯一)
name varchar(50) not null default '',#菜品名称
type varchar(50) not null default '', #菜品种类
price double not null default 0#价格
)charset=utf8;
insert into menu values(null, '八宝饭', '主食类', 10);
insert into menu values(null, '叉烧包', '主食类', 20);
insert into menu values(null, '宫保鸡丁', '热菜类', 30);
insert into menu values(null, '山药拨鱼', '凉菜类', 14);
insert into menu values(null, '银丝卷', '甜食类', 9);
insert into menu values(null, '水煮鱼', '热菜类', 26);
insert into menu values(null, '甲鱼汤', '汤类', 100);
insert into menu values(null, '鸡蛋汤', '汤类', 16);Menu 类
数据库菜单表的映射（javabean）
java
package domain;
/**
* ClassName: Menu
* Package: domain
* Description:
*
* @author jacksonling
* @version 1.0
* @Date 2025-08-06 18:32
*/
public class Menu {
private Integer id;
private String name;
private String type;
private Double price;
public Menu() {//无参构造器
}
public Menu(Integer id, String name, String type, Double price) {
this.id = id;
this.name = name;
this.type = type;
this.price = price;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public Double getPrice() {
return price;
}
public void setPrice(Double price) {
this.price = price;
}
@Override
public String toString() {
return id + "\t\t\t" + name + "\t\t" + type + "\t\t" + price;
}
}MenuDao
java
package dao;
import domain.Menu;
/**
* ClassName: MenuDao
* Package: domain
* Description:
*
* @author jacksonling
* @version 1.0
* @Date 2025-08-06 18:34
*/
public class MenuDao extends BasicDao<Menu> {
}MenuService
业务层，编写相应的逻辑显示菜单，在界面层调用
java
package service;
import dao.MenuDao;
import domain.Menu;
import java.util.List;
/**
* ClassName: MenuService
* Package: service
* Description:
*
* @author jacksonling
* @version 1.0
* @Date 2025-08-06 18:35
*/
public class MenuService {
//定义MenuDAO 属性
private MenuDao menuDao = new MenuDao();
//返回所有的菜品，在界面层调用
public void listMenu(){
List<Menu> menus = menuDao.queryTable("select * from menu", Menu.class);
System.out.println("\n菜品编号\t\t菜品名\t\t类别\t\t价格");
for (Menu menu : menus) {
System.out.println(menu);
}
System.out.println("==============显示完毕============");
}
}View
java
package view;
import com.sun.org.apache.bcel.internal.generic.NEW;
import domain.Employee;
import service.DiningTableService;
import service.EmployeeService;
import service.MenuService;
import utils.Utility;
/**
* ClassName: logInView
* Package: view
* Description:
*
* @author jacksonling
* @version 1.0
* @Date 2025-08-06 14:09
*/
public class View {
// 循环结束标志
boolean loop = true;
// 接收用户输入
String key = "";
// 创建 EmployeeService 对象
EmployeeService employeeService = new EmployeeService();
// 创建 DiningTableService 对象
DiningTableService diningTableService = new DiningTableService();
// 创建 MenuService 对象
MenuService menuService = new MenuService();
//显示主菜单
public void mainMenu() {
while (loop) {
System.out.println("\n===============满汉楼================");
System.out.println("\t\t 1 登录满汉楼");
System.out.println("\t\t 2 退出满汉楼");
System.out.print("请输入你的选择: ");
key = Utility.readString(1);
switch (key) {
case "1":
System.out.print("输入员工号: ");
String empId = Utility.readString(50);
System.out.print("输入密 码: ");
String pwd = Utility.readString(50);
Employee employee = employeeService.getEmployeeByIdAndPwd(empId, pwd);
if (employee != null) { //说明存在该用户
System.out.println("===============登录成功[" + employee.getName() + "]================\n");
//显示二级菜单, 这里二级菜单是循环操作，所以做成while
while (loop) {
System.out.println("\n===============满汉楼(二级菜单)================");
System.out.println("\t\t 1 显示餐桌状态");
System.out.println("\t\t 2 预定餐桌");
System.out.println("\t\t 3 显示所有菜品");
System.out.println("\t\t 4 点餐服务");
System.out.println("\t\t 5 查看账单");
System.out.println("\t\t 6 结账");
System.out.println("\t\t 9 退出满汉楼");
System.out.print("请输入你的选择: ");
key = Utility.readString(1);
switch (key) {
case "1":
// 显示餐桌状态
diningTableService.listDiningTale();
break;
case "2":
// 预定餐桌
diningTableService.orderDiningTable();
break;
case "3":
// 显示所有菜品
menuService.listMenu();
break;
case "4":
// 点餐服务
System.out.println("点餐服务");
break;
case "5":
// 查看账单
System.out.println("查看账单");
break;
case "6":
// 结账
System.out.println("结账");
break;
case "9":
loop = false;
break;
default:
System.out.println("你的输入有误，请重新输入");
break;
}
}
} else {
System.out.println("=====登录失败（用户名 / 密码错误）=====");
}
break;
case "2":
loop = false;//
break;
default:
System.out.println("你输入有误，请重新输入.");
}
}
System.out.println("退出了满汉楼系统~");
}
}