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

        }
    }


    protected SqlBuilder createSqlBuilder()
    {
        return new SqlBuilder(sqlDialect);
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

        throws SQLException
    {
        String initialSchema = info.getProperty("schema");
        if (initialSchema != null) {
            Statement stmt = this.createStatement();
            final SqlBuilder buf = new SqlBuilder(SqlDialect.EIGENBASE);
            buf.append("set schema ");
            buf.literal(initialSchema);
            final String sql = buf.getSql();
            try {
                stmt.executeUpdate(sql);
            } finally {
                try {
                    stmt.close();

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

            4,
            new StringBuffer("New York"));
        doEmpInsert(name, 10);


        // only query what we insert above
        final SqlBuilder buf = new SqlBuilder(SqlDialect.EIGENBASE);
        buf.append(
            "select gender, city, empid from sales.emps where name like ")
            .literal(name + "%");
        String query = buf.getSql();


        preparedStmt = connection.prepareStatement(query);


        resultSet = preparedStmt.executeQuery();
        int empid;

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

                }
                schemas.close();
            }


            tracer.finer("Schema name list has " + list.size() + " entries");
            final SqlBuilder buf = new SqlBuilder(SqlDialect.EIGENBASE);
            for (String name : list) {
                String dropStmt =
                    buf.append("drop schema ")
                        .identifier(name)
                        .append(" cascade")
                        .getSqlAndClear();
                tracer.finer(dropStmt);
                try {

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

            }


            tracer.finer(
                "Datawrapper name list has " + list.size() + " entries");
            Iterator<String> iter = list.iterator();
            final SqlBuilder buf = new SqlBuilder(SqlDialect.EIGENBASE);
            while (iter.hasNext()) {
                String wrapperType = iter.next();
                String name = iter.next();
                String sql =
                    buf.append("drop ")
                        .append(wrapperType)
                        .append(" data wrapper ")
                        .identifier(name)
                        .append(" cascade")
                        .getSqlAndClear();

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

                }
            }


            tracer.finer(
                "Dataserver name list has " + list.size() + " entries");
            final SqlBuilder buf = new SqlBuilder(SqlDialect.EIGENBASE);
            for (String name : list) {
                String sql =
                    buf.append("drop server ")
                        .identifier(name)
                        .append(" cascade")
                        .getSqlAndClear();
                tracer.finer(sql);
                getStmt().execute(sql);

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

                    }
                }
            }


            tracer.finer("Label name list has " + list.size() + " entries");
            final SqlBuilder buf = new SqlBuilder(SqlDialect.EIGENBASE);
            for (String name : list) {
                String sql =
                    buf.append("drop label ")
                        .identifier(name)
                        .append(" cascade")
                        .getSqlAndClear();
                tracer.finer(sql);
                getStmt().execute(sql);

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

            throws Exception
        {
            tracer.fine("Dropping AuthIds.");
            List<String> list = new ArrayList<String>();
            final FarragoRepos repos = getRepos();
            final SqlBuilder buf = new SqlBuilder(SqlDialect.EIGENBASE);
            if (repos != null) {
                for (FemAuthId authId : repos.allOfType(FemAuthId.class)) {
                    if (isBlessedAuthId(authId)) {
                        continue;
                    }
                    list.add(
                        buf.append("drop ")
                            .append(authId instanceof FemRole ? "ROLE" : "USER")
                            .append(" ")
                            .identifier(authId.getName())
                            .getSqlAndClear());
                }
            } else if (stmt != null) {
                if (stmt.execute(
                        "select \"name\",\"mofClassName\" from "
                        + "sys_fem.\"Security\".\"AuthId\""))
                {
                    ResultSet rset = stmt.getResultSet();
                    while (rset.next()) {
                        String name = rset.getString(1);
                        String className = rset.getString(2);
                        if (isBlessedAuthId(name)) {
                            continue;
                        }
                        list.add(
                            buf.append("drop ")
                                .append(className + " " + name)
                                .getSqlAndClear());
                    }
                }
            }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

        this.tracer = tracer;
    }


    private SqlBuilder createSqlBuilder()
    {
        return new SqlBuilder(SqlDialect.EIGENBASE);
    }

View Full Code Here

Examples of org.eigenbase.sql.util.SqlBuilder

    private String generateMedQuery(
        String query,
        String libraryFileName,
        final String mofId)
    {
        final SqlBuilder sqlBuilder = createSqlBuilder();
        sqlBuilder
            .append(
                "select stream name, avalue, description, choices, required "
                + "from table(sys_boot.mgmt.")
            .append(query)
            .append("(")
            .literal(mofId)
            .append(", ")
            .literal(libraryFileName)
            .append(", ")
            .literal("")
            .append(", ")
            .literal("")
            .append(", ")
            .literal("")
            .append(", ")
            .literal(locale.toString())
            .append("))");
        return sqlBuilder.getSql();
    }

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.