Kod kreskowy

package com.example.kod_kreskowy;

import java.util.ArrayList;
import java.util.List;
import android.os.Bundle;
import android.os.Environment;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;

public class MainActivity extends Activity {

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		
		final EditText eTKod=(EditText)findViewById(R.id.eTKod);
		final EditText eTProducent=(EditText)findViewById(R.id.eTProducent);
		final EditText eTNazwa=(EditText)findViewById(R.id.eTNazwa);	
		Button bTCzysc=(Button)findViewById(R.id.bTCzysc);
		
		bTCzysc.setOnClickListener(new View.OnClickListener() {		
			@Override
			public void onClick(View v) {
			eTKod.setText("");
			eTNazwa.setText("");
			eTProducent.setText("");
			}
		});
		
		final List<String> listaKodow = new ArrayList<String>();
		final List<String> listaNazw = new ArrayList<String>();
		final List<String> listaProducentow = new ArrayList<String>();
		
		SQLiteDatabase baza = openOrCreateDatabase(Environment.getExternalStorageDirectory().getPath()
                +"/"+"kody.db", SQLiteDatabase.OPEN_READWRITE, null);
		String kolumny[]={"Kod","Nazwa","Producent"}; 
		Cursor kursor=baza.query("Kody", kolumny, null, null, null, null, null);
		kursor.moveToFirst();
		
		while(kursor.moveToNext())
		{
			listaKodow.add(kursor.getString(0));
			listaNazw.add(kursor.getString(1));
			listaProducentow.add(kursor.getString(2));
		}	
		baza.close();
		kursor.close();
		
		eTKod.setOnFocusChangeListener(new View.OnFocusChangeListener() {	
			@Override
			public void onFocusChange(View v, boolean hasFocus) {	
				for(int i=0; i<listaKodow.size();i++){
					
					if(eTKod.getText().toString().equals(listaKodow.get(i).toString())){
						eTNazwa.setText(listaNazw.get(i).toString());
						eTProducent.setText(listaProducentow.get(i).toString());
					}
				}
			}
		});
	}

	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
		getMenuInflater().inflate(R.menu.main, menu);
		return true;
	}
}