gzrzsearchhelper.java

企业进销存源码

package com.common.search;

import javax.servlet.http.HttpServletRequest;

import com.common.util.Chinese;
import com.web.util.SQLTool;

import com.web.util.SearchPageHelper;

public class GzrzSearchHelper extends SearchPageHelper {
	    private String sqlStr;
	    private String condition;
	    private String order;
	    
	public GzrzSearchHelper(){
		sqlStr = "select * from gzrz";
		condition = "";
	}

	public String getSqlStr(HttpServletRequest request) {
		condition = SQLTool.getSelectWhereClause(SQLTool.STRING,condition,"dates","=",Chinese.toChinese(request.getParameter("name")));
		if (!condition.equals("")) {
			sqlStr = sqlStr + " and " + condition;
		}
        return sqlStr;
    }
	}