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.eigenbase.sql.util.SqlBuilder

              && generateSetSchema(stmt, view.getNamespace().getName(), false))
        {
            stmt.addStmt(";" + NL);
        }


        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "VIEW", stmt);
        name(sb, view.getNamespace(), view.getName());
        addDescription(sb, view);
        sb.append(" AS");
        sb.append(NL);
        stmt.addStmt(sb.getSqlAndClear());


        if (!uglyViews) {
            sb.append(view.getOriginalDefinition());
        } else {
            sb.append(view.getQueryExpression().getBody());
        }
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemLocalSchema schema,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "SCHEMA", stmt);


        name(sb, null, schema.getName());
        addDescription(sb, schema);


        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemUser user,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "USER", stmt);


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


        sb.append(NL);
        if (user.getEncryptedPassword() == null) {
            sb.append("AUTHORIZATION ");
            // Auths are not stored by the parser.
            sb.literal("Unused");
        } else {
            sb.append("IDENTIFIED BY ");
            sb.literal("********");
        }
        stmt.addStmt(sb.getSqlAndClear());


        CwmNamespace ns = user.getDefaultNamespace();
        if (ns != null) {
            sb.append(NL);
            sb.append("DEFAULT ");
            if (ns instanceof FemLocalSchema) {
                sb.append("SCHEMA ");
            } else if (ns instanceof FemLocalCatalog) {
                sb.append("CATALOG ");
            }
            name(sb, ns.getNamespace(), ns.getName());
        }
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemRole role,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "ROLE", stmt);


        name(sb, null, role.getName());


        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemJar jar,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "JAR", stmt);


        name(sb, jar.getNamespace(), jar.getName());
        addDescription(sb, jar);


        stmt.addStmt(sb.getSqlAndClear());
        sb.append(NL);
        sb.append("LIBRARY ");
        sb.literal(jar.getUrl());
        sb.append(NL);
        sb.append("OPTIONS(");
        sb.append(jar.getDeploymentState());
        sb.append(")");


        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemLocalTable table,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "TABLE", false, null);


        name(sb, table.getNamespace(), table.getName());
        stmt.addStmt(sb.getSqlAndClear());


        addColumns(sb, table);
        addOptions(
            sb,
            table.getStorageOptions());
        addDescription(sb, table);
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemForeignTable table,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "FOREIGN TABLE", false, null);


        name(sb, table.getNamespace(), table.getName());
        stmt.addStmt(sb.getSqlAndClear());


        addColumns(sb, table);
        sb.append(NL);
        sb.append("SERVER ");
        FemDataServer server = table.getServer();
        if (server != null) {
            name(sb, null, server.getName());
        }
        addOptions(
            sb,
            ((FemElementWithStorageOptions) table).getStorageOptions());
        addDescription(sb, table);
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemDataWrapper wrapper,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        createHeader(sb, "FOREIGN DATA WRAPPER", stmt);


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


        // "LIBRARY" clause is optional
        if (wrapper.getLibraryFile() != null) {
            sb.append(" LIBRARY ");
            sb.literal(wrapper.getLibraryFile());
        }
        sb.append(NL);
        sb.append("LANGUAGE ");
        sb.append(wrapper.getLanguage());
        addOptions(
            sb,
            wrapper.getStorageOptions());
        addDescription(sb, wrapper);
        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder


    public void create(
        FemRoutine routine,
        GeneratedDdlStmt stmt)
    {
        SqlBuilder sb = createSqlBuilder();
        final ProcedureType routineType = routine.getType();
        final CwmClassifier owner = routine.getSpecification().getOwner();
        boolean method =
            (routine.getSpecification() != null)
            && (owner
                instanceof FemUserDefinedType);
        if (method) {
            createHeader(sb, "SPECIFIC METHOD", stmt);
        } else if (routineType.equals(ProcedureTypeEnum.FUNCTION)) {
            createHeader(sb, "FUNCTION", stmt);
        } else if (routineType.equals(ProcedureTypeEnum.PROCEDURE)) {
            createHeader(sb, "PROCEDURE", stmt);
        }


        name(sb, routine.getNamespace(), routine.getInvocationName());
        stmt.addStmt(sb.getSqlAndClear());


        if (method) {
            sb.append(NL);
            sb.append("FOR ");
            name(sb, owner.getNamespace(), owner.getName());
        } else {
            methodBody(routine, sb);
        }


        if (routine.getExternalName() == null) {
            sb.append(NL);
            sb.append(routine.getBody().getBody());
        }


        stmt.addStmt(sb.getSqlAndClear());
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

        if ((schemaName != null)
            && (evenIfUnchanged
                || (previousSetSchema == null)
                || !previousSetSchema.equals(schemaName)))
        {
            SqlBuilder sb = createSqlBuilder();
            sb.append("SET SCHEMA ");
            sb.literal(sb.getDialect().quoteIdentifier(schemaName));
            stmt.addStmt(sb.getSql());
            previousSetSchema = schemaName;
            return true;
        } else {
            return false;
        }

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.