Examples of StatementBuilder | massapi.com

Home Package Class Method

Examples of StatementBuilder

com.alibaba.wasp.util.StatementBuilder

A utility class to build a statement. In addition to the methods supported by StringBuilder, it allows to add a text only in the second iteration. This simplified constructs such as:

 StringBuilder buff = new StringBuilder(); for (int i = 0; i < args.length; i++) { if (i > 0) { buff.append(", "); } buff.append(args[i]); }

to

 StatementBuilder buff = new StatementBuilder(); for (String s : args) { buff.appendExceptFirst(", "); buff.append(a); }

com.google.api.ads.dfp.axis.utils.v201208.StatementBuilder
tatementBuilder.increaseOffsetBy(20); statement = statementBuilder.toStatement(); @author Adam Rogal
com.google.api.ads.dfp.axis.utils.v201211.StatementBuilder
tatementBuilder.increaseOffsetBy(20); statement = statementBuilder.toStatement(); @author Adam Rogal
com.google.api.ads.dfp.axis.utils.v201302.StatementBuilder
tatementBuilder.increaseOffsetBy(20); statement = statementBuilder.toStatement(); @author Adam Rogal
com.google.api.ads.dfp.axis.utils.v201306.StatementBuilder
tatementBuilder.increaseOffsetBy(20); statement = statementBuilder.toStatement(); @author Adam Rogal
com.google.api.ads.dfp.axis.utils.v201308.StatementBuilder
tatementBuilder.increaseOffsetBy(20); statement = statementBuilder.toStatement(); @author Adam Rogal
com.google.api.ads.dfp.axis.utils.v201311.StatementBuilder
tatementBuilder.increaseOffsetBy(20); statement = statementBuilder.toStatement(); @author Adam Rogal

com.google.api.ads.dfp.lib.utils.v201208.StatementBuilder

{@code StatementBuilder} allows for statements to be constructed in parts.

Typical usage is:

 StatementBuilder statementBuilder = new StatementBuilder("WHERE id = :id AND type = :type"); statementBuilder.putValue("id", 1234L).putValue("type", "Type"); Statement statement = statementBuilder.toStatement();

@author api.arogal@gmail.com (Adam Rogal)

com.google.api.ads.dfp.lib.utils.v201211.StatementBuilder

{@code StatementBuilder} allows for statements to be constructed in parts.

Typical usage is:

 StatementBuilder statementBuilder = new StatementBuilder("WHERE id = :id AND type = :type"); statementBuilder.putValue("id", 1234L).putValue("type", "Type"); Statement statement = statementBuilder.toStatement();

@author api.arogal@gmail.com (Adam Rogal)

com.google.api.ads.dfp.lib.utils.v201302.StatementBuilder

{@code StatementBuilder} allows for statements to be constructed in parts.

Typical usage is:

 StatementBuilder statementBuilder = new StatementBuilder("WHERE id = :id AND type = :type"); statementBuilder.putValue("id", 1234L).putValue("type", "Type"); Statement statement = statementBuilder.toStatement();

@author api.arogal@gmail.com (Adam Rogal)

com.google.api.ads.dfp.lib.utils.v201306.StatementBuilder

{@code StatementBuilder} allows for statements to be constructed in parts.

Typical usage is:

 StatementBuilder statementBuilder = new StatementBuilder("WHERE id = :id AND type = :type"); statementBuilder.putValue("id", 1234L).putValue("type", "Type"); Statement statement = statementBuilder.toStatement();

@author api.arogal@gmail.com (Adam Rogal)

com.google.api.ads.dfp.lib.utils.v201308.StatementBuilder

{@code StatementBuilder} allows for statements to be constructed in parts.

Typical usage is:

 StatementBuilder statementBuilder = new StatementBuilder("WHERE id = :id AND type = :type"); statementBuilder.putValue("id", 1234L).putValue("type", "Type"); Statement statement = statementBuilder.toStatement();

@author api.arogal@gmail.com (Adam Rogal)

