exampanelaction.java

培训时做的学生管理系统.基于J2SE平台开发

package cn.com.action.chivementaction;

import java.awt.HeadlessException;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.print.PrinterException;
import java.util.Vector;

import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import cn.com.dao.chivementdao.ExamDao;
import cn.com.dialog.chivementdialog.ExamHighSelectDialog;
import cn.com.dialog.chivementdialog.ExamUpdateClassChivementDialog;
import cn.com.dialog.chivementdialog.ExamUpdateStuDialog;
import cn.com.panel.chivementpanel.ExamPanel;
import cn.com.studentsystem.excel.ExamExcelFrame;
import cn.com.studentsystem.excel.ExamPutOutExcel;
import cn.com.util.LogWriter;
import cn.com.vo.chivementvo.ChivementVo;

public class ExamPanelAction implements ActionListener {

	private ChivementVo examVo;

	private ExamPanel chivementPanel;

	private String[] column = { "学号", "组号", "学生姓名", "课程编号", "课程名称", "课程成绩" };

	private LogWriter logWriter;

	public ExamPanelAction(ExamPanel chivementPanel, LogWriter logWriter) {
		super();
		this.chivementPanel = chivementPanel;
		this.logWriter = logWriter;
	}

	public void actionPerformed(ActionEvent e) {

		String str = e.getActionCommand();
		ExamDao examdao = null;
		if (str.equals("查询")) {
			String str1 = chivementPanel.getSelect();
			if (str1.equals("查询全部学生成绩")) {
				logWriter.Log("查询了全部学生的成绩");
				examdao = new ExamDao(examVo);
				Object[][] s2 = examdao.selectAll();
				chivementPanel.creatJTable().setModel(
						new DefaultTableModel(s2, column));
				if(s2.length==0){
					javax.swing.JOptionPane
					.showMessageDialog(null, "没有搜索到结果！");
				}
			} else if (str1.equals("根据学号查询学生考试成绩")) {
				examVo = new ChivementVo();
				if (chivementPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
					try {
						examVo.setS_id(Integer.parseInt(chivementPanel
								.getInput()));
						examdao = new ExamDao(examVo);
						Object[][] s2 = examdao.selectBySid();
						chivementPanel.creatJTable().setModel(
								new DefaultTableModel(s2, column));
						if(s2.length==0){
							javax.swing.JOptionPane
							.showMessageDialog(null, "没有搜索到结果！");
						}
					} catch (NumberFormatException ex) {
						javax.swing.JOptionPane.showMessageDialog(null,
								"请输入正确的字符格式！");
					}
				}
			} else if (str1.equals("根据组号查询学生考试成绩")) {
				if (chivementPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
					try {
						examVo = new ChivementVo();
						examVo.setG_id(Integer.parseInt(chivementPanel
								.getInput()));
						examdao = new ExamDao(examVo);
						Object[][] s2 = examdao.selectByGid();
						chivementPanel.creatJTable().setModel(
								new DefaultTableModel(s2, column));
						if(s2.length==0){
							javax.swing.JOptionPane
							.showMessageDialog(null, "没有搜索到结果！");
						}
					} catch (NumberFormatException ex) {
						javax.swing.JOptionPane.showMessageDialog(null,
								"请输入正确的字符格式！");
					}
				}
			} else if (str1.equals("根据课程编号查询学生成绩")) {
				if (chivementPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
					try {
						examVo = new ChivementVo();
						examVo.setC_id(Integer.parseInt(chivementPanel
								.getInput()));
						examdao = new ExamDao(examVo);
						Object[][] s2 = examdao.selectByCid();
						chivementPanel.creatJTable().setModel(
								new DefaultTableModel(s2, column));
						if(s2.length==0){
							javax.swing.JOptionPane
							.showMessageDialog(null, "没有搜索到结果！");
						}
					} catch (NumberFormatException ex) {
						javax.swing.JOptionPane.showMessageDialog(null,
								"请输入正确的字符格式！");
					}
				}
			} else if (str1.equals("根据姓名查询学生考试成绩")) {
				if (chivementPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
					examVo = new ChivementVo();
					examVo.setS_name(chivementPanel.getInput());
					examdao = new ExamDao(examVo);
					Object[][] s2 = examdao.selectByName();
					chivementPanel.creatJTable().setModel(
							new DefaultTableModel(s2, column));
					if(s2.length==0){
						javax.swing.JOptionPane
						.showMessageDialog(null, "没有搜索到结果！");
					}
				}
			} else if (str1.equals("根据课程名称查询学生成绩")) {
				if (chivementPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
					examVo = new ChivementVo();
					examVo.setClass_name(chivementPanel.getInput());
					examdao = new ExamDao(examVo);
					Object[][] s2 = examdao.selectByClassName();
					chivementPanel.creatJTable().setModel(
							new DefaultTableModel(s2, column));
					if(s2.length==0){
						javax.swing.JOptionPane
						.showMessageDialog(null, "没有搜索到结果！");
					}
				}
			}

		} else if (str.equals("高级查询")) {
			ExamHighSelectDialog dialog = new ExamHighSelectDialog(
					chivementPanel);
			dialog.CreatHighSelectDialog().setVisible(true);
		} else if (str.equals("刷新")) {
			examdao = new ExamDao(examVo);
			Object[][] s2 = examdao.selectAll();
			chivementPanel.creatJTable().setModel(
					new DefaultTableModel(s2, column));
		} else if (str.equals("修改选中学生成绩")) {
			if (chivementPanel.creatJTable().getSelectedRow() >= 0) {
				examVo = new ChivementVo();
				int i = chivementPanel.getChevementJtable().getSelectedRow();

				int stuid = Integer.parseInt(chivementPanel
						.getChevementJtable().getValueAt(i, 0).toString());

				String stuname = chivementPanel.getChevementJtable()
						.getValueAt(i, 2).toString();

				int classid = Integer.parseInt(chivementPanel
						.getChevementJtable().getValueAt(i, 3).toString());

				String className = chivementPanel.getChevementJtable()
						.getValueAt(i, 4).toString();

				int exam = Integer.parseInt(chivementPanel.getChevementJtable()
						.getValueAt(i, 5).toString());

				examVo.setS_id(stuid);
				examVo.setS_name(stuname);
				examVo.setC_id(classid);
				examVo.setClass_name(className);
				examVo.setClassExamChivement(exam);
				// examdao = new ExamDao(examVo);
				ExamUpdateStuDialog dialog = new ExamUpdateStuDialog(examVo);
				dialog.creatUpdateStuDialog().setVisible(true);
				// Vector vo = examdao.getSelectClass();
			} else {
				javax.swing.JOptionPane.showMessageDialog(null, "请先选择");
			}

		} else if (str.equals("修改科目成绩")) {
			ExamUpdateClassChivementDialog dialog = new ExamUpdateClassChivementDialog();
			dialog.creatUpdateClassDialog().setVisible(true);

		} else if (str.equals("打印")) {
			if (chivementPanel.getChevementJtable() != null) {
				try {
					chivementPanel.creatJTable().print(null, null, null, true,
							null, false);
				} catch (HeadlessException e1) {
					e1.printStackTrace();
				} catch (PrinterException e1) {
					e1.printStackTrace();
				}
			} else {
				javax.swing.JOptionPane.showMessageDialog(null, "请先得到表格");
			}
		}else if(str.equals("导出")){
			ExamExcelFrame excel_frame = new ExamExcelFrame();
//			String filename = "f:\\exam.xls";
//			int row_count = ExamPanel.chevementJtable.getRowCount();
//			Vector vector = new Vector();
//			for(int i=0;i<row_count;i++){
//				vector.add(ExamPanel.chevementJtable.getValueAt(i, 0));
//				vector.add(ExamPanel.chevementJtable.getValueAt(i, 1));
//				vector.add(ExamPanel.chevementJtable.getValueAt(i, 2));
//				vector.add(ExamPanel.chevementJtable.getValueAt(i, 3));
//				vector.add(ExamPanel.chevementJtable.getValueAt(i, 4));
//				vector.add(ExamPanel.chevementJtable.getValueAt(i, 5));
//			}
//			WritableWorkbook workbook = ExamPutOutExcel.buildWorkBook(filename);
//			WritableSheet sheet = ExamPutOutExcel.setExcel(workbook, row_count,vector);
//			JOptionPane.showMessageDialog(null, "消息表已导出,存放在"+filename);
		}
	}

}