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 {
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(){
;
}
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();
}
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;
}
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 '%";
//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();
}
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;
}
//opener.onOpen(dbTest);
//opener.getWritableDatabase();
String query
= "INSERT INTO USER (IMIE, NAZWISKO) VALUES ('";
//sbuf.insert(0, "");
sbuf.append(im);
sbuf.append("','");
sbuf.append(nazw);
sbuf.append("');commit;");
try{
dbTest.execSQL(ss);
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);
}
}