spesubaction.java

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

package com.hb.studentmanager.action;

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

import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JTable;

import com.hb.studentmanager.date.SpeDAO;
import com.hb.studentmanager.date.SpeDTO;
import com.hb.studentmanager.date.SpeSubDAO;
import com.hb.studentmanager.date.SpeSubDTO;
import com.hb.studentmanager.date.SubDAO;
import com.hb.studentmanager.date.SubDTO;

public class SpeSubAction {
	SpeSubDAO dao=new SpeSubDAO();
	SpeSubDTO dto=new SpeSubDTO();
	public boolean speSubInsert(String speName,String subName){	
		SpeDAO spdao=new SpeDAO();
		SpeDTO spdto=new SpeDTO();
		spdto.setSpe_id("");
		spdto.setSpe_name(speName);
		List list=spdao.speExactSelect(spdto);
		spdto=(SpeDTO)list.get(0);
		String speId=spdto.getSpe_id();
		SubDAO sudao=new SubDAO();
		SubDTO sudto=new SubDTO();
		sudto.setSub_id("");
		sudto.setSub_name(subName);
		sudto.setSub_score("");
		list=sudao.subExactSelect(sudto);
		sudto=(SubDTO)list.get(0);
		String subId=sudto.getSub_id();
		dto.setSpe_id(speId);
		dto.setSub_id(subId);
		dto.setSub_sco("");
		SpeSubDAO ssdao=new SpeSubDAO();
		list=ssdao.speSubExactSelect(dto);
		if(list.isEmpty()==false)
		{
			JOptionPane.showMessageDialog(new JFrame(),"本专业已存在此科目！");
			return false;
		}
		else{
			dao.speSubInsert(dto);
			return true;
		}
	}
	public boolean speSubUpdate(String speName,String subName,String firstSubName){
		SpeDAO spdao=new SpeDAO();
		SpeDTO spdto=new SpeDTO();
		spdto.setSpe_id("");
		spdto.setSpe_name(speName);
		List list=spdao.speExactSelect(spdto);
		spdto=(SpeDTO)list.get(0);
		String speId=spdto.getSpe_id();
		SubDAO sudao=new SubDAO();
		SubDTO sudto=new SubDTO();
		sudto.setSub_id("");
		sudto.setSub_name(subName);
		sudto.setSub_score("");
		list=sudao.subExactSelect(sudto);
		sudto=(SubDTO)list.get(0);
		String subId=sudto.getSub_id();
		sudto.setSub_id("");
		sudto.setSub_name(firstSubName);
		sudto.setSub_score("");
		list=sudao.subExactSelect(sudto);
		sudto=(SubDTO)list.get(0);
		String firstSubId=sudto.getSub_id();
		dto.setSpe_id(speId);
		dto.setSub_id(subId);
		dto.setSub_sco("");
		SpeSubDAO ssdao=new SpeSubDAO();
		list=ssdao.speSubExactSelect(dto);
		if(list.isEmpty()==false)
		{
			JOptionPane.showMessageDialog(new JFrame(),"本专业已存在此科目！");
			return false;
		}
		else{
			dao.speSubUpdate(dto,firstSubId);
			return true;
		}	
	}
	public void speSubDelete(String speId,String subId){
		dto.setSpe_id(speId);
		dto.setSub_id(subId);
		dao.speSubDelete(dto);	
	}
	public boolean  speSubSelect(JTable table,int page,String speId,String speName,String subId,String subName,String subSco){
		dto.setSpe_id(speId);
		dto.setSpe_name(speName);
		dto.setSub_id(subId);
		dto.setSub_name(subName);
		dto.setSub_sco(subSco);
		List list=dao.speSubBlurrySelect(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=(SpeSubDTO)it.next();
					table.setValueAt(dto.getSpe_id(), i, 0);
					table.setValueAt(dto.getSpe_name(), i,1);
					table.setValueAt(dto.getSub_id(), i, 2);
					table.setValueAt(dto.getSub_name(), i,3);
					table.setValueAt(dto.getSub_sco(), i,4);
					}	
				else{
					table.setValueAt("", i, 0);
					table.setValueAt("", i,1);
					table.setValueAt("", i,2);
					table.setValueAt("", i,3);
					table.setValueAt("", i,4);
					}
				}
			return true;
			}
		}

	public int pageCountSelect(String speId,String speName,String subId,String subName,String subSco){
		int page,rowCount=0;
		dto.setSpe_id(speId);
		dto.setSpe_name(speName);
		dto.setSub_id(subId);
		dto.setSub_name(subName);
		dto.setSub_sco(subSco);
		List list=dao.speSubBlurrySelect(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;
		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){
		List 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=(SpeSubDTO)it.next();
				table.setValueAt(dto.getSpe_id(), i, 0);
				table.setValueAt(dto.getSpe_name(), i,1);
				table.setValueAt(dto.getSub_id(), i, 2);
				table.setValueAt(dto.getSub_name(), i,3);
				table.setValueAt(dto.getSub_sco(), i,4);
			}	
			else{
				table.setValueAt("", i, 0);
				table.setValueAt("", i,1);
				table.setValueAt("", i,2);
				table.setValueAt("", i,3);
				table.setValueAt("", i,4);
				}
			}
		}
	
	public void initSpeComboBox(JComboBox comboBox){
		SpeDAO spedao=new SpeDAO();
		SpeDTO spedto=new SpeDTO();
		List list=spedao.selectAll();
		Iterator it=list.iterator();
		while(it.hasNext()){
			spedto=(SpeDTO)it.next();
			comboBox.addItem(spedto.getSpe_name());
		}	 
	}
	public void initSubComboBox(JComboBox comboBox){
		SubDAO subdao=new SubDAO();
		SubDTO subdto=new SubDTO();
		List list=subdao.selectAll();
		Iterator it=list.iterator();
		while(it.hasNext()){
			subdto=(SubDTO)it.next();
			comboBox.addItem(subdto.getSub_name());
		}	 
	}

}