コード例 #1
0
 public void deleteTran(Account acct, String transID) {
   String[] args = {Integer.toString(acct.ID), transID};
   db.beginTransaction();
   try {
     db.delete("trans", "acct_id=? and trans_id=?", args);
     db.setTransactionSuccessful();
   } finally {
     db.endTransaction();
   }
 }
コード例 #2
0
 private void updateTran(Transaction trans) {
   db.beginTransaction();
   try {
     ContentValues newValue = tranValues(trans);
     String[] args = {Integer.toString(trans.ID)};
     db.update("trans", newValue, "_id=?", args);
     db.setTransactionSuccessful();
   } finally {
     db.endTransaction();
   }
 }
コード例 #3
0
 private void updateAccount(Account acct) {
   db.beginTransaction();
   try {
     ContentValues newValue = acctValues(acct);
     String[] args = {Integer.toString(acct.ID)};
     db.update("acct", newValue, "_id=?", args);
     db.setTransactionSuccessful();
   } finally {
     db.endTransaction();
   }
 }
コード例 #4
0
 private int addAccount(Account acct) {
   db.beginTransaction();
   int acct_id;
   try {
     ContentValues newValue = acctValues(acct);
     acct_id = (int) db.insertOrThrow("acct", "name", newValue);
     acct.ID = acct_id;
     db.setTransactionSuccessful();
   } finally {
     db.endTransaction();
   }
   return acct_id;
 }
コード例 #5
0
 public Cursor acctList(String constraint) {
   if (constraint == null) {
     return db.query("acct", AC_COLS, null, null, null, null, "name");
   } else {
     return db.query(
         "acct",
         AC_COLS,
         "name like ?",
         new String[] {"%" + constraint + "%"},
         null,
         null,
         "name");
   }
 }
コード例 #6
0
  private int addTran(Transaction trans) {
    db.beginTransaction();
    int tran_id;
    try {
      ContentValues newValue = tranValues(trans);
      tran_id = (int) db.insertOrThrow("trans", "acct_id", newValue);
      trans.ID = tran_id;

      db.setTransactionSuccessful();
    } finally {
      db.endTransaction();
    }
    return tran_id;
  }
コード例 #7
0
  private static Cursor getMesesDiferentes() throws SQLException {

    SQLiteDatabase conn = null;
    Cursor rs = null;
    String consulta = " Select distinct month from session ";

    try {
      conn = BaseDatos.getConn();

      rs = conn.rawQuery(consulta, null);
    } catch (SQLException e) {
      throw (e);
    }

    return rs;
  }
コード例 #8
0
 private boolean tranExists(Transaction trans) {
   String[] args = {Integer.toString(trans.acct.ID), trans.transID};
   Cursor cur = db.query("trans", ID_COLS, "acct_id=? and trans_id=?", args, null, null, null);
   try {
     return cur.moveToNext();
   } finally {
     cur.close();
   }
 }
コード例 #9
0
  public Account getAccount(int ID) {
    Account acct = null;
    String[] args = {Integer.toString(ID)};
    Cursor cur = db.query("acct", AC_COLS, "_id=?", args, null, null, null);
    try {
      if (!cur.moveToNext()) return null;
      acct = getAccountFromCursor(cur);
    } finally {
      cur.close();
    }

    return acct;
  }
コード例 #10
0
  public void establishAccount(ServiceAcctInfo acct) {
    String[] args = {Integer.toString(acct.ID)};
    Cursor cur = db.query("acct", AC_COLS, "service_id=?", args, null, null, null);
    try {
      if (cur.moveToNext()) return;
    } finally {
      cur.close();
    }

    Account newAcct = new Account();
    newAcct.serviceId = acct.ID;
    newAcct.name = acct.desc;
    addAccount(newAcct);
  }
コード例 #11
0
 public void close() {
   db.close();
 }
コード例 #12
0
 public void wipeTable(SQLiteDatabase db) {
   for (String cmd : DROP_TABLE) {
     db.execSQL(cmd);
   }
   onCreate(db);
 }
コード例 #13
0
 @Override
 public void onCreate(SQLiteDatabase db) {
   for (String cmd : CREATE_TABLE) {
     db.execSQL(cmd);
   }
 }