webutils.java

本文论述了一个前台笔记本销售系统的开发过程

package com.set.utils;

import java.io.*;
import java.net.*;
import java.sql.Statement;
import java.util.*;

import javax.servlet.*;
import javax.servlet.http.*;
import org.apache.log4j.*;
import com.mysql.jdbc.Connection;
import com.set.appframe.business.*;
import com.set.appframe.data.*;
import com.set.appframe.exception.*;
import com.set.db.*;
import com.set.system.business.*;
import com.set.system.model.*;
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.engine.base.*;
import net.sf.jasperreports.engine.data.*;
import net.sf.jasperreports.engine.export.*;
import net.sf.jasperreports.engine.util.*;
import com.set.appframe.business.SpringBeanFactory;

/**
 * <p>
 * Title: app frame work
 * </p>
 * <p>
 * Description:
 * </p>
 * <p>
 * Copyright: Copyright (c) 2004
 * </p>
 * <p>
 * Company: SET
 * </p>
 * 
 * @author zhifeng
 * @version 1.0
 */

public class WebUtils {

	private static Logger logger = Logger.getLogger("WebUtils");

	public WebUtils() {
	}

	/**
	 * note that in the name-value pair,the name must be upper case it dosen't
	 * trim the string by default
	 * 
	 * @param request
	 *            HttpServletRequest
	 * @return Hashtable
	 */
	public static Hashtable convertEnumeration(HttpServletRequest request) {
		return convertEnumeration(request, false);
	}

	/**
	 * note that in the name-value pair,the name must be upper case
	 * 
	 * @param request
	 *            HttpServletRequest
	 * @param isTrim
	 *            boolean
	 * @return Hashtable
	 */
	public static Hashtable convertEnumeration(HttpServletRequest request,
			boolean isTrim) {
		return convertEnumeration(request, true, isTrim);
	}

	/**
	 * 
	 * @param request
	 *            HttpServletRequest
	 * @param uppercase
	 *            boolean, determine if the key be uppercased
	 * @return Hashtable
	 */
	public static Hashtable convertEnumeration(HttpServletRequest request,
			boolean uppercase, boolean isTrim) {
		Hashtable ht = new Hashtable();
		Enumeration names = request.getParameterNames();
		String values[];
		if (null != names) {
			for (; names.hasMoreElements();) {
				String name = (String) names.nextElement();
				values = request.getParameterValues(name);
				if (uppercase) {
					name = name.toUpperCase();
				}
				if (null != values) {
					if (values.length == 1) {
						String tpValue = values[0];
						if (isTrim) {
							tpValue = tpValue.trim();
						}
						ht.put(name, tpValue);
					} else {
						ht.put(name, toList(values, isTrim));

						// System.out.println(name + "--->" + values[0]);
					}
				}
			}
		}
		return ht;

	}

	/**
	 * 计算页面的上一页，下一页，第一页，最后一页，第n页，并搜索相应页数的记录
	 * 修改：修改了totalPage参数的取值，第三个参数已经不用，需refactor ----zzf (2004-12-19)
	 */
	// 注意：由于子网中分页模式（jsp）和总网分页模式有区别，总网中用ctlPageNo表示当前页，而子网中使用intPageNo表示(zhifeng
	// 2004-12-5)
	public static int getpageNo(HttpServletRequest request, String ActionID,
			int totalPage) {
		int intPageNo = 1;

		if (request.getParameter("ctlPageNo") != null) { // 总网分页
			intPageNo = Integer.parseInt((String) request
					.getParameter("ctlPageNo"));
		} else if (request.getParameter("CTLPAGENO") != null) { // 总网分页
			intPageNo = Integer.parseInt((String) request
					.getParameter("CTLPAGENO"));
		} else if (request.getParameter("intPageNo") != null) { // 子网分页
			intPageNo = Integer.parseInt((String) request
					.getParameter("intPageNo"));
		} else if (request.getParameter("INTPAGENO") != null) { // 子网分页
			intPageNo = Integer.parseInt((String) request
					.getParameter("INTPAGENO"));
		}

		totalPage = StringUtils.toInteger(request.getParameter("ctlTotalPage"),
				0);

		if (ActionID != null) {
			if (ActionID.equals("search")) {
				intPageNo = 1;
			} else if (ActionID.equals("PreviousPage")) {
				if (intPageNo > 1) {
					intPageNo--;
				}
			} else if (ActionID.equals("FirstPage")) {
				intPageNo = 1;
			} else if (ActionID.equals("LastPage")) {
				intPageNo = totalPage;
			} else if (ActionID.equals("NextPage")) {
				if (intPageNo < totalPage) {
					intPageNo++;
				}
			} else if (ActionID.equals("GoPageNo")) {
				if (null != request.getParameter("ctlGoPageNo")) {
					intPageNo = Integer.parseInt(request
							.getParameter("ctlGoPageNo"));
				} else {
					intPageNo = Integer.parseInt(request
							.getParameter("ctlPageNo"));
				}
			}
		}
		return intPageNo;

	}

	public static String getDropDownList(Hashtable ht) {
		if (null == ht) {
			return "";
		}
		StringBuffer buffer = new StringBuffer();
		Enumeration set = ht.keys();
		while (set.hasMoreElements()) {
			Object obj = set.nextElement();
			buffer.append("<option value='").append((String) obj).append("'>")
					.append(ht.get(obj)).append("</option>");
		}
		return buffer.toString();
	}

