Package org.nutz.dao.sql

Examples of org.nutz.dao.sql.Sql

123
124
125
126
127
128
129
130
131
132
133
134
135
    @Test
    public void test_dynamic_query() {
        pojos.init();
        Platoon p = pojos.create4Platoon(Base.make("xyz"), "GG");
        Sql sql = dao.sqls().create("tank.query").setEntity(dao.getEntity(Tank.class));
        sql.vars().set("id", p.getId());
        sql.setCallback(Sqls.callback.entities());
        dao.execute(sql);
        assertEquals(2, sql.getList(Tank.class).size());

        pojos.dropPlatoon(p.getId());
    }
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
    }

    @Test
    public void test_statice_null_field() {
        pojos.init();
        Sql sql = Sqls.create("INSERT INTO dao_country (name,detail) VALUES(@name,@detail)");
        sql.params().set("name", "ABC").set("detail", "haha");
        dao.execute(sql);
        assertEquals(1, dao.count("dao_country"));

        sql = Sqls.create("UPDATE dao_country SET detail=@detail WHERE name=@name");
        sql.params().set("name", "ABC").set("detail", null);
        dao.execute(sql);
        Country c = dao.fetch(Country.class, "ABC");
        assertNull(c.getDetail());
    }
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
    }
   
    @Test
    public void test_cnd_pager() {
        pojos.init();
        Sql sql = Sqls.create("select * from t_pet $condition");
        sql.setCondition(Cnd.where("name", "=", "wendal"));
        Pager pager = dao.createPager(1, 20);
        sql.setPager(pager);
        dao.execute(sql);
    }
View Full Code Here
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
            return;
        }
        List<Sql> sqls = new ArrayList<Sql>();
        // 表注释
        if (en.hasTableComment()) {
            Sql tableCommentSQL = Sqls.create(Strings.isBlank(commentTable)    ? DEFAULT_COMMENT_TABLE
                                                                            : commentTable);
            tableCommentSQL.vars()
                            .set("table", en.getTableName())
                            .set("tableComment", en.getTableComment());
            sqls.add(tableCommentSQL);
        }
        // 字段注释
        if (en.hasColumnComment()) {
            for (MappingField mf : en.getMappingFields()) {
                if (mf.hasColumnComment()) {
                    Sql columnCommentSQL = Sqls.create(Strings.isBlank(commentColumn)    ? DEFAULT_COMMENT_COLUMN
                                                                                        : commentColumn);
                    columnCommentSQL.vars()
                                    .set("table", en.getTableName())
                                    .set("column", mf.getColumnName())
                                    .set("columnComment", mf.getColumnComment());
                    sqls.add(columnCommentSQL);
                }
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
        }
        return pager;
    }

    public static <T> List<T> queryList(Dao dao, Class<T> klass, String sql_str) {
        Sql sql = Sqls.create(sql_str)
                        .setCallback(Sqls.callback.entities())
                        .setEntity(dao.getEntity(klass));
        dao.execute(sql);
        return sql.getList(klass);
    }
View Full Code Here
120
121
122
123
124
125
126
127
128
        dao.execute(sql);
        return sql.getList(klass);
    }

    public static Object query(Dao dao, String sql_str, SqlCallback callback) {
        Sql sql = Sqls.create(sql_str).setCallback(callback);
        dao.execute(sql);
        return sql.getResult();
    }
View Full Code Here
205
206
207
208
209
210
211
212
213
214
215
216
   
    /**
     * 查询sql并把结果放入传入的class组成的List中
     */
    public static <T> List<T> query(Dao dao, Class<T> classOfT, String sql, Condition cnd, Pager pager) {
        Sql sql2 = Sqls.queryEntity(sql);
        sql2.setEntity(dao.getEntity(classOfT));
        sql2.setCondition(cnd);
        sql2.setPager(pager);
        dao.execute(sql2);
        return sql2.getList(classOfT);
    }
View Full Code Here
217
218
219
220
221
222
223
224
225
   
    /**
     * 查询某sql的结果条数
     */
    public static int queryCount(Dao dao, String sql) {
        Sql sql2 = Sqls.fetchLong("select count(1) FROM ("+sql+")");
        dao.execute(sql2);
        return sql2.getInt();
    }
View Full Code Here
36
37
38
39
40
41
42
43
    }

    @Test
    public void check_Create_SQL() {
        SqlManager sqls = createSqls();
        Sql sql = sqls.create(".abc.create");
        assertTrue(sql.toString().toUpperCase().startsWith("CREATE"));
    }
View Full Code Here
43
44
45
46
47
48
49
50
    }

    @Test
    public void check_Insert_SQL() {
        SqlManager sqls = createSqls();
        Sql sql = sqls.create(".abc.insert");
        assertTrue(sql.toString().toUpperCase().startsWith("INSERT"));
    }
View Full Code Here
TOP

Related Classes of org.nutz.dao.sql.Sql

  • org.nutz.dao.impl.AbstractSqlManager
  • org.nutz.dao.impl.jdbc.AbstractJdbcExpert
  • org.nutz.dao.impl.jdbc.sqlserver2005.Sqlserver2005JdbcExpert
  • org.nutz.dao.impl.NutDao
  • org.nutz.dao.impl.sql.SqlTemplate
  • org.nutz.dao.test.exec.SimpleDaoExecTest
  • org.nutz.dao.test.normal.BoneCP_Test
  • org.nutz.dao.test.normal.CreateDropTableTest
  • org.nutz.dao.test.normal.CreateTableWithCommentTest
  • org.nutz.dao.test.normal.DaoRecordTest
    • Copyright © 2018 www.massapicom. 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.