Java StringUtils.quoteIdentifier方法代码示例

import org.h2.util.StringUtils; //导入方法依赖的package包/类
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;
}
 

import org.h2.util.StringUtils; //导入方法依赖的package包/类
/**
 * Remove all triggers that start with the given prefix.
 *
 * @param conn the database connection
 * @param prefix the prefix
 */
protected static void removeAllTriggers(Connection conn, String prefix)
        throws SQLException {
    Statement stat = conn.createStatement();
    ResultSet rs = stat.executeQuery("SELECT * FROM INFORMATION_SCHEMA.TRIGGERS");
    Statement stat2 = conn.createStatement();
    while (rs.next()) {
        String schema = rs.getString("TRIGGER_SCHEMA");
        String name = rs.getString("TRIGGER_NAME");
        if (name.startsWith(prefix)) {
            name = StringUtils.quoteIdentifier(schema) + "." +
                    StringUtils.quoteIdentifier(name);
            stat2.execute("DROP TRIGGER " + name);
        }
    }
}
 

import org.h2.util.StringUtils; //导入方法依赖的package包/类
private static void createOrDropTrigger(Connection conn,
        String schema, String table, boolean create) throws SQLException {
    Statement stat = conn.createStatement();
    String trigger = StringUtils.quoteIdentifier(schema) + "."
            + StringUtils.quoteIdentifier(TRIGGER_PREFIX + table);
    stat.execute("DROP TRIGGER IF EXISTS " + trigger);
    if (create) {
        StringBuilder buff = new StringBuilder("CREATE TRIGGER IF NOT EXISTS ");
        // needs to be called on rollback as well, because we use the init
        // connection do to changes in the index (not the user connection)
        buff.append(trigger).
            append(" AFTER INSERT, UPDATE, DELETE, ROLLBACK ON ").
            append(StringUtils.quoteIdentifier(schema)).
            append('.').
            append(StringUtils.quoteIdentifier(table)).
            append(" FOR EACH ROW CALL \"").
            append(FullText.FullTextTrigger.class.getName()).
            append('\"');
        stat.execute(buff.toString());
    }
}
 

import org.h2.util.StringUtils; //导入方法依赖的package包/类
/**
 * Add the existing data to the index.
 *
 * @param conn the database connection
 * @param schema the schema name
 * @param table the table name
 */
protected static void indexExistingRows(Connection conn, String schema,
        String table) throws SQLException {
    FullText.FullTextTrigger existing = new FullText.FullTextTrigger();
    existing.init(conn, schema, null, table, false, Trigger.INSERT);
    String sql = "SELECT * FROM " + StringUtils.quoteIdentifier(schema) +
            "." + StringUtils.quoteIdentifier(table);
    ResultSet rs = conn.createStatement().executeQuery(sql);
    int columnCount = rs.getMetaData().getColumnCount();
    while (rs.next()) {
        Object[] row = new Object[columnCount];
        for (int i = 0; i < columnCount; i++) {
            row[i] = rs.getObject(i + 1);
        }
        existing.fire(conn, null, row);
    }
}
 

import org.h2.util.StringUtils; //导入方法依赖的package包/类
private static void createOrDropTrigger(Connection conn,
        String schema, String table, boolean create) throws SQLException {
    Statement stat = conn.createStatement();
    String trigger = StringUtils.quoteIdentifier(schema) + "." +
            StringUtils.quoteIdentifier(TRIGGER_PREFIX + table);
    stat.execute("DROP TRIGGER IF EXISTS " + trigger);
    if (create) {
        StringBuilder buff = new StringBuilder(
                "CREATE TRIGGER IF NOT EXISTS ");
        // the trigger is also called on rollback because transaction
        // rollback will not undo the changes in the Lucene index
        buff.append(trigger).
            append(" AFTER INSERT, UPDATE, DELETE, ROLLBACK ON ").
            append(StringUtils.quoteIdentifier(schema)).
            append('.').
            append(StringUtils.quoteIdentifier(table)).
            append(" FOR EACH ROW CALL \"").
            append(FullTextLucene.FullTextTrigger.class.getName()).
            append('\"');
        stat.execute(buff.toString());
    }
}
 

import org.h2.util.StringUtils; //导入方法依赖的package包/类
/**
 * Add the existing data to the index.
 *
 * @param conn the database connection
 * @param schema the schema name
 * @param table the table name
 */
protected static void indexExistingRows(Connection conn, String schema,
        String table) throws SQLException {
    FullTextLucene.FullTextTrigger existing = new FullTextLucene.FullTextTrigger();
    existing.init(conn, schema, null, table, false, Trigger.INSERT);
    String sql = "SELECT * FROM " + StringUtils.quoteIdentifier(schema) +
            "." + StringUtils.quoteIdentifier(table);
    ResultSet rs = conn.createStatement().executeQuery(sql);
    int columnCount = rs.getMetaData().getColumnCount();
    while (rs.next()) {
        Object[] row = new Object[columnCount];
        for (int i = 0; i < columnCount; i++) {
            row[i] = rs.getObject(i + 1);
        }
        existing.insert(row, false);
    }
    existing.commitIndex();
}
 

import org.h2.util.StringUtils; //导入方法依赖的package包/类
/**
 * Add double quotes around an identifier if required.
 *
 * @param s the identifier
 * @return the quoted identifier
 */
public static String quoteIdentifier(String s) {
    if (s == null || s.length() == 0) {
        return "\"\"";
    }
    char c = s.charAt(0);
    // lowercase a-z is quoted as well
    if ((!Character.isLetter(c) && c != '_') || Character.isLowerCase(c)) {
        return StringUtils.quoteIdentifier(s);
    }
    for (int i = 1, length = s.length(); i < length; i++) {
        c = s.charAt(i);
        if ((!Character.isLetterOrDigit(c) && c != '_') ||
                Character.isLowerCase(c)) {
            return StringUtils.quoteIdentifier(s);
        }
    }
    if (isKeyword(s, true)) {
        return StringUtils.quoteIdentifier(s);
    }
    return s;
}
 

import org.h2.util.StringUtils; //导入方法依赖的package包/类
@Override
public String getSQL() {
    if (table == null) {
        return "*";
    }
    return StringUtils.quoteIdentifier(table) + ".*";
}