Package org.nutz.dao.sql

Examples of org.nutz.dao.sql.Pojo

152
153
154
155
156
157
158
159
160
        return "SELECT * FROM " + en.getViewName() + " LIMIT 1";
    }
   
    public Pojo fetchPojoId(Entity<?> en, MappingField idField) {
        String autoSql = "select IDENTITY_VAL_LOCAL() as id from " + en.getTableName();
        Pojo autoInfo = new SqlFieldMacro(idField, autoSql);
        autoInfo.setEntity(en);
        return autoInfo;
    }
View Full Code Here
335
336
337
338
339
340
341
342
343
        throw Lang.noImplement();
    }
   
    public Pojo fetchPojoId(Entity<?> en, MappingField idField) {
        String autoSql = "SELECT MAX($field) AS $field FROM $view";
        Pojo autoInfo = new SqlFieldMacro(idField, autoSql);
        autoInfo.setEntity(en);
        return autoInfo;
    }
View Full Code Here
400
401
402
403
404
405
406
407
408
409
410
411
412
413
    public <T> int each(Class<T> classOfT, Condition cnd, Each<T> callback) {
        return each(classOfT, cnd, Pojos.Items.pager(cnd), callback);
    }

    public List<Record> query(String tableName, Condition cnd, Pager pager) {
        Pojo pojo = pojoMaker.makeQuery(tableName)
                                .addParamsBy("*")
                                .setPager(pager)
                                .append(Pojos.Items.cnd(cnd));
        expert.formatQuery(pojo);
        pojo.setAfter(_pojo_queryRecord);
        _exec(pojo);
        return pojo.getList(Record.class);
    }
View Full Code Here
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
    public List<Record> query(String tableName, Condition cnd) {
        return query(tableName, cnd, Pojos.Items.pager(cnd));
    }

    public int each(String tableName, Condition cnd, Pager pager, Each<Record> callback) {
        Pojo pojo = pojoMaker.makeQuery(tableName)
                                .addParamsBy("*")
                                .setPager(pager)
                                .append(Pojos.Items.cnd(cnd));
        expert.formatQuery(pojo);
        pojo.setAfter(_pojo_eachRecord);
        pojo.getContext().attr(Each.class.getName(), callback);
        _exec(pojo);
        return pojo.getInt();
    }
View Full Code Here
434
435
436
437
438
439
440
441
442
443
444
445
    public <T> T fetch(Class<T> classOfT, long id) {
        Entity<T> en = holder.getEntity(classOfT);
        if (en.getIdField() == null)
            throw new DaoException("Need @Id for " + classOfT);
        Pojo pojo = pojoMaker.makeQuery(en)
                                .append(Pojos.Items.cndId(en, id))
                                .addParamsBy(id)
                                .setAfter(_pojo_fetchEntity);
        _exec(pojo);
        return pojo.getObject(classOfT);
    }
View Full Code Here
448
449
450
451
452
453
454
455
456
457
458
459
        if (name == null)
            throw new IllegalArgumentException("name MUST NOT NULL!");
        Entity<T> en = holder.getEntity(classOfT);
        if (en.getNameField() == null)
            throw new DaoException("Need @Name for " + classOfT);
        Pojo pojo = pojoMaker.makeQuery(en)
                                .append(Pojos.Items.cndName(en, name))
                                .addParamsBy(name)
                                .setAfter(_pojo_fetchEntity);
        _exec(pojo);
        return pojo.getObject(classOfT);
    }
View Full Code Here
458
459
460
461
462
463
464
465
466
467
468
        return pojo.getObject(classOfT);
    }

    public <T> T fetchx(Class<T> classOfT, Object... pks) {
        Entity<T> en = holder.getEntity(classOfT);
        Pojo pojo = pojoMaker.makeQuery(en)
                                .append(Pojos.Items.cndPk(en, pks))
                                .setAfter(_pojo_fetchEntity);
        _exec(pojo);
        return pojo.getObject(classOfT);
    }
View Full Code Here
466
467
468
469
470
471
472
473
474
475
476
477
        _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
475
476
477
478
479
480
481
482
483
484
485
486
        _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
486
487
488
489
490
491
492
493
494
495
496
    }

    @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
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.