Error while trying to fetch record from SQL with comparing strings in android

Question

I made a table in SQL that stores id as a string. Now when I want to retrieve a particular record by comparing the string id, it is returning null pointer exception. I don't know how to solve this.

here is the activity that calls the database by passing the string

SearchDb.java

import android.app.Activity;
import android.app.Dialog;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

public class SearchDb extends Activity implements OnClickListener {

    EditText enid;
    Button search;
    TextView id, name, age;
    String s;

    Bundle value;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.searchdb);

        enid = (EditText) findViewById(R.id.et_enid);
        search = (Button) findViewById(R.id.bsearch);
        id = (TextView) findViewById(R.id.tv_enid);
        name = (TextView) findViewById(R.id.tv_name);
        age = (TextView) findViewById(R.id.tv_age);

        search.setOnClickListener(this);
    }

    @Override
    public void onClick(View v) {
        switch (v.getId()) {
        case R.id.bsearch:
            try {
                s = enid.getText().toString();

                CreateDB fetch = new CreateDB(this);
                value = fetch.fetchData(s);
                fetch.close();

                id.setText(value.getString("id"));
                name.setText(value.getString("name"));
                age.setText(value.getString("age"));

            } catch (Exception e) {
                Dialog d = new Dialog(this);
                TextView tv = new TextView(this);
                tv.setText(e.toString());
                d.setTitle("Error!!");
                d.setContentView(tv);
                d.show();

            }
        }
        // TODO Auto-generated method stub

    }

}

the CreateDB class constructor is--

public CreateDB(Context cxt) {
    myContext = cxt;
    myDB = myContext.openOrCreateDatabase(DbName, DbVersion, null);
}

and the method to search is like this--

public Bundle fetchData(String l) throws SQLException {


        String[] chck=new String[]{l};
        Cursor c = myDB.query(TbName, cols, KeyId+"=?", chck, null, null, null);
        if (c != null) {
            int iName = c.getColumnIndex(KeyName);
            int iAge = c.getColumnIndex(KeyAge);
            int iId = c.getColumnIndex(KeyId);

            c.moveToFirst();

            send.putString("id", c.getString(iId));
            send.putString("name", c.getString(iName));
            send.putString("age", c.getString(iAge));

            return send;
        }
        // TODO Auto-generated method stub
        return null;
    }

Finally I am getting a java.lang.NullPointerException in LogCat.

Please help!

I tried to post a picture of my emulator, but i need to have 15 reputation for that. Since i am a new user, i dont have enough reputation. — Aradhna
– Aradhna, Commented Mar 19, 2014 at 9:41
No need to post image just copy your logcat and paste it here as a text. — InnocentKiller
– InnocentKiller, Commented Mar 19, 2014 at 9:44
my logcat does not post an error, since i have put the code in try and catch and am then printing the error as a dialog. i just checked my logcat, it is not giving any error statement at all. — Aradhna
– Aradhna, Commented Mar 19, 2014 at 9:53

bhakti123 · Accepted Answer · 2014-03-19 17:14:53Z

1

Your code is totally correct. It is returning error because the bundle in which the values are stored is not initialized. So it becomes null hence null pointer exception error. Just initialize your bundle as Bundle send=new Bundle();. Then your code will work fine.

answered Mar 19, 2014 at 17:14

bhakti123

85310 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error while trying to fetch record from SQL with comparing strings in android

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related