op_term.java

考勤管理系统是针对学校每个月的考勤的报表进行总结

package action;

import java.sql.SQLException;
import java.util.Vector;

import util.Term;

public class Op_term extends DBOption {
	private Term aterm = null;
	private Vector<Term> termlist = null;
	
	private String sqlStr = "";
	public String msg = "";
	
	public Op_term() {
		this.setPoolName("kaoqin");
	}
	
	/**
	 * 获取当前学期信息
	 * @return Term 返回学期对象
	 */
	public Term getCurTerm() {
		this.aterm = new Term();
		sqlStr = "select * from Term where Term_state = 1";

		try {
			rs = query(sqlStr);	
			if (rs.next()) {
				//找到记录
				aterm.setTerm_Id(rs.getLong("Term_ID"));
				aterm.setTerm_state(rs.getBoolean("Term_state"));
				aterm.setTerm_term(rs.getString("Term_term"));
				aterm.setTerm_year(rs.getString("Term_year"));
				rs.close();
				return aterm;
			} else {
				//没有找到记录
				rs.close();
				this.msg = "当前学期未设置!";
				return null;
			}
		} catch (SQLException e) {
			// TODO 数据库操作错误
			this.msg = "取得当前学期信息时出错!请稍微再试!";
			Log.writeLog(e, "action.Op_weeks.getCurTerm: " +
					"\n\t获取当前学期信息时出错");
			return null;
		}
	}
	
	/**
	 * 获取所有学年信息
	 * @return
	 */
	public Vector getAllYear() {
		sqlStr = "select distinct Term_year from Term order by Term_year desc";
		
		try {
			this.rs = this.query(sqlStr);
			Vector<String> years = new Vector<String>();
			
			while (rs.next()) {
				years.addElement(rs.getString("Term_year"));
				//System.out.println(rs.getString("Term_year"));
			}
			rs.close();
			this.freeConn();
			if (years.size()==0) {
				this.msg = "暂时没有学年信息";
				return null;
			}
			return years;
		} catch (SQLException e) {
			this.msg = "读取所有学年信息时出错,主稍候再试";
			this.freeConn();
			Log.writeLog(e, "action.Op_term.getAllYear:\n\t"+msg);
			return null;
		}
	}
	
	public Vector getYTerm(String year) {
		if (year == null || year.equals("")) {
			this.msg = "请选择指定学年!";
			return null;
		}
		sqlStr = "select * from Term where Term_year='" + year + "' order by Term_state desc";
		
		Vector<String> terms = new Vector<String>();
		try {
			rs = this.query(sqlStr);
			while (rs.next()) {
				terms.addElement(rs.getString("Term_term"));
			}
			this.freeConn();
			if (terms.size() == 0) {
				this.msg = "找不到批定学年的学期设置!";
				return null;
			}
			return terms;
		} catch (SQLException e) {
			this.freeConn();
			this.msg = "查询指定的"+year+"学期时出错!";
			Log.writeLog(e, "action.Op_term.getYTerm:\n\t"+msg);
			return null;
		}
	}
	
	public Vector getAllTerm() {
		sqlStr = "select * from Term order by Term_state desc, Term_year desc";
		
		try {
			this.rs = this.query(sqlStr);
			this.termlist = new Vector<Term>();
			
			while (rs.next()) {
				this.aterm = new Term();
				aterm.setTerm_Id(rs.getLong("Term_ID"));
				aterm.setTerm_year(rs.getString("Term_year"));
				aterm.setTerm_term(rs.getString("Term_term"));
				aterm.setTerm_state(rs.getBoolean("Term_state"));
				
				termlist.addElement(aterm);
			}
			this.rs.close();
			freeConn();
			if (termlist.size() == 0) {
				this.msg = "没有学期信息";
				return null;
			}
			return termlist;
		} catch (SQLException e) {
			freeConn();
			Log.writeLog(e,"Op_term.getAllTerm()_1 查找所有学期信息时出错!");
			this.msg = "查找所有学期信息时出错!";
			return null;
		}
	}
}