SQLite Spinner

August 3,2016

In this example, we are adding a label on button click and displaying all the added labels on the spinner. As you have seen in the previous example, SQLiteOpenHelper class need to be extended for performing operations on the sqlite.

We have overridden the onCreate() and onUpgrade() method of SQLiteOpenHelper class in the DatabaseHandler class that provides additional methods to insert and display the labels or data.

Android Sqlite Spinner Example

Let’s see the simple code to add and display the string content on spinner using sqlite database.

activity_main.xml

File: activity_main.xml
  1. <RelativeLayout xmlns:androclass=“http://schemas.android.com/apk/res/android&#8221;
  2.     xmlns:tools=“http://schemas.android.com/tools&#8221;
  3.     android:layout_width=“match_parent”
  4.     android:layout_height=“match_parent”
  5.     tools:context=“.MainActivity” >
  7.      <!– Label –>
  8.     <TextView
  9.         android:layout_width=“fill_parent”
  10.         android:layout_height=“wrap_content”
  11.         android:text=“Add New Label”
  12.         android:padding=“8dip” />
  14.     <!– Input Text –>
  15.     <EditText android:id=“@+id/input_label”
  16.         android:layout_width=“fill_parent”
  17.         android:layout_height=“wrap_content”
  18.         android:layout_marginLeft=“8dip”
  19.         android:layout_marginRight=“8dip”/>
  21.     <Spinner
  22.         android:id=“@+id/spinner”
  23.         android:layout_width=“fill_parent”
  24.         android:layout_height=“wrap_content”
  25.         android:layout_alignParentLeft=“true”
  26.         android:layout_below=“@+id/btn_add”
  27.         android:layout_marginTop=“23dp” />
  29.     <Button
  30.         android:id=“@+id/btn_add”
  31.         android:layout_width=“wrap_content”
  32.         android:layout_height=“wrap_content”
  33.         android:layout_below=“@+id/input_label”
  34.         android:layout_centerHorizontal=“true”
  35.         android:text=“Add Item” />
  37. </RelativeLayout>

Leave a comment