op_weeks.java

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

package action;

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

import util.TermAndWeeks;

public class Op_weeks extends DBOption {
	private TermAndWeeks aweek = null;
	private Vector<TermAndWeeks> weeklist = null;
	
	private String sqlStr = "";
	public String msg = "";
	
	public Op_weeks() {
		this.setPoolName("kaoqin");
	}
	
	/**
	 * 获取指定学期的所有周
	 * @param termid
	 * @return
	 */
	public Vector getTermWeeks(long termid) {
		sqlStr = "select * from Weeks where Wek_term = " + termid;
		sqlStr = sqlStr +" order by Wek_week";
		
		try {
			rs = this.query(sqlStr);
			this.weeklist = new Vector<TermAndWeeks>();
			while (rs.next()) {
				this.aweek = new TermAndWeeks();
				aweek.setWek_Id(rs.getLong("Wek_ID"));
				aweek.setTerm_Id(rs.getLong("Wek_term"));
				aweek.setWek_week(rs.getInt("Wek_week"));
				aweek.setWek_month(rs.getInt("Wek_month"));
				weeklist.addElement(aweek);
			}
			rs.close();
			if (weeklist.size() == 0) return null;
			return weeklist;
		} catch (SQLException e) {
			this.msg = "查询时出错，请稍微再试!";
			Log.writeLog(e, "action.Op_week.getTermWeeks:" +
					"\n\t查询指定学期"+ termid + "的所有周失败！");
			return null;
		}
	}
	
	public Vector getTermMoons(String year, String term) {
		//System.out.println(year + term);
		if (year == null || term == null || year.equals("") || term.equals("")) {
			this.msg = "请指定学年与学期!";
			return null;
		}
		sqlStr = "select distinct wt_month from wt " +
				"where wt_year = '" + year + "' and wt_term = '"+ term+ "'";
		//System.out.println(sqlStr);
		try {
			rs = this.query(sqlStr);
			Vector<String> moons = new Vector<String>();
			while(rs.next()) {
				moons.addElement(rs.getString("wt_month"));
				//System.out.println(rs.getString("wt_month"));
			}
			rs.close();
			this.freeConn();
			if (moons.size() == 0) {
				this.msg = "没的找到指定学期的学月信息!";
				return null;
			}
			return moons;
		} catch (SQLException e) {
			this.freeConn();
			this.msg = "查询指定的学期"+year+term+"时出错!";
			Log.writeLog(e, "action.Op_weeks.getTermMoons:\n\t" + msg);
			return null;
		}
	}
	
	public Vector getMoonWeeks(String year, String term, String moon) {
		//System.out.println(year+term+moon);
		if (year == null || term == null || moon == null ||
				year.equals("") || term.equals("") || moon.equals("")) {
			this.msg = "请指定学期与学月!";
			return null;
		}
		sqlStr = "select distinct wt_week from wt " +
				"where wt_year = '"+ year +"'" +
				" and wt_term = '" + term +"'" +
				" and wt_month = " + moon;
		//System.out.println(sqlStr);
		try {
			rs = this.query(sqlStr);
			Vector<String> weeks = new Vector<String>();
			while(rs.next()) {
				weeks.addElement(rs.getString("wt_week"));
				//System.out.println(rs.getString("wt_week"));
			}
			rs.close();
			this.freeConn();
			if (weeks.size() == 0) {
				this.msg = "找不到指定的周次!";
				return null;
			}
			return weeks;
		} catch (SQLException e) {
			this.freeConn();
			this.msg = "查询指定学月的周次信息时出错!";
			Log.writeLog(e, "action.Op_weeks.getMoonWeeks:\n\t"+msg);
			return null;
		}
	}
	
}