sj201dao.java

基于STRUTS的试卷分析系统,实现JFREECHART画图片和POI生成EXCEL文档,开发平台:eclipse3.0+myclipse+tomcat5.0+mysql4.0

/*
 * Name:xxx.java 
 * Version:1.0 
 * Copyright(c) MA-LF, WANG-X. 2006 All right reserved. 
 * Created:2006-4-20 
 * Author:WANG-X
 * Updated: 2006-4-20 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 Sj201Dao {

	public ArrayList getSj201Info(String txt_id) throws SQLException, Exception {
		/*DBConn数据库实例化*/
		DBConn db = new DBConn();
		/*查询SQL List*/
		ArrayList sj201List = new ArrayList();
		/*返回情报List*/
		ArrayList rtnList = new ArrayList();
		 
		try {
			db.start();
			/*查询SQL语句*/
			StringBuffer sbSql = new StringBuffer();
			sbSql.append(" SELECT");
			sbSql.append(" s.zymc,");
			sbSql.append(" s.pscj,"); 
			sbSql.append(" s.pscjqz,");
			sbSql.append(" s.sycj,");
			sbSql.append(" s.sycjqz,");
			sbSql.append(" s.qmcjqz,");
			sbSql.append(" s.mtfs,");
			sbSql.append(" s.yjjs,"); 
			sbSql.append(" s.yjfs,");
			sbSql.append(" s.bjmc, ");
			sbSql.append(" s.rklaoshi,");
			sbSql.append(" k.kcmc,");
			sbSql.append(" s.kssj,");
			sbSql.append(" s.ksfs,");
			sbSql.append(" s.jysmc,"); 
			sbSql.append(" k.kclb,");
			sbSql.append(" k.kcbh,");
			sbSql.append(" k.kcxs,");
			sbSql.append(" k.xuefen");
			sbSql.append(" FROM sjxxb  s,");
			sbSql.append(" kcxxb k ");
			sbSql.append(" WHERE ");
			sbSql.append(" s.kcmc=k.kcmc ");
			sbSql.append(" AND s.zymc = k.zymc ");
			sbSql.append(" AND s.sjbh = ") ;
			sbSql.append(DUtilBean.sqlEscape(txt_id)); 
			/*SQL语句执行*/
			sj201List = db.execSelect(sbSql.toString());
			/*返回结果不为空*/
			if (sj201List.size() > 0) {
				for (int i = 0; i < sj201List.size(); i++) {
					Map selectMap = new HashMap();
					String[] strResult = (String[]) sj201List.get(i);
					selectMap.put("zymc", strResult[0]); 		/*专业名称*/
					selectMap.put("pscj", strResult[1]);		/*平时成绩 */
					selectMap.put("pscjqz", strResult[2]);		/* 平时成绩权重 */
					selectMap.put("sycj", strResult[3]);		/* 实验成绩 */
					selectMap.put("sycjqz", strResult[4]);		/* 实验成绩权重 */
					selectMap.put("qmcjqz", strResult[5]);		/* 期末成绩权重 */
					selectMap.put("mtfs", strResult[6]); 		/* 命题方式*/
					selectMap.put("yjjs", strResult[7]);		/* 阅卷老师 */
					selectMap.put("yjfs", strResult[8]);		/* 阅卷方式 */
					selectMap.put("bjmc", strResult[9]);		/* 班级名称 */
					selectMap.put("rklaoshi", strResult[10]);	/* 任课老师 */
					selectMap.put("kcmc", strResult[11]);       /* 课程名称 */
					selectMap.put("kssj", strResult[12]); 		/* 考试时间 */
					selectMap.put("ksfs", strResult[13]);		/* 考试方式 */
					selectMap.put("jysmc", strResult[14]);		/* 教研室名称 */
					selectMap.put("kclb", strResult[15]);		/* 课程类别 */
					selectMap.put("kcbh", strResult[16]);		/* 课程编号 */
					selectMap.put("kcxs", strResult[17]);      	/* 课程学时 */
					selectMap.put("xuefen", strResult[18]); 	/* 课程学分 */
					rtnList.add(selectMap);
				}
			}
		} catch (Exception e) {
			throw e;
		} finally {
			try {
				if (db != null) {
					db.execClose();
				}
			}catch (Exception e) {
				throw e;
			}
		}
			
		return rtnList;	
			
	}
}