studyaction.java

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

package com.hb.studentmanager.action;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;

import javax.swing.DefaultComboBoxModel;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

import com.hb.studentmanager.date.DutyDTO;
import com.hb.studentmanager.date.StudyDAO;
import com.hb.studentmanager.date.StudyDTO;
import com.hb.studentmanager.ui.StudyAddFrame;
import com.hb.studentmanager.ui.StudyUpdateFrame;

public class StudyAction {
	
	StudyDAO dao=new StudyDAO();
	
	StudyDTO dto=new StudyDTO();
	
	/**
	 * 分页显示总页数
	 * @return
	 */
	public int page(String stuid,String name,String xuexi,String xinli,String week,String month,String year){
		int page=1;
		int count=0;
		List list=new ArrayList();
		if(stuid.equals("")&&name.equals("")&&xuexi.equals("")&&xinli.equals("")&&week.equals("")&&month.equals("")&&year.equals("")){
			list=dao.FirstSelect();
		}
		else{
			list=dao.selectView(stuid, name, xuexi, xinli, week, month, year);
		}
	    Iterator it=list.iterator();
	    if(list.isEmpty()){
	    	page=1;
	    }
	    else{
	    while(it.hasNext()){
	    	it.next();
	    	count++;
	    }
	    if(count%5!=0){
	    	page=count/5+1;
	    	
	    }
	    else{
	    	page=count/5;
	    }
	    }
		return page;
	}
	
	/**
	 * 初始化页面
	 * @param dtm
	 * @param page
	 */
	public void FristSelect(String stuid,String name,String xuexi,String xinli,String week,String month,String year,DefaultTableModel dtm,int page){
		List list=new ArrayList();
		if(stuid.equals("")&&name.equals("")&&xuexi.equals("")&&xinli.equals("")&&week.equals("")&&month.equals("")&&year.equals("")){
			list=dao.FirstSelect();
		}
		else{
			list=dao.selectView(stuid, name, xuexi, xinli, week, month, year);
		}
		Iterator it=list.iterator();
		if(list.isEmpty())
		{
			for(int i=1;i<6;i++)
			{
				Vector vt=new Vector();
				vt.add("");
				vt.add("");
				vt.add("");
				vt.add("");
				vt.add("");
				vt.add("");
				vt.add("");
				dtm.addRow(vt);
			}
		}
		else{
		 for(int i=0;i<(page-1)*5;i++){
		    	it.next();
		    }
		Vector vt;
		while(it.hasNext()){
			dto=(StudyDTO)it.next();
			vt=new Vector();
			vt.add(dto.getStu_id());
			vt.add(dto.getStu_name());
			vt.add(dto.getStu_sta());
			vt.add(dto.getStu_men());
			vt.add(dto.getStu_week());
			vt.add(dto.getStu_month());
			vt.add(dto.getStu_year());
			dtm.addRow(vt);
		}
	}
	}
	
	/**
	 * 得到StudyAddFrame中的数据传入到StudyDAO中
	 * @param saf
	 */
	public boolean AddStudy(StudyAddFrame saf){
		dto.setStu_id(saf.stuidjComboBoxModel.getSelectedItem().toString());//得到学号
		if(saf.studyjComboBox.getSelectedItem()==null){
			
		}
		else{
		dto.setStu_sta(saf.studyjComboBox.getSelectedItem().toString());//得到学习情况	
		}
		if(saf.xinlijComboBox.getSelectedItem()==null){
			
		}
		else{
		dto.setStu_men(saf.xinlijComboBox.getSelectedItem().toString());//得到心理情况
		}
		dto.setStu_week(saf.weekjComboBox.getSelectedItem().toString());//得到周时间	
		dto.setStu_month(saf.monthjComboBox.getSelectedItem().toString());//得到月时间
		dto.setStu_year(saf.xueqjComboBox.getSelectedItem().toString());//得到学期
		List list=dao.getStudyPk(dto);
		if(list.isEmpty()){			
			dao.AddStudy(dto);
			return true;
		}
		else{
			JOptionPane.showMessageDialog(new JFrame(), "添加数据项重复");
			return false;
		}
	}
	
