Java Code Examples for org.apache.commons.lang.StringUtils#indexOfIgnoreCase()

The following examples show how to use org.apache.commons.lang.StringUtils#indexOfIgnoreCase() . These examples are extracted from open source projects. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may want to check out the right sidebar which shows the related API usage.
Example 1
Source Project: pentaho-kettle   File: SftpFileSystemWindows.java    License: Apache License 2.0 6 votes vote down vote up 
/**
 * cut user groups from output whoami
 *
 * @param commandOutput output from whoami
 * @return list of user groups
 */
private List<String> getUserGroups( String commandOutput ) {
  List<String> result = new ArrayList<>();
  int startIndex = 0;
  int endIndex;
  while ( true ) {

    startIndex = StringUtils.indexOfIgnoreCase( commandOutput, GROUP_NAME, startIndex );
    if ( startIndex < 0 ) {
      return result;
    }
    startIndex += GROUP_NAME.length();
    endIndex = StringUtils.indexOfIgnoreCase( commandOutput, RN_DELIMITER, startIndex );
    if ( endIndex < 0 ) {
      return result;
    }
    result.add( commandOutput.substring( startIndex, endIndex ).toUpperCase().trim() );
  }
}
Example 2
Source Project: jeecg-cloud   File: FreemarkerParseFactory.java    License: Apache License 2.0 5 votes vote down vote up 
/**
 * 除去无效字段，去掉注释 不然批量处理可能报错 去除无效的等于
 */
private static String getSqlText(String sql) {
    // 将注释替换成""
    sql = p.matcher(sql).replaceAll("");
    sql = sql.replaceAll("\\n", " ").replaceAll("\\t", " ")
            .replaceAll("\\s{1,}", " ").trim();
    // 去掉 最后是 where这样的问题
    if (sql.endsWith("where") || sql.endsWith("where ")) {
        sql = sql.substring(0, sql.lastIndexOf("where"));
    }
    // 去掉where and 这样的问题
    int index = 0;
    while ((index = StringUtils.indexOfIgnoreCase(sql, "where and", index)) != -1) {
        sql = sql.substring(0, index + 5)
                + sql.substring(index + 9, sql.length());
    }
    // 去掉 , where 这样的问题
    index = 0;
    while ((index = StringUtils.indexOfIgnoreCase(sql, ", where", index)) != -1) {
        sql = sql.substring(0, index)
                + sql.substring(index + 1, sql.length());
    }
    // 去掉 最后是 ,这样的问题
    if (sql.endsWith(",") || sql.endsWith(", ")) {
        sql = sql.substring(0, sql.lastIndexOf(","));
    }
    return sql;
}
Example 3
Source Project: teaching   File: FreemarkerParseFactory.java    License: Apache License 2.0 5 votes vote down vote up 
/**
 * 除去无效字段，去掉注释 不然批量处理可能报错 去除无效的等于
 */
private static String getSqlText(String sql) {
    // 将注释替换成""
    sql = p.matcher(sql).replaceAll("");
    sql = sql.replaceAll("\\n", " ").replaceAll("\\t", " ")
            .replaceAll("\\s{1,}", " ").trim();
    // 去掉 最后是 where这样的问题
    if (sql.endsWith("where") || sql.endsWith("where ")) {
        sql = sql.substring(0, sql.lastIndexOf("where"));
    }
    // 去掉where and 这样的问题
    int index = 0;
    while ((index = StringUtils.indexOfIgnoreCase(sql, "where and", index)) != -1) {
        sql = sql.substring(0, index + 5)
                + sql.substring(index + 9, sql.length());
    }
    // 去掉 , where 这样的问题
    index = 0;
    while ((index = StringUtils.indexOfIgnoreCase(sql, ", where", index)) != -1) {
        sql = sql.substring(0, index)
                + sql.substring(index + 1, sql.length());
    }
    // 去掉 最后是 ,这样的问题
    if (sql.endsWith(",") || sql.endsWith(", ")) {
        sql = sql.substring(0, sql.lastIndexOf(","));
    }
    return sql;
}
Example 4
Source Project: jeecg-boot   File: FreemarkerParseFactory.java    License: Apache License 2.0 5 votes vote down vote up 
/**
 * 除去无效字段，去掉注释 不然批量处理可能报错 去除无效的等于
 */
