public void setPatternMapping(String phonr_nr, long[] pattern){ //Database call here. Example: try{ database.open(); database.setPattern(phone_nr, pattern); database.close(); }catch(SQLiteException e){ e.printStackTrace(); } }
public long[] getPattern(String phone_nr){ //Database call here. Example: long[] pattern = null; try{ database.open(); pattern = database.setPattern(phone_nr, pattern); database.close(); }catch(SQLiteException e){ e.printStackTrace(); } return pattern; }
private void populateDatabase() { try { long rowId = 0; rowId = dbControl.addWord("testSyn",null,null,1); } catch (SQLiteException e){ e.printStackTrace(); }
try { Log.i(TAG, "donedddddd"); database = SQLiteDatabase.openOrCreateDatabase(DATABASE_FILE_PATH + File.separator + DATABASE_NAME, null); String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "(" + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT," + KEY_PH_NO + " TEXT" + ")"; database.execSQL(CREATE_CONTACTS_TABLE); } catch (SQLiteException ex) { ex.printStackTrace(); } finally { database.close(); }
case R.id.addBtn: String name = et.getText().toString(); try { dbcon.insertVestiging(groupd, name); }catch(SQLiteException e) { e.printStackTrace(); } Intent main = new Intent(Add_vestiging.this, vestiging_list.class); main.putExtra("groupID", String.valueOf(groupd)); startActivity(main); break;
myDB = jDB.getInstance(getApplicationContext()).db; myDB.beginTransaction(); try { String sSQL = "INSERT INTO kosik (mnozstvi, cena, idVyrobek) VALUES ('" + sMn + "', '" + sCena + "', '" + String.valueOf(iIDVyrobku) + "');"; myDB.execSQL(sSQL, null); myDB.setTransactionSuccessful(); } catch (SQLiteException e) { e.printStackTrace(); } finally { myDB.endTransaction(); }
public boolean checkOrder(String couponBrand, String couponTitle, String couponDenomination) { database = this.getReadableDatabase(); try { Cursor checkOrderConfirmationCursor = database.rawQuery("SELECT * FROM " + TABLE_ORDER_CONFIRMATION + " WHERE " + KEY_ORDER_BRAND + " = ? AND " + KEY_ORDER_TITLE + " = ? AND " + KEY_ORDER_DENOMINATION + " = ?", new String[] {couponBrand, couponTitle, couponDenomination}); if (checkOrderConfirmationCursor != null && checkOrderConfirmationCursor.getCount() > 0) { return true } } catch (SQLiteException sqle) { sqle.printStackTrace(); } return false; }
public void addNewData(String value) { try { ContentValues values = new ContentValues(); values.put([name of the column in your database for this value],value); getWritableDatabase().insertOrThrow([name of your table], null, values); } catch (SQLiteException sqlExc) { sqlExc.printStackTrace(); } catch (Exception exc) { exc.printStackTrace(); } }
public ArrayList<String> getDBTables() { ArrayList<String> toReturn = new ArrayList<String>(); try { Cursor c = db.rawQuery("SELECT name FROM sqlite_master WHERE type='table' AND name LIKE 'tbl%' ORDER BY name DESC", null); while(c.moveToNext()) { toReturn.add(c.getString(c.getColumnIndex("name"))); } c.close(); } catch(SQLiteException e) { e.printStackTrace(); } return toReturn; }
public static boolean checkDataBase(Context c) { File f = new File("/data/data/" + c.getPackageName() + "/databases/" + DATABASE_NAME); if (!f.exists()) return false; SQLiteDatabase checkDB = null; try { checkDB = SQLiteDatabase .openDatabase("/data/data/" + c.getPackageName() + "/databases/" + DATABASE_NAME, null, SQLiteDatabase.OPEN_READONLY); checkDB.close(); } catch (SQLiteException e) { e.printStackTrace(); } return checkDB != null ? true : false; }
ArrayList results= new ArrayList(); SQLiteDatabase myDB = this.openOrCreateDatabase("dummy.db", SQLiteDatabase.OPEN_READWRITE, null); try{ Cursor c = myDB.rawQuery("select a from xyz", null); int Column1 = c.getColumnIndex("a"); // Check if our result was valid. c.moveToFirst(); if (c != null) { int i = 0; // Loop through all Results do { i++; String a= c.getString(Column1); results.add(a); } while (c.moveToNext()); } } catch (SQLiteException e) { e.printStackTrace(); } finally { if (myDB != null) myDB.close(); }
public boolean isDbCreated() { String sDatabasePath = context.getDatabasePath(DB_NAME).getPath(); SQLiteDatabase tmpDb = null; if (mContext.getDatabasePath(DB_NAME).exists()) { try { tmpDb = SQLiteDatabase.openDatabase(sDatabasePath, null, SQLiteDatabase.OPEN_READONLY); tmpDb.close(); } catch (SQLiteException e) { e.printStackTrace(); } } else { Log.e(TAG, "DB file doesn't exist."); // If the parent dir doesn't exist, create it File parentDir = new File(mContext.getDatabasePath(DB_NAME).getParent()); if (!parentDir.exists()) { if (parentDir.mkdirs()) { Log.d(TAG, "Successfully created the parent dir:" + parentDir.getName()); } else { Log.e(TAG, "Failed to create the parent dir:" + parentDir.getName()); } } } return (tmpDb != null); }
SQLiteDatabase db = null; try { db = ctx.openOrCreateDatabase(DB_NAME, Context.MODE_PRIVATE, null); // Start the transaction db.beginTransaction(); // Fill the table db.execSQL("INSERT INTO users () values ()"); // ... more inserts... db.setTransactionSuccessful(); } catch (final SQLiteException se) { System.out.println ( ctx.getClass().getSimpleName() + "\n" + "Could not import to the database" ); se.printStackTrace(); result = 0; } finally { // End the transaction db.endTransaction(); db.close(); }
private List<MyItem> getAllItems() List<MyItem> itemsList = new ArrayList<MyItem>(); Cursor cursor = null; try { //get all rows cursor = mDatabase.query(MY_TABLE, null, null, null, null, null, null); if (cursor.moveToFirst()) { do { MyItem c = new MyItem(); c.setId(cursor.getInt(ID_COLUMN)); c.setName(cursor.getString(NAME_COLUMN)); itemsList.add(c); } while (cursor.moveToNext()); } } catch (SQLiteException e) { e.printStackTrace(); } finally { cursor.close(); } return itemsList; }
public static void loadParamTrees(SpectrumHeader[] spectrumHeaders, SQLiteConnection mzDbConnection) { // TODO: load all param_trees in a single SQL query for (SpectrumHeader header : spectrumHeaders) { if (!header.hasParamTree()) try { header.loadParamTree(mzDbConnection); } catch (SQLiteException e) { e.printStackTrace(); } } }
private List<Information> getAllItems() List<Information> itemsList = new ArrayList<Information>(); Cursor cursor = null; try { //get all rows cursor = mDatabase.query(TABLE_Name, null, null, null, null, null, null); if (cursor.moveToFirst()) { do { Information c = new Information(); c.setName(cursor.getString(KEY_NAME)); itemsList.add(c); } while (cursor.moveToNext()); } } catch (SQLiteException e) { e.printStackTrace(); } finally { cursor.close(); } return itemsList; }
public static void loadParamTrees(SpectrumHeader[] spectrumHeaders, SQLiteConnection mzDbConnection) { // TODO: load all param_trees in a single SQL query for (SpectrumHeader header : spectrumHeaders) { if (!header.hasParamTree()) try { header.loadParamTree(mzDbConnection); } catch (SQLiteException e) { e.printStackTrace(); } } }
// Create the database table if it doesn't exist protected final static void dbTableCreate(final Context ctx) { SQLiteDatabase db = null; try { db = ctx.openOrCreateDatabase(DB_NAME, Context.MODE_PRIVATE, null); db.execSQL ( "CREATE TABLE IF NOT EXISTS " + DB_TABLE + " (date DATETIME PRIMARY KEY NOT NULL DEFAULT (CURRENT_DATE), " + "score INTEGER DEFAULT (null));" ); } catch (final SQLiteException se) { System.out.println ( ctx.getClass().getSimpleName() + "\n" + "Could not create the database" ); se.printStackTrace(); } finally { db.close(); } }
public boolean hasNext() { try { if (_hasNextChecked == false) { this._hasNextChecked = true; if (stmt.step()) { this._hasNext = true; } else { this.dispose(); this._hasNext = false; } } return this._hasNext; } catch (SQLiteException e) { e.printStackTrace(); return false; } }
public boolean hasNext() { try { if (_hasNextChecked == false) { this._hasNextChecked = true; if (stmt.step()) { this._hasNext = true; } else { this.dispose(); this._hasNext = false; } } return this._hasNext; } catch (SQLiteException e) { e.printStackTrace(); return false; } }