public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
final EditText searchchang = (EditText)findViewById(R.id.searchchang);
Button searchb = (Button)findViewById(R.id.searchb);
Button favorite = (Button)findViewById(R.id.favorite);
favorite.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Intent i = new Intent(jwA.this,jwFavorite.class);
startActivity(i);
}
});
searchb.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
if(jwb.data != null){
for (int j = 0; j < jwb.data.size(); j++) {
if(jwb.data.get(j).contains((searchchang.getText().toString()))){
showDialog(PROGRESS_DIALOG);
Intent in = new Intent(jwA.this,jwB.class);
startActivity(in);
}else{
Intent ia = new Intent(jwA.this,jwA.class);
startActivity(ia);}
}
}
searchchang.setText("");
}
});
}
------------디비 부분 -----------
public class jwB
extends Activity {
private ListView list = null;
private SQLiteDatabase _DB = null;
ArrayAdapter<String> aa;
ArrayList<String> data = new ArrayList<String>();
private String iCode = null;
/*@Override
protected void onListItemClick(ListView l, View v, int position, long id) {
// TODO Auto-generated method stub
super.onListItemClick(l, v, position, id);
}*/
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.mainb);
aa = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1,data);
Button searchlist = (Button)findViewById(R.id.searchlist);
Button backmain = (Button)findViewById(R.id.backmain);
backmain.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Intent i = new Intent(jwB.this, jwA.class);
startActivity(i);
}
});
searchlist.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Intent i = new Intent(jwB.this, jwC.class);
startActivity(i);
}
});
// TODO Auto-generated method stub
list = (ListView)findViewById(R.id.list);
_DB = this.openOrCreateDatabase("jwDb", MODE_PRIVATE, null); //jwDb 라는 데이터 베이스 생성
//_DB.execSQL("CREATE TABLE m2(_id INTEGER PRIMARY KEY AUTOINCREMENT, " + "name varchar, price varchar ,mart varchar,location varchar);");
_DB.execSQL("INSERT INTO m2 VALUES (null, '오징어땅콩', '1200원','코사마트','선릉점');");
_DB.execSQL("INSERT INTO m2 VALUES (null, '가지', '900원','하모니마트','양재점');");
_DB.execSQL("INSERT INTO m2 VALUES (null, '펩시', '900원','하모니마트','양재점');");
_DB.execSQL("INSERT INTO m2 VALUES (null, '해표식용유', '900원','하모니마트','양재점');");
_DB.execSQL("INSERT INTO m2 VALUES (null, '오이', '2000원','하모니마트','역삼점');");
_DB.execSQL("INSERT INTO m2 VALUES (null, '가지', '2000원','하모니마트','역삼점');");
Cursor _Cursor = _DB.rawQuery("Select * from m2", null); // 커서는 데이터에 차례대로 접근하기위함
//String _Result = "";
if (_Cursor.moveToFirst()){; // 데이터의 맨 앞으로 이동
do{
//_Result = _Result + _Cursor.getString(0) ; // 0번째 타이틀 리턴
data.add(_Cursor.getString(0) + " " + _Cursor.getString(1) + " " + _Cursor.getString(2)
+" " + _Cursor.getString(3)+" " + _Cursor.getString(4));
}while (_Cursor.moveToNext()); // 전체 데이터만큼 루프돈후 빠짐
}
list.setAdapter(aa);
// _DB.close();
list.setOnItemClickListener(m_clicklistener);
}// end of oncreate
/* public class Tabs3 extends TabActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
final TabHost tabHost = getTabHost();
tabHost.addTab(tabHost.newTabSpec("tab1")
.setIndicator("list1")
.setContent(new Intent(this, jwA.class)));
tabHost.addTab(tabHost.newTabSpec("tab2")
.setIndicator("list2")
.setContent(new Intent(this, jwC.class)));
// 클릭할때 마다 리플레쉬
tabHost.addTab(tabHost.newTabSpec("tab3")
.setIndicator("destroy")
.setContent(new Intent(this, jwB.class)
.addFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP)));
}
}
*/
AdapterView.OnItemClickListener m_clicklistener = new AdapterView.OnItemClickListener() {
public void onItemClick(AdapterView<?> parent, View view, int position, long id)
{
Intent i = new Intent(jwB.this, jwC.class);
startActivity(i);
}
};
// Tabs3 t = new Tabs3();
}// end of activity
위에 분홍색 바탕부분 디비 입력한건 이미 들어간 상태에서
searchang 이라는 edittext 에서 "오징어땅콩" 를 검색한후 seachb 버튼클릭하여 그 검색한 디비 정보만 리스트뷰에 뿌려줘야하는데요
맨위 빨간 글씨부분에서 if문 조차 들어가지 않습니다 data 안에 아무것도 없다는거 같은데요 고로 검색조차안되구요
에러 로그 index와 size가 0 이라고 뜨는군요
도와주세요 ㅠㅠ