android database getting nullpointer exception

Question

enter image description here I'm trying to load values into a SQLite table on android. I'm getting nullpointer exception when I click on button. Please find the attached image for the logcat.so to store values into the sqlite database table.

    public class MainActivity extends Activity {


    EditText edt1,edt2; 
    DataAdapter adapter;
    //String valueName,valueAddress;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

    //  database =new DataAdapter(this);        
        edt1 =(EditText)findViewById(R.id.editText1);
        edt2 =(EditText)findViewById(R.id.editText2);   
        // sdb = database.getWritableDatabase();

        Button button =(Button)findViewById(R.id.button1);

        button.setOnClickListener(new OnClickListener() {

            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub

                String  valueName =edt1.getText().toString().trim();
                String  valueAddress =edt2.getText().toString().trim(); 
             long value = adapter.insertData(valueName,valueAddress);   

             if (value < 0) {

                 Toast.makeText(getApplicationContext(), "Data not Added ",Toast.LENGTH_SHORT).show();
            } else {
                 Toast.makeText(getApplicationContext(), "Data Added",Toast.LENGTH_SHORT).show();
            }                           
            }               
        });

    }

}


public class DataAdapter {

       DataBase database;
       SQLiteDatabase db;      

public DataAdapter(Context context) {
    // TODO Auto-generated constructor stub
    database =new DataBase(context);    
}

public long insertData(String name ,String address){    

    SQLiteDatabase db= database.getWritableDatabase();  
    ContentValues values = new ContentValues();
    values.put(DataBase.NAME, name);
    values.put(DataBase.ADDRESS, address);
    return db.insert(DataBase.TABLENAME, null,values);
    }

public static class DataBase extends SQLiteOpenHelper{

    public static final String DATABASE="DataBase";
    public static final String TABLENAME="TableName";   
    public static final int VERSION = 5;
    public static final String NAME="name"; 
    public static final String ADDRESS="address";
    public static final String ID="_id";

    public static final String CREATE_TABLE = "create table "+TABLENAME+"("+ID+"" +
            "INTEGER PRIMARY KEY AUTOINCREMENT,"+NAME+" VARCHAR(255),"+ADDRESS+"  VARCHAR(255));";

    private Context context;

    public DataBase(Context context) {
        super(context, DATABASE, null, VERSION);        
        this.context =context;
        // TODO Auto-generated constructor stub     
        Toast.makeText(context, "onDataBase",Toast.LENGTH_SHORT).show();

    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub

        try {
            Toast.makeText(context, "oncreate",Toast.LENGTH_SHORT).show();
            db.execSQL(CREATE_TABLE);
        } catch (SQLException e) {
            // TODO: handle exception
        }       

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        try {
            Toast.makeText(context, "oncUpgrade",Toast.LENGTH_SHORT).show();
            db.execSQL("DROP TABLE IF EXITS"+TABLENAME);
            onCreate(db);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

}   



}][1]

what is MainActivity.java line 42?

Raghunandan
– Raghunandan

2014-01-21 09:59:09 +00:00
Commented Jan 21, 2014 at 9:59 — Raghunandan
– Raghunandan, Commented Jan 21, 2014 at 9:59
long value = adapter.insertData(valueName,valueAddress);

arunk
– arunk

2014-01-21 10:01:50 +00:00
Commented Jan 21, 2014 at 10:01 — arunk
– arunk, Commented Jan 21, 2014 at 10:01
@arunk uncomment database =new DataAdapter(this);

Raghunandan
– Raghunandan

2014-01-21 10:03:21 +00:00
Commented Jan 21, 2014 at 10:03 — Raghunandan
– Raghunandan, Commented Jan 21, 2014 at 10:03

kalyan pvs · Accepted Answer · 2014-01-21 09:59:45Z

3

 DataAdapter adapter;

is not initialized in your code initilize it and then use..like

adapter = new DataAdapter(this);

answered Jan 21, 2014 at 9:59

kalyan pvs

14.6k4 gold badges43 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

android database getting nullpointer exception

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