adddatadao.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-5-2 
 * Author:WANG-X
 * Updated: 2006-5-2 WANG-X
 * 
 */
package com.hbnu.dao;

/**
 * @author jackie
 * @version 1.0
 * 
 */
import java.util.ArrayList;
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 AddDataDao {
	/**
	 * Sj301画面对应项目提交到数据库里
	 * 
	 * @param coursename 课程名称
	 *  @param classname 班级名称
	 * @throws SQLException，Exception 
	 * 
	 */
	public void  doInfoInsert (String coursename, String classname ,Map Info)
	                      					throws SQLException, Exception{
		
		/*DBConn数据库实例化*/
		DBConn db = new DBConn();
		//将相应的文字转换，以免出现乱码
		CodingConvert convert = new CodingConvert();
		//从Map中区出各个ArrayList
		ArrayList list_ps_scorse = (ArrayList)Info.get("list_ps_scorse");
		ArrayList list_sy_scorse = (ArrayList)Info.get("list_sy_scorse");
		ArrayList list_qm_scorse = (ArrayList)Info.get("list_qm_scorse");
		ArrayList list_zp_scorse = (ArrayList)Info.get("list_zp_scorse");
		ArrayList list_beizhu = (ArrayList)Info.get("list_beizhu");
		ArrayList list_xuefen = (ArrayList)Info.get("list_xuefen");
		ArrayList list_xuhao = (ArrayList)Info.get("list_xuhao");	
		//
		int sizze = list_ps_scorse.size();
		try{
			db.start();
		for(int i = 0; i < sizze; i++){		
			if((list_ps_scorse.get(i) == null || "".equals(list_ps_scorse.get(i))) 
					&& (list_sy_scorse.get(i) == null || "".equals(list_sy_scorse.get(i)))
					&& (list_qm_scorse.get(i) == null    || "".equals(list_qm_scorse.get(i)))
					&& (list_zp_scorse.get(i) == null || "".equals(list_zp_scorse.get(i)))
					&& (list_beizhu.get(i) == null || "".equals(list_beizhu.get(i)))
					&& (list_xuefen.get(i) == null 	|| "".equals(list_xuefen.get(i)))
					&& (list_xuhao.get(i) == null || "".equals(list_xuhao.get(i))) ){
				continue;	
			}else {
				StringBuffer saSql = new StringBuffer();
				saSql.append(" INSERT INTO cjxxb(");
				saSql.append(" pscj,");
				saSql.append(" sycj,");
				saSql.append(" qmcj,");
				saSql.append(" zpcj,");
				saSql.append(" beizhu,");
				saSql.append(" xuefen,");
				saSql.append(" xuhao,");
				saSql.append(" bjmc,");
				saSql.append(" kcmc");
				saSql.append(" )VALUES (");
				saSql.append(DUtilBean.sqlEscape(String.valueOf(list_ps_scorse.get(i))));				
				saSql.append(",");
				saSql.append(DUtilBean.sqlEscape(String.valueOf(list_sy_scorse.get(i))));	
				saSql.append(",");
				saSql.append(DUtilBean.sqlEscape(String.valueOf(list_qm_scorse.get(i))));	
				saSql.append(",");
				saSql.append(DUtilBean.sqlEscape(String.valueOf(list_zp_scorse.get(i))));	
				saSql.append(",");
				saSql.append(DUtilBean.sqlEscape(String.valueOf(list_beizhu.get(i))));	
				saSql.append(",");
				saSql.append(DUtilBean.sqlEscape(String.valueOf(list_xuefen.get(i))));	
				saSql.append(",");
				saSql.append(DUtilBean.sqlEscape(String.valueOf(list_xuhao.get(i))));	
				saSql.append(",");
				saSql.append(DUtilBean.sqlEscape(convert.toGb(classname))); 
				saSql.append(",");
				saSql.append(DUtilBean.sqlEscape(convert.toGb(coursename))); 
				saSql.append(" )");			
				db.execUpdate(saSql.toString());}
										}
						}catch (Exception e) {
							throw e;
						} finally {
							try {
								if (db != null) {
									db.execClose();
								}
							}catch (Exception e) {
								throw e;
							}
						}		
	}			
				
}