Exemplo n.º 1
0
 /** This method used to connect to the Conection pool */
 public void connect() throws ConnectException, RemoteException {
   try {
     conn = null;
     conn = dbconn.open();
     USFEnv.getLog().writeDebug("created db connection(), ref: " + conn.toString(), this, null);
   } catch (Exception e) {
     throw new ConnectException("Database connection failure");
   }
 }
Exemplo n.º 2
0
  /** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
  public void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {

    final DataTableRequestParam param = DataTablesParamUtility.getParam(request);

    String sEcho = param.sEcho;
    int iTotalRecords = 0; // total number of records (unfiltered)
    int iTotalDisplayRecords = 0; // value will be set when code filters companies by keyword
    // DBConnection dbconn = new DBConnection();
    ErateProducts erateProducts = new ErateProducts();
    HttpSession session = request.getSession();
    Connection conn = null;
    DBConn dbconn = new DBConn();
    if (conn == null) {
      conn = dbconn.open();
    }
    JSONArray data = new JSONArray(); // data that will be shown in the table
    try {
      iTotalRecords = erateProducts.getProductCount(conn);
    } catch (Exception e2) {
      // TODO Auto-generated catch block
      e2.printStackTrace();
    }
    // iTotalRecords = DataRepository.GetCompanies().size();
    // List<ProductDataDao> companies = new LinkedList<ProductDataDao>();
    List<ProductDataDao> companies = new LinkedList(Collections.nCopies(iTotalRecords, null));
    ProductDataDao dao = new ProductDataDao();
    System.out.println("company size" + DataRepository.GetCompanies().size());
    // for (int i=0;i<iTotalRecords;i++){
    // List arr ;

    boolean flag = false;
    String searchValue = param.sSearchKeyword.toLowerCase();
    //	System.out.println("testing search.."+param.sSearchKeyword.toLowerCase());
    USFEnv.getLog().writeDebug("testing search.." + param.sSearchKeyword.toLowerCase(), this, null);
    if (!searchValue.equals("")) {
      flag = true;

    } else {

    }
    String var = "NotInSearch";
    session.setAttribute("companySize", var);

    if (param.bSearchable[1] && flag) {
      try {
        dao = erateProducts.searchCRISProduct(param.sSearchKeyword.toLowerCase(), conn);

        if (dao.getProductCode() == null) {
          companies.clear();
        } else {
          session.removeAttribute("companySize");
          companies.clear();
          companies.add(dao);
          if (companies.size() > 0) {
            var = "inFilteredRecord";
            session.setAttribute("companySize", var);
          } else {
            var = "outSideFilteredRecord";
            session.setAttribute("companySize", var);
          }
          // session.setAttribute("companySize",companies.size());
        }
        //	iTotalDisplayRecords1 =companies.size();
      } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }
      if (dao.getProductCode() != null) {
        // boolean flag= true;
        // companies.add(dao);
      }
    }

    //	boolean flag = false;

    /*	if(	param.bSearchable[1])  {
    	try {
    		dao = dbconn.searchProduct(param.sSearchKeyword.toLowerCase());
    	} catch (Exception e) {
    		// TODO Auto-generated catch block
    		e.printStackTrace();
    	}
    	if(dao.getProductCode()!=null ){
    	boolean flag= true;
    	companies.add(dao);
    	}
    }*/
    //	param.sSearchKeyword.toLowerCase()
    // if(	param.bSearchable[1] &&
    //	c.getName().toLowerCase().contains(param.sSearchKeyword.toLowerCase())
    //	|| param.bSearchable[2] &&
    // c.getAddress().toLowerCase().contains(param.sSearchKeyword.toLowerCase())
    //	|| param.bSearchable[3] &&
    // c.getTown().toLowerCase().contains(param.sSearchKeyword.toLowerCase()))

    // }

    /*for(ProductDataDao c : iTotalRecords){
    	//Cannot search by column 0 (id)
    	if(	param.bSearchable[1] &&
    		c.getName().toLowerCase().contains(param.sSearchKeyword.toLowerCase())
    		||
    		param.bSearchable[2] &&
    		c.getAddress().toLowerCase().contains(param.sSearchKeyword.toLowerCase())
    		||
    		param.bSearchable[3] &&
    		c.getTown().toLowerCase().contains(param.sSearchKeyword.toLowerCase()))
    	{
    	//	companies.add(c); // Add a company that matches search criterion
    	}
    }*/

    try {
      iTotalDisplayRecords = erateProducts.getProductCount(conn);
      USFEnv.getLog().writeDebug("iTotalDisplayRecords" + iTotalDisplayRecords, this, null);
      //	System.out.println("iTotalDisplayRecords"+iTotalDisplayRecords);
    } catch (Exception e2) {
      // TODO Auto-generated catch block
      e2.printStackTrace();
    }
    // iTotalDisplayRecords = companies.size();//Number of companies that matches search criterion
    // should be returned
    USFEnv.getLog()
        .writeDebug(
            " before param.iDisplayStart"
                + param.iDisplayStart
                + "companies.size()"
                + companies.size(),
            this,
            null);

    //	System.out.println(" before
    // param.iDisplayStart"+param.iDisplayStart+"companies.size()"+companies.size());
    if (companies.size() < param.iDisplayStart + param.iDisplayLength) {

      companies = companies.subList(param.iDisplayStart, companies.size());
    } else {
      try {
        // System.out.println(" after
        // param.iDisplayStart"+param.iDisplayStart+"param.iDisplayLength"+param.iDisplayLength);
        companies =
            erateProducts.getProductInfo(
                param.iDisplayStart, param.iDisplayStart + param.iDisplayLength, conn);
        System.out.println("after");
        try {
          if (conn != null) {
            conn.close();
          }
        } catch (Exception e) {
          // TODO: handle exception
        }

      } catch (Exception e1) {
        // TODO Auto-generated catch block
        e1.printStackTrace();
      }
    }
    // System.out.println(" after
    // param.iDisplayStart"+param.iDisplayStart+"param.iDisplayLength"+param.iDisplayLength);

    USFEnv.getLog()
        .writeDebug(
            " after param.iDisplayStart"
                + param.iDisplayStart
                + "param.iDisplayLength"
                + param.iDisplayLength,
            this,
            null);

    session.putValue("param.iDisplayStart", param.iDisplayStart);
    session.putValue("param.length", param.iDisplayStart + param.iDisplayLength);

    try {
      JSONObject jsonResponse = new JSONObject();

      jsonResponse.put("sEcho", sEcho);
      jsonResponse.put("iTotalRecords", iTotalRecords);
      jsonResponse.put("iTotalDisplayRecords", iTotalDisplayRecords);

      for (ProductDataDao c : companies) {
        JSONArray row = new JSONArray();
        row.put(c.getSeq_id())
            .put(c.getProductCode())
            .put(c.getDescription())
            .put(c.getModifiedBy())
            .put((new SimpleDateFormat("MM/dd/yyyy")).format((java.util.Date) c.getModifiedDate()));
        data.put(row);
      }
      jsonResponse.put("aaData", data);

      response.setContentType("application/json");
      response.getWriter().print(jsonResponse.toString());
    } catch (JSONException e) {
      e.printStackTrace();
      response.setContentType("text/html");
      response.getWriter().print(e.getMessage());
    } finally {
      try {
        conn.close();
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }
    }
  }