In the below code I have created a spinner, when you add your name or text in edit text box and press Add Button your text data will be save on Spinner. Here first I have added a EditText, Button and Spinner with in activity_main.xml layout. In next step I have created a new spinner _item layout here I have added a TextView. After this in Programming area , Here I have created a Databasehelper class and extended with SQLiteOpenHelper . In forth step i have created SQLController class here I have used insertData method , In MainActivity I have used loadtospinner() and OnClickListener() method, In MainActivity I have created a MyAsync private class and this class is extended with AsynTask. You can see below example code it clearly describe you "How to save Data items in spinner “.
Step(1)-actvity_main.xml layout-
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="vertical"
android:padding="30dp" >
<EditText
android:id="@+id/et_id"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:ems="10" >
<requestFocus />
</EditText>
<Button
android:id="@+id/addbtn_id"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:layout_marginTop="10dp"
android:text="Add Member" />
<Spinner
android:id="@+id/spinner_id"
android:layout_width="match_parent"
android:layout_height="wrap_content" />
</LinearLayout>
Step(2)-Created a spinner_item layout-
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical" >
<TextView
android:id="@+id/textView1"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:padding="5dp"
android:textColor="#000000"
android:textSize="20dp" />
</LinearLayout>
Step(3)- I have created DatabaseHelper class-
public class DatabaseHelper extends SQLiteOpenHelper {
// TABLE INFORMATTION
public static final String TABLE_MEMBER = "member";
public static final String MEMBER_ID = "_id";
public static final String MEMBER_NAME = "name";
// DATABASE INFORMATION
static final String DB_NAME = "MEMBER.DB";
static final int DB_VERSION = 1;
// TABLE CREATION STATEMENT
private static final String CREATE_TABLE = "create table " + TABLE_MEMBER
+ "(" + MEMBER_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ MEMBER_NAME + " TEXT NOT NULL);";
public DatabaseHelper(Context context) {
super(context, DB_NAME, null, DB_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(CREATE_TABLE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_MEMBER);
onCreate(db);
}
}
Step(4)-I have created a new SQLController class -
public class SQLController {
private DatabaseHelper dbhelper;
private Context ourcontext;
private SQLiteDatabase database;
public SQLController(Context c) {
ourcontext = c;
}
public SQLController open() throws SQLException {
dbhelper = new DatabaseHelper(ourcontext);
database = dbhelper.getWritableDatabase();
return this;
}
public void close() {
dbhelper.close();
}
public void insertData(String name) {
ContentValues cv = new ContentValues();
cv.put(DatabaseHelper.MEMBER_NAME, name);
database.insert(DatabaseHelper.TABLE_MEMBER, null, cv);
}
public Cursor readData() {
String[] allColumns = new String[] { DatabaseHelper.MEMBER_ID, DatabaseHelper.MEMBER_NAME };
Cursor c = database.query(DatabaseHelper.TABLE_MEMBER, allColumns, null, null, null, null, null);
if (c != null) {
c.moveToFirst();
}
return c;
}
}
Step(5)-MainActivity-
public class MainActivity extends AppCompatActivity {
Button AddBtn;
EditText et;
Spinner spn;
SQLController SQLcon;
ProgressDialog PD;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
AddBtn = (Button) findViewById(R.id.addbtn_id);
et = (EditText) findViewById(R.id.et_id);
spn = (Spinner) findViewById(R.id.spinner_id);
SQLcon = new SQLController(this);
// opening database
SQLcon.open();
loadtospinner();
AddBtn.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
new MyAsync().execute();
}
});
}
public void loadtospinner() {
Cursor c = SQLcon.readData();
final ArrayList<String> al = new ArrayList<String>();
c.moveToFirst();
while (!c.isAfterLast()) {
String name = c.getString(c.getColumnIndex(DatabaseHelper.MEMBER_NAME));
al.add(name);
c.moveToNext();
}
ArrayAdapter<String> aa1 = new ArrayAdapter<String>(
getApplicationContext(), R.layout.spinner_item, R.id.textView1,
al);
spn.setAdapter(aa1);
// closing database
SQLcon.close();
}
private class MyAsync extends AsyncTask<Void, Void, Void> {
@Override
protected void onPreExecute() {
super.onPreExecute();
PD = new ProgressDialog(MainActivity.this);
PD.setTitle("Please Wait..");
PD.setMessage("Loading...");
PD.setCancelable(false);
PD.show();
}
@Override
protected Void doInBackground(Void... params) {
String name = et.getText().toString();
// opening database
SQLcon.open();
// insert data into table
SQLcon.insertData(name);
return null;
}
@Override
protected void onPostExecute(Void result) {
super.onPostExecute(result);
loadtospinner();
PD.dismiss();
}
}
}
0 Comment(s)