mardi 14 juin 2016

How to Store and Retrive values from a Spinner to SQLite on my case?

I'm just trying various tutorials to help with my simple project, I'm still not understanding, I just need to modified my old code.

EditText txt_Jenis from Edit Text to Spinner,

I need to add the items Mobil and Motor from Spinner and store them to a SQLite database. Then I would like to retrieve the selected item, if I need to show one of data selected. The logic is the same with my old code but I just need to change Edit_Text to Spinner

So what should I do with my old code?

import android.content.Intent;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class DataKendaraanDetail extends ActionBarActivity implements android.view.View.OnClickListener{

Button btnSave ,  btnDelete;
Button btnClose;
EditText txt_NomorPolisi;
EditText txt_NamaLengkap;
EditText txt_Jenis;
EditText txt_Warna;
EditText txt_Ciri;
private int _DataKendaraan_Id=0;

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_detail_data_kendaraan);

    btnSave = (Button) findViewById(R.id.btnSave);
    btnDelete = (Button) findViewById(R.id.btnDelete);
    btnClose = (Button) findViewById(R.id.btnClose);

    txt_NomorPolisi = (EditText) findViewById(R.id.txt_NomorPolisi);
    txt_NamaLengkap= (EditText) findViewById(R.id.txt_NamaLengkap);
    txt_Jenis= (EditText) findViewById(R.id.txt_Jenis);
    txt_Warna= (EditText) findViewById(R.id.txt_Waktu);
    txt_Ciri = (EditText) findViewById(R.id.txt_Ciri);

    btnSave.setOnClickListener(this);
    btnDelete.setOnClickListener(this);
    btnClose.setOnClickListener(this);


    _DataKendaraan_Id =0;
    Intent intent = getIntent();
    _DataKendaraan_Id =intent.getIntExtra("datakendaraan_Id", 0);
    DataKendaraanRepo repo = new DataKendaraanRepo(this);
    DataKendaraan datakendaraan = new DataKendaraan();
    datakendaraan = repo.getDataKendaraanById(_DataKendaraan_Id);

    txt_Ciri.setText(datakendaraan.Ciri);
    txt_Warna.setText(datakendaraan.Warna);
    txt_Jenis.setText(datakendaraan.Jenis);
    txt_NamaLengkap.setText(datakendaraan.Nama_Lengkap);
    txt_NomorPolisi.setText(datakendaraan.Nomor_Polisi);

}



public void onClick(View view) {
    if (view == findViewById(R.id.btnSave)){
        DataKendaraanRepo repo = new DataKendaraanRepo(this);
        DataKendaraan datakendaraan = new DataKendaraan();
        datakendaraan.Ciri=txt_Ciri.getText().toString();
        datakendaraan.Warna=txt_Warna.getText().toString();
        datakendaraan.Jenis=txt_Jenis.getText().toString();
        datakendaraan.Nama_Lengkap=txt_NamaLengkap.getText().toString();
        datakendaraan.Nomor_Polisi=txt_NomorPolisi.getText().toString();
        datakendaraan.datakendaraan_ID=_DataKendaraan_Id;

        if (_DataKendaraan_Id==0){
            _DataKendaraan_Id = repo.insert(datakendaraan);

            Toast.makeText(this,"Data Kendaraan Terbaru tersimpan",Toast.LENGTH_SHORT).show();
        }else{

            repo.update(datakendaraan);
            Toast.makeText(this,"Data Kendaraan diperbaharui",Toast.LENGTH_SHORT).show();
        }
    }else if (view== findViewById(R.id.btnDelete)){
        DataKendaraanRepo repo = new DataKendaraanRepo(this);
        repo.delete(_DataKendaraan_Id);
        Toast.makeText(this, "Data Kendaraan dihapus", Toast.LENGTH_SHORT);
        finish();
    }else if (view== findViewById(R.id.btnClose)){
        finish();
    }


}

}

And this is my activity DataKendaraan_Detail_Activity

<RelativeLayout 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"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    android:paddingBottom="@dimen/activity_vertical_margin">
    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:textAppearance="?android:attr/textAppearanceLarge"
        android:text="Data Kendaraan"
        android:id="@+id/textView3"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="30dp" />

    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:textAppearance="?android:attr/textAppearanceMedium"
        android:text="Nomor Polisi"
        android:id="@+id/textView4"
        android:layout_marginTop="51dp"
        android:layout_below="@+id/textView3"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true" />

    <EditText
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:inputType="textPersonName"
        android:ems="10"
        android:id="@+id/txt_NomorPolisi"
        android:layout_alignBottom="@+id/textView4"
        android:layout_alignLeft="@+id/btnSave"
        android:layout_alignStart="@+id/btnSave" />

    <EditText
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:inputType="textPersonName"
        android:ems="10"
        android:id="@+id/txt_NamaLengkap"
        android:layout_below="@+id/txt_NomorPolisi"
        android:layout_alignParentRight="true"
        android:layout_alignParentEnd="false"
        android:layout_toEndOf="@+id/textView6"
        android:layout_alignLeft="@+id/txt_NomorPolisi"
        android:layout_alignStart="@+id/txt_NomorPolisi"
        android:layout_toRightOf="@+id/textView6" />

    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:textAppearance="?android:attr/textAppearanceMedium"
        android:text="Nama Lengkap"
        android:id="@+id/textView6"
        android:layout_alignBottom="@+id/txt_NamaLengkap"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true" />

    <Spinner

        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:inputType="textPersonName"
        android:ems="10"
        android:id="@+id/txt_Jenis"
        android:spinnerMode="dropdown"
        android:layout_centerVertical="true"
        android:layout_alignLeft="@+id/txt_Waktu"
        android:layout_alignStart="@+id/txt_Waktu" />

    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:textAppearance="?android:attr/textAppearanceMedium"
        android:text="Jenis / Model"
        android:id="@+id/textView2"
        android:layout_centerVertical="true"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true" />

    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:textAppearance="?android:attr/textAppearanceMedium"
        android:text="Warna"
        android:id="@+id/textView5"
        android:layout_above="@+id/txt_Ciri"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true" />

    <EditText
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:inputType="textPersonName"
        android:ems="10"
        android:id="@+id/txt_Waktu"
        android:layout_below="@+id/txt_Jenis"
        android:layout_alignParentRight="true"
        android:layout_alignParentEnd="true" />

    <EditText
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:inputType="textPersonName"
        android:ems="10"
        android:id="@+id/txt_Ciri"
        android:layout_below="@+id/txt_Waktu"
        android:layout_alignLeft="@+id/txt_Waktu"
        android:layout_alignStart="@+id/txt_Waktu" />

    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:textAppearance="?android:attr/textAppearanceMedium"
        android:text="Ciri Lainnya"
        android:id="@+id/textView7"
        android:layout_alignBottom="@+id/txt_Ciri"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true" />

    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Hapus"
        android:id="@+id/btnDelete"
        android:layout_below="@+id/txt_Ciri"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true"
        android:layout_marginTop="52dp" />

    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Simpan"
        android:id="@+id/btnSave"
        android:layout_alignTop="@+id/btnDelete"
        android:layout_centerHorizontal="true" />

    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Keluar"
        android:id="@+id/btnClose"
        android:layout_alignTop="@+id/btnSave"
        android:layout_alignParentRight="true"
        android:layout_alignParentEnd="true" />

</RelativeLayout>

Aucun commentaire:

Enregistrer un commentaire