clascoaction.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 javax.swing.JTextField;
import com.hb.studentmanager.date.ClaDAO;
import com.hb.studentmanager.date.ClaDTO;
import com.hb.studentmanager.date.ClaScoDAO;
import com.hb.studentmanager.date.ClaScoDTO;
import com.hb.studentmanager.date.SubDAO;
import com.hb.studentmanager.date.SubDTO;
public class ClaScoAction {
	ClaScoDAO dao = new ClaScoDAO();

	ClaScoDTO dto = new ClaScoDTO();
	public void claScoSelect(JTable table,JTextField minTextField,JTextField maxTextField,JTextField avgTextField,int page,String claId, String subName,int minScore,int maxScore) {
		boolean flag=true;
		SubDAO subdao=new SubDAO();
		SubDTO subdto=new SubDTO();
        subdto.setSub_id("");
        subdto.setSub_name(subName);
        subdto.setSub_score("");
		List list = subdao.subExactSelect(subdto);
		subdto=(SubDTO)list.get(0);
		String subId=subdto.getSub_id();
		list=dao.claScoSelect(claId, subId, minScore, maxScore);
		if (list.isEmpty()) {
			JOptionPane.showMessageDialog(new JFrame(), "此班级还未测试这个科目或者沒有此分数段的记录！");
			flag=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 = (ClaScoDTO) it.next();
					table.setValueAt(dto.getStuId(),i,0);
					table.setValueAt(dto.getStuName(),i,1);
					table.setValueAt(dto.getTesId(),i,2);
					table.setValueAt(subName,i,3);
					table.setValueAt(dto.getStuSco(),i,4);
				} else {
					table.setValueAt("", i, 0);
					table.setValueAt("", i, 1);
					table.setValueAt("", i, 2);
					table.setValueAt("",i,3);
					table.setValueAt("",i,4);
				}
			}
		}
		if(flag==true){
			list=dao.claScoSelectAll(claId, subId, minScore, maxScore);
			if(list.isEmpty()==false){
				dto=(ClaScoDTO)list.get(0);
				minTextField.setText(Integer.toString(dto.getMinScore()));
				maxTextField.setText(Integer.toString(dto.getMaxScore()));
				avgTextField.setText(Float.toString(dto.getAveScore()));
				}
			}
	}

	public int pageCount(String claId, String subName,int minScore,int maxScore) {
		int page, rowCount = 0;
		SubDAO subdao=new SubDAO();
		SubDTO subdto=new SubDTO();
        subdto.setSub_id("");
        subdto.setSub_name(subName);
        subdto.setSub_score("");
		List list = subdao.subExactSelect(subdto);
		subdto=(SubDTO)list.get(0);
		String subId=subdto.getSub_id();
	    list = dao.claScoSelect(claId, subId, minScore, maxScore);
		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 initClaComboBox(JComboBox comboBox){
		ClaDAO cladao=new ClaDAO();
		ClaDTO cladto=new ClaDTO();
		List list=cladao.select();
		Iterator it=list.iterator();
		while(it.hasNext()){
			cladto=(ClaDTO)it.next();
			comboBox.addItem(cladto.getCla_id());
		}	 
	}
	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());
		}			
	}
	public boolean selectIsNull(String claId, String subName){
		SubDAO subdao=new SubDAO();
		SubDTO subdto=new SubDTO();
        subdto.setSub_id("");
        subdto.setSub_name(subName);
        subdto.setSub_score("");
		List list = subdao.subExactSelect(subdto);
		subdto=(SubDTO)list.get(0);
		String subId=subdto.getSub_id();
		list=dao.claScoSelect(claId, subId, 0, 100);
		if (list.isEmpty()) {
			return true;
		} else {
			return false;
		}	
	}
}