querydefineshowedithandler.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

						modifyEnterpriseDAO.executeSQLS(sqls);
					}

					//是变更in_change表的修改保存
					if("1".equals(queryPageDefine.getPageType()) && "5".equals(queryPageDefine.getCATEGORY1()) &&
					   "03".equals(queryPageDefine.getBID().substring(0,2))){
						//获得查询页面的字段信息
						Debug.print("[QueryDefineShowEditHandler]------->变更in_change表修改--->>>start!");
						int recordCount = Integer.parseInt((String) request.getParameter("recordCount"));
						String tableName = TableNameUtil.IN_CHANGE;
						sqls = new ArrayList();
						for(int i = 0;i < recordCount;i++){
							String updateSql = "";
							if("gsgsjin_basis02".equals((String) request.getParameter("field004_" + i))){
								Debug.println("[QueryDefineShowEditHandler]processEvent-----table = gsgsjin_basis02");

								updateSql = "update " + tableName + " set "
									+ " field001='" + PubFunc.toSql((String) request.getParameter("field001_" + i)) + "',"
									+ " field002='" + PubFunc.toSql((String) request.getParameter("field002_" + i)) + "',"
									+ " field003='" + PubFunc.toSql((String) request.getParameter("field003_" + i)) + "',"
									+ " field004='" + PubFunc.toSql((String) request.getParameter("field004_" + i)) + "',"
									+ " field005='" + PubFunc.toSql((String) request.getParameter("field005_" + i)) + "',"
									+ " field006='" + PubFunc.toSql((String) request.getParameter("field006_" + i)) + "',"
									+ " field007='" + PubFunc.toSql((String) request.getParameter("field007_" + i)) + "',"
									+ " field008='" + PubFunc.toSql((String) request.getParameter("field008_" + i)) + "',"
									+ " field009='" + PubFunc.toSql((String) request.getParameter("field009_" + i)) + "',"
									+ " field010='" + PubFunc.toSql((String) request.getParameter("field010_" + i)) + "',"
									+ " field011='" + PubFunc.toSql((String) request.getParameter("field011_" + i)) + "'"
									+ " where field001='" + PubFunc.toSql((String) request.getParameter("field001_" + i)) + "'"
									+ " and field002='" + PubFunc.toSql((String) request.getParameter("field002_" + i)) + "'"
									+ " and field003='" + PubFunc.toSql((String) request.getParameter("field003_" + i)) + "'"
									+ " and field007='" + PubFunc.toSql((String) request.getParameter("field007_" + i)) + "'"
									;
							} else{
								Debug.println("[QueryDefineShowEditHandler]processEvent-----table = 子表");

								updateSql = "update " + tableName + " set "
									+ " field001='" + PubFunc.toSql((String) request.getParameter("field001_" + i)) + "',"
									+ " field002='" + PubFunc.toSql((String) request.getParameter("field002_" + i)) + "',"
									+ " field003='" + PubFunc.toSql((String) request.getParameter("field003_" + i)) + "',"
									+ " field004='" + PubFunc.toSql((String) request.getParameter("field004_" + i)) + "',"
									+ " field005='" + PubFunc.toSql((String) request.getParameter("field005_" + i)) + "',"
									+ " field006='" + PubFunc.toSql((String) request.getParameter("field006_" + i)) + "',"
									+ " field007='" + PubFunc.toSql((String) request.getParameter("field007_" + i)) + "',"
									+ " field008='" + PubFunc.toSql((String) request.getParameter("field008_" + i)) + "',"
									+ " field009='" + PubFunc.toSql((String) request.getParameter("field009_" + i)) + "',"
									+ " field010='" + PubFunc.toSql((String) request.getParameter("field010_" + i)) + "',"
									+ " field011='" + PubFunc.toSql((String) request.getParameter("field011_" + i)) + "'"
									+ " where field001='" + PubFunc.toSql((String) request.getParameter("field001_" + i)) + "'"
									+ " and field002='" + PubFunc.toSql((String) request.getParameter("field002_" + i)) + "'"
									+ " and field003='" + PubFunc.toSql((String) request.getParameter("field003_" + i)) + "'"
									+ " and field005='" + PubFunc.toSql((String) request.getParameter("field005_" + i)) + "'"
									;
							}
							//将要执行的SQL放到ArrayList中
							sqls.add(updateSql);
							Debug.println("[QueryDefineShowEditHandler]processEvent----->updateSql=" + updateSql);
						}
						modifyEnterpriseDAO.executeSQLS(sqls); //执行ArrayList中的SQL
						Debug.print("[QueryDefineShowEditHandler]------->变更in_change表修改--->>>end!");
					}
				}

				//判断页面类型(自动生成页面)
				if("1".equals(queryPageDefine.getPageType()) && "5".equals(queryPageDefine.getCATEGORY1())){
					//获得查询页面的字段信息null
					Debug.print("[QueryDefineShowEditHandler]--->>>显示页面innerID " + innerID + " BID " + BID + " DJJG " + DJJG + " PAGE_CODE " +
								queryPageDefine.getPageCode());
					queryFieldList = queryDAO.getQueryFieldList(innerID,BID,DJJG,GXDW,queryPageDefine.getPageCode(),"",SN);
					if(BID.startsWith("03")){
						queryChangeRecordList = queryDAO.getQueryChangeFieldList(SN,BID,DJJG,GXDW,queryPageDefine.getPageCode(),innerID);
					}

				} else

				//调用pageBuilder组件生成
				if("2".equals(queryPageDefine.getPageType()) && "5".equals(queryPageDefine.getCATEGORY1())){
					if(BID.startsWith("03")){
						MSN = queryDAO.getChangeMaxSN(innerID);
					}
					//接收页面参数
					HashMap strParment = new HashMap();

					//获取页面参数
					sub = new ArrayList();
					sub.add("DJJF"); // namefield
					sub.add(DJJG); // namevalue
					strParment.put((Object) (new Integer(strParment.size())),sub);

					sub = new ArrayList();
					sub.add("GXDW"); // namefield
					sub.add(GXDW); // namevalue
					strParment.put((Object) (new Integer(strParment.size())),sub);

					sub = new ArrayList();
					sub.add("action"); // namefield
					sub.add(action); // namevalue
					strParment.put((Object) (new Integer(strParment.size())),sub);

					sub = new ArrayList();
					sub.add("innerID"); // namefield
					sub.add(innerID); // namevalue
					strParment.put((Object) (new Integer(strParment.size())),sub);

					sub = new ArrayList();
					sub.add("yearCheckupY"); // namefield
					sub.add(yearCheckupY); // namevalue
					strParment.put((Object) (new Integer(strParment.size())),sub);

					sub = new ArrayList();
					sub.add("SN"); // namefield
					sub.add(SN); // namevalue
					strParment.put((Object) (new Integer(strParment.size())),sub);

					sub = new ArrayList();
					sub.add("BID"); // namefield
					sub.add(BID); // namevalue
					strParment.put((Object) (new Integer(strParment.size())),sub);

					sub = new ArrayList();
					sub.add("code"); // namefield
					sub.add(code); // namevalue
					strParment.put((Object) (new Integer(strParment.size())),sub);

					sub = new ArrayList();
					sub.add("MSN"); // namefield
					sub.add(MSN); // namevalue
					strParment.put((Object) (new Integer(strParment.size())),sub);

					ArrayList autoPageList = AutoBuild.autoBuilder(queryPageDefine.getPageCode(),"row",strParment,queryPageDefine.getPageWidth(),request.getContextPath());

					autoPageStr = (String) autoPageList.get(0);
				}
				request.setAttribute("queryChangeRecordList",queryChangeRecordList); //显示数据
				request.setAttribute("autoPageStr",autoPageStr); //页面数据
				request.setAttribute("queryFieldList",queryFieldList);
				request.setAttribute("queryPageDefine",queryPageDefine);
				request.setAttribute("pageTitle",pageTitle);

				request.setAttribute("SN",SN); //事物号
				request.setAttribute("BID",BID); //业务类型
				request.setAttribute("page_code",code); //编号页面
				request.setAttribute("DJJG",DJJG);
				request.setAttribute("GXDW",GXDW);
				request.setAttribute("innerID",innerID);

				request.setAttribute("action",action);
				request.setAttribute("code",code);
				request.setAttribute("yearCheckupY",yearCheckupY);

				request.setAttribute("MSN",MSN); //事物号
				//request.setAttribute("OPR",OPR);

			} catch(Exception ex){
				ex.printStackTrace();
				Debug.println("[QueryDefineShowEditHandler]Exception----->1" + ex);
				throw new WebException(ex);
			}

		} catch(Exception ex){
			Debug.println("[QueryDefineShowEditHandler]Exception----->2" + ex);
			throw new WebException(ex);
		}

		Debug.println("[QueryDefineShowEditHandler]-----processEvent END!");
		return handlerEvent;
	}

	/**
	 *得到页面参数
	 * @param request
	 * @return HashMap
	 * @throws AppException
	 */
	/*
		 private HashMap getPageElement(HttpServletRequest request) throws
		AppException{
		String strtemp;
		int i;
		HashMap strParment = new HashMap();
		ArrayList sub = new ArrayList();
		//得到参数群
		Enumeration e;
		e = request.getParameterNames();
		for(i = 0;e.hasMoreElements();i++){
			strtemp = (e.nextElement()).toString();
			sub = new ArrayList();
			sub.add(strtemp); // namefield
			strtemp = request.getParameter(strtemp);
			try{
				strtemp = PubFunc.decodeISO(strtemp);
				//Debug.println("[QueryDefineShowEditHandler]--->>>getPageElementValue====" + strtemp);
			} catch(Exception ex){}
			sub.add(strtemp); // namevalue
			strParment.put((Object) (new Integer(i)),sub);
		}
		return strParment;
		 }
	 */

	/**
	 * 截取字段名
	 * @param str  带表名的页面字段名 gsgsjin_basis02_field001
	 * @return  String  不带表名的用于SQL的字段名 field001
	 * @throws AppException
	 * @author glt
	 */
	private String getFieldName(String str) throws
		AppException{
		str = str.substring(str.indexOf("field"),str.indexOf("field") + 8);
		return str;
	}

	/**
	 * 判断是否是空记录
	 * @param  str
	 * @return  String
	 * @exception AppException
	 * @author glt
	 */
	private String getInsertOrNot(String str) throws
		AppException{
		String returnStr = "";
		StringTokenizer subTokenizer = new StringTokenizer(str,"'");
		try{
			while(subTokenizer.hasMoreTokens()){
				String temp = (String) (subTokenizer.nextToken());
				if(!",".equals(temp)){
					returnStr += temp;
				}
			}
			if(!"".equals(returnStr)){
				returnStr = str;
			}
		} catch(Exception ex){
			Debug.print("");
		}
		return returnStr;
	}
}