com.google.api.ads.dfp.lib.utils.v201311.StatementBuilder

{@code StatementBuilder} allows for statements to be constructed in parts.

Typical usage is:

 StatementBuilder statementBuilder = new StatementBuilder("WHERE id = :id AND type = :type"); statementBuilder.putValue("id", 1234L).putValue("type", "Type"); Statement statement = statementBuilder.toStatement();

@author api.arogal@gmail.com (Adam Rogal)

com.redspr.redquerybuilder.core.client.util.StatementBuilder

A utility class to build a statement. In addition to the methods supported by StringBuilder, it allows to add a text only in the second iteration. This simplified constructs such as:

 StringBuilder buff = new StringBuilder(); for (int i = 0; i < args.length; i++) { if (i > 0) { buff.append(", "); } buff.append(args[i]); }

to

 StatementBuilder buff = new StatementBuilder(); for (String s : args) { buff.appendExceptFirst(", "); buff.append(a); }

net.mlw.vlh.adapter.hibernate.util.StatementBuilder
Utility for working with hibernate. @author Matthew L. Wilson, Andrej Zachar @version $Revision: 1.4 $ $Date: 2005/12/16 15:40:12 $
net.mlw.vlh.adapter.hibernate3.util.StatementBuilder
Utility for working with hibernate. @author Matthew L. Wilson, Andrej Zachar @version $Revision: 1.2 $ $Date: 2005/12/16 15:40:09 $
org.apache.whirr.service.jclouds.StatementBuilder

org.h2.jaqu.util.StatementBuilder

A utility class to build a statement. In addition to the methods supported by StringBuilder, it allows to add a text only in the second iteration. This simplified constructs such as:

 StringBuilder buff = new StringBuilder(); for (int i = 0; i < args.length; i++) { if (i > 0) { buff.append(", "); } buff.append(args[i]); }

to

 StatementBuilder buff = new StatementBuilder(); for (String s : args) { buff.appendExceptFirst(", "); buff.append(a); }

org.h2.util.StatementBuilder

A utility class to build a statement. In addition to the methods supported by StringBuilder, it allows to add a text only in the second iteration. This simplified constructs such as:

 StringBuilder buff = new StringBuilder(); for (int i = 0; i < args.length; i++) { if (i > 0) { buff.append(", "); } buff.append(args[i]); }

to

 StatementBuilder buff = new StatementBuilder(); for (String s : args) { buff.appendExceptFirst(", "); buff.append(a); }

org.lealone.util.StatementBuilder

A utility class to build a statement. In addition to the methods supported by StringBuilder, it allows to add a text only in the second iteration. This simplified constructs such as:

 StringBuilder buff = new StringBuilder(); for (int i = 0; i < args.length; i++) { if (i > 0) { buff.append(", "); } buff.append(args[i]); }

to

 StatementBuilder buff = new StatementBuilder(); for (String s : args) { buff.appendExceptFirst(", "); buff.append(a); }

org.skife.jdbi.v2.tweak.StatementBuilder
Used to convert translated SQL into a prepared statement. The default implementation created by {@link org.skife.jdbi.v2.CachingStatementBuilderFactory} caches all preparedstatements created against a given handle. A StatementBuilder is always associated with exactly one Handle instance @see StatementBuilderFactory

