java - Adding SQLite database value to ListView -

java - Adding SQLite database value to ListView -

i want add together sqlite database value listview if record exists, i'm getting text edittext.

here's i'm doing

code databasehelper class

public string ifexistin(string stationname) { string query = "select stationname review stationid='" + stationname + "' limit 1"; seek { sqlitedatabase database = getreadabledatabase(); cursor c = database.rawquery(query, null)); homecoming stationname; } }

code activity class

public view.onclicklistener searchstation = new view.onclicklistener() { @override public void onclick(view v) { databasehelper dbhelper = new databasehelper(getapplicationcontext()); string searchstring= searchtext.gettext().tostring(); dbhelper.ifexistin(searchstring); list.add(searchstring); arrayadapter= new arrayadapter<string>(searchandreview.this, android.r.layout.simple_list_item_1, list); listview.setadapter(arrayadapter); } };

probably few mistakes here can see can seek this:

public string ifexistin(string stationname) { string query = "select stationname review stationid='" + stationname + "' limit 1"; sqlitedatabase database = getreadabledatabase(); cursor c = database.rawquery(query, null); c.movetofirst(); homecoming c.getstring(c.getcolumnindex("stationname")); }

you have result of cursor , interpret homecoming string stationname.

and this:

public view.onclicklistener searchstation = new view.onclicklistener() { @override public void onclick(view v) { databasehelper dbhelper = new databasehelper(getapplicationcontext()); string searchstring= searchtext.gettext().tostring(); string usethis = dbhelper.ifexistin(searchstring); list.add(usethis); arrayadapter= new arrayadapter<string>(searchandreview.this, android.r.layout.simple_list_item_1, list); listview.setadapter(arrayadapter); } };

you're getting searchstring , putting list , not doing result of query. need assign result of query somewhere utilize it. or straight utilize in insert like:

list.add(dbhelper.ifexistsin(searchstring);

java android sqlite