DrugiEkran

package com.example.aplikacija;

import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.List;
import java.util.Set;

import com.example.aplikacija.DrugiEkran;
import com.example.aplikacija.R;
import com.example.aplikacija.Baza;
import com.example.aplikacija.DrugiEkran;

import android.app.Activity;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.Spinner;

public class DrugiEkran extends Activity {
    private int ID;
    private Baza db = null;


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

        db = new Baza(getApplicationContext());
        final SQLiteDatabase Baza = db.getWritableDatabase();

        UcitajPodatke(db, db.TABELA_BUILDING, R.id.spinnerBuilding);
        UcitajPodatke(db, db.TABELA_FLOOR, R.id.spinnerfloor);
        UcitajPodatke(db, db.TABELA_ROOM, R.id.spinnerRoom);

        /// Provjeriti u bazi max(ID) + 1
        /// Upisati u varijablu ID

        Button back2 = (Button)findViewById(R.id.Back);
        back2.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {
                finish();
            }
        });

        Button next2 = (Button)findViewById(R.id.Next);

        next2.setOnClickListener(new View.OnClickListener(){





                public void onClick(View v){
                    /// INSERT u bazu sa IDjem

                    Intent intent = new Intent(DrugiEkran.this,TreciEkran.class);
                    intent.putExtra("_id", ID);
                    startActivity(intent);

                    //startActivityForResult(intent, 0);
                    finish();
                }
                });
    }

        private void UcitajPodatke(final Baza db, String NazivTabele, int SpinnerID) {
            Set<String> set = db.getAllData(NazivTabele);
            //Convert set into list
            List<String> list = new ArrayList<String>(set);
            //Sort Data Alphabetical order
            Collections.sort(list, new Comparator<String>() {
          @Override
          public int compare(String lhs, String rhs) {
                  return lhs.compareTo(rhs);
                  }
                 });

                ArrayAdapter adapter = new ArrayAdapter<String>(DrugiEkran.this,
             android.R.layout.simple_spinner_item, list);
                adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

                Spinner s = (Spinner)findViewById(SpinnerID);
                s.setAdapter(adapter);









        }

}