teacherpanelaction.java

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

package cn.com.action.studentmanageraction;

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.JDialog;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import cn.com.dao.studentmanagerdao.TeacherDao;
import cn.com.dialog.studentmanagerdialog.TeacherAdd;
import cn.com.dialog.studentmanagerdialog.TeacherHighSelectDialog;
import cn.com.dialog.studentmanagerdialog.TeacherUpdateDialog;
import cn.com.panel.studentmanagerpanel.TeacherPanel;
import cn.com.studentsystem.excel.TeacherExcelFrame;
import cn.com.studentsystem.excel.TeacherPutOutExcel;
import cn.com.util.LogWriter;
import cn.com.vo.studentmanagervo.TeacherVo;

public class TeacherPanelAction implements ActionListener {

	private TeacherVo teacherVo;

	private TeacherPanel teacherPanel;

	private String[] column = { "教师ID", "教师姓名", "教师性别", "教师年龄", "教师职务", "教师QQ",
			"教师email", "教师电话" };

	private LogWriter logWriter;

	public TeacherPanelAction(TeacherPanel teacherPanel, LogWriter logWriter) {
		super();
		this.teacherPanel = teacherPanel;
		this.logWriter = logWriter;
	}

	public void actionPerformed(ActionEvent e) {

		String str = e.getActionCommand();
		TeacherDao teacherdao = null;
		if (str.equals("查询")) {
			String str1 = teacherPanel.getSelect();
			if (str1.equals("查询全部教师信息")) {
				logWriter.Log("查询了全部教师的成绩");
				teacherdao = new TeacherDao();
				Object[][] s2 = teacherdao.selectAll();
				teacherPanel.creatJTable().setModel(
						new DefaultTableModel(s2, column));
			} else if (str1.equals("根据教师编号查询教师信息")) {
				if (teacherPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
					try {
						teacherVo = new TeacherVo();
						teacherVo.setT_id(Integer.parseInt(teacherPanel
								.getInput()));
						teacherdao = new TeacherDao(teacherVo);
						Object[][] s2 = teacherdao.selectBySid();
						teacherPanel.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 (teacherPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
					teacherVo = new TeacherVo();
					teacherVo.setT_duty(teacherPanel.getInput());
					teacherdao = new TeacherDao(teacherVo);
					Object[][] s2 = teacherdao.selectByDuty();
					teacherPanel.creatJTable().setModel(
							new DefaultTableModel(s2, column));
					if (s2.length == 0) {
						javax.swing.JOptionPane.showMessageDialog(null,
								"没有搜索到结果！");
					}
				}
			} else if (str1.equals("根据姓名查询教师信息")) {
				if (teacherPanel.getInput().equals("")) {
					javax.swing.JOptionPane
							.showMessageDialog(null, "查询条件不能为空！");
				} else {
				}
				teacherVo = new TeacherVo();
				teacherVo.setT_name(teacherPanel.getInput());
				teacherdao = new TeacherDao(teacherVo);
				Object[][] s2 = teacherdao.selectByName();
				teacherPanel.creatJTable().setModel(
						new DefaultTableModel(s2, column));
				if (s2.length == 0) {
					javax.swing.JOptionPane.showMessageDialog(null, "没有搜索到结果！");
				}
			}
		} else if (str.equals("高级查询")) {
			TeacherHighSelectDialog dialog = new TeacherHighSelectDialog(
					teacherPanel);
			dialog.CreatHighSelectDialog().setVisible(true);
		} else if (str.equals("删除信息")) {
			if (teacherPanel.creatJTable().getSelectedRow() >= 0) {
				teacherVo = new TeacherVo();
				int i = teacherPanel.getChevementJtable().getSelectedRow();
				int teacherid = Integer.parseInt(teacherPanel
						.getChevementJtable().getValueAt(i, 0).toString());
				if (teacherid != 0) {
					teacherVo.setT_id(teacherid);
					int choice = javax.swing.JOptionPane.showConfirmDialog(
							null, "确定删除？", "删除确认", JOptionPane.YES_NO_OPTION);
					if (choice == JOptionPane.YES_OPTION) {
						teacherdao = new TeacherDao(teacherVo);
						teacherdao.deletestudentinfo();
						javax.swing.JOptionPane
								.showMessageDialog(null, "删除成功！");
						Object[][] s2 = teacherdao.selectAll();
						teacherPanel.creatJTable().setModel(
								new DefaultTableModel(s2, column));
					} else {
						javax.swing.JOptionPane
								.showMessageDialog(null, "删除取消！");
					}
				} else {
					javax.swing.JOptionPane.showMessageDialog(null,
							"该老师为缺省老师，不能删除！");
				}
			} else {
				javax.swing.JOptionPane.showMessageDialog(null, "请先选择");
			}
		} else if (str.equals("刷新")) {
			teacherdao = new TeacherDao(teacherVo);
			Object[][] s2 = teacherdao.selectAll();
			teacherPanel.creatJTable().setModel(
					new DefaultTableModel(s2, column));
		} else if (str.equals("增加信息")) {
			TeacherAdd dialog = new TeacherAdd();
			JDialog dialog1 = dialog.init();
			dialog1.setModal(true);
		}

		else if (str.equals("修改信息")) {
			if (teacherPanel.creatJTable().getSelectedRow() >= 0) {
				teacherVo = new TeacherVo();
				int i = teacherPanel.getChevementJtable().getSelectedRow();

				int teacherid = Integer.parseInt(teacherPanel
						.getChevementJtable().getValueAt(i, 0).toString());
				if (teacherid != 0) {
					String teachername = teacherPanel.getChevementJtable()
							.getValueAt(i, 1).toString();

					String sex = teacherPanel.getChevementJtable().getValueAt(
							i, 2).toString();

					int age = Integer.parseInt(teacherPanel
							.getChevementJtable().getValueAt(i, 3).toString());

					String duty = teacherPanel.getChevementJtable().getValueAt(
							i, 4).toString();

					Long tel = Long.parseLong(teacherPanel
							.getChevementJtable().getValueAt(i, 7).toString());
					// /////////////////////////////////////////////
					Long qq = Long.parseLong(teacherPanel.getChevementJtable()
							.getValueAt(i, 5).toString());

					String email = teacherPanel.getChevementJtable()
							.getValueAt(i, 6).toString();
					// /////////////////////////////////////////
					TeacherVo teacherVo = new TeacherVo();
					teacherVo.setT_id(teacherid);
					teacherVo.setT_name(teachername);
					teacherVo.setT_sex(sex);
					teacherVo.setT_age(age);
					teacherVo.setT_duty(duty);
					teacherVo.setT_tel(tel);
					teacherVo.setT_qq(qq);
					teacherVo.setT_email(email);
					TeacherUpdateDialog dialog = new TeacherUpdateDialog(
							teacherVo);
					JDialog dialog1 = dialog.init();
					dialog1.setModal(true);

				} else {
					javax.swing.JOptionPane.showMessageDialog(null,
							"该老师为缺省老师，不能修改！");
				}
			} else {
				javax.swing.JOptionPane.showMessageDialog(null, "请先选择");
			}
		} else if (str.equals("打印")) {
			if (teacherPanel.getChevementJtable() != null) {
				try {
					teacherPanel.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("导出")) {
			TeacherExcelFrame tef = new TeacherExcelFrame();
//			String filename = "f:\\teacher.xls";
//			int row_count = TeacherPanel.stuinfoJtable.getRowCount();
//			Vector vector = new Vector();
//			for (int i = 0; i < row_count; i++) {
//				vector.add(TeacherPanel.stuinfoJtable.getValueAt(i, 0));
//				vector.add(TeacherPanel.stuinfoJtable.getValueAt(i, 1));
//				vector.add(TeacherPanel.stuinfoJtable.getValueAt(i, 2));
//				vector.add(TeacherPanel.stuinfoJtable.getValueAt(i, 3));
//				vector.add(TeacherPanel.stuinfoJtable.getValueAt(i, 4));
//				vector.add(TeacherPanel.stuinfoJtable.getValueAt(i, 5));
//				vector.add(TeacherPanel.stuinfoJtable.getValueAt(i, 6));
//				vector.add(TeacherPanel.stuinfoJtable.getValueAt(i, 7));
//
//			}
//
//			WritableWorkbook workbook = TeacherPutOutExcel
//					.buildWorkBook(filename);
//			WritableSheet sheet = TeacherPutOutExcel.setExcel(workbook,
//					row_count, vector);
//			JOptionPane.showMessageDialog(null, "表已导出,存放在" + filename);

		}
	}
}