package com.example.test2;


import android.app.Activity;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
//import android.database.sqlite.SQLiteQueryBuilder;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

public class BazaActivity extends Activity {

	Button pokaz, pokaz2,dodaj;
	TextView imie, textGora,wyszukany;
	EditText dodaj_imie, dodaj_nazwisko,szukaj_im;
	SQLiteDatabase dbTest;// = null;
	SQLiteOpenHelper opener;
	
	@Override
	protected void onCreate(Bundle savedInstanceState) {
		
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_baza);
		pokaz = (Button) findViewById(R.id.button1);
		dodaj = (Button) findViewById(R.id.button2);
		pokaz2 = (Button) findViewById(R.id.button3);
		imie = (TextView) findViewById(R.id.textView2);
		textGora = (TextView) findViewById(R.id.textView1);
		wyszukany = (TextView) findViewById(R.id.textView3);
		dodaj_imie=(EditText)findViewById(R.id.editText1);
		dodaj_nazwisko = (EditText) findViewById(R.id.editText2);
		szukaj_im = (EditText) findViewById(R.id.editText3);
		dbTest = this.openOrCreateDatabase("newdb.db", MODE_PRIVATE, null);
		//opener.onOpen(dbTest);
		//opener.
		/*dbTest.execSQL("DROP TABLE IF EXISTS USER;");
		dbTest.execSQL("CREATE TABLE USER (" + "ID INTEGER PRIMARY KEY AUTOINCREMENT," +
					"NAZWISKO VARCHAR (20)," + 
					"IMIE VARCHAR (20)"
					+ "); ");
		dbTest.execSQL("INSERT INTO USER (IMIE, NAZWISKO) VALUES ('KinGA', 'SIELCZAK');");
		dbTest.execSQL("INSERT INTO USER "+"(IMIE, NAZWISKO) VALUES (" + "'KAMIL', 'ZAPOTOCZNY');");
		Log.d("Baza sqlite", "dodanie");
		*/pokaz.setOnClickListener(
				new OnClickListener(){

					@Override
					public void onClick(View v) {
						// TODO Auto-generated method stub
						//imie.setText("Test podmiana");
						wczytajUsera(); // metoda nie działa 
					}
					
				}
				);
		
		dodaj.setOnClickListener(
				new OnClickListener() {
			
			@Override
			public void onClick(View v) {
				// TODO Auto-generated method stub
			dodajUsera(dodaj_imie.getText().toString(), dodaj_nazwisko.getText().toString());	
			}
		});
		
		pokaz2.setOnClickListener(
				new OnClickListener(){

					@Override
					public void onClick(View v) {
						// TODO Auto-generated method stub
						//imie.setText("Test podmiana");
						wczytajUsera(szukaj_im.getText().toString()); // metoda nie działa 
					}
					
				}
				);
	
	}

	
	public void ustawParam(){
		;
	}
	
	public String wczytajUsera(){
		String s ="";
		try{
		//Cursor c=dbTest.rawQuery("SELECT IMIE FROM USER WHERE NAZWISKO = "+ "\"SIELCZAK\"", null);
		//Cursor c=dbTest.rawQuery("SELECT * FROM USER where NAZWISKO = "+"\"ZAPOTOCZNY\"", null);
		Cursor c=dbTest.rawQuery("SELECT * FROM USER where NAZWISKO = 'ZAPOTOCZNY'", null);
		if(c.moveToFirst()){
		s=c.getString(c.getColumnIndex("IMIE"));
		//s=c.toString();
		}
		}catch(SQLException e){
			s=e.toString();
			
		}
		//s= c.getString(1);
		//imie.setText(s);
		//String st=dodajUsera("Ciapa", "Rapa");
		imie.setText(s);
		
		//System.out.println("Wynik zapytania po kliknięciu ");
		return s;
	}
	
	
	public String wczytajUsera(String szukaj_imie){
		String s ="";
		try{
		//Cursor c=dbTest.rawQuery("SELECT IMIE FROM USER WHERE NAZWISKO = "+ "\"SIELCZAK\"", null);
		//Cursor c=dbTest.rawQuery("SELECT * FROM USER where NAZWISKO = "+"\"ZAPOTOCZNY\"", null);
		
		String ss="SELECT * FROM USER where IMIE LIKE '%";	
		StringBuffer sbuf = new StringBuffer(ss);
		//sbuf.insert(0, "");
		sbuf.append(szukaj_imie);
		sbuf.append("%'");
		ss=sbuf.toString();
	
		Cursor c=dbTest.rawQuery(ss, null);
		//Cursor c=dbTest.rawQuery("SELECT * FROM USER where NAZWISKO = 'ZAPOTOCZNY'", null);
		if(c.moveToFirst()){
		s=c.getString(c.getColumnIndex("IMIE"));
		//s=c.toString();
		c.close();
		}
		}catch(SQLException e){
			s=e.toString();
			
		}
		//s= c.getString(1);
		//imie.setText(s);
		//String st=dodajUsera("Ciapa", "Rapa");
		wyszukany.setText(s);
		
		
		//System.out.println("Wynik zapytania po kliknięciu ");
		return s;
	}
	
	
	
	SQLiteDatabase  dodajUsera (String im, String nazw){
		//opener.onOpen(dbTest);
		//opener.getWritableDatabase();
		String query = "INSERT INTO USER (IMIE, NAZWISKO) VALUES ('";
		StringBuffer sbuf = null;
		sbuf=new StringBuffer(query);
		//sbuf.insert(0, "");
		sbuf.append(im);
		sbuf.append("','");
		sbuf.append(nazw);
		sbuf.append("');commit;");
		String ss=sbuf.toString();
		try{
		dbTest.execSQL(ss);
		}catch(SQLException e){
			imie.setText(e.toString());
		}
		//dbTest.
		return dbTest;
	}
	
	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
		// Inflate the menu; this adds items to the action bar if it is present.
		getMenuInflater().inflate(R.menu.baza, menu);
		return true;
	}

	
	@Override
	public boolean onOptionsItemSelected(MenuItem item) {
		// Handle action bar item clicks here. The action bar will
		// automatically handle clicks on the Home/Up button, so long
		// as you specify a parent activity in AndroidManifest.xml.
		int id = item.getItemId();
		if (id == R.id.action_settings) {
			return true;
		}
		return super.onOptionsItemSelected(item);
	}
}