显示账单
思路分析
这个功能相对简单，使用 BillDao 完成对账单表的查询，返回一个 List 对象，遍历打印输出结果即可
BillService
java
package service;
import dao.BillDao;
import domain.Bill;
import domain.DiningTable;
import domain.Menu;
import utils.Utility;
import java.util.List;
import java.util.UUID;
/**
* ClassName: BillService
* Package: service
* Description:
*
* @author jacksonling
* @version 1.0
* @Date 2025-08-07 19:56
*/
public class BillService {
private BillDao billDao = new BillDao();
// 调用 MenuService 类中的方法，传入 id，返回菜品对象，用于计算价格
private MenuService menuService = new MenuService();
// 点完餐后需要更新餐桌状态
DiningTableService diningTableService = new DiningTableService();
/**
* 点餐功能
* （1）生成账单
* 参数：订单号、菜品编号、份数、金额、餐桌号、订单日期、订单状态（未结账、已经结账、挂单...）
* 传入参数：菜品编号、份数、餐桌号（）
* （2）更新餐桌状态（数据库）
*/
public boolean orderMenu(int menuId, int nums, int diningTableId) {
// 随机生成一个订单号
String billId = UUID.randomUUID().toString();
// 更新账单表，同时根据传入信息计算余额
int update = billDao.update("insert into bill values(null,?,?,?,?,?,now(),'未结账')",
billId, menuId, nums, menuService.getMenuById(menuId).getPrice() * nums, diningTableId);
if (update <= 0) {
return false;
}
//需要更新对应餐桌的状态
return diningTableService.updateDiningTableState(diningTableId, "就餐中");
}
// 用户层点餐界面
public void orderMenu() {
System.out.println("==============点餐服务============");
System.out.print("请输入点餐的桌号(-1退出): ");
int orderDiningTableId = Utility.readInt();
if (orderDiningTableId == -1) {
System.out.println("==============取消点餐============");
return;
}
System.out.print("请输入点餐的菜品号(-1退出): ");
int orderMenuId = Utility.readInt();
if (orderMenuId == -1) {
System.out.println("==============取消点餐============");
return;
}
System.out.print("请输入点餐的菜品量(-1退出): ");
int orderNums = Utility.readInt();
if (orderNums == -1) {
System.out.println("==============取消点餐============");
return;
}
//验证餐桌号是否存在
DiningTable diningTable = diningTableService.getDiningTableById(orderDiningTableId);
if (diningTable == null) {
System.out.println("==============餐桌号不存在============");
return;
}
//验证菜品编号
Menu menu = menuService.getMenuById(orderMenuId);
if (menu == null) {
System.out.println("==============菜品号不存在============");
return;
}
//点餐
if (orderMenu(orderMenuId, orderNums, orderDiningTableId)) {
System.out.println("==============点餐成功============");
} else {
System.out.println("==============点餐失败============");
}
}
// 显示所有账单
public void listBill() {
List<Bill> bills = billDao.queryTable("select * from bill", Bill.class);
System.out.println("\n编号\t菜品号\t\t菜品量\t\t金额\t\t桌号\t\t日期\t\t\t\t\t\t\t状态");
for (Bill bill : bills) {
System.out.println(bill);
}
System.out.println("==============显示完毕============");
}
}View
java
package view;
import com.sun.org.apache.bcel.internal.generic.NEW;
import domain.Employee;
import service.BillService;
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();
// 创建 BillService 对象
BillService billService = new BillService();
//显示主菜单
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":
// 点餐服务
billService.orderMenu();
break;
case "5":
// 查看账单
billService.listBill();
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("退出了满汉楼系统~");
}
}