Could not Retrieve Username and Password from Sqlite Database

Question

While i was trying to retrieve username and password from Sqlite i found the following exception

  java.lang.NullPointerException: Attempt to invoke virtual method 'android.database.sqlite.SQLiteDatabase android.content.Context.openOrCreateDatabase(java.lang.String, int, android.database.sqlite.SQLiteDatabase$CursorFactory, android.database.DatabaseErrorHandler)' on a null object reference
                                                                            at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:223)
                                                                            at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)
                                                                            at com.example.nawin.demo.database.DatabaseOpenHelper.getUserPass(DatabaseOpenHelper.java:115)
                                                                            at com.example.nawin.demo.login_fragment$2.onClick(login_fragment.java:68)
                                                                            at android.view.View.performClick(View.java:5076)
                                                                            at android.view.View$PerformClick.run(View.java:20279)
                                                                            at android.os.Handler.handleCallback(Handler.java:739)
                                                                            at android.os.Handler.dispatchMessage(Handler.java:95)
                                                                            at android.os.Looper.loop(Looper.java:135)
                                                                            at android.app.ActivityThread.main(ActivityThread.java:5910)
                                                                            at java.lang.reflect.Method.invoke(Native Method)
                                                                            at java.lang.reflect.Method.invoke(Method.java:372)
                                                                            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1405)
                                                                            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1200)

//this is my method to retrieve

 public void getUserPass(String user, String pass)throws SQLException{
        db=this.getWritableDatabase();
        String query="select * from register where username= '"+user+"' and password= '"+pass+"'";
        cursor=db.rawQuery(query,null);

    }

// this is where i called above method

login.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                String strUser = txUserName.getText().toString();
                String strPass = txPassword.getText().toString();
                boolean loginStatus = false;
                String NAME = "";

                if (view.getId() == R.id.btnLogin) {

                    helper.getUserPass(strUser,strPass);
                   helper.cursor.moveToFirst();

                    do {
                        if(strUser.equals(helper.cursor.getString(0))&& (strPass.equals(helper.cursor.getString(1)))){

                          loginStatus=true;
                            NAME=helper.cursor.getString(0);
                        }
                    }while (helper.cursor.moveToNext());

                        if(loginStatus==true){

                            Toast.makeText(getActivity(),"Login Successful!!",Toast.LENGTH_SHORT).show();
                        }
                        else{

                                Toast.makeText(getActivity(),"Invalid Username Password",Toast.LENGTH_SHORT).show();
                                txUserName.setText("");
                                txPassword.setText("");
            }


        }

change your query statement like this `String query="select * from register where username= "+user+" and password= "+pass";` — GIRIDHARAN, Jan 04 '16 at 09:20
@nawin khatiwada: Have u create SQLiteDatabase obj correctly b4 calling getWriteableDatabase()? — kevz, Jan 04 '16 at 09:21

User Learning · Answer 1 · 2016-01-04T09:43:08.467

loginButton.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View view) {
                String userName = txUserName.getText().toString();
                String password = txPassword.getText().toString();
                String storedPassword = helper
                        .getSinlgeEntry(userName);
                if (password.equals(storedPassword)) {
                // ur stuff
                }
            }
        });

Change ur getUserPass(String user, String pass) to this and modify ur code try this following:

public String getSinlgeEntry(String userName) {
db = dbHelper.getWritableDatabase();
    Cursor cursor = db.query("REGISTER", null, " USERNAME=?",
            new String[] { userName }, null, null, null);
    if (cursor.getCount() < 1) {
        cursor.close();
        return "NOT EXIST";
    }
    cursor.moveToFirst();
    String password = cursor.getString(cursor.getColumnIndex("PASSWORD"));
    cursor.close();
    return password;
}

Or Post ur full code of db class we ll check

Could not Retrieve Username and Password from Sqlite Database

1 Answers1