Examples of SQLTemplate

com.alibaba.otter.node.etl.common.db.dialect.SqlTemplate
sql构造模板操作 @author jianghang 2011-10-27 下午01:31:15 @version 4.0.0
org.apache.cayenne.query.SQLTemplate
A query that executes unchanged (except for template preprocessing) "raw" SQL specified by the user.
Template Script

SQLTemplate stores a dynamic template for the SQL query that supports parameters and customization using Velocity scripting language. The most straightforward use of scripting abilities is to build parameterized queries. For example:
```
 SELECT ID, NAME FROM SOME_TABLE WHERE NAME LIKE $a 
```
For advanced scripting options see "Scripting SQLTemplate" chapter in the User Guide.

Per-Database Template Customization

SQLTemplate has a {@link #getDefaultTemplate() default template script}, but also it allows to configure multiple templates and switch them dynamically. This way a single query can have multiple "dialects" specific to a given database.

Parameter Sets

SQLTemplate supports multiple sets of parameters, so a single query can be executed multiple times with different parameters. "Scrolling" through parameter list is done by calling {@link #parametersIterator()}. This iterator goes over parameter sets, returning a Map on each call to "next()"
@since 1.1
org.nutz.dao.impl.sql.SqlTemplate
仿照Spring JdbcTemplate实现nutz的SqlTemplate，方便sql的调用 @author hzl7652(hzl7652@sina.com)

Examples of org.apache.cayenne.query.SQLTemplate

        assertTrue(sql, sql.endsWith(" FROM ARTIST t0 WHERE t0.ARTIST_NAME ="
                + " #bind('Dali' 'VARCHAR')"));
    }


    public void testSelectFromWhereOrEqual() {
        SQLTemplate query = translateSelect("select a from Artist a where a.artistName = 'Dali' "
                + "or a.artistName = 'Malevich'");
        String sql = query.getDefaultTemplate();


        SQLTemplate query1 = translateSelect("select a from Artist a where a.artistName = 'Picasso' "
                + "or a.artistName = 'Malevich' "
                + "or a.artistName = 'Dali'");
        String sql1 = query1.getDefaultTemplate();


        assertTrue(sql, sql.startsWith("SELECT"));
        assertTrue(sql, sql.indexOf(" FROM ARTIST t0 WHERE ") > 0);
        assertEquals(1, countDelimiters(sql, " OR ", sql.indexOf("WHERE ")));

View Full Code Here

Examples of org.apache.cayenne.query.SQLTemplate

        assertEquals(2, countDelimiters(sql1, " OR ", sql.indexOf("WHERE ")));
    }


    public void testSelectFromWhereAndEqual() {


        SQLTemplate query = translateSelect("select a from Artist a where a.artistName = 'Dali' "
                + "and a.artistName = 'Malevich'");
        String sql = query.getDefaultTemplate();


        SQLTemplate query1 = translateSelect("select a from Artist a where a.artistName = 'Picasso' "
                + "and a.artistName = 'Malevich' "
                + "and a.artistName = 'Dali'");
        String sql1 = query1.getDefaultTemplate();


        assertTrue(sql, sql.startsWith("SELECT"));
        assertTrue(sql, sql.indexOf("WHERE ") > 0);
        assertEquals(1, countDelimiters(sql, " AND ", sql.indexOf("WHERE ")));

View Full Code Here

Examples of org.nutz.dao.impl.sql.SqlTemplate

    private SqlTemplate sqlTemplate;


    @Override
    protected void before() {
        if (sqlTemplate == null)
            sqlTemplate = new SqlTemplate(dao);
    }

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.

Examples of SQLTemplate

Template Script

Per-Database Template Customization

Parameter Sets

Examples of org.apache.cayenne.query.SQLTemplate

Examples of org.apache.cayenne.query.SQLTemplate

Examples of org.nutz.dao.impl.sql.SqlTemplate