Esempio n. 1
0
  @ResponseBody
  @RequestMapping(
      value = "/map/{xmlName}/{sheetName}/{requiredField}",
      method = RequestMethod.GET,
      params = {"fld", "val"})
  public List<Map<String, String>> queryAnyFile(
      @PathVariable String sheetName,
      @PathVariable String xmlName,
      @RequestParam(value = "fld", required = false) String[] queryFlds,
      @RequestParam(value = "val", required = false) String[] queryVals,
      @PathVariable String requiredField) {

    try {
      StringBuffer buf = new StringBuffer();
      for (int idx = 0; idx < queryFlds.length; idx++) {
        buf.append(
            queryFlds[idx].replaceAll("%20", " ")
                + AppConstants.QUERY_EQUALS_EXP
                + queryVals[idx].replaceAll("%20", " "));
        if (idx != (queryFlds.length - 1)) {
          buf.append(AppConstants.QUERY_CONCAT_EXP);
        }
      }
      reader_node_1.changeXmlDataSource(xmlName);

      return reader.queryAbstractElementDoc_List(
          sheetName.toString(), buf.toString(), requiredField);
    } catch (Exception e) {
      e.printStackTrace();
      return new ArrayList<Map<String, String>>();
    }
  }
Esempio n. 2
0
  @ResponseBody
  @RequestMapping(
      value = "/{bookName}/{requiredField}",
      method = RequestMethod.GET,
      params = {"fld", "val"})
  public List<Map<String, String>> queryByParams(
      @PathVariable String bookName,
      @RequestParam(value = "fld", required = false) String[] queryFlds,
      @RequestParam(value = "val", required = false) String[] queryVals,
      @PathVariable String requiredField) {

    try {
      StringBuffer buf = new StringBuffer();
      for (int idx = 0; idx < queryFlds.length; idx++) {
        buf.append(
            queryFlds[idx].replaceAll("%20", " ")
                + AppConstants.QUERY_EQUALS_EXP
                + queryVals[idx].replaceAll("%20", " "));
        if (idx != (queryFlds.length - 1)) {
          buf.append(AppConstants.QUERY_CONCAT_EXP);
        }
      }
      reader.changeXmlDataSource(bookName);
      // Currently only single sheet xls is supported, 97-2003 format
      return reader.queryAbstractElementDoc_List("".toString(), buf.toString(), requiredField);
    } catch (Exception e) {
      e.printStackTrace();
      return new ArrayList<Map<String, String>>();
    }
  }