Package com.j256.ormlite.jdbc

Examples of com.j256.ormlite.jdbc.JdbcDatabaseConnection

49
50
51
52
53
54
55
56
57
58
59
60
    return new Dictionary();
  }

  public Dictionary getRandom() {
    try {
      JdbcDatabaseConnection c = (JdbcDatabaseConnection) DicConnection.getInstance().getReadOnlyConnection();
      Connection conn = c.getInternalConnection();
      Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
      ResultSet result = stmt.executeQuery("select * from v_randomdic");
      result.first();
      return new Dictionary(result.getString(1), result.getString(2), result.getString(3), result.getString(4));
    } catch (SQLException e) {
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
115
  }

  @Override
  public void refreshModel() {
    try {
      JdbcDatabaseConnection c = (JdbcDatabaseConnection) DicConnection.getInstance().getReadOnlyConnection();
      Connection conn = c.getInternalConnection();
      Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

      result = stmt.executeQuery("SELECT * FROM " + tableName);
      rsmd = result.getMetaData();
      result.last();
View Full Code Here
24
25
26
27
28
29
30
31
32
33
    super(cs);
  }

  @Override
  protected WrappedConnection wrapConnection(DatabaseConnection connection) {
    JdbcDatabaseConnection conn = (JdbcDatabaseConnection) connection;
    WrappedJdbcConnection wrapped = new WrappedJdbcConnection(connection, conn.getInternalConnection());
    conn.setInternalConnection(wrapped.getConnectionProxy());
    return wrapped;
  }
View Full Code Here
159
160
161
162
163
164
165
166
167
168
   * <b>NOTE:</b> I couldn't remove the code warning associated with this method when used with more than 2 arguments.
   * </p>
   */
  public Where<T, ID> and(Where<T, ID> first, Where<T, ID> second, Where<T, ID>... others) {
    Clause[] clauses = buildClauseArray(others, "AND");
    Clause secondClause = pop("AND");
    Clause firstClause = pop("AND");
    addClause(new ManyClause(firstClause, secondClause, clauses, ManyClause.AND_OPERATION));
    return this;
  }
View Full Code Here
364
365
366
367
368
369
370
371
372
373
   * <b>NOTE:</b> I can't remove the code warning associated with this method. Use the iterator method below.
   * </p>
   */
  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
518
519
520
521
522
523
524
525
526
  @Override
  public String toString() {
    if (clauseStackLevel == 0) {
      return "empty where clause";
    } else {
      Clause clause = peek();
      return "where clause: " + clause;
    }
  }
View Full Code Here
548
549
550
551
552
553
554
555
556
557
  private Clause pop(String label) {
    if (clauseStackLevel == 0) {
      throw new IllegalStateException("Expecting there to be a clause already defined for '" + label
          + "' operation");
    }
    Clause clause = clauseStack[--clauseStackLevel];
    // to help gc
    clauseStack[clauseStackLevel] = null;
    return clause;
  }
View Full Code Here
272
273
274
275
276
277
278
279
   * </p>
   */
  public Where<T, ID> exists(QueryBuilder<?, ?> subQueryBuilder) throws SQLException {
    // we do this to turn off the automatic addition of the ID column in the select column list
    subQueryBuilder.enableInnerQuery();
    addClause(new Exists(new InternalQueryBuilderWrapper(subQueryBuilder)));
    return this;
  }
View Full Code Here
225
226
227
228
229
230
231
232
  /**
   * Add a IN clause so the column must be equal-to one of the objects from the list passed in.
   */
  public Where<T, ID> in(String columnName, Iterable<?> objects) throws SQLException {
    addClause(new In(columnName, findColumnFieldType(columnName), objects));
    return this;
  }
View Full Code Here
236
237
238
239
240
241
242
243
   */
  public Where<T, ID> in(String columnName, Object... objects) throws SQLException {
    if (objects.length == 1 && objects[0].getClass().isArray()) {
      throw new IllegalArgumentException("in(Object... objects) seems to be an array within an array");
    }
    addClause(new In(columnName, findColumnFieldType(columnName), objects));
    return this;
  }
View Full Code Here
TOP

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

  • 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.Dao.CreateOrUpdateStatus
  • com.j256.ormlite.dao.DaoManager
  • com.j256.ormlite.dao.DaoManagerTest
  • com.j256.ormlite.dao.RuntimeExceptionDaoTest
  • com.j256.ormlite.db.BaseCoreDatabaseTypeTest
    • 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.