title: how to store the values of edittext in database and then how to get that back
body: <p>I'm trying to put the value from an EditText into a database and then get the value from that database.</p>
  
  <p>I tried to store the values in database when the button is clicked in the activity as follows:</p>
  
  <pre><code>import android.app.Activity;
  
  import android.os.Bundle;
  import android.view.View;
  import android.view.View.OnClickListener;
  import android.widget.Button;
  import android.widget.EditText;
  
  public class hjhj extends Activity implements OnClickListener {
      private EditText txt,txt1;
  
      Button b;
  
      String nam;
      String ag;
  
  
      /** Called when the activity is first created. */
      @Override
      public void onCreate(Bundle savedInstanceState) {
          super.onCreate(savedInstanceState);
          setContentView(R.layout.main);
  
          txt = (EditText) findViewById(R.id.EditText01);
          txt1= (EditText) findViewById(R.id.EditText02);
          b=(Button) this.findViewById(R.id.Button01);
          b.setOnClickListener(this);         
     }
  
  
  
      @Override
      public void onClick(View v) {
          // TODO Auto-generated method stub
          nam=txt.getText().toString();
          ag=txt1.getText().toString();
  
          new DetailsOpenHelper(this);
  
      }
  
  
  }
  </code></pre>
  
  <p>DetailsOpenHelper:</p>
  
  <pre><code>import android.content.ContentValues;
  
  import android.database.Cursor;
  import android.database.SQLException;
  import android.database.sqlite.SQLiteDatabase;
  import android.database.sqlite.SQLiteOpenHelper;
  
  
  public class DetailsOpenHelper extends SQLiteOpenHelper{
  
      private static String DATABASE_NAME="employeedatabase";
  
      private static final int DATABASE_VERSION = 2;
      private static final String DETAILS_TABLE_NAME = "employeedetails";
  
      private static String nam;
      private static String ag;
  
      static String NAME=nam;
      static String AGE=ag;
      private String KEY_ROWID;
  
      private static final String DETAILS_TABLE_CREATE =
                  "CREATE TABLE " + DETAILS_TABLE_NAME + " (" +
                  NAME + " TEXT, " +
                  AGE + " TEXT);";
  
      private SQLiteOpenHelper mSQL;
      private SQLiteDatabase db;
  
  
  
      public DetailsOpenHelper(hjhj hjhj){
          super(hjhj, DATABASE_NAME, null,DATABASE_VERSION );
          // TODO Auto-generated constructor stub
      }
  
      @Override
      public void onCreate(SQLiteDatabase db) {
          // TODO Auto-generated method stub
           db.execSQL(DETAILS_TABLE_CREATE);
  
      }
  
      @Override
      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
          // TODO Auto-generated method stub
          db.execSQL("DETAILS_TABLE_IF_NOT_EXISTS");
          onCreate(db);
      }
  
  
        public void open() throws SQLException
          {
            DetailsOpenHelper mSQL = new DetailsOpenHelper(null);
              db = mSQL.getWritableDatabase();
           } 
  
  
      private void addDetails( String nam, String ag) {
  
              SQLiteDatabase db = mSQL.getWritableDatabase();
              ContentValues values = new ContentValues();
              values.put(NAME, nam);
              //values.put(TIME, System.currentTimeMillis());
              values.put(AGE, ag);
              db.insert(DETAILS_TABLE_NAME, null, values);
          }
  
        public Cursor getAllDetails() 
        {
            return db.query(DETAILS_TABLE_NAME, new String[] {
                    KEY_ROWID, 
                    NAME,
                    AGE  },  null, null, null, null, null, null);
        }   
  
  
        public boolean updateDetails(long rowId, String nam, 
                String ag) 
                {
                    ContentValues args = new ContentValues();
                    args.put(NAME, nam);
                    args.put(AGE, ag);
  
                    return db.update(DETAILS_TABLE_NAME, args, 
                                     KEY_ROWID + "=" + rowId, null) &gt; 0;
                }
  
  }
  </code></pre>
  
  <p>I want to store and retrieve the values when I click the button. Please can anyone help me if you know about this. I have tried a lot.</p>
  
  <p>Also, how do I view the database with the command prompt?</p>