thsearchhelper.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 ThSearchHelper extends SearchPageHelper
{

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

    public ThSearchHelper()
    {
        sqlStr = "select  a.* from Th a,goods b where a.goodsid=b.id  ";
        condition = "";
        order = " order by type";
    }

    public String getSqlStr(HttpServletRequest request)
    {        
        condition =SQLTool.getSelectWhereClause(SQLTool.STRING,condition,"b.name","like",Chinese.toChinese(request.getParameter("name")));
		condition =SQLTool.getSelectWhereClause(SQLTool.STRING,condition,"b.type","=",Chinese.toChinese(request.getParameter("type")));
		condition =SQLTool.getSelectWhereClause(SQLTool.STRING,condition,"outDate","=",Chinese.toChinese(request.getParameter("outDate")));
		//condition =SQLTool.getSelectWhereClause(SQLTool.STRING,condition,"c.name","like",Chinese.toChinese(request.getParameter("clientName")));
		//condition =SQLTool.getSelectWhereClause(SQLTool.STRING,condition,"c.type","=",Chinese.toChinese(request.getParameter("clientType")));
		
		if (!condition.equals("")) {
			sqlStr = sqlStr + " and " + condition +order;
		}
		System.out.println(sqlStr);
        return sqlStr;
    }
}