Example #1
0
  @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;
    }
  }