ListViewRubrica

package com.example.appassistenza;



import java.util.ArrayList;

import android.app.Activity;
import android.content.pm.ActivityInfo;
import android.database.Cursor;
import android.os.Bundle;
import android.widget.ArrayAdapter;
import android.widget.ListView;

public class ListViewRubrica extends Activity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        super.setRequestedOrientation(ActivityInfo.SCREEN_ORIENTATION_PORTRAIT);

        final DatabaseHelper database = new DatabaseHelper(
                getApplicationContext());
        database.open();

        final ListView listViewRubrica = (ListView) findViewById(R.id.listViewRubrica);


    }
        public void listaNomiCognomi(final DatabaseHelper database,
                final ListView listViewRubrica) {

            final Cursor curNomiCognomi = database.fetchNomiCognomi();

            ArrayList<String> nomiList = new ArrayList<String>();
            ArrayList<String> cognomiList = new ArrayList<String>();

            if (curNomiCognomi != null) {

                if (curNomiCognomi.moveToFirst()) {

                    do {
                        String nomi = curNomiCognomi.getString(curNomiCognomi
                                .getColumnIndex("nome"));
                        String cognomi = curNomiCognomi.getString(curNomiCognomi
                                .getColumnIndex("cognome"));

                        nomiList.add(nomi);
                        cognomiList.add(cognomi);

                    } while (curNomiCognomi.moveToNext());

                }
            }

            if (nomiList.size() > 0) {
                final String[] arNomiCli = new String[nomiList.size()];
                final String[] arCognCli = new String[nomiList.size()];
                final String[] arNomiCognomiCli = new String[nomiList.size()];

                for (int i = 0; i < nomiList.size(); i++) {

                    arNomiCli[i] = nomiList.get(i);
                    arCognCli[i] = cognomiList.get(i);
                    arNomiCognomiCli[i] = arNomiCli[i] + " " + arCognCli[i];

                }

                ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>(this,
                        android.R.layout.simple_list_item_1, arNomiCognomiCli);
                ListViewRubrica.setAdapter(arrayAdapter);

            }
        }

        private static void setAdapter(ArrayAdapter<String> arrayAdapter) {
            // TODO Auto-generated method stub






    }

}