SelectListInputクラスサンプルプログラム

package jp.co.ulsystems.xmldb.input

import javax.servlet.http.HttpServletRequest;

public class SelectListInput {
   private String customer;
   private String title;
   private String location;
   private String charge;

   public void evaluateParams(HttpServletRequest request) throws Exception {
      customer = (String)request.getParameter("customer");
      title = (String)request.getParameter("title");
      location = (String)request.getParameter("location");
      charge = (String)request.getParameter("charge");
   }

   public String createWhere() {
      String where = "";
      //入力された条件からwhrere句の文字列取得
      // 検索条件：お客様名
      if(!customer.equals("")){
         where = " where " + "contains($customer/text(),'" + customer + "')";
      }
      // 検索条件：提案タイトル
      if(!title.equals("")){
         if(where.equals("")){
            where += " where " + "contains($title/text(),'" + title + "')";
         }else{
            where += " and " + "contains($title/text(),'" + title + "')";
         }
      }
      // 検索条件：営業拠点
      if(!location.equals("")){
         if(where.equals("")){
            where += " where " + "contains($location/text(),'" + location + "')";
         }else{
            where += " and " + "contains($location/text(),'" + location + "')";
         }
      }
      // 検索条件：担当営業者
      if(!charge.equals("")){
         if(where.equals("")){
            where += " where " + "contains($charge/text(),'" + charge + "')";
         }else{
            where += " and " + "contains($charge/text(),'" + charge + "')";
         }
      }
      return where;
   }
}