	/**
	 * 按照学号查询的结果全部传到StudyUpdateFrame页面
	 * @param stuid
	 * @param suf
	 */
	public void getStudyAll(String stuid,String week,String month,String year,StudyUpdateFrame suf){
		List list=dao.getStudy(stuid,week,month,year);
	    Iterator it=list.iterator();
	    while(it.hasNext()){
	    	StudyDTO dto=(StudyDTO)it.next();
	    	suf.stuidjTextField.setText(stuid);
	    	suf.monthjTextField.setText(dto.getStu_month());
	    	suf.weekjTextField.setText(dto.getStu_week());
	    	suf.yearjTextField.setText(dto.getStu_year());
	    	suf.xuexijComboBox.setSelectedItem(dto.getStu_sta());
	    	suf.xinlijComboBox.setSelectedItem(dto.getStu_men());
	    }
		
	}
	
	/**
	 * 得到StudyUpdateFrame更新后的数据传到DAO中
	 * @param suf
	 */
	public void UpdateStudy(StudyUpdateFrame suf){
		dto.setStu_id(suf.stuidjTextField.getText());//得到学号
		dto.setStu_week(suf.weekjTextField.getText());//得到周时间
		dto.setStu_month(suf.monthjTextField.getText());//得到月时间
		if(suf.xuexijComboBox.getSelectedItem()==null){
			
		}
		else{
		dto.setStu_sta(suf.xuexijComboBox.getSelectedItem().toString());
		}
		if(suf.xinlijComboBox.getSelectedItem()==null){
			
		}
		else{
		dto.setStu_men(suf.xinlijComboBox.getSelectedItem().toString());
		}
		dto.setStu_year(suf.yearjTextField.getText());//得到
		dao.updateStudy(dto);
	}
	
	/**
	 * 联合查询 
	 * @param stuid
	 * @param name
	 * @param xuexi
	 * @param xinli
	 * @param week
	 * @param month
	 * @param year
	 * @param dtm
	 */
	public void selectView(String stuid,String name,String xuexi,String xinli,String week,String month,String year,DefaultTableModel dtm){
		List list=dao.selectView(stuid, name,xuexi, xinli, week, month, year);
		Iterator it=list.iterator();
//		if(list.isEmpty()){
//			for(int i=1;i<=5;i++){
//				Vector vt=new Vector();
//				vt.add("");
//				vt.add("");
//				vt.add("");
//				vt.add("");
//				vt.add("");
//				vt.add("");
//				vt.add("");	
//				dtm.addRow(vt);
//			}
//		}
//		else{
		Vector vt;
		while(it.hasNext()){
			dto=(StudyDTO)it.next();
			vt=new Vector();
			vt.add(dto.getStu_id());
			vt.add(dto.getStu_name());
			vt.add(dto.getStu_sta());
			vt.add(dto.getStu_men());
			vt.add(dto.getStu_week());
			vt.add(dto.getStu_month());
			vt.add(dto.getStu_year());
			dtm.addRow(vt);
		}
	}
//}
	
	/**
	 * 将学号添加到DutyAddFrame的学号下拉列表中
	 * @param dcbm
	 */
	public void getStudentId(DefaultComboBoxModel dcbm){
		List list=dao.getStudentId();
		Iterator it=list.iterator();
	    Vector vt;
	    while(it.hasNext()){
	    	dto=(StudyDTO)it.next();
	    	vt=new Vector();
	    	vt.add(dto.getStu_id());
	    	dcbm.insertElementAt(dto.getStu_id(),0);
	    }
	}
	
	/**
	 * 得到StudyMainFrame中的数据再传到StudyDAO中
	 * @param stuid
	 * @param week
	 * @param month
	 * @param year
	 */
	public void deleteStudy(String stuid,String week,String month,String year ){
		dao.deleteStudy(stuid, week, month, year);
	}
}