List of usage examples for android.database.sqlite SQLiteDatabase close
public void close()
From source file:net.olejon.mdapp.NotesEditActivity.java
private void deleteNote(boolean delete) { if (delete) { SQLiteDatabase sqLiteDatabase = new NotesSQLiteHelper(mContext).getWritableDatabase(); sqLiteDatabase.delete(NotesSQLiteHelper.TABLE, NotesSQLiteHelper.COLUMN_ID + " = " + noteId, null); sqLiteDatabase.close(); mTools.showToast(getString(R.string.notes_edit_deleted), 1); finish();/* w w w .jav a 2 s. c o m*/ } else { new MaterialDialog.Builder(mContext).title(getString(R.string.notes_edit_delete_dialog_title)) .content(getString(R.string.notes_edit_delete_dialog_message)) .positiveText(getString(R.string.notes_edit_delete_dialog_positive_button)) .neutralText(getString(R.string.notes_edit_delete_dialog_neutral_button)) .callback(new MaterialDialog.ButtonCallback() { @Override public void onPositive(MaterialDialog dialog) { deleteNote(true); } }).contentColorRes(R.color.black).positiveColorRes(R.color.red) .neutralColorRes(R.color.dark_blue).show(); } }
From source file:it.sasabz.android.sasabus.fragments.OnlineShowFragment.java
/** Called with the activity is first created. */ @Override// ww w . j a va2 s .c o m public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) { super.onCreate(savedInstanceState); if (!XMLRequest.haveNetworkConnection()) { Toast.makeText(getContext(), R.string.no_network_connection, Toast.LENGTH_LONG).show(); getFragmentManager().popBackStack(); return null; } result = inflater.inflate(R.layout.connection_listview_layout, container, false); if (list == null && request == null) { progress = new ProgressDialog(getContext()); progress.setMessage(getResources().getText(R.string.waiting)); progress.setProgressStyle(ProgressDialog.STYLE_SPINNER); progress.setCancelable(false); progress.show(); request = new XMLConnectionRequestList(from, to, datetime, this); request.execute(); } else { progress = null; fillData(list); } listview = (ListView) result.findViewById(android.R.id.list); listview.setOnItemClickListener(this); Button later = (Button) result.findViewById(R.id.later); Button earlier = (Button) result.findViewById(R.id.earlier); later.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub progress = new ProgressDialog(getContext()); progress.setMessage(getResources().getText(R.string.waiting)); progress.setProgressStyle(ProgressDialog.STYLE_SPINNER); progress.setCancelable(false); progress.show(); isLater = true; XMLForwardScroll forward = new XMLForwardScroll(list, getThis()); forward.execute(); } }); earlier.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub progress = new ProgressDialog(getContext()); progress.setMessage(getResources().getText(R.string.waiting)); progress.setProgressStyle(ProgressDialog.STYLE_SPINNER); progress.setCancelable(false); progress.show(); isEarlier = true; XMLBackwardScroll backward = new XMLBackwardScroll(list, getThis()); backward.execute(); } }); Button favorites = (Button) result.findViewById(R.id.favorite); favorites.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub SQLiteDatabase favdb = new FavoritenDB(getActivity()).getReadableDatabase(); Favorit favorit = new Favorit(from.getName(), to.getName()); if (favorit.insert(favdb)) { Toast.makeText(getActivity(), R.string.favorit_add, Toast.LENGTH_LONG).show(); } favdb.close(); } }); return result; }
From source file:com.openerp.addons.note.EditNoteFragment.java
public void updateNote(int row_id) { try {// w ww .ja v a 2 s. c o m JSONArray tagID = db.getSelectedTagId(selectedTags); long stage_id = Long.parseLong(stages.get(noteStages.getSelectedItem().toString())); ContentValues values = new ContentValues(); JSONObject vals = new JSONObject(); // If Pad Installed Over Server if (padAdded) { JSONArray url = new JSONArray(); url.put(originalMemo); JSONObject obj = oe_obj.call_kw("pad.common", "pad_get_content", url); // HTMLHelper helper = new HTMLHelper(); String link = HTMLHelper.htmlToString(obj.getString("result")); values.put("stage_id", stage_id); vals.put("stage_id", Integer.parseInt(values.get("stage_id").toString())); values.put("name", db.generateName(link)); vals.put("name", values.get("name").toString()); values.put("memo", obj.getString("result")); vals.put("memo", values.get("memo").toString()); values.put("note_pad_url", originalMemo); vals.put("note_pad_url", values.get("note_pad_url").toString()); } // If Pad Not Installed Over Server else { values.put("stage_id", stage_id); vals.put("stage_id", Integer.parseInt(values.get("stage_id").toString())); values.put("name", db.generateName(noteMemo.getText().toString())); vals.put("name", values.get("name").toString()); values.put("memo", Html.toHtml(noteMemo.getText())); vals.put("memo", values.get("memo").toString()); } JSONArray tag_ids = new JSONArray(); tag_ids.put(6); tag_ids.put(false); JSONArray c_ids = new JSONArray(tagID.toString()); tag_ids.put(c_ids); vals.put("tag_ids", new JSONArray("[" + tag_ids.toString() + "]")); // This will update Notes over Server And Local database db = new NoteDBHelper(scope.context()); if (oe_obj.updateValues(db.getModelName(), vals, row_id)) { db.write(db, values, row_id, true); db.executeSQL("delete from note_note_note_tag_rel where note_note_id = ? and oea_name = ?", new String[] { row_id + "", scope.User().getAndroidName() }); for (int i = 0; i < tagID.length(); i++) { ContentValues rel_vals = new ContentValues(); rel_vals.put("note_note_id", row_id); rel_vals.put("note_tag_id", tagID.getInt(i)); rel_vals.put("oea_name", scope.User().getAndroidName()); SQLiteDatabase insertDb = db.getWritableDatabase(); insertDb.insert("note_note_note_tag_rel", null, rel_vals); insertDb.close(); } } } catch (Exception e) { e.printStackTrace(); } }
From source file:com.dm.wallpaper.board.databases.Database.java
public int getCategoryCount(String category) { SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor = db.query(TABLE_WALLPAPERS, null, "LOWER(" + KEY_CATEGORY + ") LIKE ?", new String[] { "%" + category.toLowerCase(Locale.getDefault()) + "%" }, null, null, null); int count = cursor.getCount(); cursor.close();//from w w w . j a v a 2s . c om db.close(); return count; }
From source file:net.olejon.mdapp.NotesActivity.java
private void getNotes() { if (mIsAuthenticated) { GetNotesTask getNotesTask = new GetNotesTask(); getNotesTask.execute();// w ww . j av a 2 s . co m } else { new MaterialDialog.Builder(mContext).title(getString(R.string.notes_dialog_verify_pin_code_title)) .customView(R.layout.activity_notes_dialog_verify_pin_code, true) .positiveText(getString(R.string.notes_dialog_verify_pin_code_positive_button)) .negativeText(getString(R.string.notes_dialog_verify_pin_code_negative_button)) .neutralText(getString(R.string.notes_dialog_verify_pin_code_neutral_button)) .callback(new MaterialDialog.ButtonCallback() { @Override public void onPositive(MaterialDialog dialog) { EditText pinCodeEditText = (EditText) dialog .findViewById(R.id.notes_dialog_verify_pin_code); String pinCode = pinCodeEditText.getText().toString(); if (pinCode.equals(mTools.getSharedPreferencesString("NOTES_PIN_CODE"))) { GetNotesTask getNotesTask = new GetNotesTask(); getNotesTask.execute(); dialog.dismiss(); } else { mTools.showToast(getString(R.string.notes_dialog_verify_pin_code_wrong), 1); } } @Override public void onNegative(MaterialDialog dialog) { dialog.dismiss(); finish(); } @Override public void onNeutral(MaterialDialog dialog) { dialog.dismiss(); new MaterialDialog.Builder(mContext) .title(getString(R.string.notes_dialog_reset_pin_code_title)) .content(getString(R.string.notes_dialog_reset_pin_code_message)) .positiveText(getString(R.string.notes_dialog_reset_pin_code_positive_button)) .neutralText(getString(R.string.notes_dialog_reset_pin_code_neutral_button)) .callback(new MaterialDialog.ButtonCallback() { @Override public void onPositive(MaterialDialog dialog) { mTools.setSharedPreferencesString("NOTES_PIN_CODE", ""); SQLiteDatabase sqLiteDatabase = new NotesSQLiteHelper(mContext) .getWritableDatabase(); sqLiteDatabase.delete(NotesSQLiteHelper.TABLE, null, null); sqLiteDatabase.close(); mTools.showToast(getString(R.string.notes_dialog_reset_pin_code_reset), 1); finish(); } @Override public void onNeutral(MaterialDialog dialog) { finish(); } }).cancelListener(new DialogInterface.OnCancelListener() { @Override public void onCancel(DialogInterface dialogInterface) { finish(); } }).contentColorRes(R.color.black).positiveColorRes(R.color.red) .neutralColorRes(R.color.dark_blue).show(); } }).showListener(new DialogInterface.OnShowListener() { @Override public void onShow(DialogInterface dialogInterface) { mInputMethodManager.toggleSoftInput(InputMethodManager.SHOW_IMPLICIT, 0); } }).cancelListener(new DialogInterface.OnCancelListener() { @Override public void onCancel(DialogInterface dialogInterface) { dialogInterface.dismiss(); finish(); } }).contentColorRes(R.color.black).positiveColorRes(R.color.dark_blue) .negativeColorRes(R.color.black).neutralColorRes(R.color.dark_blue).autoDismiss(false).show(); } }
From source file:heartware.com.heartware_master.DBAdapter.java
public void createProfile(HashMap<String, String> queryValues) { SQLiteDatabase database = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(USERNAME, queryValues.get(USERNAME)); values.put(PASSWORD, queryValues.get(PASSWORD)); values.put(DIFFICULTY, queryValues.get(DIFFICULTY)); values.put(DISABILITY, queryValues.get(DISABILITY)); database.insert(PROFILES_TABLE, null, values); database.close(); }
From source file:nerd.tuxmobil.fahrplan.congress.FahrplanMisc.java
/** * Load all Lectures from the DB on the day specified * * @param context The Android Context/*from w w w .j a v a2s .c o m*/ * @param day The day to load lectures for (0..), or -1 for all days * @return ArrayList of Lecture objects */ public static LectureList loadLecturesForDayIndex(Context context, int day) { MyApp.LogDebug(LOG_TAG, "load lectures of day " + day); SQLiteDatabase lecturedb = null; LecturesDBOpenHelper lecturesDB = new LecturesDBOpenHelper(context); lecturedb = lecturesDB.getReadableDatabase(); HighlightDBOpenHelper highlightDB = new HighlightDBOpenHelper(context); SQLiteDatabase highlightdb = highlightDB.getReadableDatabase(); LectureList lectures = new LectureList(); Cursor cursor, hCursor; boolean allDays; if (day == ALL_DAYS) { allDays = true; } else { allDays = false; } try { cursor = lecturedb.query(LecturesTable.NAME, LecturesDBOpenHelper.allcolumns, allDays ? null : (LecturesTable.Columns.DAY + "=?"), allDays ? null : (new String[] { String.format("%d", day) }), null, null, LecturesTable.Columns.DATE_UTC); } catch (SQLiteException e) { e.printStackTrace(); lecturedb.close(); highlightdb.close(); lecturesDB.close(); return null; } try { hCursor = highlightdb.query(HighlightsTable.NAME, HighlightDBOpenHelper.allcolumns, null, null, null, null, null); } catch (SQLiteException e) { e.printStackTrace(); lecturedb.close(); highlightdb.close(); lecturesDB.close(); return null; } MyApp.LogDebug(LOG_TAG, "Got " + cursor.getCount() + " rows."); MyApp.LogDebug(LOG_TAG, "Got " + hCursor.getCount() + " highlight rows."); if (cursor.getCount() == 0) { cursor.close(); lecturedb.close(); highlightdb.close(); lecturesDB.close(); return null; } cursor.moveToFirst(); while (!cursor.isAfterLast()) { Lecture lecture = new Lecture(cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.EVENT_ID))); lecture.title = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.TITLE)); lecture.subtitle = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.SUBTITLE)); lecture.day = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.DAY)); lecture.room = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.ROOM)); lecture.startTime = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.START)); lecture.duration = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.DURATION)); lecture.speakers = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.SPEAKERS)); lecture.track = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.TRACK)); lecture.type = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.TYPE)); lecture.lang = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.LANG)); lecture.abstractt = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.ABSTRACT)); lecture.description = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.DESCR)); lecture.relStartTime = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.REL_START)); lecture.date = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.DATE)); lecture.links = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.LINKS)); lecture.dateUTC = cursor.getLong(cursor.getColumnIndex(LecturesTable.Columns.DATE_UTC)); lecture.room_index = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.ROOM_IDX)); lecture.recordingLicense = cursor.getString(cursor.getColumnIndex(LecturesTable.Columns.REC_LICENSE)); lecture.recordingOptOut = cursor.getInt( cursor.getColumnIndex(LecturesTable.Columns.REC_OPTOUT)) == LecturesTable.Values.REC_OPTOUT_OFF ? Lecture.RECORDING_OPTOUT_OFF : Lecture.RECORDING_OPTOUT_ON; lecture.changedTitle = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_TITLE)) != 0; lecture.changedSubtitle = cursor .getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_SUBTITLE)) != 0; lecture.changedRoom = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_ROOM)) != 0; lecture.changedDay = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_DAY)) != 0; lecture.changedSpeakers = cursor .getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_SPEAKERS)) != 0; lecture.changedRecordingOptOut = cursor .getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_RECORDING_OPTOUT)) != 0; lecture.changedLanguage = cursor .getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_LANGUAGE)) != 0; lecture.changedTrack = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_TRACK)) != 0; lecture.changedIsNew = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_IS_NEW)) != 0; lecture.changedTime = cursor.getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_TIME)) != 0; lecture.changedDuration = cursor .getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_DURATION)) != 0; lecture.changedIsCanceled = cursor .getInt(cursor.getColumnIndex(LecturesTable.Columns.CHANGED_IS_CANCELED)) != 0; lectures.add(lecture); cursor.moveToNext(); } cursor.close(); hCursor.moveToFirst(); while (!hCursor.isAfterLast()) { String lecture_id = hCursor.getString(hCursor.getColumnIndex(HighlightsTable.Columns.EVENT_ID)); int highlightState = hCursor.getInt(hCursor.getColumnIndex(HighlightsTable.Columns.HIGHLIGHT)); MyApp.LogDebug(LOG_TAG, "lecture " + lecture_id + " is hightlighted:" + highlightState); for (Lecture lecture : lectures) { if (lecture.lecture_id.equals(lecture_id)) { lecture.highlight = (highlightState == HighlightsTable.Values.HIGHLIGHT_STATE_ON ? true : false); } } hCursor.moveToNext(); } hCursor.close(); highlightdb.close(); lecturedb.close(); lecturesDB.close(); return lectures; }
From source file:com.raspi.chatapp.util.storage.MessageHistory.java
public int getMessageAmount(String buddyId) { SQLiteDatabase db = mDbHelper.getReadableDatabase(); try {// w w w . ja va2 s . co m Cursor c = db.rawQuery("SELECT * FROM " + buddyId, null); int cnt = c.getCount(); c.close(); db.close(); return cnt; } catch (Exception e) { return 0; } }
From source file:com.melchor629.musicote.MainActivity.java
@Override public void onCreate(Bundle savedInstanceState) { // Set the user interface layout for this Activity // The layout file is defined in the project res/layout/main.xml file super.onCreate(savedInstanceState); setContentView(R.layout.main);//from www .j a v a2s . c o m appContext = getApplicationContext(); swipeRefreshLayout = (SwipeRefreshLayout) findViewById(R.id.mainLayout); swipeRefreshLayout.setOnRefreshListener(this); swipeRefreshLayout.setColorSchemeResources(R.color.colorAccent, R.color.colorPrimaryDark, R.color.colorGrey600); final ListView list = (ListView) findViewById(android.R.id.list); list.setOnScrollListener(new ListView.OnScrollListener() { @Override public void onScrollStateChanged(AbsListView view, int scrollState) { } @Override public void onScroll(AbsListView view, int firstVisibleItem, int visibleItemCount, int totalItemCount) { boolean enable = false; if (list != null && list.getChildCount() > 0) { // check if the first item of the list is visible boolean firstItemVisible = list.getFirstVisiblePosition() == 0; // check if the top of the first item is visible boolean topOfFirstItemVisible = list.getChildAt(0).getTop() == 0; // enabling or disabling the refresh layout enable = firstItemVisible && topOfFirstItemVisible; } swipeRefreshLayout.setEnabled(enable); } }); getActionBar().setIcon(R.drawable.ic_launcher); getActionBar().setDisplayUseLogoEnabled(true); // La app prueba en busca de la direccin correcta WifiManager mw = (WifiManager) getSystemService(Context.WIFI_SERVICE); WifiInfo wi = mw.getConnectionInfo(); String SSID = wi.getSSID(); Log.i("MainActivity", "Wifi conectado: " + SSID + " " + (SSID != null ? SSID.equals("Madrigal") : "")); if (SSID == null) { SSID = ""; Toast.makeText(this, getString(R.string.no_wifi), Toast.LENGTH_LONG).show(); } if (SSID.equals("Madrigal") || SSID.contains("Madrigal") || System.getProperty("os.version").equals("3.4.67+")) { MainActivity.HOST = "192.168.1.133"; } else { MainActivity.HOST = "reinoslokos.no-ip.org"; } Log.i("MainActivity", "HOST: " + HOST); //Deletes the notification if remains (BUG) NotificationManager mn = (NotificationManager) getSystemService(Context.NOTIFICATION_SERVICE); if (Reproductor.a == -1) mn.cancel(1); mn.cancel(3); //Revisa la base de datos DB mDbHelper = new DB(getBaseContext()); SQLiteDatabase db = mDbHelper.getWritableDatabase(); //Actualizacin de la lista if (mDbHelper.isNecesaryUpgrade(db) && Utils.HostTest(HOST) == 200) async(); else cursordb(db); db.close(); setRequestedOrientation(ActivityInfo.SCREEN_ORIENTATION_PORTRAIT); }
From source file:com.onesignal.NotificationBundleProcessor.java
private static void saveNotification(Context context, Bundle bundle, boolean opened, int notificationId) { try {//from w w w . j a va 2 s . c o m JSONObject customJSON = new JSONObject(bundle.getString("custom")); OneSignalDbHelper dbHelper = new OneSignalDbHelper(context); SQLiteDatabase writableDb = dbHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(NotificationTable.COLUMN_NAME_NOTIFICATION_ID, customJSON.getString("i")); if (bundle.containsKey("grp")) values.put(NotificationTable.COLUMN_NAME_GROUP_ID, bundle.getString("grp")); values.put(NotificationTable.COLUMN_NAME_OPENED, opened ? 1 : 0); if (!opened) values.put(NotificationTable.COLUMN_NAME_ANDROID_NOTIFICATION_ID, notificationId); if (bundle.containsKey("title")) values.put(NotificationTable.COLUMN_NAME_TITLE, bundle.getString("title")); values.put(NotificationTable.COLUMN_NAME_MESSAGE, bundle.getString("alert")); values.put(NotificationTable.COLUMN_NAME_FULL_DATA, bundleAsJSONObject(bundle).toString()); writableDb.insert(NotificationTable.TABLE_NAME, null, values); // Clean up old records that have been dismissed or opened already after 1 week. writableDb.delete(NotificationTable.TABLE_NAME, NotificationTable.COLUMN_NAME_CREATED_TIME + " < " + ((System.currentTimeMillis() / 1000) - 604800) + " AND " + "(" + NotificationTable.COLUMN_NAME_DISMISSED + " = 1 OR " + NotificationTable.COLUMN_NAME_OPENED + " = 1" + ")", null); writableDb.close(); } catch (JSONException e) { e.printStackTrace(); } }