subaction.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.SubDAO;
import com.hb.studentmanager.date.SubDTO;
public class SubAction {
	SubDAO dao=new SubDAO();
	SubDTO dto=new SubDTO();
	public boolean subInsert(String subId,String subName,String subSco){
		dto.setSub_id(subId);
		dto.setSub_name(subName);
		dto.setSub_score(subSco);
		SubDTO subdto=new SubDTO();
		subdto.setSub_id(subId);
		subdto.setSub_name("");
		subdto.setSub_score("");
		if(dao.subExactSelect(subdto).isEmpty()==false){
			JOptionPane.showMessageDialog(new JFrame(),"此科目代号已存在！");
			return false;
		}
		else {
			subdto.setSub_id("");
			subdto.setSub_name(subName);
			subdto.setSub_score("");
			if(dao.subExactSelect(subdto).isEmpty()==false){
				JOptionPane.showMessageDialog(new JFrame(),"此科目名称已存在！");
				return false;
			}
			else{
				dao.subInsert(dto);
				return true;
			}
		}
	}
	public boolean subUpdate(String subId,String subName,String subSco){
		dto.setSub_id(subId);
		dto.setSub_name(subName);
		dto.setSub_score(subSco);
		SubDTO subdto=new SubDTO();
		subdto.setSub_id("");
		subdto.setSub_name(subName);
		subdto.setSub_score("");
		List list=dao.subExactSelect(subdto);
		if(list.isEmpty()==false){
			subdto=(SubDTO)list.get(0);
			if(subdto.getSub_id().equals(subId)&&subdto.getSub_name().equals(subName)){
				dao.subUpdate(dto);
				return true;
			}
			else{
				JOptionPane.showMessageDialog(new JFrame(),"此科目名称已存在！");
			    return false;
			}
		}
		else{
			dao.subUpdate(dto);
			return true;
		}	
	}
	public void subDelete(String subId){
		dao.subDelete(subId);	
	}
	public boolean  subSelect(JTable table,int page,String subId,String subName,String subSco){
		dto.setSub_id(subId);
		dto.setSub_name(subName);
		dto.setSub_score(subSco);
		List list=dao.subBlurrySelect(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;i<table.getRowCount();i++){
				if(it.hasNext()){
					dto=(SubDTO)it.next();
					table.setValueAt(dto.getSub_id(), i, 0);
					table.setValueAt(dto.getSub_name(), i,1);
					table.setValueAt(dto.getSub_score(), i,2);
				}	
				else{
					table.setValueAt("", i, 0);
					table.setValueAt("", i,1);
					table.setValueAt("", i,2);
					}
				}
			return true;
			}
	}
	public int pageCountSelect(String subId,String subName,String subSco){
		int page,rowCount=0;
		dto.setSub_id(subId);
		dto.setSub_name(subName);
		dto.setSub_score(subSco);
		List list=dao.subBlurrySelect(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;i<table.getRowCount();i++){
			if(it.hasNext()){
				dto=(SubDTO)it.next();
				table.setValueAt(dto.getSub_id(), i, 0);
				table.setValueAt(dto.getSub_name(), i,1);
				table.setValueAt(dto.getSub_score(), i,2);
			}	
			else{
				table.setValueAt("", i, 0);
				table.setValueAt("", i,1);
				table.setValueAt("", i,2);
				}
			}
		}

}