Examples of org.h2.util.StatementBuilder

                throw DbException.get(ErrorCode.CANNOT_DROP_TABLE_1, tableName);
            }
            if (dropAction == ConstraintReferential.RESTRICT) {
                ArrayList<TableView> views = table.getViews();
                if (views != null && views.size() > 0) {
                    StatementBuilder buff = new StatementBuilder();
                    for (TableView v : views) {
                        buff.appendExceptFirst(", ");
                        buff.append(v.getName());
                    }
                    throw DbException.get(ErrorCode.CANNOT_DROP_2, tableName, buff.toString());
                }
            }
            table.lock(session, true, true);
        }
        if (next != null) {

View Full Code Here

Examples of org.h2.util.StatementBuilder


    private DbException getSyntaxError() {
        if (expectedList == null || expectedList.size() == 0) {
            return DbException.getSyntaxError(sqlCommand, parseIndex);
        }
        StatementBuilder buff = new StatementBuilder();
        for (String e : expectedList) {
            buff.appendExceptFirst(", ");
            buff.append(e);
        }
        return DbException.getSyntaxError(sqlCommand, parseIndex, buff.toString());
    }

View Full Code Here

Examples of org.h2.util.StatementBuilder

        buff.append(" CALL ").append(Parser.quoteIdentifier(triggerClassName));
        return buff.toString();
    }


    public String getTypeNameList() {
        StatementBuilder buff = new StatementBuilder();
        if ((typeMask & Trigger.INSERT) != 0) {
            buff.appendExceptFirst(", ");
            buff.append("INSERT");
        }
        if ((typeMask & Trigger.UPDATE) != 0) {
            buff.appendExceptFirst(", ");
            buff.append("UPDATE");
        }
        if ((typeMask & Trigger.DELETE) != 0) {
            buff.appendExceptFirst(", ");
            buff.append("DELETE");
        }
        if ((typeMask & Trigger.SELECT) != 0) {
            buff.appendExceptFirst(", ");
            buff.append("SELECT");
        }
        if (onRollback) {
            buff.appendExceptFirst(", ");
            buff.append("ROLLBACK");
        }
        return buff.toString();
    }

View Full Code Here

Examples of org.h2.util.StatementBuilder

            Arrays.sort(wordIds);
            return wordIds;
        }


        private String getKey(Object[] row) throws SQLException {
            StatementBuilder buff = new StatementBuilder();
            for (int columnIndex : index.keys) {
                buff.appendExceptFirst(" AND ");
                buff.append(StringUtils.quoteIdentifier(index.columns[columnIndex]));
                Object o = row[columnIndex];
                if (o == null) {
                    buff.append(" IS NULL");
                } else {
                    buff.append('=').append(quoteSQL(o, columnTypes[columnIndex]));
                }
            }
            return buff.toString();
        }

View Full Code Here

Examples of org.h2.util.StatementBuilder

            displaySize = type.defaultDisplaySize;
        }
    }


    public String getSQL() {
        StatementBuilder buff = new StatementBuilder(info.name);
        buff.append('(');
        switch (info.type) {
        case CAST: {
            buff.append(args[0].getSQL()).append(" AS ").
                append(new Column(null, dataType, precision, scale, displaySize).getCreateSQL());
            break;
        }
        case CONVERT: {
            buff.append(args[0].getSQL()).append(',').
                append(new Column(null, dataType, precision, scale, displaySize).getCreateSQL());
            break;
        }
        case EXTRACT: {
            ValueString v = (ValueString) ((ValueExpression) args[0]).getValue(null);
            buff.append(v.getString()).append(" FROM ").append(args[1].getSQL());
            break;
        }
        default: {
            for (Expression e : args) {
                buff.appendExceptFirst(", ");
                buff.append(e.getSQL());
            }
        }
        }
        return buff.append(')').toString();
    }

View Full Code Here

Examples of org.h2.util.StatementBuilder

                        Value[] a2 = ((ValueArray) v2).getList();
                        return sortOrder.compare(a1, a2);
                    }
                });
            }
            StatementBuilder buff = new StatementBuilder();
            String sep = separator == null ? "," : separator.getValue(session).getString();
            for (Value val : list) {
                String s;
                if (val.getType() == Value.ARRAY) {
                    s = ((ValueArray) val).getList()[0].getString();
                } else {
                    s = val.convertTo(Value.STRING).getString();
                }
                if (s == null) {
                    continue;
                }
                if (sep != null) {
                    buff.appendExceptFirst(sep);
                }
                buff.append(s);
            }
            v = ValueString.get(buff.toString());
        }
        return v;
    }

View Full Code Here

