/**
* Obtiene los valores nombre y contraseña, de un usuario especifico.
*
* @param name
* @return
*/
public String getData(String name) {
SQLiteDatabase db = helper.getWritableDatabase();
/*Sentencia SQL a ejecutar
* SELECT name,password from user where name="name";
*/
String[] columns = {helper.COLUMN_NAME_NAME, helper.COLUMN_NAME_PHOTOURI};
// Estableciendo la consulta SQL
Cursor cursor =
db.query(
helper.TABLE_NAME,
columns,
helper.COLUMN_NAME_NAME + " = '" + name + "'",
null,
null,
null,
null,
null);
StringBuffer buffer = new StringBuffer();
while (cursor.moveToNext()) {
// Obteniendo los valores de los indices de las columnas.
int index1 = cursor.getColumnIndex(helper.COLUMN_NAME_NAME);
int index2 = cursor.getColumnIndex(helper.COLUMN_NAME_PHOTOURI);
String nameCol = cursor.getString(index1);
String passCol = cursor.getString(index2);
buffer.append(nameCol + " " + passCol + "\n");
}
return buffer.toString();
}
/**
* Inserta la data a la base de datos.
*
* @param name
* @return
*/
public long insertData(String name, String photouri) {
SQLiteDatabase db = helper.getWritableDatabase();
ContentValues contentValues = new ContentValues();
// content values basically
contentValues.put(MyDatabaseOpenHelper.COLUMN_NAME_NAME, name);
contentValues.put(MyDatabaseOpenHelper.COLUMN_NAME_PHOTOURI, photouri);
long id = db.insert(MyDatabaseOpenHelper.TABLE_NAME, null, contentValues);
return id;
}
/**
* Obtiene todos los valores de la base de datos.
*
* @return
*/
public String getAllData() {
SQLiteDatabase db = helper.getWritableDatabase();
/*Sencia SQL a ejecutar
*SELECT id,name,password FROM USER
*/
String[] columns = {
helper.COLUMN_NAME_ID, helper.COLUMN_NAME_NAME, helper.COLUMN_NAME_PHOTOURI
};
Cursor cursor = db.query(helper.TABLE_NAME, columns, null, null, null, null, null);
StringBuffer buffer = new StringBuffer();
while (cursor.moveToNext()) {
int cid = cursor.getInt(0);
String name = cursor.getString(1);
String password = cursor.getString(2);
buffer.append(cid + " " + name + " " + password + "\n");
}
return buffer.toString();
}
