Package org.nutz.dao.sql

Examples of org.nutz.dao.sql.Pojo

20
21
22
23
24
25
26
27
28
29
30
31
    return pojo;
  }

  public Pojo makeInsert(Entity<?> en) {
    Pojo pojo = Pojos.pojo(expert, en, SqlType.INSERT);
    pojo.setEntity(en);
    pojo.append(Pojos.Items.entityTableName());
    pojo.append(Pojos.Items.insertFields());
    pojo.append(Pojos.Items.insertValues());
    return pojo;
  }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
    pojo.append(Pojos.Items.insertValues());
    return pojo;
  }

  public Pojo makeUpdate(Entity<?> en, Object refer) {
    Pojo pojo = Pojos.pojo(expert, en, SqlType.UPDATE);
    pojo.setEntity(en);
    pojo.append(Pojos.Items.entityTableName());
    pojo.append(Pojos.Items.updateFields(refer));
    return pojo;
  }
View Full Code Here
373
374
375
376
377
378
379
380
381
382
383
384
    _exec(pojo);
    return pojo.getObject(classOfT);
  }

  public <T> T fetch(Class<T> classOfT, Condition cnd) {
    Pojo pojo = pojoMaker.makeQuery(holder.getEntity(classOfT))
                .append(Pojos.Items.cnd(cnd))
                .addParamsBy("*")
                .setAfter(_pojo_fetchEntity);
    _exec(pojo);
    return pojo.getObject(classOfT);
  }
View Full Code Here
382
383
384
385
386
387
388
389
390
391
392
393
    _exec(pojo);
    return pojo.getObject(classOfT);
  }

  public Record fetch(String tableName, Condition cnd) {
    Pojo pojo = pojoMaker.makeQuery(tableName)
                .append(Pojos.Items.cnd(cnd))
                .addParamsBy("*")
                .setAfter(_pojo_fetchRecord);
    _exec(pojo);
    return pojo.getObject(Record.class);
  }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
    pojo.append(Pojos.Items.updateFields(refer));
    return pojo;
  }

  public Pojo makeQuery(Entity<?> en) {
    Pojo pojo = Pojos.pojo(expert, en, SqlType.SELECT);
    pojo.setEntity(en);
    pojo.append(Pojos.Items.queryEntityFields());
    pojo.append(Pojos.Items.wrap("FROM"));
    pojo.append(Pojos.Items.entityViewName());
    return pojo;
  }
View Full Code Here
393
394
395
396
397
398
399
400
401
402
403
  }

  @SuppressWarnings("unchecked")
  public <T> T fetch(T obj) {
    Entity<?> en = holder.getEntityBy(obj);
    Pojo pojo = pojoMaker.makeQuery(en)
                .append(Pojos.Items.cndAuto(en, obj))
                .setAfter(_pojo_fetchEntity);
    _exec(pojo);
    return (T) pojo.getResult();
  }
View Full Code Here
419
420
421
422
423
424
425
426
427
    opt.exec();
    return obj;
  }

  public int clear(Class<?> classOfT, Condition cnd) {
    Pojo pojo = pojoMaker.makeDelete(holder.getEntity(classOfT)).append(Pojos.Items.cnd(cnd));
    _exec(pojo);
    return pojo.getUpdateCount();
  }
View Full Code Here
425
426
427
428
429
430
431
432
433
    _exec(pojo);
    return pojo.getUpdateCount();
  }

  public int clear(String tableName, Condition cnd) {
    Pojo pojo = pojoMaker.makeDelete(tableName).append(Pojos.Items.cnd(cnd));
    _exec(pojo);
    return pojo.getUpdateCount();
  }
View Full Code Here
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
  }

  private int _count(Entity<?> en, String tableName, Condition cnd) {
    // 如果有条件的话
    if (null != cnd) {
      Pojo pojo = pojoMaker.makeFunc(tableName, "COUNT", "*");
      pojo.setEntity(en);
      // 高级条件接口，直接得到 WHERE 子句
      if (cnd instanceof Criteria) {
        pojo.append(((Criteria) cnd).where());
      }
      // 否则暴力获取 WHERE 子句
      else {
        String str = Pojos.formatCondition(en, cnd);
        if (!Strings.isBlank(str)) {
          String[] ss = str.toUpperCase().split("ORDER BY");
          pojo.append(Pojos.Items.wrap(str.substring(0, ss[0].length())));
        }
      }
      // 设置回调，并执行 SQL
      pojo.setAfter(_pojo_fetchInt);
      _exec(pojo);
      return pojo.getInt();
    }
    // 没有条件，直接生成表达式
    return func(tableName, "COUNT", "*");
  }
 
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
59
  }

  public Pojo makeQuery(String tableName) {
    String[] ss = tableName.split(":");
    // String idFieldName = ss.length > 1 ? ss[1] : "*";//按id字段来统计,比较快
    Pojo pojo = makePojo(SqlType.SELECT);
    // pojo.append(Pojos.Items.wrap(idFieldName));//与org.nutz.dao.test.normal.QueryTest.query_records_pager()冲突
    pojo.append(Pojos.Items.wrap("*"));
    pojo.append(Pojos.Items.wrap("FROM"));
    pojo.append(Pojos.Items.wrap(ss[0]));
    return pojo;
  }
View Full Code Here
TOP

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

  • org.nutz.dao.impl.entity.AnnotationEntityMaker
  • org.nutz.dao.impl.EntityOperator
  • org.nutz.dao.impl.jdbc.AbstractJdbcExpert
  • org.nutz.dao.impl.jdbc.derby.DerbyJdbcExpert
  • org.nutz.dao.impl.jdbc.gbase.GBaseJdbcExpert
  • org.nutz.dao.impl.jdbc.h2.H2JdbcExpert
  • org.nutz.dao.impl.jdbc.mysql.MysqlJdbcExpert
  • org.nutz.dao.impl.jdbc.sqlite.SQLiteJdbcExpert
  • org.nutz.dao.impl.jdbc.sqlserver2005.Sqlserver2005JdbcExpert
  • org.nutz.dao.impl.link.DoClearLinkVisitor
    • 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.