menuactiondao.java

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

package com.hbnu.dao;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;
import java.sql.SQLException;
import com.hbnu.common.CodingConvert;
import com.hbnu.common.DBConn;
import com.hbnu.common.DUtilBean;
public class MenuActionDao {
	/**
	 * Sj２01画面对应项目提交
	 * 
	 * @param classId  	    班级名称
	 * @return rtnList	 	返回情报List	
	 * @throws SQLException，Exception 
	 * 
	 */
	public ArrayList getSj201Info (String className , String courseName) throws SQLException, Exception {
		/*DBConn数据库实例化*/
		DBConn db = new DBConn();
		/*查询SQL List*/
		ArrayList selectList = new ArrayList();
		/*返回情报List*/
		ArrayList rtnList = new ArrayList();
		
		try {
			db.start();
			CodingConvert convert = new CodingConvert();
			courseName = convert.toGb(courseName);
			
			/*查询SQL语句*/
			StringBuffer sbSql = new StringBuffer();
			sbSql.append(" SELECT");
			sbSql.append(" x.xuhao,");
			sbSql.append(" x.xsxm, ");
			sbSql.append(" c.pscj,");
			sbSql.append(" c.sycj, ");
			sbSql.append(" c.qmcj, ");
			sbSql.append(" c.zpcj, ");
			sbSql.append(" c.xuefen, ");
			sbSql.append(" c.beizhu ");
			sbSql.append(" FROM xsxxb  x,");
			sbSql.append(" cjxxb c ");
			sbSql.append("WHERE ");
			sbSql.append(" x.bjmc =  ");
			sbSql.append(DUtilBean.sqlEscape(className)); 
			sbSql.append(" AND c.bjmc =  ");
			sbSql.append(DUtilBean.sqlEscape(className)); 
			sbSql.append(" AND c.kcmc = ");
			sbSql.append(DUtilBean.sqlEscape(courseName)); 
			/*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("xuhao", strResult[0]); 		/* 学生序号 */
					selectMap.put("xsxm", strResult[1]);		/* 学生姓名 */
					selectMap.put("pscj", strResult[2]);	
					selectMap.put("sycj", strResult[3]);	
					selectMap.put("qmcj", strResult[4]);	
					selectMap.put("zpcj", strResult[5]);	
					selectMap.put("xuefen", strResult[6]);	
					selectMap.put("beizhu", strResult[7]);	
					rtnList.add(selectMap);
					}
				}
			} catch (Exception e) {
				throw e;
			} finally {
				try {
					if (db != null) {
						db.execClose();
					}
				}catch (Exception e) {
					throw e;
				}
			}
			return rtnList;
	}

}