private static String getSqlText(String sql) {
    // 将注释替换成""
    sql = p.matcher(sql).replaceAll("");
    sql = sql.replaceAll("\\n", " ").replaceAll("\\t", " ")
            .replaceAll("\\s{1,}", " ").trim();
    // 去掉 最后是 where这样的问题
    if (sql.endsWith("where") || sql.endsWith("where ")) {
        sql = sql.substring(0, sql.lastIndexOf("where"));
    }
    // 去掉where and 这样的问题
    int index = 0;
    while ((index = StringUtils.indexOfIgnoreCase(sql, "where and", index)) != -1) {
        sql = sql.substring(0, index + 5)
                + sql.substring(index + 9, sql.length());
    }
    // 去掉 , where 这样的问题
    index = 0;
    while ((index = StringUtils.indexOfIgnoreCase(sql, ", where", index)) != -1) {
        sql = sql.substring(0, index)
                + sql.substring(index + 1, sql.length());
    }
    // 去掉 最后是 ,这样的问题
    if (sql.endsWith(",") || sql.endsWith(", ")) {
        sql = sql.substring(0, sql.lastIndexOf(","));
    }
    return sql;
}
Example 5
Source Project: sonar-css-plugin   File: CommentContainsPatternChecker.java    License: GNU Lesser General Public License v3.0 5 votes vote down vote up 
private static boolean isLetterAround(String line, String pattern) {
  int start = StringUtils.indexOfIgnoreCase(line, pattern);
  int end = start + pattern.length();

  boolean pre = start > 0 && Character.isLetter(line.charAt(start - 1));
  boolean post = end < line.length() - 1 && Character.isLetter(line.charAt(end));

  return pre || post;
}
Example 6
Source Project: sonar-gherkin-plugin   File: CommentContainsPatternChecker.java    License: GNU Lesser General Public License v3.0 5 votes vote down vote up 
private static boolean isLetterAround(String line, String pattern) {
  int start = StringUtils.indexOfIgnoreCase(line, pattern);
  int end = start + pattern.length();

  boolean pre = start > 0 && Character.isLetter(line.charAt(start - 1));
  boolean post = end < line.length() - 1 && Character.isLetter(line.charAt(end));

  return pre || post;
}
Example 7
Source Project: r2rml-parser   File: SelectQuery.java    License: Apache License 2.0 5 votes vote down vote up 
public ArrayList<SelectTable> createSelectTables(String q) {
	ArrayList<SelectTable> results = new ArrayList<SelectTable>();
	
	int start = q.toUpperCase().indexOf("FROM") + 4;
	ArrayList<String> tables = new ArrayList<String>();
	
	//split in spaces
	String tokens[] = q.substring(start).split("\\s+");
	
	//if there are aliases
	if (StringUtils.containsIgnoreCase(q.substring(start), " AS ")) {
		for (int i = 0; i < tokens.length; i++) {
			if ("AS".equalsIgnoreCase(tokens[i])) {
				if (tokens[i+1].endsWith(",")) {
					tokens[i+1] = tokens[i+1].substring(0, tokens[i+1].indexOf(",")); 
				}
				tables.add(tokens[i-1] + " " + tokens[i] + " " + tokens[i+1]);
			}
		}
	} else {
		//otherwise, split in commas
		int end = StringUtils.indexOfIgnoreCase(q, "WHERE");
		if (end == -1) end = q.length();
		tables = new ArrayList<String>(Arrays.asList(q.substring(start, end).split(",")));
	}
	
	for (String table : tables) {
		SelectTable selectTable = new SelectTable();
		selectTable.setName(table.trim());
		selectTable.setAlias(createAlias(selectTable.getName()).trim());
		log.info("Adding table with: name '" + selectTable.getName() + "', alias '" + selectTable.getAlias() + "'");
		results.add(selectTable);
	}
	return results;
}