@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());
}
}
}
