@Override public void onClick(View view) { switch (view.getId()) { case R.id.bt: DatabaseHelper myDbHelper = new DatabaseHelper(this); usuario = et.getText().toString(); try { myDbHelper.createDatabase(); } catch (Exception e) { throw new Error("No se creo"); } try { myDbHelper.openDataBase(); SQLiteDatabase db = myDbHelper.getWritableDatabase(); ContentValues valores = new ContentValues(); valores.put("dni", "009"); valores.put("nombre", usuario); valores.put("apellido", "NH"); db.insert("usuarios", null, valores); db.close(); myDbHelper.close(); } catch (SQLException sqle) { throw sqle; } break; case R.id.bt2: DatabaseHelper myDbHelper2 = new DatabaseHelper(this); usuario = et.getText().toString(); try { myDbHelper2.createDatabase(); } catch (Exception e) { throw new Error("No se pudo crear"); } try { myDbHelper2.openDataBase(); Cursor cursor = myDbHelper2.buscarusuario(usuario); if (cursor != null) { tv1.setText(cursor.getString(0)); tv2.setText(cursor.getString(1)); cursor.close(); myDbHelper2.close(); } else { cursor.close(); myDbHelper2.close(); } } catch (Exception e) { } break; default: break; } }
@Override protected void onStop() { super.onStop(); // TODO something goes wrong with the spinner // close cursors if (cursorBusLineNames != null) { cursorBusLineNames.close(); } // close adapters if ((adapterBusLineNames != null) && (adapterBusLineNames.getCursor() != null)) { adapterBusLineNames.getCursor().close(); adapterBusLineNames = null; } if ((adapterLineSearch != null) && (adapterLineSearch.getCursor() != null)) { adapterLineSearch.getCursor().close(); adapterLineSearch = null; } // close database helper if (dbhelper != null) { dbhelper.close(); } // store position state of spinner to SharedPreferences // SettingsHelper.saveSpinnerVehicleCategoryPosition( // getApplicationContext(), vehicleCatSpinnerSelIndex); Log.d(TAG, "onPause()"); }
@Override protected void onPostExecute(final Boolean success) { mAuthTask = null; if (success) { String[] registerMsg = RegisterMsg.split(":"); DatabaseHelper dbHelper = new DatabaseHelper(RegisterActivity.this, "iPin"); SQLiteDatabase db = dbHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("ID", registerMsg[1]); values.put("username", register_name_str); values.put("password", MD5_Password); values.put("sex", register_sex); values.put("telephone", register_telephone_str); values.put("HeadImageVersion", 0); values.put("autoLogin", true); db.update("LoginUser", values, "autoLogin=?", new String[] {"0"}); db.close(); dbHelper.close(); Intent intent = new Intent(RegisterActivity.this, InfoListActivity.class); startActivity(intent); RegisterActivity.this.finish(); } else { showProgress(false); register_password_confirm.setError("注册失败"); register_password_confirm.requestFocus(); } try { socket.close(); } catch (Exception e) { } }
@Override public void onDestroy() { super.onDestroy(); ((CursorAdapter) getListAdapter()).getCursor().close(); db.close(); }
@Override protected HistoryAdapter doInBackground(AppCompatActivity... activity) { ArrayList<String> history = new ArrayList<>(); DatabaseHelper helper = new DatabaseHelper(MainActivity.mContext); SQLiteDatabase db = helper.getReadableDatabase(); Cursor c = db.query( DatabaseHelper.Columns.TABLE_NAME, new String[] { DatabaseHelper.Columns.COLUMN_INPUT, DatabaseHelper.Columns.COLUMN_RESULT }, null, null, null, null, DatabaseHelper.Columns._ID + " DESC"); if (c.moveToFirst()) { do history.add(c.getString(0) + " = " + c.getString(1)); while (c.moveToNext()); } c.close(); db.close(); helper.close(); if (activity.length > 0) return new HistoryAdapter(history, activity[0]); else return new HistoryAdapter(history, null); }
// 在使用该函数之前最好先判断数据库中movieList这个表是否为空 public List<UriInstance> queryFromUserID(int userID) { DatabaseHelper dbHelper = new DatabaseHelper(context, "CAMO_db1"); SQLiteDatabase db = dbHelper.getWritableDatabase(); Cursor cursor = db.query( "playList", new String[] {"userID", "uri", "classType", "name", "mediaType"}, "userID=?", new String[] {Integer.toString(userID)}, null, null, null); // UriInstance item = new UriInstance(); String uri = null; String classType = null; String name = null; String mediaType = null; List<UriInstance> list = new ArrayList<UriInstance>(); while (cursor.moveToNext()) { uri = cursor.getString(cursor.getColumnIndex("uri")); classType = cursor.getString(cursor.getColumnIndex("classType")); name = cursor.getString(cursor.getColumnIndex("name")); mediaType = cursor.getString(cursor.getColumnIndex("mediaType")); RdfFactory factory = RdfFactory.getInstance(); UriInstance item = factory.createInstance(uri, mediaType, classType, name); list.add(item); } dbHelper.close(); return list; }
public static void updateCanUpgradePlugins(Context context, int value, String selection) { DatabaseHelper helper = PluginsDatabaseHelper.getDatabaseHelperInstance(context); SQLiteDatabase db = helper.getWritableDatabase(); Cursor cursor = db.rawQuery( "SELECT * FROM " + PluginsDatabaseHelper.PLUGIN_TABLE + " AS T1 INNER JOIN " + PluginsDatabaseHelper.PLUGIN_TABLE_EXTRA + " AS T2 ON T1.id = T2.id " + "WHERE T1.filename = ?", new String[] {selection}); if (cursor != null && cursor.getCount() > 0 && cursor.moveToFirst()) { if (cursor.getInt(cursor.getColumnIndex("update_flag")) == 1) { int id = cursor.getInt(cursor.getColumnIndex("id")); ContentValues values = new ContentValues(); values.put("update_flag", value); db.update( PluginsDatabaseHelper.PLUGIN_TABLE_EXTRA, values, "id = ?", new String[] {String.valueOf(id)}); } } cursor.close(); db.close(); helper.close(); }
public void reset(Context context) { DatabaseHelper old = this.databaseHelper; this.databaseHelper = new DatabaseHelper(context.getApplicationContext(), DATABASE_NAME, null, DATABASE_VERSION); old.close(); fillCache(); }
/** * {@inheritDoc} * * @see android.app.Service#onDestroy() */ @Override public void onDestroy() { LOGGER.info("onDestroy(): Terminating this instance."); super.onDestroy(); // Shutdown the databaseHelper databaseHelper.close(); databaseHelper = null; if (MoatIoTService.motionSensorListener != null) { // Remove BroadcastReceiver MoatIoTService.motionSensorListener.invalidate(); MoatIoTService.motionSensorListener = null; } final MoatAndroidFactory factory = MoatAndroidFactory.getInstance(); if (factory.isValid(moat)) { // Remove unused model descriptors moat.removeModel(ShakeEvent.class); moat.removeModel(VibrationDevice.class); } factory.destroyMoat(moat); moat = null; LOGGER.info("onDestroy(): Done!"); }
public void onClickDeleteRecord(View view) { helper.open(); if (helper.deleteRecord(getId())) { Toast.makeText(this, "Delete process succeded", Toast.LENGTH_SHORT).show(); } else { Toast.makeText(this, "Record could not be deleted", Toast.LENGTH_SHORT).show(); } helper.close(); }
public void onStop() { // cam.release(); try { db.close(); } catch (Exception e) { } super.onStop(); } // end of onStop
// Terminate DB public void close() { if (mDb != null) { mDb.close(); mDb = null; } if (mDbHelper != null) { mDbHelper.close(); mDbHelper = null; } }
public void onDestroy() { // cam.release(); try { db.close(); } catch (Exception e) { } super.onDestroy(); }
public void dropTable(@NonNull Class<?> type) { if (!DatabaseSchemaParser.isTable(type)) throw new UnsupportedOperationException( "Unable to drop table for type " + type.getSimpleName()); String table = DatabaseSchemaParser.getTableName(type); DatabaseHelper database = new DatabaseHelper(context, databaseName, table, null, databaseVersion); database.dropTable(); database.close(); }
public int length() { DatabaseHelper dbHelper = new DatabaseHelper(context, "CAMO_db1"); SQLiteDatabase db = dbHelper.getWritableDatabase(); Cursor cursor = db.query("playList", new String[] {"COUNT(*)"}, null, null, null, null, null); int length = 0; if (cursor.moveToNext()) { dbHelper.close(); length = cursor.getInt(0); } // dbHelper.close(); return length; }
// id的值最好连续,这样方便遍历 public void insert( int id, int userID, String uri, String classType, String name, String mediaType) { ContentValues value = new ContentValues(); value.put("userID", userID); value.put("id", id); value.put("uri", uri); value.put("classType", classType); value.put("name", name); value.put("mediaType", mediaType); DatabaseHelper dbHelper = new DatabaseHelper(context, "CAMO_db1"); SQLiteDatabase db = dbHelper.getWritableDatabase(); db.insert("playList", null, value); dbHelper.close(); }
public void onClickGetRecord(View view) { helper.open(); Cursor c = helper.getSingleRecord((long) getId()); if (c != null) { Toast.makeText( this, "The name is: " + c.getString(0) + " phone number is " + c.getString(1) + " and enail is" + c.getString(2), Toast.LENGTH_SHORT) .show(); } else { Toast.makeText(this, "No records found", Toast.LENGTH_SHORT).show(); } helper.close(); }
public static boolean hasCanUpgradePlugins(Context context) { boolean result = false; DatabaseHelper helper = PluginsDatabaseHelper.getDatabaseHelperInstance(context); SQLiteDatabase db = helper.getWritableDatabase(); Cursor cursor = db.rawQuery( "SELECT * FROM " + PluginsDatabaseHelper.PLUGIN_TABLE + " AS T1 INNER JOIN " + PluginsDatabaseHelper.PLUGIN_TABLE_EXTRA + " AS T2 ON T1.id = T2.id " + "WHERE T2.update_flag = ?", new String[] {String.valueOf(1)}); result = cursor != null && cursor.getCount() > 0 && cursor.moveToFirst(); cursor.close(); db.close(); helper.close(); return result; }
public void onClickGetAllRecords(View view) { helper.open(); Cursor c = helper.getAllRecords(); if (c != null) { do { Toast.makeText( this, "The name is " + c.getString(0) + "\nThe phone is " + c.getString(1) + "\nThe email is " + c.getString(2), Toast.LENGTH_SHORT) .show(); } while (c.moveToNext()); } else { Toast.makeText(this, "No records found", Toast.LENGTH_SHORT).show(); } helper.close(); }
public List<Categoria> selecionarTodas() { List<Categoria> lista = new ArrayList<Categoria>(); db = helper.getReadableDatabase(); Cursor cursor = db.query(Categoria.TABELA, null, null, null, null, null, Categoria.NOME); if (cursor.moveToFirst()) { do { Categoria categoria = new Categoria(); categoria.setId(cursor.getInt(cursor.getColumnIndex(Categoria.ID))); categoria.setNome(cursor.getString(cursor.getColumnIndex(Categoria.NOME))); lista.add(categoria); } while (cursor.moveToNext()); } cursor.close(); db.close(); helper.close(); return lista; }
public void close() { mDbHelper.close(); }
public static synchronized void closeDatabase() { sDatabaseHelper.close(); }
public void close() { mDatabaseHelper.close(); }
public void delete(int id) { DatabaseHelper dbHelper = new DatabaseHelper(context, "CAMO_db1"); SQLiteDatabase db = dbHelper.getWritableDatabase(); db.delete("playList", "id=?", new String[] {Integer.toString(id)}); dbHelper.close(); }
// closes database public void close() { ourHelper.close(); }
// ---closes the database--- public void close() { DBHelper.close(); }
public void close() { if (mDbHelper != null) { mDbHelper.close(); } }
public void close() { ourDatabase.close(); ourHelper.close(); }
public void close() { dbHelper.close(); }
public DBAdapter close() { mDatabaseHelper.close(); return this; }