Java Query.use Examples

Example #1

File: Select.java Project: yabqiu/monalisa-db

  /**
   * @param limit limit
   * @param offset offset
   * @param whereStatement where cause
   * @param args args
   * @return Page
   * @see com.tsc9526.monalisa.core.resources.HelpDoc#helpQuery(int,int,Example,String, Object...)
   */
  public Page<T> selectPage(int limit, int offset, String whereStatement, Object... args) {
    Query query = model.dialect().select(model, whereStatement, args);
    query.use(db());

    Page<T> r = (Page<T>) query.getPage(getResultCreator(query), limit, offset);
    return r;
  }

Example #2

File: Select.java Project: yabqiu/monalisa-db

  /**
   * @param limit limit
   * @param offset offset
   * @param example Example
   * @return Page
   * @see com.tsc9526.monalisa.core.resources.HelpDoc#helpQuery(int,int,Example,String, Object...)
   */
  public Page<T> selectPageByExample(int limit, int offset, Example example) {
    Query w = QEH.getQuery(example);

    Query query = model.dialect().select(model, w.getSql(), w.getParameters());
    query.use(db());

    Page<T> r = (Page<T>) query.getPage(getResultCreator(query), limit, offset);
    return r;
  }

Example #3

File: Select.java Project: yabqiu/monalisa-db

  /**
   * @param example Example
   * @return DataTable
   * @see com.tsc9526.monalisa.core.resources.HelpDoc#helpQuery(int,int,Example,String, Object...)
   */
  public DataTable<T> selectByExample(Example example) {
    Query w = QEH.getQuery(example);

    Query query = model.dialect().select(model, w.getSql(), w.getParameters());
    query.use(db());

    DataTable<T> r = (DataTable<T>) query.getList(getResultCreator(query));
    return r;
  }

Example #4

File: Select.java Project: yabqiu/monalisa-db

  /**
   * @param example Example
   * @return the first record
   * @see com.tsc9526.monalisa.core.resources.HelpDoc#helpQuery(int,int,Example,String, Object...)
   */
  public T selectOneByExample(Example example) {
    Query w = QEH.getQuery(example);

    Query query = model.dialect().selectOne(model, w.getSql(), w.getParameters());
    query.use(db());

    T r = (T) query.getResult(getResultCreator(query));
    return r;
  }

Example #5

File: Select.java Project: yabqiu/monalisa-db

  /**
   * @param whereStatement where cause
   * @param args args
   * @return DataTable
   * @see com.tsc9526.monalisa.core.resources.HelpDoc#helpQuery(int,int,Example,String, Object...)
   */
  public DataTable<T> select(String whereStatement, Object... args) {
    Query query = model.dialect().select(model, whereStatement, args);
    query.use(db());

    return (DataTable<T>) query.getList(getResultCreator(query));
  }

Example #6

File: Select.java Project: yabqiu/monalisa-db

 /**
  * @param whereStatement where cause
  * @param args args
  * @return count of records
  * @see com.tsc9526.monalisa.core.resources.HelpDoc#helpQuery(int,int,Example,String, Object...)
  */
 public long count(String whereStatement, Object... args) {
   Query query = model.dialect().count(model, whereStatement, args);
   query.use(db());
   return query.getResult(Long.class);
 }

Example #7

File: Select.java Project: yabqiu/monalisa-db

 public long count() {
   Query query = model.dialect().count(model, null);
   query.use(db());
   return query.getResult(Long.class);
 }

Example #8

File: Select.java Project: yabqiu/monalisa-db

 /**
  * @param whereStatement where cause
  * @param args args
  * @return the first record
  * @see com.tsc9526.monalisa.core.resources.HelpDoc#helpQuery(int,int,Example,String,Object...)
  */
 public T selectOne(String whereStatement, Object... args) {
   Query query = model.dialect().selectOne(model, whereStatement, args);
   query.use(db());
   T r = (T) query.getResult(getResultCreator(query));
   return r;
 }