mercredi 9 mars 2016

How To Get A Boolean Result From Search - SQLite Database

Good day, I always used getString() and getInt() in getting results. I'm doing a simple searching and I want to get a boolean result if it is found.

Here's my sample code: ForgotPassword.java

 @Override
public void onClick(View v) {

    String strUserForget = edtForgotPassword.getText().toString().trim();

    switch (v.getId()){
        case R.id.buttonSubmit:

            if (strUserForget.matches("")){
                Toast.makeText(ForgotPasswordActivity.this, "Please Provide Complete Info", Toast.LENGTH_LONG).show();
            }else {
                //String forgetPassProject = "";
                Cursor cursor = (registerDatabase.getSingleRecordForgetPass(strUserForget));
                boolean value = (cursor.getInt(registerDatabase.ID) == 1);

                Toast.makeText(ForgotPasswordActivity.this, "Your password is: " , Toast.LENGTH_LONG).show();
            }
            break;

        case R.id.buttonGoBackWelcome:
            startActivity( new Intent(getApplicationContext(),WelcomeActivity.class));
            finish();
            break;
    }

}

And for registerSQLDatabase.java

public Cursor getSingleRecordForgetPass(String username){

    String querySingleRecord = "SELECT * FROM " + DB_TABLE + "WHERE = " +FULL_NAME+ "LIKE" +username ;
    return  sqLiteDatabase.rawQuery(querySingleRecord,null);
}

The boolean value = (cursor.getInt(registerDatabase.ID) > 0); is incompatible.

Aucun commentaire:

Enregistrer un commentaire