/**
  * Converts connection properties to a String to be passed to the mappers.
  *
  * @param properties JDBC connection parameters
  * @return String to be passed to configuration
  */
 protected static String propertiesToString(Properties properties) {
   List<String> propertiesList = new ArrayList<String>(properties.size());
   for (Entry<Object, Object> property : properties.entrySet()) {
     String key = StringEscapeUtils.escapeCsv(property.getKey().toString());
     if (key.equals(property.getKey().toString()) && key.contains("=")) {
       key = "\"" + key + "\"";
     }
     String val = StringEscapeUtils.escapeCsv(property.getValue().toString());
     if (val.equals(property.getValue().toString()) && val.contains("=")) {
       val = "\"" + val + "\"";
     }
     propertiesList.add(StringEscapeUtils.escapeCsv(key + "=" + val));
   }
   return StringUtils.join(propertiesList, ',');
 }
Example #2
0
  /** 5、字符串的Escape */
  @Test
  public void test5() {
    System.out.println(StringEscapeUtils.escapeCsv("测试测试哦")); // "测试测试哦"
    System.out.println(StringEscapeUtils.escapeCsv("测试,测试哦")); // "\"测试,测试哦\""
    System.out.println(StringEscapeUtils.escapeCsv("测试\n测试哦")); // "\"测试\n测试哦\""

    System.out.println(StringEscapeUtils.escapeHtml("测试测试哦")); // "<p>测试测试哦</p>"
    System.out.println(
        StringEscapeUtils.escapeJava(
            "\"rensaninng\",欢迎您!")); // "\"rensaninng\"\uFF0C\u6B22\u8FCE\u60A8\uFF01"

    // System.out.println(StringEscapeUtils.escapeEcmaScript("测试'测试哦"));//"\u6D4B\u8BD5\'\u6D4B\u8BD5\u54E6"
    System.out.println(
        StringEscapeUtils.escapeXml(
            "<tt>\"bread\" & \"butter\"</tt>")); // "<tt>"bread" &amp; "butter"</tt>"
  }
  private String getCoPIsPerYearCSVContent(Map<String, Set<Collaborator>> yearToCoPI) {

    StringBuilder csvFileContent = new StringBuilder();

    csvFileContent.append("Year, Count, Co-investigator(s)\n");

    for (Map.Entry<String, Set<Collaborator>> currentEntry : yearToCoPI.entrySet()) {

      csvFileContent.append(StringEscapeUtils.escapeCsv(currentEntry.getKey()));
      csvFileContent.append(",");
      csvFileContent.append(currentEntry.getValue().size());
      csvFileContent.append(",");
      csvFileContent.append(
          StringEscapeUtils.escapeCsv(getCoPINamesAsString(currentEntry.getValue())));
      csvFileContent.append("\n");
    }

    return csvFileContent.toString();
  }
 protected String escapeQuotes(final String input) {
   final String[] splitedInput = StringUtils.splitPreserveAllTokens(input, SEMICOLON_CHAR);
   final List<String> tmp = new ArrayList<String>();
   for (final String string : splitedInput) {
     if (doesNotContainNewLine(string)) {
       tmp.add(StringEscapeUtils.escapeCsv(string));
     } else {
       tmp.add(string);
     }
   }
   return StringUtils.join(tmp, SEMICOLON_CHAR);
 }
Example #5
0
 /**
  * Returns a <code>String</code> value for a CSV column enclosed in double quotes, if required.
  *
  * <p>If the value contains a comma, newline or double quote, then the String value is returned
  * enclosed in double quotes.
  *
  * <p>Any double quote characters in the value are escaped with another double quote.
  *
  * <p>If the value does not contain a comma, newline or double quote, then the String value is
  * returned unchanged. see <a
  * href="http://en.wikipedia.org/wiki/Comma-separated_values">Wikipedia</a> and <a
  * href="http://tools.ietf.org/html/rfc4180">RFC 4180</a>.
  *
  * @param str the input CSV column String, may be null
  * @return the input String, enclosed in double quotes if the value contains a comma, newline or
  *     double quote, <code>null</code> if null string input
  * @since 2.4
  */
 public static String escapeCsv(String str) {
   if (StringUtils.containsNone(str, CSV_SEARCH_CHARS)) {
     return str;
   }
   try {
     StringWriter writer = new StringWriter();
     escapeCsv(writer, str);
     return writer.toString();
   } catch (IOException ioe) {
     // this should never ever happen while writing to a StringWriter
     throw new UnhandledException(ioe);
   }
 }
  private String getCoPIsListCSVContent(CollaborationData coPIData) {

    StringBuilder csvFileContent = new StringBuilder();

    csvFileContent.append("Co-investigator, Count\n");

    for (Collaborator currNode : coPIData.getCollaborators()) {

      /*
       * We have already printed the Ego Node info.
       * */
      if (currNode != coPIData.getEgoCollaborator()) {

        csvFileContent.append(StringEscapeUtils.escapeCsv(currNode.getCollaboratorName()));
        csvFileContent.append(",");
        csvFileContent.append(currNode.getNumOfActivities());
        csvFileContent.append("\n");
      }
    }

    return csvFileContent.toString();
  }
Example #7
0
 public static String escapeCsv(String string) {
   return string == null ? null : StringEscapeUtils.escapeCsv(string);
 }