samedi 11 avril 2015

Android Store Listview items to SQLite DB

In my custom Listview I am having different controls like EditText, Spinner... My listrow is like this... Initially I am loading 100 lines in the listview. I type in the details in the listivew and finally I save the record to database.


I would like to know how to save each row of listview details in the SQLite database.



<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout
android:id="@+id/relativeLayout1"
android:layout_height="wrap_content"
android:layout_width="fill_parent"
xmlns:android="http://ift.tt/nIICcg">

<TextView
android:id="@+id/FirstText"
android:layout_width="20dp"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:layout_centerVertical="true"
android:layout_marginLeft="1dp"
android:text="TextView" />

<EditText
android:id="@+id/SecondText"
android:layout_width="200dp"
android:layout_height="wrap_content"
android:layout_marginLeft="5dp"
android:layout_centerVertical="true"
android:inputType="text|textNoSuggestions"
android:ellipsize="end"
android:focusable="true"
android:focusableInTouchMode="true"
android:layout_toRightOf="@+id/FirstText"
android:background="@drawable/edit_text"
>
<requestFocus />
</EditText>

<Spinner
android:id="@+id/spUnitType"
android:layout_width="90dp"
android:layout_height="wrap_content"
android:layout_marginLeft="10dp"
android:entries="@array/unit"
android:layout_centerVertical="true"
android:spinnerMode="dropdown"
android:hint="Unit"
android:background="@drawable/edit_text"
android:textColor="@color/hookup_positive"
android:layout_toRightOf="@+id/SecondText" />

<Spinner
android:id="@+id/spDeviceType"
android:layout_width="80dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="10dp"
android:entries="@array/devicetype"
android:spinnerMode="dropdown"
android:background="@drawable/edit_text"
android:textColor="@color/hookup_positive"
android:layout_toRightOf="@+id/spUnitType" />

<Spinner
android:id="@+id/spInstalled"
android:layout_width="60dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="5dp"
android:entries="@array/yesno"
android:spinnerMode="dropdown"
android:background="@drawable/edit_text"
android:textColor="@color/hookup_positive"
android:layout_toRightOf="@+id/spDeviceType" />

<Spinner
android:id="@+id/spRemoteHeads"
android:layout_width="70dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="5dp"
android:entries="@array/remote"
android:spinnerMode="dropdown"
android:background="@drawable/edit_text"
android:textColor="@color/hookup_positive"
android:layout_toRightOf="@+id/spInstalled" />

<Spinner
android:id="@+id/spExitLamps"
android:layout_width="50dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="5dp"
android:entries="@array/remote"
android:spinnerMode="dropdown"
android:background="@drawable/edit_text"
android:textColor="@color/hookup_positive"
android:layout_toRightOf="@+id/spRemoteHeads" />

<Spinner
android:id="@+id/spDeficiency"
android:layout_width="80dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="5dp"
android:entries="@array/deficiency"
android:spinnerMode="dropdown"
android:background="@drawable/edit_text"
android:textColor="@color/hookup_positive"
android:layout_toRightOf="@+id/spExitLamps" />
<Spinner
android:id="@+id/spOperation"
android:layout_width="80dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="5dp"
android:entries="@array/yesno"
android:spinnerMode="dropdown"
android:background="@drawable/edit_text"
android:textColor="@color/hookup_positive"
android:layout_toRightOf="@+id/spDeficiency" />

<EditText
android:id="@+id/Voltage"
android:layout_width="60dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="5dp"
android:inputType="number"
android:ellipsize="end"
android:focusable="true"
android:focusableInTouchMode="true"
android:background="@drawable/edit_text"
android:layout_toRightOf="@+id/spOperation"
>
<requestFocus />
</EditText>
<EditText
android:id="@+id/Wattage"
android:layout_width="60dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="5dp"
android:inputType="number"
android:ellipsize="end"
android:focusable="true"
android:focusableInTouchMode="true"
android:background="@drawable/edit_text"
android:layout_toRightOf="@+id/Voltage"
>
<requestFocus />
</EditText>
<Spinner
android:id="@+id/spLamp"
android:layout_width="80dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="5dp"
android:entries="@array/lamp"
android:spinnerMode="dropdown"
android:background="@drawable/edit_text"
android:textColor="@color/hookup_positive"
android:layout_toRightOf="@+id/Wattage" />
<EditText
android:id="@+id/NotesText"
android:layout_width="180dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="5dp"
android:inputType="text|textNoSuggestions"
android:ellipsize="end"
android:focusable="true"
android:focusableInTouchMode="true"
android:background="@drawable/edit_text"
android:layout_toRightOf="@+id/spLamp"
>
<requestFocus />
</EditText>
<Spinner
android:id="@+id/spModel"
android:layout_width="80dp"
android:layout_height="wrap_content"
android:layout_centerVertical="true"
android:layout_marginLeft="5dp"
android:entries="@array/model"
android:spinnerMode="dropdown"
android:background="@drawable/edit_text"
android:textColor="@color/hookup_positive"
android:layout_toRightOf="@+id/NotesText" />
</RelativeLayout>

Aucun commentaire:

Enregistrer un commentaire