Examples of org.h2.util.StatementBuilder

    public int getDisplaySize() {
        return displaySize;
    }


    private String getSQLGroupConcat() {
        StatementBuilder buff = new StatementBuilder("GROUP_CONCAT(");
        buff.append(on.getSQL());
        if (orderList != null) {
            buff.append(" ORDER BY ");
            for (SelectOrderBy o : orderList) {
                buff.appendExceptFirst(", ");
                buff.append(o.expression.getSQL());
                if (o.descending) {
                    buff.append(" DESC");
                }
            }
        }
        if (separator != null) {
            buff.append(" SEPARATOR ").append(separator.getSQL());
        }
        return buff.append(')').toString();
    }

View Full Code Here

Examples of org.h2.util.StatementBuilder

                    Field.Store.YES, Field.Index.NOT_ANALYZED));
            long time = System.currentTimeMillis();
            doc.add(new Field(LUCENE_FIELD_MODIFIED,
                    DateTools.timeToString(time, DateTools.Resolution.SECOND),
                    Field.Store.YES, Field.Index.NOT_ANALYZED));
            StatementBuilder buff = new StatementBuilder();
            for (int index : indexColumns) {
                String columnName = columns[index];
                String data = asString(row[index], columnTypes[index]);
                // column names that start with _
                // must be escaped to avoid conflicts
                // with internal field names (_DATA, _QUERY, _modified)
                if (columnName.startsWith(LUCENE_FIELD_COLUMN_PREFIX)) {
                    columnName = LUCENE_FIELD_COLUMN_PREFIX + columnName;
                }
                doc.add(new Field(columnName, data,
                        Field.Store.NO, Field.Index.ANALYZED));
                buff.appendExceptFirst(" ");
                buff.append(data);
            }
            Field.Store storeText = STORE_DOCUMENT_TEXT_IN_INDEX ?
                    Field.Store.YES : Field.Store.NO;
            doc.add(new Field(LUCENE_FIELD_DATA, buff.toString(), storeText,
                    Field.Index.ANALYZED));
            try {
                indexAccess.writer.addDocument(doc);
                indexAccess.writer.commit();
                // recreate Searcher with the IndexWriter's reader.

View Full Code Here

Examples of org.h2.util.StatementBuilder

                throw convertException(e);
            }
        }


        private String getQuery(Object[] row) throws SQLException {
            StatementBuilder buff = new StatementBuilder();
            if (schema != null) {
                buff.append(StringUtils.quoteIdentifier(schema)).append('.');
            }
            buff.append(StringUtils.quoteIdentifier(table)).append(" WHERE ");
            for (int columnIndex : keys) {
                buff.appendExceptFirst(" AND ");
                buff.append(StringUtils.quoteIdentifier(columns[columnIndex]));
                Object o = row[columnIndex];
                if (o == null) {
                    buff.append(" IS NULL");
                } else {
                    buff.append('=').append(FullText.quoteSQL(o, columnTypes[columnIndex]));
                }
            }
            return buff.toString();
        }

View Full Code Here

Examples of org.h2.util.StatementBuilder

     * @param session the session
     */
    public synchronized void addMeta(PageIndex index, Session session) {
        int type = index instanceof PageDataIndex ? META_TYPE_DATA_INDEX : META_TYPE_BTREE_INDEX;
        IndexColumn[] columns = index.getIndexColumns();
        StatementBuilder buff = new StatementBuilder();
        for (IndexColumn col : columns) {
            buff.appendExceptFirst(",");
            int id = col.column.getColumnId();
            buff.append(id);
            int sortType = col.sortType;
            if (sortType != 0) {
                buff.append('/');
                buff.append(sortType);
            }
        }
        String columnList = buff.toString();
        Table table = index.getTable();
        CompareMode mode = table.getCompareMode();
        String options = mode.getName()+ "," + mode.getStrength() + ",";
        if (table.isTemporary()) {
            options += "temp";

View Full Code Here

0 1 2 3 4 5 6

Copyright © 2018 www.massapi.com. All rights reserved.

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.