exammanage.java

accp s1毕业项目 考试管理系统

		for (int i = 0; i < tblStudent.getColumnCount(); i++) {
			tblStudent.getColumn(stuCol[i]).setCellRenderer(dtcrStudent);
		}

		lblPage = new JLabel("第 " + currentPage + " / " + totalPage + " 页");
		btnFirstPage = new JButton("第一页");
		btnPreviousPage = new JButton("上一页");
		btnNextPage = new JButton("下一页");
		btnLastPage = new JButton("最末页");

		lblPage.setBounds(50, 300, 80, 25);
		btnFirstPage.setBounds(150, 300, 60, 25);
		btnFirstPage.setMargin(new Insets(0, 0, 0, 0));
		btnPreviousPage.setBounds(230, 300, 60, 25);
		btnPreviousPage.setMargin(new Insets(0, 0, 0, 0));
		btnNextPage.setBounds(310, 300, 60, 25);
		btnNextPage.setMargin(new Insets(0, 0, 0, 0));
		btnLastPage.setBounds(390, 300, 60, 25);
		btnLastPage.setMargin(new Insets(0, 0, 0, 0));
		pnlRightBottom.add(lblPage);
		pnlRightBottom.add(btnFirstPage);
		pnlRightBottom.add(btnPreviousPage);
		pnlRightBottom.add(btnNextPage);
		pnlRightBottom.add(btnLastPage);

		final JPopupMenu pop = new JPopupMenu();
		JMenuItem mnuMore = new JMenuItem("成绩详细信息");
		pop.add(mnuMore);

		mnuAddTeacher.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AddTeacher();
			}
		});
		mnuAddCourse.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AddCourse();
			}
		});
		mnuAddBanJi.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AddBanJiSchedule();
			}
		});
		mnuAddStudent.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AddStudent();
			}
		});
		mnuAddQuestion.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AddQuestion(teaID);
			}
		});
		mnuExit.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				System.exit(0);
			}
		});
		mnuBomb.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new Bomb();
			}
		});
		mnuAbout.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AboutUs();
			}
		});
		btnAddTeacher.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AddTeacher();
			}
		});
		btnAddCourse.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AddCourse();
			}
		});
		btnAddBanJi.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AddBanJiSchedule();
			}
		});
		btnAddStudent.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AddStudent();
			}
		});
		btnAddQuestion.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new AddQuestion(teaID);
			}
		});
		this.addWindowListener(new WindowListener() {
			public void windowActivated(WindowEvent arg0) {
			}

			public void windowClosed(WindowEvent arg0) {
			}

			public void windowClosing(WindowEvent arg0) {
				int result = JOptionPane.showConfirmDialog(null, "是否退出！", "确定",
						JOptionPane.YES_NO_OPTION);
				if (result == JOptionPane.YES_OPTION) {
					setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
				} else {
					setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
				}
			}

			public void windowDeactivated(WindowEvent arg0) {
			}

			public void windowDeiconified(WindowEvent arg0) {
			}

			public void windowIconified(WindowEvent arg0) {
			}

			public void windowOpened(WindowEvent arg0) {
			}

		});

		treInfo.addTreeSelectionListener(new TreeSelectionListener() {
			public void valueChanged(TreeSelectionEvent arg0) {
				DefaultMutableTreeNode node = (DefaultMutableTreeNode) treInfo
						.getLastSelectedPathComponent();
				if (node.isLeaf()) {
					if (node.toString().equals("S1")
							|| node.toString().equals("S2")
							|| node.toString().equals("Y2")) {
						JOptionPane.showMessageDialog(null, "该年级还没有班级！");
						return;
					} else {
						showInfo(node.toString());
						showTea(node.toString());
					}
				}
			}
		});

		btnFirstPage.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				currentPage = 1;
				showTblStudent();
			}
		});
		btnPreviousPage.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				currentPage--;
				if (currentPage < 1) {
					currentPage = 1;
				}
				showTblStudent();
			}
		});
		btnNextPage.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				currentPage++;
				if (currentPage == totalPage) {
					currentPage = totalPage;
				}
				showTblStudent();
			}
		});
		btnLastPage.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				currentPage = totalPage;
				showTblStudent();
			}
		});
		mnuUpdateTeacher.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new ChangeTeacher();
			}
		});
		mnuUpdateStudent.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				new ChangeStudents();
			}
		});
		mnuSelectAllTeacher.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				new ShowAllTeacher();
			}
		});
		mnuSelectAllStudent.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				new ShowAllStudent();
			}
		});
		mnuSelectQuestion.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				new SelectQuestion();
			}			
		});
		mnuSelectPaper.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				new SelectPaper();
			}	
		});
		mnuSelectScore.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				new SelectScore();
			}			
		});
		btnSelectPaper.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				new SelectPaper();
			}			
		});
		btnSelectQuestion.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				new SelectQuestion();
			}			
		});
		btnSelectScore.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				new SelectScore();
			}			
		});
		btnSelectStudent.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				new ShowAllStudent();
			}			
		});
		btnSelectTeacher.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				new ShowAllTeacher();
			}			
		});

		tblStudent.addMouseListener(new MouseListener() {
			public void mouseClicked(MouseEvent e) {
				int x = e.getX();
				int y = e.getY();
				if (e.getButton() == MouseEvent.BUTTON3) {
					pop.show(tblStudent, x, y);
				}
				if (e.getButton() == MouseEvent.BUTTON1) {
					if (tblStudent.getValueAt(tblStudent.getSelectedRow(), 0) == null) {
					} else {
						stuID = tblStudent.getValueAt(
								tblStudent.getSelectedRow(), 0).toString();
					}
				}
			}

			public void mouseEntered(MouseEvent e) {
			}

			public void mouseExited(MouseEvent e) {
			}

			public void mousePressed(MouseEvent e) {
			}

			public void mouseReleased(MouseEvent e) {
			}
		});
		mnuMore.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				if (stuID == null) {
					JOptionPane.showMessageDialog(null, "请选择有数据的行!");
				} else {
					new ShowStudentScore(stuID);
				}
			}
		});
	}

	private void showBanJi() {
		BanJiDao banJiDao = new BanJiDao();
		List<BanJi> listS1 = new ArrayList<BanJi>();
		BanJi banJi = new BanJi();
		listS1 = banJiDao.selectBanJiByGrade("S1");
		for (int i = 0; i < listS1.size(); i++) {
			banJi = new BanJi();
			banJi = listS1.get(i);
			DefaultMutableTreeNode S1i = new DefaultMutableTreeNode(banJi
					.getBanJiID());
			S1.add(S1i);
		}
		List<BanJi> listS2 = new ArrayList<BanJi>();
		listS2 = banJiDao.selectBanJiByGrade("S2");
		for (int i = 0; i < listS2.size(); i++) {
			banJi = new BanJi();
			banJi = listS2.get(i);
			DefaultMutableTreeNode S2i = new DefaultMutableTreeNode(banJi
					.getBanJiID());
			S2.add(S2i);
		}
		List<BanJi> listY2 = new ArrayList<BanJi>();
		listY2 = banJiDao.selectBanJiByGrade("Y2");
		for (int i = 0; i < listY2.size(); i++) {
			banJi = new BanJi();
			banJi = listY2.get(i);
			DefaultMutableTreeNode Y2i = new DefaultMutableTreeNode(banJi
					.getBanJiID());
			Y2.add(Y2i);
		}
	}

	private void showInfo(String banJiID) {
		currentPage = 1;
		BanJiDao banJiDao = new BanJiDao();
		BanJi banJi = new BanJi();
		TeacherDao teacherDao = new TeacherDao();
		Teacher teacher = new Teacher();
		StudentDao studentDao = new StudentDao();
		list = new ArrayList<Student>();

		banJi = banJiDao.selectBanJiByID(banJiID);
		teacher = teacherDao.selectTeaNameByTeaID(banJi.getTeaID());
		list = studentDao.selectAllByBanJiID(banJiID);

		txtBanJiID.setText(banJiID);
		txtBanJiDate.setText(banJi.getBanJiDate());
		txtTeaName.setText(teacher.getTeaName());
		txtTotal.setText(list.size() + "");
		showTblStudent();
	}

	private void showTblStudent() {
		if (list.size() % 10 == 0) {
			if (list.size() == 0) {
				totalPage = 1;
			} else {
				totalPage = list.size() / 10;
			}
		} else {
			totalPage = list.size() / 10 + 1;
		}
		lblPage.setText("第 " + currentPage + " / " + totalPage + " 页");
		if (currentPage == 1) {
			btnFirstPage.setEnabled(false);
			btnPreviousPage.setEnabled(false);
		} else {
			btnFirstPage.setEnabled(true);
			btnPreviousPage.setEnabled(true);
		}
		if (totalPage == currentPage) {
			btnNextPage.setEnabled(false);
			btnLastPage.setEnabled(false);
		} else {
			btnNextPage.setEnabled(true);
			btnLastPage.setEnabled(true);
		}
		for (int i = 0; i < 10; i++) {
			for (int j = 0; j < 9; j++) {
				tblStudent.setValueAt("", i, j);
			}
		}
		Student student = new Student();
		int first = (currentPage - 1) * 10;
		for (int i = first; i < list.size(); i++) {
			student = list.get(i);
			tblStudent.setValueAt(student.getStuID(), i % 10, 0);
			tblStudent.setValueAt(student.getStuName(), i % 10, 1);
			tblStudent.setValueAt(student.getStuSex(), i % 10, 2);
			tblStudent.setValueAt(student.getStuAge() + "", i % 10, 3);
			tblStudent.setValueAt(student.getStuCardID(), i % 10, 4);
			tblStudent.setValueAt(student.getStuNation(), i % 10, 5);
			tblStudent.setValueAt(student.getStuPhone(), i % 10, 6);
			tblStudent.setValueAt(student.getStuAddr(), i % 10, 7);
			tblStudent.setValueAt(student.getRemark(), i % 10, 8);
			if ((i % 10) == 9) {
				break;
			}
		}
	}

	private void showTea(String banJiID) {
		clearTea();
		ScheduleDao scheduleDao = new ScheduleDao();
		CourseDao courseDao = new CourseDao();
		TeacherDao teacherDao = new TeacherDao();
		Schedule schedule = new Schedule();
		schedule.setBanJiID(banJiID);
		List<Schedule> list = new ArrayList<Schedule>();
		list = scheduleDao.selectAllByBanJiID(schedule);
		for (int i = 0; i < list.size(); i++) {
			tblSchedule.setValueAt(courseDao.selectCourseNameByID(
					list.get(i).getCouID()).getCouName(), i, 0);
			tblSchedule.setValueAt(teacherDao.selectTeaNameByTeaID(
					list.get(i).getTeaID()).getTeaName(), i, 1);
		}
	}

	private void clearTea() {
		for (int i = 0; i < 10; i++) {
			tblSchedule.setValueAt("", i, 0);
			tblSchedule.setValueAt("", i, 1);
		}
	}
}