yhsearchhelper.java

企业进销存源码

package com.common.search;
import com.common.util.*;

import com.web.util.SQLTool;
import com.web.util.SearchPageHelper;
import java.io.PrintStream;
import javax.servlet.ServletRequest;
import javax.servlet.http.HttpServletRequest;

public class YhSearchHelper extends SearchPageHelper
{

    private String sqlStr;
    private String condition;
    private String order;

    public YhSearchHelper()
    {
        sqlStr = "select  * from yh ";
        condition = "";
    }

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