Examples of vars()

Examples of org.nutz.dao.sql.Sql.vars()

92
93
94
95
96
97
98
99
100
101
102
      sql.vars().set("id", platoonId);
      sql.params().set("code", "T1").set("weight", 12);
      dao.execute(sql);

      sql = dao.sqls().create("tank.insert");
      sql.vars().set("id", platoonId);
      sql.params().set("code", "T2").set("weight", 13);
      dao.execute(sql);

      sql = dao.sqls().create("tank.insert");
      sql.vars().set("id", platoonId);
View Full Code Here

Examples of org.nutz.dao.sql.Sql.vars()

97
98
99
100
101
102
103
104
105
106
107
      sql.vars().set("id", platoonId);
      sql.params().set("code", "T2").set("weight", 13);
      dao.execute(sql);

      sql = dao.sqls().create("tank.insert");
      sql.vars().set("id", platoonId);
      sql.params().set("code", "T3").set("weight", 14);
      dao.execute(sql);

      sql = dao.sqls().create("tank.insert");
      sql.vars().set("id", platoonId);
View Full Code Here

Examples of org.nutz.dao.sql.Sql.vars()

102
103
104
105
106
107
108
109
110
111
112
      sql.vars().set("id", platoonId);
      sql.params().set("code", "T3").set("weight", 14);
      dao.execute(sql);

      sql = dao.sqls().create("tank.insert");
      sql.vars().set("id", platoonId);
      sql.params().set("code", "T4").set("weight", 15);
      dao.execute(sql);

      TableName.run(platoonId, new Atom() {
        public void run() {
View Full Code Here

Examples of org.nutz.dao.sql.Sql.vars()

123
124
125
126
127
128
129
130
131
132
133
  @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

Examples of org.nutz.dao.sql.Sql.vars()

290
291
292
293
294
295
296
297
298
299
300
        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);
        }
        // 字段注释
View Full Code Here

Examples of org.nutz.dao.sql.Sql.vars()

301
302
303
304
305
306
307
308
309
310
311
        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

Examples of org.nutz.dao.sql.Sql.vars()

93
94
95
96
97
98
99
100
101
102
103
        if (en.hasColumnComment()) {
            List<Sql> sqls = new ArrayList<Sql>();
            for (MappingField mf : en.getMappingFields()) {
                if (mf.hasColumnComment()) {
                    Sql columnCommentSQL = Sqls.create(commentColumn);
                    columnCommentSQL.vars()
                                    .set("table", en.getTableName())
                                    .set("column", mf.getColumnName())
                                    .set("columnComment", mf.getColumnComment());
                    sqls.add(columnCommentSQL);
                }
View Full Code Here

Examples of org.nutz.dao.sql.Sql.vars()

103
104
105
106
107
108
109
110
111
112
113
            sql.vars().set("id", platoonId);
            sql.params().set("code", "T3").set("weight", 14);
            dao.execute(sql);

            sql = dao.sqls().create("tank.insert");
            sql.vars().set("id", platoonId);
            sql.params().set("code", "T4").set("weight", 15);
            dao.execute(sql);

            TableName.run(platoonId, new Atom() {
                public void run() {
View Full Code Here

Examples of org.nutz.dao.sql.Sql.vars()

124
125
126
127
128
129
130
131
132
133
134
    @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

Examples of org.nutz.dao.sql.Sql.vars()

298
299
300
301
302
303
304
305
306
307
308
        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);
        }
        // 字段注释
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.