SMS.rar_学生_成绩

package com.management; import java.util.Iterator; import java.util.List; import java.util.Scanner; import com.admin.Admin; import com.admin.AdminOperation; import com.course.Course; import com.course.CourseOperation; import com.scc.SCC; import com.scc.SCCOperation; import com.score.Score; import com.score.ScoreOperation; //import com.shopping.admin.Admin; import com.student.Student; import com.student.StudentOperation; import com.tcc.TCC; import com.tcc.TCCOperation; import com.teacher.Teacher; import com.teacher.TeacherOperation; /* * AdminManagement类，其实现了管理员的各种操作方法,管理员登陆的时候 * 成员变量admin会根据管理员输入的ID从数据库中取出该ID的数据实现初始化 */ public class AdminManagement { Scanner s=new Scanner(System.in); Admin admin = null; /** * 管理员更新学生信息 */ public void updateStudent() { Scanner s = new Scanner(System.in); StudentOperation so = new StudentOperation(); String sql = "select * from student where student_id = ?;"; boolean flag = false; char input = 0; while (!flag) { System.out.print("请输入学生ID："); int id = s.nextInt(); Student stu = (Student) so.query(sql, id); if (stu != null) { flag = true; studentItem(); input = s.next().charAt(0); switch (input) { case '1': System.out.print("请输入学生姓名："); stu.setStudent_name(s.next()); break; case '2': System.out.print("请输入学生性别："); stu.setStudent_sex(s.next()); break; case '3': System.out.print("请输入学生年龄："); stu.setStudent_age(s.nextInt()); break; default: input = '4'; break; } if (input != '4') { String updatesql = "update student set student_name=?,student_password=?,student_sex=?,student_age=? where student_id =?;"; so.update(updatesql, stu, id); System.out.println("学生信息更新成功！"); } } else { System.out.print("输入的学生ID有误！\n继续请按1，退出请按其他键："); if (s.next().charAt(0) != '1') { flag = true; } } }// while } /** * 打印学生Item */ private void studentItem() { System.out.println("#############################"); System.out.println("# 修改学生姓名 ---1 #"); System.out.println("# 修改学生性别 ---2 #"); System.out.println("# 修改学生年龄 ---3 #"); System.out.println("# 返回请按其他键 #"); System.out.println("#############################"); System.out.print("请选择："); } /** * 查询所有学生的信息 */ public void queryStudent() { StudentOperation so = new StudentOperation(); String sql = "select * from student;"; Student stu = null; List<Object> list = so.query(sql); Iterator<Object> it = list.iterator(); System.out.println("学号" + "\t" + "姓名" + "\t" + "性別" + "\t" + "年龄"); while (it.hasNext()) { stu = (Student) it.next(); System.out.println(stu.getStudent_id() + "\t" + stu.getStudent_name() + "\t" + stu.getStudent_sex() + "\t" + stu.getStudent_age()); } } /** * 打印课程Item */ private void courseItem() { System.out.println("#############################"); System.out.println("# 修改课程名字 ---1 #"); System.out.println("# 修改课程学分 ---2 #"); System.out.println("# 修改课程学时 ---3 #"); System.out.println("# 返回请按其他键 #"); System.out.println("#############################"); System.out.print("请选择："); } /** * 更新课程信息 */ public void updateCourse() { Scanner s = new Scanner(System.in); CourseOperation co = new CourseOperation(); String sql = "select * from course where course_id = ?;"; boolean flag = false; char input = 0; while (!flag) { System.out.print("请输入课程ID："); int id = s.nextInt(); Course c = (Course) co.query(sql, id); if (c != null) { flag = true; courseItem(); input = s.next().charAt(0); switch (input) { case '1': System.out.print("请输入课程名称："); c.setCourse_name(s.next()); break; case '2': System.out.print("请输入课程学分："); c.setCourse_credit(s.nextFloat()); break; case '3': System.out.print("请输入课程学时："); c.setCourse_period(s.nextInt()); break; default: input = '4'; break; } if (input != '4') { String updatesql = "update course set course_name=?,course_credit=?,course_period=? where course_id =?;"; co.update(updatesql, c, id); System.out.println("课程信息更新成功！"); } } else { System.out.print("输入的课程ID有误！\n继续请按1，退出请按其他键："); if (s.next().charAt(0) != '1') { flag = true; } } }// while } /** * 管理员查询所有的课程信息 */ public void queryCourse() { CourseOperation co = new CourseOperation(); String sql = "select * from course;"; Course c = null; List<Object> list = co.query(sql); Iterator<Object> it = list.iterator(); System.out.println("ID" + "\t" + "课程" + "\t\t" + "学分" + "\t" + "学时"); while (it.hasNext()) { c = (Course) it.next(); System.out .println(c.getCourse_id() + "\t" + c.getCourse_name() + "\t" + c.getCourse_credit() + "\t" + c.getCourse_period()); } } /** * 打印教师信息Item供管理员选择修改哪一项 */ private void teacherItem() { System.out.println("#############################"); System.out.println("# 修改教师姓名 ---1 #"); System.out.println("# 修改教师性别 ---2 #"); System.out.println("# 修改教师年龄 ---3 #"); System.out.println("# 修改教师职称 ---4 #"); System.out.println("# 返回请按其他键 #"); System.out.println("#############################"); System.out.print("请选择："); } /** * 管理员更新教师信息 */ public void updateTeacher() { Scanner s = new Scanner(System.in); TeacherOperation to = new TeacherOperation(); String sql = "select * from teacher where teacher_id = ?;"; boolean flag = false; char input = 0; while (!flag) { System.out.print("请输入教师ID："); int id = s.nextInt(); Teacher t = (Teacher) to.query(sql, id); if (t != null) { flag = true; teacherItem(); input = s.next().charAt(0); switch (input) { case '1': System.out.print("请输入教师姓名："); // stu.setStudent_name(s.next()); t.setTeacher_name(s.next()); break; case '2': System.out.print("请输入教师性别："); t.setTeacher_sex(s.next()); break; case '3': System.out.print("请输入教师年龄："); t.setTeacher_age(s.nextInt()); break; case '4': System.out.print("请输入教师职称："); t.setTeacher_rank(s.next()); break; default: input = '5'; break; } if (input != '5') { String updatesql = "update teacher set teacher_name=?,teacher_sex=?,teacher_age=?,teacher_rank=?,teacher_password=? where teacher_id =?;"; int num = to.update(updatesql, t, id); if (num == 1) System.out.println("教师信息更新成功！"); } } else { System.out.print("输入的教师ID有误！\n继续请按1，退出请按其他键："); if (s.next().charAt(0) != '1') { flag = true; } } }// while } /** * 管理员查询所有的教师信息 */ public void query