StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POANDROID : give id into widget such as Textview, Edittext, spinner in dynamic row/view and store it into sqlite
text
Body
copied!<p>i have one dynamic view with edittext and textview, when user click on add button, it will add one row, when user click remove button, it will remove one row. every user add one row, it will inflate one layout, my problem is every time when i add a row ,all the widget of row have same id and name. it will give me a problem when i want to save it into my sqlite, because it only save the last row, not all row. <img src="https://i.stack.imgur.com/4Dyww.png" alt="enter image description here"></p> <p><img src="https://i.stack.imgur.com/N8Yvq.png" alt="enter image description here"></p> <p>so my question is : 1. how to change the name and id of widget on add button click. 2.add how to store multiple row into table of database. this is how i add my view :</p> <pre><code> public class Pemegang_polis extends Activity{ Cursor model=null; spaj1_adapter adapter=null; DBSpaj helper=null; int count_anak = 0; int counter = 1; EditText nama_pp; TextView adapter_no_dana,adapter_jenis_dana,adapter_jelaskan_dana,nomor,anggota,ttl; EditText nama; @Override protected void onCreate(Bundle savedInstanceState) { //hide title bar BasicDisplaySettings.toggleTaskBar(Pemegang_polis.this, false); //show status bar BasicDisplaySettings.toggleStatusBar(Pemegang_polis.this, true); super.onCreate(savedInstanceState); helper=new DBSpaj(this); model=helper.getAll(); startManagingCursor(model); adapter= new spaj1_adapter(model); setContentView(R.layout.pemegang_polis2); mContainerView = (LinearLayout) polis.findViewById(R.id.parentView); btn_save=(Button)menu.findViewById(R.id.btn_save); list_terkirim.setAdapter(adapter); list_terkirim.setOnItemClickListener(onListClick); // add view inflateEditRow(counter,"Istri/Suami"); nama_pp=(EditText)polis.findViewById(R.id.nama_pp); //saving into database btn_save.setOnClickListener(new OnClickListener() { @Override public void onClick(View v) { helper.insert(nama_pp.getText().toString(), nomor.getText().toString(), anggota.getText().toString(), nama.getText().toString(), ttl.getText().toString() ); model.requery(); nama_pp.setText(null); anggota.setText(null); nama.setText(null); ttl.setText(null); // mContainerView.removeView((View) v.getParent()); } }); } //Adapter for display saved data private AdapterView.OnItemClickListener onListClick=new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, View view, int position, long id) { model.moveToPosition(position); nama_pp.setText(helper.getNamaPP(model)); for (int i=0;i<helper.getNo(model).length();i++){ nomor.setText(helper.getNo(model)); anggota.setText(helper.getAnggota(model)); nama.setText(helper.getNama(model)); ttl.setText(helper.getTTL(model)); } } }; </code></pre> <p>// Helper for inflating and add a new row private void inflateEditRow(int counter2,String name) {</p> <pre><code> LayoutInflater inflater = (LayoutInflater) getSystemService(Context.LAYOUT_INFLATER_SERVICE); final View rowView = inflater.inflate(R.layout.row, null); deleteButton = (ImageButton) rowView.findViewById(R.id.buttonDelete); nomor = (TextView) rowView.findViewById(R.id.nomor); anggota = (TextView) rowView.findViewById(R.id.anggota); nama = (EditText) rowView.findViewById(R.id.nama); ttl = (TextView) rowView.findViewById(R.id.ttl); button_tanggal_anak=(ImageView)rowView.findViewById(R.id.button_tanggal_anak); button_tanggal_anak.setOnClickListener(new OnClickListener() { @Override public void onClick(View arg0) { showDialog(1); } }); if (name != null && !name.isEmpty()) { anggota.setText(name); nomor.setText(String.valueOf(counter2)); } else { mExclusiveEmptyView = rowView; deleteButton.setVisibility(View.VISIBLE); } // A TextWatcher to control the visibility of the "Add new" button and // handle the exclusive empty view. anggota.addTextChangedListener(new TextWatcher() { @Override public void afterTextChanged(Editable s) { if (s.toString().isEmpty()) { deleteButton.setVisibility(View.INVISIBLE); if (mExclusiveEmptyView != null && mExclusiveEmptyView != rowView) { mContainerView.removeView(mExclusiveEmptyView); } mExclusiveEmptyView = rowView; } else { if (mExclusiveEmptyView == rowView) { mExclusiveEmptyView = null; } deleteButton.setVisibility(View.VISIBLE); } } @Override public void beforeTextChanged(CharSequence s, int start, int count, int after) {} @Override public void onTextChanged(CharSequence s, int start, int before, int count) {} }); // Inflate at the end of all rows but before the "Add new" button mContainerView.addView(rowView, mContainerView.getChildCount() - 1); } //end //add view list // onClick handler for the "Add new" button; public void onAddNewClicked(View v) { counter++; count_anak++; inflateEditRow(counter, "anak "+count_anak); v.setVisibility(View.VISIBLE); } // onClick Hapus public void onDeleteClicked(View v) { counter--; count_anak--; mContainerView.removeView((View) v.getParent()); anggota.setText("anak"+count_anak); nomor.setText(String.valueOf(counter)); } } </code></pre> <p>this is my row.xml</p> <pre><code> <?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="wrap_content" android:background="@drawable/border_for_table" android:orientation="horizontal" > <ImageButton android:id="@+id/buttonDelete" android:layout_width="30dp" android:layout_height="30dp" android:layout_gravity="center" android:layout_marginRight="10dp" android:layout_marginLeft="10dp" android:background="@drawable/remove" android:contentDescription="Hapus" android:onClick="onDeleteClicked"/> <View android:layout_width="2dp" android:layout_height="match_parent" android:background="#EEEEEE"/> <TextView style="@style/textview_with_weight_1" android:id="@+id/nomor" android:layout_width="50dp" android:layout_height="65dp" android:textStyle="bold" android:gravity="center_vertical" android:text="" /> <TextView style="@style/textview_with_weight_1" android:id="@+id/anggota" android:textStyle="bold" android:layout_width="110dp" android:layout_marginRight="10dp" android:layout_height="65dp" android:gravity="center_vertical" android:text="" /> <EditText android:id="@+id/nama" android:layout_width="330dp" android:layout_height="65dp" android:layout_marginBottom="1.25dp" android:layout_marginRight="10dp" android:maxLength="25" style="@style/edittext_with_weight_2" android:background="@drawable/border_corner_4" android:hint=". . ." /> <TextView style="@style/textview_with_weight_1" android:id="@+id/ttl" android:layout_width="110dp" android:layout_height="65dp" android:textStyle="bold" android:gravity="center_vertical" android:text="" /> <ImageView android:id="@+id/button_tanggal_anak" style="@style/spinner_image" android:layout_width="25dp" android:layout_height="fill_parent" android:src="@drawable/espaj_button_calendar" /> </LinearLayout> </code></pre> <p>this is my class for my sqlite:</p> <pre><code> class DBSpaj extends SQLiteOpenHelper { private static final String DATABASE_NAME="dbspaj.db"; private static final int SCHEMA_VERSION=1; public DBSpaj(Context context) { super(context, DATABASE_NAME, null, SCHEMA_VERSION); } //koma jangan lupa @Override public void onCreate(SQLiteDatabase db) { db.execSQL("DROP TABLE IF EXISTS table_spaj"); db.execSQL("CREATE TABLE if not exists table_spaj (_id INTEGER PRIMARY KEY AUTOINCREMENT," + " nama_pp TEXT,"+ " no TEXT,"+ " anggota TEXT,"+ " nama TEXT,"+ " ttl TEXT"+ ");"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // no-op, since will not be called until 2nd schema // version exists } public Cursor getAll() { return(getReadableDatabase() .rawQuery("SELECT _id, nama_pp,no,anggota,nama,ttl FROM table_spaj ORDER BY no", null)); } public void insert( String nama_pp, String no, String anggota, String nama, String ttl ) { ContentValues cv=new ContentValues(); cv.put("nama_pp", nama_pp); cv.put("no", no); cv.put("anggota", anggota); cv.put("nama", nama); cv.put("ttl", ttl); getWritableDatabase().insert("table_spaj", "name", cv); } public String getNamaPP(Cursor c) { return(c.getString(1)); } public String getNo(Cursor c) { return(c.getString(2)); } public String getAnggota(Cursor c) { return(c.getString(3)); } public String getNama(Cursor c) { return(c.getString(4)); } public String getTTL(Cursor c) { return(c.getString(5)); } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload