Examples of com.j256.ormlite.jdbc.JdbcConnectionSource

com.j256.ormlite.stmt.query.SimpleComparison
Implementation of the ConnectionSource interface that supports what is needed by ORMLite. This is not thread-safe nor synchronized. For other dataSources, see the {@link DataSourceConnectionSource} class.
NOTE: If you are using the Spring type wiring in Java, {@link #initialize} should be called after all of theset methods. In Spring XML, init-method="initialize" should be used.
@author graywatson


  /**
   * OR operation which takes the previous clause and the next clause and OR's them together.
   */
  public Where<T, ID> or() {
    addNeedsFuture(new ManyClause(pop("OR"), ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here

   */
  public Where<T, ID> or(Where<T, ID> left, Where<T, ID> right, Where<T, ID>... others) {
    Clause[] clauses = buildClauseArray(others, "OR");
    Clause secondClause = pop("OR");
    Clause firstClause = pop("OR");
    addClause(new ManyClause(firstClause, secondClause, clauses, ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here

    }
    Clause[] clauses = new Clause[numClauses];
    for (int i = numClauses - 1; i >= 0; i--) {
      clauses[i] = pop("OR");
    }
    addClause(new ManyClause(clauses, ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Used to NOT the next clause specified.
   */
  public Where<T, ID> not() {
    addNeedsFuture(new Not());
    return this;
  }

View Full Code Here


  /**
   * Used to NOT the argument clause specified.
   */
  public Where<T, ID> not(Where<T, ID> comparison) {
    addClause(new Not(pop("NOT")));
    return this;
  }

View Full Code Here

   * Add a raw statement as part of the where that can be anything that the database supports. Using more structured
   * methods is recommended but this gives more control over the query and allows you to utilize database specific
   * features.
   */
  public Where<T, ID> raw(String rawStatement) {
    addClause(new Raw(rawStatement));
    return this;
  }

View Full Code Here


  /**
   * Add a '=' clause so the column must be equal to the value.
   */
  public Where<T, ID> eq(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.EQUAL_TO_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Add a '&gt;=' clause so the column must be greater-than or equals-to the value.
   */
  public Where<T, ID> ge(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.GREATER_THAN_EQUAL_TO_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Add a '&gt;' clause so the column must be greater-than the value.
   */
  public Where<T, ID> gt(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.GREATER_THAN_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Add a '&lt;=' clause so the column must be less-than or equals-to the value.
   */
  public Where<T, ID> le(String columnName, Object value) throws SQLException {
    addClause(new SimpleComparison(columnName, findColumnFieldType(columnName), value,
        SimpleComparison.LESS_THAN_EQUAL_TO_OPERATION));
    return this;
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.j256.ormlite.jdbc.JdbcConnectionSource

android.database.sqlite.SQLiteStatement

com.j256.ormlite.android.AndroidDatabaseConnection

com.j256.ormlite.android.apptools.OrmLiteSqliteOpenHelper

com.j256.ormlite.dao.BaseDaoImpl

com.j256.ormlite.dao.BaseDaoImplTest

com.j256.ormlite.dao.BaseForeignCollection

com.j256.ormlite.dao.Dao.CreateOrUpdateStatus

com.j256.ormlite.dao.DaoManager

com.j256.ormlite.dao.DaoManagerTest

com.j256.ormlite.dao.RuntimeExceptionDaoTest

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.