Examples of SqlBuilder

br.com.objectos.comuns.relational.search.SQLBuilder
@author marcio.endo@objectos.com.br (Marcio Endo)
com.blogger.tcuri.appserver.db.SqlBuilder
PreparedStatement用のSQLを構築するためのクラスです。 @author tomofumi
org.apache.camel.builder.sql.SqlBuilder
A builder of SQL {@link org.apache.camel.Expression} and{@link org.apache.camel.Predicate} implementations @version $Revision: $
org.apache.ddlutils.platform.SqlBuilder
This class is a collection of Strategy methods for creating the DDL required to create and drop databases and tables. It is hoped that just a single implementation of this class, for each database should make creating DDL for each physical database fairly straightforward. An implementation of this class can always delegate down to some templating technology such as Velocity if it requires. Though often that can be quite complex when attempting to reuse code across many databases. Hopefully only a small amount code needs to be changed on a per database basis. @version $Revision: 518498 $
org.eigenbase.sql.util.SqlBuilder
Extension to {@link StringBuilder} for the purposes of creating SQL queriesand expressions.
Using this class helps to prevent SQL injection attacks, incorrectly quoted identifiers and strings. These problems occur when you build SQL by concatenating strings, and you forget to treat identifers and string literals correctly. SqlBuilder has special methods for appending identifiers and literals.
org.fto.jthink.jdbc.SQLBuilder
构建SQL。此类型已经提供了构建常用SQL语句的方法，但如果要构建复杂SQL，建议扩展此类型，然后覆盖在此类型中没有实现的方法：constructSQL()和constructSQLForSelect()。如果扩展了此类型，相应的也需要实现SQLBuilderFactory工厂来创建SQLBuilder类型的实例。
```
 历史更新记录: 2005-07-15  创建此类型 2009-07-29  优化SQL构建 
```
想法： @author wenjian @version 1.0 @since JThink 1.0
org.restsql.core.SqlBuilder
Builds SQL for an operation on a SQL Resource. @author Mark Sawers

Examples of org.apache.camel.builder.sql.SqlBuilder

        
    }


    public Expression createExpression(String expression) {
        try {
            SqlBuilder builder = SqlBuilder.sql(expression);
            return builder;
        } catch (QueryParseException e) {
            RuntimeException exception = new RuntimeCamelException("Canont create the SqlBuilder.", e);
            throw exception;
        }

View Full Code Here

Examples of org.apache.ddlutils.platform.SqlBuilder

                    {
                        StringWriter stringWriter = new StringWriter();
                        platform.getSqlBuilder().setWriter(stringWriter);
                        // use cglib enhanced wrapper for SqlBuilder to allow overriding ddlutils 1.0 behavior at runtime for 
                        // https://issues.apache.org/jira/browse/DDLUTILS-75 which is fixed in ddlutils 1.1 but hasn't been released yet.
                        SqlBuilder sqlBuilder = new EnhancedSqlBuilder(platform.getSqlBuilder());
                        sqlBuilder.createTables(model, params, false);
                        int createSchemaLength = stringWriter.getBuffer().length();
                        writeOutput(new File(outputDir,"create-schema.sql"),stringWriter.toString());
                        stringWriter.getBuffer().setLength(0);
                        sqlBuilder.createTables(model, params, true);
                        stringWriter.getBuffer().setLength(stringWriter.getBuffer().length()-createSchemaLength);
                        writeOutput(new File(outputDir,"drop-schema.sql"), stringWriter.toString());
                    }
                    catch (IOException ioe)
                    {

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemSqlobjectType type,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "TYPE", stmt);
        name(sb, type.getNamespace(), type.getName());
        sb.append(" AS");
        addColumns(sb, type);
        sb.append(NL);
        sb.append(maybeNot(type.isFinal(), "FINAL"));
        sb.append(NL);
        sb.append(maybeNot(!type.isAbstract(), "INSTANTIABLE"));
        addDescription(sb, type);


        addOperations(sb, Util.filter(type.getFeature(), CwmOperation.class));
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemSqldistinguishedType type,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "TYPE", stmt);
        name(sb, type.getNamespace(), type.getName());
        sb.append(" AS ");


        appendType(
            sb,
            type.getType(),
            type.getPrecision(),
            type.getScale(),
            type.getLength(),
            null,
            null,
            true);


        sb.append(NL);
        sb.append(maybeNot(type.isFinal(), "FINAL"));
        sb.append(NL);
        sb.append(maybeNot(!type.isAbstract(), "INSTANTIABLE"));
        addDescription(sb, type);
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemDataServer server,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "SERVER", stmt);


        name(sb, null, server.getName());
        stmt.addStmt(sb.getSqlAndClear());


        // "TYPE" clause is optional
        final String type = server.getType();
        if ((type != null) && !type.equals("UNKNOWN")) {
            sb.append(" TYPE ");
            sb.literal(type);
        }


        // "VERSION" clause is optional
        final String version = server.getVersion();
        if ((version != null) && !version.equals("UNKNOWN")) {
            sb.append(" VERSION ");
            sb.literal(version);
        }
        sb.append(NL);
        sb.append("FOREIGN DATA WRAPPER ");
        name(sb, null, server.getWrapper().getName());
        addOptions(
            sb,
            server.getStorageOptions());
        addDescription(sb, server);
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void drop(
        CwmSchema schema,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        sb.append("DROP SCHEMA ");
        name(sb, null, schema.getName());
        if (dropCascade) {
            sb.append(" CASCADE");
        }
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void drop(
        CwmTable table,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        sb.append("DROP TABLE ");
        name(sb, table.getNamespace(), table.getName());
        if (dropCascade) {
            sb.append(" CASCADE");
        }
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

            || index.getName().startsWith("SYS$CONSTRAINT_INDEX$")
            || index.getName().startsWith("SYS$DELETION_INDEX"))
        {
            stmt.setTopLevel(false);
        }
        SqlBuilder sb = createSqlBuilder();
        createHeader(
            sb,
            index.isClustered() ? "CLUSTERED INDEX" : "INDEX",
            stmt);
        name(sb, null, index.getName());
        sb.append(" ON ");
        final CwmClass spanned = index.getSpannedClass();
        name(sb, spanned.getNamespace(), spanned.getName());
        sb.append(" (");
        int k = -1;
        for (CwmIndexedFeature feature : index.getIndexedFeature()) {
            if (++k > 0) {
                sb.append(", ");
            }
            sb.identifier(feature.getName());
        }
        sb.append(")");
        addDescription(sb, index);
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemLabel label,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "LABEL", stmt);
        name(sb, null, label.getName());
        if (label.getParentLabel() != null) {
            sb.append(" FROM LABEL ");
            name(sb, null, label.getParentLabel().getName());
        }
        addDescription(sb, label);
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

        GeneratedDdlStmt stmt)
    {
        if (e == null) {
            return;
        }
        SqlBuilder sb = createSqlBuilder();
        sb.append("DROP ").append(elementType).append(" ");


        name(sb, e.getNamespace(), e.getName());
        if (dropCascade) {
            sb.append(" CASCADE");
        }
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

0 1 2 3 4 5

TOP

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.