private static String translate(String original, String findChars, String replaceChars) { if (StringUtils.isNullOrEmpty(original) || StringUtils.isNullOrEmpty(findChars)) { return original;
/** * Format a string as a Java string literal. * * @param s the string to convert * @return the Java string literal */ protected static String quote(String s) { return StringUtils.quoteJavaString(s); }
@Override public String getSQL() { return StringUtils.quoteStringSQL(value); }
@Override public String getSQL() { String s; if (type == Value.CLOB) { s = getString(); return StringUtils.quoteStringSQL(s); } byte[] buff = getBytes(); s = StringUtils.convertBytesToHex(buff); return "X'" + s + "'"; }
@Override public String getCreateSQLForCopy(Table forTable, String quotedName) { StringBuilder buff = new StringBuilder("ALTER TABLE "); buff.append(forTable.getSQL()).append(" ADD CONSTRAINT "); if (forTable.isHidden()) { buff.append("IF NOT EXISTS "); } buff.append(quotedName); if (comment != null) { buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment)); } buff.append(" CHECK").append(StringUtils.enclose(expr.getSQL())) .append(" NOCHECK"); return buff.toString(); }
} else { String tmp = v.getString(); if (!StringUtils.isNullOrEmpty(separator) && !StringUtils.isNullOrEmpty(tmp)) { tmp = separator + tmp; break; case STRINGENCODE: result = ValueString.get(StringUtils.javaEncode(v0.getString()), database.getMode().treatEmptyStringsAsNull); break; case STRINGDECODE: result = ValueString.get(StringUtils.javaDecode(v0.getString()), database.getMode().treatEmptyStringsAsNull); break; break; case XMLCOMMENT: result = ValueString.get(StringUtils.xmlComment(v0.getString()), database.getMode().treatEmptyStringsAsNull); break; case XMLCDATA: result = ValueString.get(StringUtils.xmlCData(v0.getString()), database.getMode().treatEmptyStringsAsNull); break; case XMLSTARTDOC: result = ValueString.get(StringUtils.xmlStartDoc(), database.getMode().treatEmptyStringsAsNull); break;
break; case STRINGENCODE: result = ValueString.get(StringUtils.javaEncode(v0.getString())); break; case STRINGDECODE: result = ValueString.get(StringUtils.javaDecode(v0.getString())); break; case STRINGTOUTF8: result = ValueBytes.getNoCopy(StringUtils.utf8Encode(v0.getString())); break; case UTF8TOSTRING: result = ValueString.get(StringUtils.utf8Decode(v0.getBytesNoCopy())); break; case XMLCOMMENT: result = ValueString.get(StringUtils.xmlComment(v0.getString())); break; case XMLCDATA: result = ValueString.get(StringUtils.xmlCData(v0.getString())); break; case XMLSTARTDOC: result = ValueString.get(StringUtils.xmlStartDoc()); break; case XMLTEXT: result = ValueString.get(StringUtils.xmlText(v0.getString())); break; case DAYNAME: {
int end = line.indexOf("*/"); String sql = line.substring(end + "*/".length()); sql = StringUtils.javaDecode(sql); line = line.substring("/*SQL".length(), end); if (line.length() > 0) {
@Override public String getSQL() { if (table == null) { return "*"; } return StringUtils.quoteIdentifier(table) + ".*"; }
/** * Get the alias name of a column or SQL expression * if it is not an aliased expression. * * @return the alias name */ public String getAlias() { return StringUtils.unEnclose(getSQL()); }
@Override public String toString() { return StringUtils.addAsterisk(sqlCommand, parseIndex); } }
/** * Convert a byte array to a hex encoded string. * * @param value the byte array * @return the hex encoded string */ public static String convertBytesToHex(byte[] value) { return convertBytesToHex(value, value.length); }
private static String[] split(String s) { String[] list = new String[10]; String[] t = StringUtils.arraySplit(s, ' ', true); System.arraycopy(t, 0, list, 0, t.length); for (int i = 0; i < list.length; i++) { if ("null".equals(list[i])) { list[i] = null; } } return list; }
String getString() { return StringUtils.arrayCombine(new String[] { name, driver, url, user }, '|'); }
private void readSettingsFromURL() { DbSettings defaultSettings = DbSettings.getDefaultSettings(); int idx = url.indexOf(';'); if (idx >= 0) { String settings = url.substring(idx + 1); url = url.substring(0, idx); String[] list = StringUtils.arraySplit(settings, ';', false); for (String setting : list) { if (setting.length() == 0) { continue; } int equal = setting.indexOf('='); if (equal < 0) { throw getFormatException(); } String value = setting.substring(equal + 1); String key = setting.substring(0, equal); key = StringUtils.toUpperEnglish(key); if (!isKnownSetting(key) && !defaultSettings.containsKey(key)) { throw DbException.get(ErrorCode.UNSUPPORTED_SETTING_1, key); } String old = prop.getProperty(key); if (old != null && !old.equals(value)) { throw DbException.get(ErrorCode.DUPLICATE_PROPERTY_1, key); } prop.setProperty(key, value); } } }
DatabaseMetaData meta = conn.getMetaData(); ResultSet rs = meta.getColumns(null, StringUtils.escapeMetaDataPattern(schemaName), StringUtils.escapeMetaDataPattern(tableName), null); ArrayList<String> columnList = New.arrayList(); columns = columnList.toArray(new String[0]); rs = meta.getColumns(null, StringUtils.escapeMetaDataPattern(schemaName), StringUtils.escapeMetaDataPattern(tableName), null); for (int i = 0; rs.next(); i++) { StringUtils.escapeMetaDataPattern(schemaName), tableName); while (rs.next()) { if (cols != null) { Collections.addAll(indexList, StringUtils.arraySplit(cols, ',', true));
String[] keyValuePairs = StringUtils.arraySplit(options, ' ', false); for (String pair : keyValuePairs) { if (pair.length() == 0) { String key = StringUtils.trim(pair.substring(0, index), true, true, " "); String value = pair.substring(index + 1); char ch = value.length() == 0 ? 0 : value.charAt(0);
scriptWriter.println(StringUtils.javaDecode(sql));
@Override public String getSQL() { String s; if (type == Value.CLOB) { s = getString(); return StringUtils.quoteStringSQL(s); } byte[] buff = getBytes(); s = StringUtils.convertBytesToHex(buff); return "X'" + s + "'"; }
private static String translate(String key, String... params) { String message = null; if (MESSAGES != null) { // Tomcat sets final static fields to null sometimes message = MESSAGES.getProperty(key); } if (message == null) { message = "(Message " + key + " not found)"; } if (params != null) { for (int i = 0; i < params.length; i++) { String s = params[i]; if (s != null && s.length() > 0) { params[i] = StringUtils.quoteIdentifier(s); } } message = MessageFormat.format(message, (Object[]) params); } return message; }