ordinarypanelaction.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 cn.com.dao.chivementdao.OrdinaryDao;
import cn.com.dialog.chivementdialog.OrdinaryHighSelectDialog;
import cn.com.dialog.chivementdialog.OrdinaryUpdateClassChivementDialog;
import cn.com.dialog.chivementdialog.OrdinaryUpdateStuDialog;
import cn.com.panel.chivementpanel.OrdinaryPanel;
import cn.com.studentsystem.excel.OrdinaryExcelFrame;
import cn.com.util.LogWriter;
import cn.com.vo.chivementvo.ChivementVo;

public class OrdinaryPanelAction implements ActionListener {

	private ChivementVo examVo;

	private OrdinaryPanel ordinaryPanel;

	private String[] column = { "学号", "组号", "学生姓名", "平时成绩" };

	private LogWriter logWriter;

	public OrdinaryPanelAction(OrdinaryPanel chivementPanel, LogWriter logWriter) {
		super();
		this.ordinaryPanel = chivementPanel;
		this.logWriter = logWriter;
	}

	public void actionPerformed(ActionEvent e) {

		String str = e.getActionCommand();
		OrdinaryDao ordinarydao = null;
		if (str.equals("查询")) {
			String str1 = ordinaryPanel.getSelect();
			if (str1.equals("查询全部学生成绩")) {
				logWriter.Log("查询了全部学生的成绩");
				ordinarydao = new OrdinaryDao();
				Object[][] s2 = ordinarydao.selectAll();
				ordinaryPanel.creatJTable().setModel(
						new DefaultTableModel(s2, column));
			} else if (str1.equals("根据学号查询学生平时成绩")) {
				if (ordinaryPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
					try {
						examVo = new ChivementVo();
						examVo.setS_id(Integer.parseInt(ordinaryPanel
								.getInput()));
						ordinarydao = new OrdinaryDao(examVo);
						Object[][] s2 = ordinarydao.selectBySid();
						ordinaryPanel.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 (ordinaryPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
					try {

						examVo = new ChivementVo();
						examVo.setG_id(Integer.parseInt(ordinaryPanel
								.getInput()));
						ordinarydao = new OrdinaryDao(examVo);
						Object[][] s2 = ordinarydao.selectByGid();
						ordinaryPanel.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 (ordinaryPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
				examVo = new ChivementVo();
				examVo.setS_name(ordinaryPanel.getInput());
				ordinarydao = new OrdinaryDao(examVo);
				Object[][] s2 = ordinarydao.selectByName();
				ordinaryPanel.creatJTable().setModel(
						new DefaultTableModel(s2, column));
				if (s2.length == 0) {
					javax.swing.JOptionPane.showMessageDialog(null,
							"没有搜索到结果！");
				}
			}
			}
		} else if (str.equals("高级查询")) {
			OrdinaryHighSelectDialog dialog = new OrdinaryHighSelectDialog(
					ordinaryPanel);
			dialog.CreatHighSelectDialog().setVisible(true);
		} else if (str.equals("刷新")) {
			ordinarydao = new OrdinaryDao(examVo);
			Object[][] s2 = ordinarydao.selectAll();
			ordinaryPanel.creatJTable().setModel(
					new DefaultTableModel(s2, column));
		} else if (str.equals("修改选中学生成绩")) {
			if (ordinaryPanel.creatJTable().getSelectedRow() >= 0) {
				examVo = new ChivementVo();
				int i = ordinaryPanel.getChevementJtable().getSelectedRow();

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

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

				int ordinary = Integer.parseInt(ordinaryPanel
						.getChevementJtable().getValueAt(i, 3).toString());

				examVo.setS_id(stuid);
				examVo.setS_name(stuname);
				examVo.setClassExamChivement(ordinary);
				OrdinaryUpdateStuDialog dialog = new OrdinaryUpdateStuDialog(
						examVo);
				dialog.creatUpdateStuDialog().setVisible(true);
			} else {
				javax.swing.JOptionPane.showMessageDialog(null, "请先选择");
			}

		} else if (str.equals("修改平时成绩")) {
			examVo = new ChivementVo();
			ordinarydao = new OrdinaryDao(examVo);
			ordinarydao.SelectClassStuName();
			int[] sNum = examVo.getSid();
			String[] sName = examVo.getSname();
			int[] classExam = examVo.getClassExam();
			OrdinaryUpdateClassChivementDialog dialog1 = new OrdinaryUpdateClassChivementDialog(
					sNum, sName, classExam);
			dialog1.creatUpdateClass1Dialog().setVisible(true);

		} else if (str.equals("打印")) {
			if (ordinaryPanel.getChevementJtable() != null) {
				try {
					ordinaryPanel.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("导出")){
			OrdinaryExcelFrame excel_frame = new OrdinaryExcelFrame();
//			String filename = "f:\\ordinary.xls";
//			int row_count = OrdinaryPanel.chevementJtable.getRowCount();
//			Vector vector = new Vector();
//			for(int i=0;i<row_count;i++){
//				vector.add(OrdinaryPanel.chevementJtable.getValueAt(i, 0));
//				vector.add(OrdinaryPanel.chevementJtable.getValueAt(i, 1));
//				vector.add(OrdinaryPanel.chevementJtable.getValueAt(i, 2));
//				vector.add(OrdinaryPanel.chevementJtable.getValueAt(i, 3));
//				
//			}
//			WritableWorkbook workbook = OrdinaryPutOutExcel.buildWorkBook(filename);
//			WritableSheet sheet = OrdinaryPutOutExcel.setExcel(workbook, row_count,vector);
//			JOptionPane.showMessageDialog(null, "消息表已导出,存放在"+filename);
//			
		}
	}

}