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

     *
     * @param row the values that contain the key
     * @return the row
     */
    public Value[] readRow(Value[] row) throws SQLException {
        StatementBuilder buff = new StatementBuilder("SELECT ");
        appendColumnList(buff, false);
        buff.append(" FROM ");
        appendTableName(buff);
        appendKeyCondition(buff);
        PreparedStatement prep = conn.prepareStatement(buff.toString());
        setKey(prep, 1, row);
        ResultSet rs = prep.executeQuery();
        if (!rs.next()) {
            throw DbException.get(ErrorCode.NO_DATA_AVAILABLE);
        }

View Full Code Here

Examples of org.h2.util.StatementBuilder

     *
     * @param current the row
     * @throws SQLException if this row has already been deleted
     */
    public void deleteRow(Value[] current) throws SQLException {
        StatementBuilder buff = new StatementBuilder("DELETE FROM ");
        appendTableName(buff);
        appendKeyCondition(buff);
        PreparedStatement prep = conn.prepareStatement(buff.toString());
        setKey(prep, 1, current);
        int count = prep.executeUpdate();
        if (count != 1) {
            // the row has already been deleted
            throw DbException.get(ErrorCode.NO_DATA_AVAILABLE);

View Full Code Here

Examples of org.h2.util.StatementBuilder

     * @param current the old row
     * @param updateRow the new row
     * @throws SQLException if the row has been deleted
     */
    public void updateRow(Value[] current, Value[] updateRow) throws SQLException {
        StatementBuilder buff = new StatementBuilder("UPDATE ");
        appendTableName(buff);
        buff.append(" SET ");
        appendColumnList(buff, true);
        // TODO updatable result set: we could add all current values to the
        // where clause
        // - like this optimistic ('no') locking is possible
        appendKeyCondition(buff);
        PreparedStatement prep = conn.prepareStatement(buff.toString());
        int j = 1;
        for (int i = 0; i < columnCount; i++) {
            Value v = updateRow[i];
            if (v == null) {
                v = current[i];

View Full Code Here

Examples of org.h2.util.StatementBuilder

     *
     * @param row the new row
     * @throws SQLException if the row could not be inserted
     */
    public void insertRow(Value[] row) throws SQLException {
        StatementBuilder buff = new StatementBuilder("INSERT INTO ");
        appendTableName(buff);
        buff.append('(');
        appendColumnList(buff, false);
        buff.append(")VALUES(");
        buff.resetCount();
        for (int i = 0; i < columnCount; i++) {
            buff.appendExceptFirst(",");
            buff.append('?');
        }
        buff.append(')');
        PreparedStatement prep = conn.prepareStatement(buff.toString());
        for (int i = 0; i < columnCount; i++) {
            Value v = row[i];
            if (v == null) {
                v = ValueNull.INSTANCE;
            }

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.lealone.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.lealone.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.lealone.util.StatementBuilder

    public int getDisplaySize() {
        return displaySize;
    }


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

View Full Code Here

Examples of org.lealone.util.StatementBuilder

    public String getCreateSQL(boolean orReplace, boolean force) {
        return getCreateSQL(orReplace, force, getSQL());
    }


    private String getCreateSQL(boolean orReplace, boolean force, String quotedName) {
        StatementBuilder buff = new StatementBuilder("CREATE ");
        if (orReplace) {
            buff.append("OR REPLACE ");
        }
        if (force) {
            buff.append("FORCE ");
        }
        buff.append("VIEW ");
        buff.append(quotedName);
        if (comment != null) {
            buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment));
        }
        if (columns != null && columns.length > 0) {
            buff.append('(');
            for (Column c : columns) {
                buff.appendExceptFirst(", ");
                buff.append(c.getSQL());
            }
            buff.append(')');
        } else if (columnNames != null) {
            buff.append('(');
            for (String n : columnNames) {
                buff.appendExceptFirst(", ");
                buff.append(n);
            }
            buff.append(')');
        }
        return buff.append(" AS\n").append(querySQL).toString();
    }

View Full Code Here

Examples of org.lealone.util.StatementBuilder

        if (alias != null) {
            buff.append(' ').append(Parser.quoteIdentifier(alias));
        }
        if (index != null) {
            buff.append('\n');
            StatementBuilder planBuff = new StatementBuilder();
            planBuff.append(index.getPlanSQL());
            if (indexConditions.size() > 0) {
                planBuff.append(": ");
                for (IndexCondition condition : indexConditions) {
                    planBuff.appendExceptFirst("\n    AND ");
                    planBuff.append(condition.getSQL());
                }
            }
            String plan = StringUtils.quoteRemarkSQL(planBuff.toString());
            if (plan.indexOf('\n') >= 0) {
                plan += "\n";
            }
            buff.append(StringUtils.indent("/* " + plan + " */", 4, false));
        }

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.