suppliertypesearchhelper.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 SupplierTypeSearchHelper extends SearchPageHelper
{

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

    public SupplierTypeSearchHelper()
    {
        sqlStr = "select  * from SupplierType ";
        condition = "";
        order = " order by type";
    }

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