speaction.java

包含了学生管理系统的一些基本操作以及相关窗口页面实现。

package com.hb.studentmanager.action;

import java.util.Iterator;
import java.util.List;

import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import com.hb.studentmanager.date.SpeDAO;
import com.hb.studentmanager.date.SpeDTO;

public class SpeAction {
	SpeDAO dao = new SpeDAO();

	SpeDTO dto = new SpeDTO();

	public boolean speInsert(String speId, String speName) {
		dto.setSpe_id(speId);
		dto.setSpe_name(speName);
		SpeDTO spedto = new SpeDTO();
		spedto.setSpe_id(speId);
		spedto.setSpe_name("");
		List list = dao.speExactSelect(spedto);
		if (list.isEmpty() == false) {
			JOptionPane.showMessageDialog(new JFrame(), "此专业代号已存在！");
			return false;
		} else {
			spedto.setSpe_id("");
			spedto.setSpe_name(speName);
			list = dao.speExactSelect(spedto);
			if (list.isEmpty() == false) {
				JOptionPane.showMessageDialog(new JFrame(), "此专业名称已存在！");
				return false;
			} else {
				dao.speInsert(dto);
				return true;
			}
		}
	}

	public boolean speUpdate(String speId, String speName) {
		dto.setSpe_id(speId);
		dto.setSpe_name(speName);
		SpeDTO spedto = new SpeDTO();
		spedto.setSpe_id("");
		spedto.setSpe_name(speName);
		if (dao.speExactSelect(spedto).isEmpty() == false) {
			JOptionPane.showMessageDialog(new JFrame(), "此专业名称已存在！");
			return false;
		} else {
			dao.speUpdate(dto);
			return true;
		}
	}

	/**
	 * 
	 * @param speId
	 */
	public void speDelete(String speId) {
		dao.speDelete(speId);
	}

	public boolean speSelect(JTable table, int page, String speId,
			String speName) {
		dto.setSpe_id(speId);
		dto.setSpe_name(speName);
		List list = dao.speBlurrySelect(dto);
		if (list.isEmpty()) {
			JOptionPane.showMessageDialog(new JFrame(), "找不到和您的查询条件相符的记录。！");
			return false;
		} else {
			Iterator it = list.iterator();
			for (int i = 0; i < (page - 1) * 5; i++) {
				it.next();
			}
			for (int i = 1, j = 0; i < table.getRowCount(); i++) {
				if (it.hasNext()) {
					dto = (SpeDTO) it.next();
					table.setValueAt(dto.getSpe_id(), i, j);
					table.setValueAt(dto.getSpe_name(), i, j + 1);
				} else {
					table.setValueAt("", i, j);
					table.setValueAt("", i, j + 1);
				}
			}
			return true;
		}
	}

	public int pageCountSelect(String speId, String speName) {
		int page, rowCount = 0;
		dto.setSpe_id(speId);
		dto.setSpe_name(speName);
		List list = dao.speBlurrySelect(dto);
		Iterator it = list.iterator();
		while (it.hasNext()) {
			it.next();
			rowCount++;
		}
		if (rowCount % 5 == 0)
			page = rowCount / 5;
		else
			page = rowCount / 5 + 1;
		return page;
	}

	public int pageCount() {
		int page, rowCount = 0;
		List list = dao.init();
		Iterator it = list.iterator();
		while (it.hasNext()) {
			it.next();
			rowCount++;
		}
		if (rowCount % 5 == 0)
			page = rowCount / 5;
		else
			page = rowCount / 5 + 1;
		return page;
	}

	public void init(JTable table, int page, int pageSize) {
		List list = dao.init();
		Iterator it = list.iterator();
		for (int i = 0; i < (page - 1) * 5; i++) {
			it.next();
		}
		for (int i = 1, j = 0; i < table.getRowCount(); i++) {
			if (it.hasNext()) {
				dto = (SpeDTO) it.next();
				table.setValueAt(dto.getSpe_id(), i, j);
				table.setValueAt(dto.getSpe_name(), i, j + 1);
			} else {
				table.setValueAt("", i, j);
				table.setValueAt("", i, j + 1);
			}
		}
	}
}