@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; } }
/** * check if database must be created or is already existing * * @param context context from main activity */ public DataSource(Context context) { dbHelper = new DatabaseHelper(context); //// NanoHTTPD.myOut.println("I'm alive"); try { dbHelper.createDataBase(); } catch (IOException ioe) { throw new Error("Unable to create database"); } try { dbHelper.openDataBase(); } catch (SQLException sqle) { throw sqle; } }
private void initDatabase() { myDbHelper = new DatabaseHelper(this); try { myDbHelper.createDataBase(); } catch (IOException ioe) { throw new Error("Unable to create database"); } try { myDbHelper.openDataBase(); } catch (SQLException sqle) { Log.d(TAG, "openfailed"); throw sqle; } }
public void init_db() { myDb = new DatabaseHelper(this); { try { myDb.createDataBase(); } catch (IOException ioe) { throw new Error("Unable to create database"); } try { myDb.openDataBase(); } catch (SQLException sqle) { throw sqle; } myDb.getReadableDatabase(); c = myDb.getNotes(); if (c.moveToFirst()) { do {} while (c.moveToNext()); } } }