op_class.java

来自「考勤管理系统是针对学校每个月的考勤的报表进行总结」· Java 代码 · 共 48 行

package action;

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

public class Op_class extends DBOption {
	private Vector<String> classes = null;
	private String sqlStr = "";
	
	public String msg = "";
	
	public Op_class() {
		this.setPoolName("std");
	}
	
	/**
	 * 获取指定院系的所有班级
	 * @param dep 指定院系
	 * @return Vector 返回班级列表
	 */
	public Vector getAdepClasses(String dep) {
		sqlStr = "select distinct SCLASS from students " +
				"where SDEPART ='" + dep + "'";
		try {
			this.rs = this.query(sqlStr);
			this.classes = new Vector<String>();
			
			while (rs.next()) {
				this.classes.addElement(rs.getString("SCLASS")); 
			}
			if (classes.size() == 0) {
				this.msg = "没有找到相应的班级!";
				rs.close();
				return null;
			}
			rs.close();
			return this.classes;
		} catch (SQLException e) {
			this.msg = "查找班级时出错,请稍候再试!";
			Log.writeLog(e, "action.Op_class." +
					"geAdepClasses:\n\t查询班级时出错!");
			return null;
		}
	}
	
	
}