convert.java

ext2+spring+hibernate+dwr做的小系统

package com.newsoft.util;

import java.util.Collection;
import java.util.Iterator;

import javax.servlet.http.HttpServletRequest;
import org.hibernate.Query;


/**
 * Company: newsoft
 * @author davi
 * @version 1.0
 */
public class Convert {

	public String sql = null;

	public HttpServletRequest request = null;

	public String String(String s) {
		if (s == null || s.equals("") || s.equals("null"))
			return " ";
		return s;
	}

	public Long Long(String s) {
		s = s.trim();
		if (s == null || s.equals("") || s.equals("null")) {
			return new Long(0);
		}
		return new Long(s);
	}

	public Double Double(String s) {
		s = s.trim();
		if (s == null || s.equals("") || s.equals("null"))
			return new Double(0);
		return new Double(s);
	}

	public Integer Integer(String s) {
		s = s.trim();
		if (s.indexOf(".") >= 0)
			s = s.substring(0, s.indexOf("."));
		if (s == null || s.equals("") || s.equals("null"))
			return new Integer(0);
		return new Integer(s);
	}

	public Query getParams(Query query, String[] params) {
		if (params != null) {
			for (int i = 0; i < params.length; i++) {
				query.setParameter(i, params[i]);
			}
		}
		return query;
	}

	public Query getParams(Query query, String[][] params) {
		if (params != null) {
			String[] pValue = params[0];// 参数值
			String[] pType = params[1]; // 参数值类型
			for (int i = 0; i < pValue.length; i++) {
				if (pType[i].equals("String")) {
					query.setParameter(i, String(pValue[i]));
				} else if (pType[i].equals("Long") || pType[i].equals("Integer")) {
					query.setParameter(i, Long(pValue[i]));
				} else if (pType[i].equals("Double")) {
					query.setParameter(i, Double(pValue[i]));
				} else if (pType[i].equals("Date")) {
					query.setParameter(i, pValue[i]);//Date(pValue[i]));
				}
			}
		}
		return query;
	}

	public String[] contvertColumnName(String sql) {
		String colName = sql.substring(sql.indexOf("select") + 6, sql.lastIndexOf("from")).replaceAll("A.", "").replaceAll("B.", "").replaceAll("C.", "").replaceAll("D.", "");
		String[] colNameArray = colName.split(",");
		for (int i = 0; i < colNameArray.length; i++) {
			colNameArray[i] = colNameArray[i].indexOf(" as ") >= 0 ? colNameArray[i].split(" as ")[1] : colNameArray[i];
			colNameArray[i] = colNameArray[i].replaceAll(" ", "");
		}
		return colNameArray;
	}

	public String toXml(Collection rs, String sql, String totalCount,
			int pageStart, int pageSize) {
		return toXml(rs, sql, totalCount, pageStart, pageSize, null);
	}

	public String toXml(Collection rs, String sql, String totalCount,
			int pageStart, int pageSize, String Omissions) {
		String str = "";
		String[] colNameArray = this.contvertColumnName(sql);
		int _colNo = 1;
		int _pageNo = pageSize == 0 ? 0 : pageStart / pageSize;
		if (!rs.isEmpty()) {
			for (Iterator it = rs.iterator(); it.hasNext();) {
				String col = "";
				Object obj[] = (Object[]) it.next();
				for (int i = 0; i < colNameArray.length; i++) {
					if (Omissions == null || (i + "").indexOf(Omissions) < 0) {
						String tag = colNameArray[i];
						if (i == 0) {
							int no = _pageNo * pageSize + (_colNo++);
							col += "<" + tag + ">{'id':'" + obj[i]
									+ "', 'no':'" + no + "', 'pageNo':"
									+ (_pageNo + 1) + "}</" + tag + ">\n";
						} else {
							col += "<" + tag + ">" + (obj[i] + "").trim() + "</"
									+ tag + ">\n";
						}
					}
				}
				str += "<rows>\n" + col + "</rows>\n";
			}
		}
		str = "<root>\n<TotalCount>" + totalCount + "</TotalCount>" + str
				+ "\n</root>";
		return str;
	}

	public String isEmpty(String input) {
		if (input == null || input.indexOf("null") >= 0)
			return "";
		else
			return input;
	}

	/**
	 * 从request中获得参数值
	 * 
	 * @return string
	 */
	public String getRequest(String parameter) {
		if (this.request == null)
			return "";
		return this.isEmpty(this.request.getParameter(parameter));
	}

	/**
	 * @param request
	 *            要设置的 request
	 */
	public void setRequest(HttpServletRequest request) {
		this.request = request;
	}

	public static void main(String[] args) {

	}
}