	public static List getUserListByTeamID(String teamsId) {
		Vector params = new Vector();
		List dblist = null;

		params.add(teamsId);
		try {
			dblist = DBAccessHelper.QueryCmd(params,
					"OT_Q_SYSTEMUSERINFOBYTEAMID");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return dblist;
	}

	public static List getUserListByOrgID(String orgid, boolean flag) {
		Vector params = new Vector();
		List dblist = null;

		String sqlFile = "OT_Q_SYSTEMUSERINFOBYORGID_NEW";
		if (!flag) {
			sqlFile = "OT_Q_SYSTEMUSERINFOBYORGID_EDIT";
		}
		params.add(orgid);
		try {
			dblist = DBAccessHelper.QueryCmd(params, sqlFile);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return dblist;
	}

	/**
	 * 从GVO 列表中取出其中的两个field生成下拉列表html字符串
	 * 
	 * @param ht
	 *            List
	 * @param keyField
	 *            String
	 * @param valueField
	 *            String
	 * @return String
	 */
	public static String getDropDownList(List ht, String keyField,
			String valueField) {
		if (null == ht) {
			return "";
		}
		StringBuffer buffer = new StringBuffer();
		Iterator set = ht.iterator();
		GenericValueObject temp;
		String key, value;
		while (set.hasNext()) {
			Object obj = set.next();
			if (obj instanceof GenericValueObject) {
				temp = (GenericValueObject) obj;
				key = temp.getItemString(keyField);
				if (!"".equals(temp)) {
					value = temp.getItemString(valueField);
					String isDefault = temp.getItemString("ISDEFAULT");
					if (isDefault.equals("1")) {

						buffer.append("<option value=\"").append(key).append(
								"\" selected").append(">").append(value)
								.append("</option>");
					} else {
						buffer.append("<option value=\"").append(key).append(
								"\">").append(value).append("</option>");
					}
				}
			}
		}
		return buffer.toString();
	}

	public static String getWapDropDownList(List ht, String keyField,
			String valueField) {
		if (null == ht) {
			return "";
		}
		StringBuffer buffer = new StringBuffer();
		Iterator set = ht.iterator();
		GenericValueObject temp;
		String key, value;
		while (set.hasNext()) {
			Object obj = set.next();
			if (obj instanceof GenericValueObject) {
				temp = (GenericValueObject) obj;
				key = temp.getItemString(keyField);
				if (!"".equals(temp)) {
					value = temp.getItemString(valueField);
					String isDefault = temp.getItemString("ISDEFAULT");
					if (isDefault.equals("1")) {

						buffer.append("<option  value=\"").append(key).append(
								"\">").append(value).append("</option>");
					} else {
						buffer.append("<option value=\"").append(key).append(
								"\">").append(value).append("</option>");
					}
				}
			}
		}

		return buffer.toString();

	}

	public static String formatContent(String content) {
		if (content == null) {
			return "";
		}
		String randomStr = String.valueOf(System.currentTimeMillis());
		String html = StringUtils.replace(content, "&nbsp;", randomStr);
		html = StringUtils.replace(html, "&", "&amp;");
		html = StringUtils.replace(html, "'", "&apos;");
		html = StringUtils.replace(html, "\"", "&quot;");
		html = StringUtils.replace(html, "\t", "&nbsp;&nbsp;"); // 替换跳格
		html = StringUtils.replace(html, " ", "&nbsp;"); // 替换空格
		html = StringUtils.replace(html, "<", "&lt;");
		html = StringUtils.replace(html, ">", "&gt;");
		html = StringUtils.replace(html, "\n", "<br/>"); // 替换换行
		html = StringUtils.replace(html, "$", "$$");
		// html = StringUtils.replace(html, "-", "&shy;");
		String retval = "";
		try {
			retval = StringUtils.replace(html, randomStr, "&nbsp;").trim();
			retval = content;
			// retval=new String(retval.getBytes("UTF-8"));
		} catch (Exception ex) {
			ex.printStackTrace();

		}

		return retval;
	}

	public static String getComboxList(String name, List ht, String keyField,
			String valueField) {
		return getSelectList(name, ht, keyField, valueField, "checkbox");
	}

	public static String getComboxList(String name, List ht, String keyField,
			String valueField, String onClick) {
		return getSelectList(name, ht, keyField, valueField, "checkbox",
				onClick);
	}

	public static String getComboxList(String name, List ht, String keyField,
			String valueField, int i) {
		return getSelectList(name, ht, keyField, valueField, "checkbox", i);
	}

	public static String getRadioList(String name, List ht, String keyField,
			String valueField) {
		return getSelectList(name, ht, keyField, valueField, "radio");
	}

	public static String getSelectList(String name, List ht, String keyField,
			String valueField, String type) {
		if (null == ht) {
			return "";
		}
		StringBuffer buffer = new StringBuffer();
		Iterator set = ht.iterator();
		GenericValueObject temp;
		String key, value;
		while (set.hasNext()) {
			Object obj = set.next();
			if (obj instanceof GenericValueObject) {
				temp = (GenericValueObject) obj;
				key = temp.getItemString(keyField);
				if (!"".equals(temp)) {
					value = temp.getItemString(valueField);
					String isDefault = temp.getItemString("ISDEFAULT");
					buffer.append("<input name='").append(name).append(
							"' type='").append(type).append("' id='").append(
							name).append("' value='").append(key).append("'");
					if (!"".equals(isDefault) && "1".equals(isDefault)) {
						buffer.append(" checked");
					}
					buffer.append(">");
					buffer.append(value);
				}
			}
		}
		return buffer.toString();
	}

	public static String getSelectList(String name, List ht, String keyField,
			String valueField, String type, int i) {
		if (null == ht) {
			return "";
		}
		StringBuffer buffer = new StringBuffer();
		Iterator set = ht.iterator();
		GenericValueObject temp;
		String key, value;
		int j = 0;