Storing Data In A Database Using Edit Text And Button

Hi I am trying to insert data into database using EditText and Button I have created. I am stuck at Activity part of the code. I am unable to proceed how to write the Onclick actio

Solution 1:

Change your code as to instert Edittext values in database on button click:

publicclassDatabaseActivityextendsActivity {
 DBAdapter db;
Button submitbtn;
EditText edit1,edit2,edit3;
@OverridepublicvoidonCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_database);
    db=newDBAdapter(this);
   submitbtn = (Button) findViewById(R.id.submit);
   edit1 = (EditText) findViewById(R.id.edit1);
   edit2 = (EditText) findViewById(R.id.edit2);
   edit3 = (EditText) findViewById(R.id.edit3);
    db.open();

    submitbtn.setOnClickListener(newOnClickListener()
    {
        publicvoidonClick(View v)
        {
                String steedtone=edit1.getText().toString();
                String steedttwo=edit2.getText().toString();
                String steedtthree=edit3.getText().toString();

                long result=db.insertTitle(steedtone,steedttwo,steedtthree);
        }
         });
  } 
}

Solution 2:

publicclassDatabaseActivityextendsActivity {
    EditText edit1,edit2,edit3;
    Button submit;

    @OverridepublicvoidonCreate(Bundle savedInstanceState){
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
         finalDBAdapterdb=newDBAdapter(this);
         db.open();
         edit1=(EditText)findViewById(R.id.edit1);
         edit2=(EditText)findViewById(R.id.edit2);
         edit3=(EditText)findViewById(R.id.edit3);
         submit=(Button)findViewById(R.id.submit);
        submit.setOnClickListener(newOnClickListener(){


            @OverridepublicvoidonClick(View v) {
                String editText1=edit1.getText().toString();
                String editText2=edit2.getText().toString();
                String editText3=edit3.getText().toString();
                long result=db.insertTitle(editText1, editText2, editText3);
                Toast.makeText(MainActivity.this,"DataSaved",Toast.LENGTH_LONG).show();// TODO Auto-generated method stub

            }
        });
    }

just paste it your database Activity and see the magic cheers..

Solution 3:

This will come inside your onCreate() after setContentView() is called.

Buttonbtn= (Button) findViewById(R.id.btnId);
EditTextedtTxt= (EditText) findViewById(R.id.edtId);

btn.setOnClickListener(newOnClickListener() {

            @OverridepublicvoidonClick(View v) {
                // TODO Auto-generated method stub
                insertDataInDb();

            }
        });

---

publicvoidinsertDataInDb() {
        // TODO Auto-generated method stubString str = edtTxt.getText().toString();
        //Code for insertion
    }

Solution 4:

check below code.

package com.example.database1;
import android.os.Bundle;
import android.app.Activity;
import android.database.Cursor;
import android.view.Menu;
import android.widget.Toast;

publicclassDatabaseActivityextendsActivity {

DBAdapter db;

@OverridepublicvoidonCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_database);
    db = newDBAdapter(this);
    db.open();

    Buttonbtn= (Button) findViewById(R.id.btnId);
    EditTextedtTxt= (EditText) findViewById(R.id.edtId);

    btn.setOnClickListener(newOnClickListener() {

        @OverridepublicvoidonClick(View v) {
            // TODO Auto-generated method stubStringname= edtTxt.getText().toString();
            try{
            insertTitle("ISBN",""+name,"publisar");
            }catch(Exception e){
              Log.d("error-->","insert data-->"+e.getMassage().toString());
              }

        }
    });
  } 
  }