sj101dao.java

试卷分析系统 基于struts的试卷分析系统！ 对初学框架的人很有好处哦！

/*
 * Name:xxx.java 
 * Version:1.0 
 * Copyright(c) MA-LF, WANG-X. 2006 All right reserved. 
 * Created:2006-4-17 
 * Author:WANG-X
 * Updated: 2006-4-17 WANG-X
 * 
 */
package com.hbnu.dao;

/**
 * @author jackie
 * @version 1.0
 * 
 */
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;
import java.sql.SQLException;
import com.hbnu.common.DBConn;
import com.hbnu.common.DUtilBean;

public class Sj101Dao {
	/**
	 * Sj101画面对应项目初始化
	 * 
	 * @param username  	任课老师
	 * @return rtnList	 	返回情报List	
	 * @throws SQLException，Exception 
	 * 
	 */
	public ArrayList InitSj101 (String username) throws SQLException, Exception {
		/*DBConn数据库实例化*/
		DBConn db = new DBConn();
       
		/*查询SQL List*/
		ArrayList selectList = new ArrayList();
		/*返回情报List*/
		ArrayList rtnList = new ArrayList();
		
		try {
			db.start();
			/*查询SQL语句*/
			StringBuffer sbSql = new StringBuffer();
			sbSql.append(" SELECT");
			sbSql.append(" sjbh,");
			sbSql.append(" kcmc,");
			sbSql.append(" kssj,");
			sbSql.append(" bjmc,"); 
			sbSql.append(" ksrenshu,");
			sbSql.append(" sjfx ");
			sbSql.append("FROM sjxxb ");
			sbSql.append("WHERE ");
			sbSql.append(" rklaoshi =  ");
			sbSql.append(DUtilBean.sqlEscape(username)); 
			/*SQL语句执行*/
			selectList = db.execSelect(sbSql.toString());
			
			/*返回结果不为空*/
			if (selectList.size() > 0) {
				for (int i = 0; i < selectList.size(); i++) {
					Map selectMap = new HashMap();
					String[] strResult = (String[]) selectList.get(i);
					selectMap.put("sjbh", strResult[0]); 		/* 编号 */
					selectMap.put("kcmc", strResult[1]);		/* 课程名称 */
					selectMap.put("kssj", strResult[2]);		/* 考试时间 */
					selectMap.put("bjmc", strResult[3]);		/* 班级名称 */
					selectMap.put("ksrenshu", strResult[4]);	/* 考试人数 */
					selectMap.put("sjfx", strResult[5]);		/* 试卷分析是否完成 */
					rtnList.add(selectMap);
				}
			}
		} catch (Exception e) {
			throw e;
		} finally {
			try {
				if (db != null) {
					db.execClose();
				}
			}catch (Exception e) {
				throw e;
			}
		}
		
		return rtnList;
	}
}