Put default data in Android Database

Question

Put default data in Android Database

Navigation

#1 by (1 votes)
#2 by (0 votes)

0

I have a kind of registration form and I would like to know if, for example, if you do not put anything as a password, you will enter a default password.

So I have the registration method

    private void register(){
    String user = etuser.getText().toString();
    String pass = etPass.getText().toString();
    if(user.isEmpty() && pass.isEmpty()){
        displayToast("Usuario o contraseña vacio");
    }else{
        db.addUser(user,pass);
        displayToast("Usuario registrado con exito!");
        finish();
    }
}

And method that adds to the database

    public void addUser(String usurarios, String password) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(COLUMN_usurarios, usurarios);
    values.put(COLUMN_PASS, password);

    long id = db.insert(USER_TABLE, null, values);
    db.close();

    Log.d(TAG, "Usuario insertado" + id);
}

Updated with COLUMN_STATE

    public void addUser(String usurarios, String password, String estado) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(COLUMN_usurarios, usurarios);
    values.put(COLUMN_PASS, password);
    values.put(COLUMN_ESTADO, estado);

    long id = db.insert(USER_TABLE, null, values);
    db.close();

    Log.d(TAG, "Usuario insertado" + id);
}

Registration Method

    private void register(){
    String user = etuser.getText().toString();
    String pass = etPass.getText().toString();
    String estado = Estado.getText().toString();
    if(user.isEmpty() && pass.isEmpty()){
        displayToast("Usuario o contraseña vacio");
    }
    else if (pass.isEmpty()){
        db.addUser(user,"1234",estado);
        displayToast("Usuario registrado con exito!");
        finish();
    }
    else if (estado.isEmpty()){
        db.addUser(user,pass,"Hola que tal");
    }
    else{
        db.addUser(user,pass,estado);
        displayToast("Usuario registrado con exito!");
        finish();
    }
}

Registration Layout.

java android

asked by zzxbx 07.12.2017 в 02:45

source

2 answers

0

Another way to insert default values is to change the database definition so that you do not have to validate field by field if it comes empty in the following way when you create the table:

db.execSQL("CREATE TABLE tabla_usuarios
(usuario TEXT NOT NULL,
 clave TEXT NOT NULL DEFAULT '123456') ";

answered by 07.12.2017 в 15:47

Problem creating friendly URLs with htaccess and regular expressions How to make Javascript capitalize each element of an array?

score 1 · Accepted Answer

You can do it like this:

if(user.isEmpty()){
        displayToast("Usuario o contraseña vacio");
    }
else if (pass.isEmpty()){
       db.addUser(user,"1234");
        displayToast("Usuario registrado con exito!");
        finish();
}
else{
        db.addUser(user,pass);
        displayToast("Usuario registrado con exito!");
        finish();
    }