学生管理系统-commons-dbutils-1.6.zip

import java.util.List; import java.util.Scanner; public class MainApp { private static UserDao userDao = new UserDao(); private static Scanner scanner = new Scanner(System.in); public static void main(String[] args) { while (true) { printMenu(); String choice = scanner.nextLine(); switch (choice) { case "1": addUser(); break; case "2": updateUser(); break; case "3": deleteUser(); break; case "4": listUsers(); break; case "5": getUserById(); break; case "6": deleteAllUsers(); break; case "0": System.out.println("退出系统，欢迎下次使用！"); return; default: System.out.println("无效选择，请重新输入！"); } } } private static void printMenu() { System.out.println("\n===== 学生管理系统 ====="); System.out.println("1. 添加学生"); System.out.println("2. 修改学生"); System.out.println("3. 删除学生"); System.out.println("4. 查看所有学生"); System.out.println("5. 按ID查询学生"); System.out.println("6. 删除全部学生"); System.out.println("0. 退出"); System.out.print("请选择功能："); } // 添加学生 private static void addUser() { System.out.print("请输入学生姓名："); String name = scanner.nextLine(); System.out.print("请输入学生密码："); String pwd = scanner.nextLine(); User user = new User(0, name, pwd); int result = userDao.insert(user); System.out.println(result > 0 ? "✅ 添加成功" : "❌ 添加失败"); } // 修改学生 private static void updateUser() { System.out.print("请输入要修改的学生ID："); int id = Integer.parseInt(scanner.nextLine()); System.out.print("请输入新的姓名："); String name = scanner.nextLine(); System.out.print("请输入新的密码："); String pwd = scanner.nextLine(); User user = new User(id, name, pwd); int result = userDao.update(user); System.out.println(result > 0 ? "✅ 修改成功" : "❌ 修改失败"); } // 删除学生 private static void deleteUser() { System.out.print("请输入要删除的学生ID："); int id = Integer.parseInt(scanner.nextLine()); int result = userDao.delete(id); System.out.println(result > 0 ? "✅ 删除成功" : "❌ 删除失败"); } // 查询所有学生 private static void listUsers() { List<User> users = userDao.getAll(); if (users == null || users.isEmpty()) { System.out.println("没有学生记录！"); } else { System.out.println("\n===== 学生列表 ====="); for (User user : users) { System.out.println(user); } } } // 按ID查询 private static void getUserById() { System.out.print("请输入学生ID："); int id = Integer.parseInt(scanner.nextLine()); User user = userDao.getById(id); if (user != null) { System.out.println("查询结果：" + user); } else { System.out.println("未找到ID为 " + id + " 的学生"); } } // 删除全部学生 private static void deleteAllUsers() { int result = userDao.deleteAll(); System.out.println(result > 0 ? "✅ 已删除全部学生" : "❌ 没有数据或删除失败"); } }