scoaction.java

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

package com.hb.studentmanager.action;

import java.util.ArrayList;
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.*;

public class ScoAction {
	ScoDAO dao = new ScoDAO();//创建一个功能对象
	ScoDTO dto = new ScoDTO();//创建一个数据对象
//条件查询
	public void scoSelect(JTable table,int page,String tesid,String stuid,String stuname,String subname,String subsco,int sco1,int sco2){	
		List list = dao.scoSelect(tesid,stuid,stuname,subname,subsco,sco1,sco2);
		if (list.isEmpty()) {
			JOptionPane.showMessageDialog(new JFrame(), "找不到和您的查询条件相符的记录 ！");
		} else {
			Iterator it = list.iterator();
			for(int i=0;i<(page-1)*5;i++){
				it.next();//只显示第page页数据
			}
			for(int i=1;i<table.getRowCount();i++){
				if(it.hasNext()){
					dto=(ScoDTO)it.next();
					table.setValueAt(dto.getTes_id(), i, 0);
					table.setValueAt(dto.getStu_id(), i,1);
					table.setValueAt(dto.getStu_name(), i,2);
					table.setValueAt(dto.getSub_name(), i,3);
					table.setValueAt(dto.getSub_sco(), i,4);
					table.setValueAt(dto.getSco_sub(), i,5);
				}	
				else{
					table.setValueAt("", i,0);
					table.setValueAt("", i,1);
					table.setValueAt("", i,2);
					table.setValueAt("", i,3);
					table.setValueAt("", i,4);
					table.setValueAt("", i,5);
					}
				}
		}
	}
//修改
	public void update(String tesid,String stuid,String score){
		dao.scoUpdate(tesid, stuid, score);	
	}
//删除
	public void delete(String tesid,String stuid){
		dao.scoDelete(tesid,stuid);
	}
//添加
	public boolean add(String tes_id,String stu_id,int sco_sub){
        List list=dao.judge(tes_id,stu_id);
		if (list.isEmpty()==false) {
			JOptionPane.showMessageDialog(new JFrame(), "考试编号和学号对应记录已存在！");
			   return false;  
		}
		else{   
		   dto.setTes_id(tes_id);
		   dto.setStu_id(stu_id);
		   dto.setSco_sub(sco_sub);
		   dao.scoInsert(dto);
		   return true;
		}
	}
//返回当前总页数
	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 int pageCountSelect(String tesid,String stuid,String stuname,String subname,String subsco,int sco1,int sco2){
		int page,rowCount=0;
		List list = dao.scoSelect(tesid,stuid,stuname,subname,subsco,sco1,sco2);
		Iterator it=list.iterator();
		while(it.hasNext()){
			it.next();
			rowCount++;
		}
		if(rowCount%5==0) page=rowCount/5;
		else  page=rowCount/5+1;
		return page;
	}
//从考试表中查询tes_id
	public List selecttesid(){
		return dao.selecttes_id();
	}
//	从学生表中查询stu_id
	public List selectstuid(){
		return dao.selectstu_id();
	}
//
	public boolean judgeupdate(String tesid){
		return dao.judgeupdate(tesid);
	}
//显示结果
	public void init(JTable table,int page,int pagesize){
		List list=dao.init();
		Iterator it=list.iterator();
		for(int i=0;i<(page-1)*pagesize;i++){
			it.next();//只显示第page页数据
		}
		for(int i=1;i<table.getRowCount();i++){//行
			if(it.hasNext()){
				dto=(ScoDTO)it.next();
				table.setValueAt(dto.getTes_id(), i, 0);
				table.setValueAt(dto.getStu_id(), i,1);
				table.setValueAt(dto.getStu_name(), i,2);
				table.setValueAt(dto.getSub_name(), i,3);
				table.setValueAt(dto.getSub_sco(), i,4);
				table.setValueAt(dto.getSco_sub(), i,5);
			}	
			else{
				table.setValueAt("", i,0);
				table.setValueAt("", i,1);
				table.setValueAt("", i,2);
				table.setValueAt("", i,3);
				table.setValueAt("", i,4);
				table.setValueAt("", i,5);
				}
			}
		}

	///******////**////
	public void stuid(JComboBox stuidComboBox){
		stuidComboBox.addItem("");
		Iterator it=selectstuid().iterator();
		while(it.hasNext()){
			StuDTO dto=(StuDTO)it.next();
			stuidComboBox.addItem(dto.getStu_id());
		}
	}
	public void tesid(JComboBox tesComboBox){
		tesComboBox.addItem("");
		Iterator it=selecttesid().iterator();
		while(it.hasNext()){
			TesDTO dto=(TesDTO)it.next();
			tesComboBox.addItem(dto.getTes_id());
		}
	}
}