public void onClick(View v) {
// TODO Auto-generated method stub
int getId = v.getId();
switch (getId) {
case R.id.addbtn:
intent = new Intent(ListviewMain.this, EditClass.class);
startActivityForResult(intent, 0); // 에디트클래스의 엑티비티에서 다시
// 돌아옴으로 포리조트함수사용
break;
case R.id.Searchbtn:
// Intent intent = new Intent(ListviewMain.this, ServiceApp.class);
SearchAdd = searchinput.getText().toString();
populateListView(SearchAdd);
break;
default:
break;
}
}
public void populateListView(String s){
Log.i("여기다", "여 " + SearchAdd);
DBHelper dbhelper = new DBHelper(this);
db = dbhelper.getWritableDatabase();
try {
// Cursor c=db.rawQuery("SELECT * FROM test"+" WHERE contents LIKE '%SearchAdd%'", null);
String sql="select * from test where " + CONTENTS + " like ?";
Cursor c=db.rawQuery(sql, new String[]{SearchAdd + "%"});
Log.i("d","d"+c.getCount());
if (c != null && c.getCount() != 0){{
Log.i("d","ddddddd");
adapter1 = new SimpleCursorAdapter(getApplicationContext(),
R.layout.customview, c, new String[] { "title", "contents" },
new int[] { R.id.listTitle, R.id.listcontext });
Log.i("d","d"+c.getCount());
listView.setAdapter(adapter1);
/*if(c.moveToFirst())
{
Log.i("d","ddd");
do {
} while (c.moveToNext());
}*/
}
count가 뜨는 것으로 보아 c에 값이 있는 것을 확인했습니다 그런데 검색을 누르면 listview에 아무것도 뜨지 않아요ㅜㅜ
adapter조건이 잘못된 건가요? ㅠㅠㅠ