title: storing data in a database using edit text and button
body: <p>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 <code>Onclick action</code> part for Button and EditText part Please help me. I am new to android</p>
  
  <p>DBAdapter.java</p>
  
  <pre><code>package com.example.database1;
  
  public class DBAdapter 
  {
      public static final String KEY_ROWID = "_id";
      public static final String KEY_ISBN = "isbn";
      public static final String KEY_TITLE = "title";
      public static final String KEY_PUBLISHER = "publisher";    
      private static final String TAG = "DBAdapter";
  
      private static final String DATABASE_NAME = "books";
      private static final String DATABASE_TABLE = "titles";
      private static final int DATABASE_VERSION = 1;
  
      private static final String DATABASE_CREATE =
          "create table titles (_id integer primary key autoincrement, "
          + "isbn text not null, title text not null, " 
          + "publisher text not null);";
  
      private final Context context; 
  
      private DatabaseHelper DBHelper;
      private SQLiteDatabase db;
  
      public DBAdapter(Context ctx) 
      {
          this.context = ctx;
          DBHelper = new DatabaseHelper(context);
      }
  
      private static class DatabaseHelper extends SQLiteOpenHelper 
      {
          DatabaseHelper(Context context) 
          {
              super(context, DATABASE_NAME, null, DATABASE_VERSION);
          }
  
          @Override
          public void onCreate(SQLiteDatabase db) 
          {
              db.execSQL(DATABASE_CREATE);
          }
  
          @Override
          public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) 
          {
              Log.w(TAG, "Upgrading database from version " + oldVersion 
                      + " to "
                      + newVersion + ", which will destroy all old data");
              db.execSQL("DROP TABLE IF EXISTS titles");
              onCreate(db);
          }
      }    
  
      //---opens the database---
      public DBAdapter open() throws SQLException 
      {
          db = DBHelper.getWritableDatabase();
          return this;
      }
  
      //---closes the database---    
      public void close() 
      {
          DBHelper.close();
      }
  
      //---insert a title into the database---
      public long insertTitle(String isbn, String title, String publisher) 
      {
          ContentValues initialValues = new ContentValues();
          initialValues.put(KEY_ISBN, isbn);
          initialValues.put(KEY_TITLE, title);
          initialValues.put(KEY_PUBLISHER, publisher);
          return db.insert(DATABASE_TABLE, null, initialValues);
      }
  
      //---deletes a particular title---
      public boolean deleteTitle(long rowId) 
      {
          return db.delete(DATABASE_TABLE, KEY_ROWID + 
                  "=" + rowId, null) &gt; 0;
      }
  
      //---retrieves all the titles---
      public Cursor getAllTitles() 
      {
          return db.query(DATABASE_TABLE, new String[] {
                  KEY_ROWID, 
                  KEY_ISBN,
                  KEY_TITLE,
                  KEY_PUBLISHER
              }, 
              null, 
              null, 
              null, 
              null, 
              null);
      }
  
      //---retrieves a particular title---
      public Cursor getTitle(long rowId) throws SQLException 
      {
          Cursor mCursor =
              db.query(true, DATABASE_TABLE, new String[] {
                                  KEY_ROWID,
                                  KEY_ISBN, 
                                  KEY_TITLE,
                                  KEY_PUBLISHER
                      }, 
                      KEY_ROWID + "=" + rowId, 
                      null,
                      null, 
                      null, 
                      null, 
                      null);
          if (mCursor != null) {
              mCursor.moveToFirst();
          }
          return mCursor;
      }
  
      //---updates a title---
      public boolean updateTitle(long rowId, String isbn, String title, String publisher) 
      {
          ContentValues args = new ContentValues();
          args.put(KEY_ISBN, isbn);
          args.put(KEY_TITLE, title);
          args.put(KEY_PUBLISHER, publisher);
          return db.update(DATABASE_TABLE, args, 
                       KEY_ROWID + "=" + rowId, null) &gt; 0;
      }
  }
  </code></pre>
  
  <p>DatabaseActivity.java</p>
  
  <pre><code>package com.example.database1;
  
  public class DatabaseActivity extends Activity {
  
      @Override
      public void onCreate(Bundle savedInstanceState) {
          super.onCreate(savedInstanceState);
          setContentView(R.layout.activity_database);
          DBAdapter db = new DBAdapter(this);
          db.open();
      } 
  }
  </code></pre>
  
  <p>activity_database.xml:</p>
  
  <pre><code>&lt;LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
      xmlns:tools="http://schemas.android.com/tools"
      android:layout_width="match_parent"
      android:layout_height="match_parent"&gt;
      &lt;EditText
          android:id="@+id/edit1"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content" /&gt;
      &lt;EditText
          android:id="@+id/edit2"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content" /&gt;
      &lt;EditText
          android:id="@+id/edit3"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content" /&gt;
      &lt;Button 
          android:id="@+id/submit"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"  /&gt;
  &lt;/LinearLayout&gt;
  </code></pre>