각각 스피너 번호에따라 밑에 텍스트뷰에 출력되는 내용이 달라야합니다
밑에코드처럼 해봣는데요
처음에 월요일꺼만 계속 나오고 스피너 선택을 바꾸어도 텍스트뷰 내용이 바뀌지 않습니다.
그리고 디비 질문인데요
onCreate 에 만들어노은 insertDb함수를 불러오기해놔서 디비에 입력시켯는데요
프로그램이 실행될때마다 입력되는거같아요.. 다른방법 있나용??
if (index ==0){
db = mHelper.getReadableDatabase();
Cursor cursor;
String Result = "";
TextView menu = (TextView)findViewById(R.id.showmenu);
switch(index1)
{
case 0:
cursor = db.rawQuery("SELECT menu, price FROM one WHERE day='월요일'",null);
while (cursor.moveToNext()){
String menu1 = cursor.getString(0);
String price1 = cursor.getString(1);
Result += (menu1 + " "+ price1 + "\n");
}
menu.setText(Result.toString());
cursor.close();
mHelper.close();
break;
case 1:
cursor = db.rawQuery("SELECT menu, price FROM one WHERE day='화요일'",null);
while (cursor.moveToNext()){
String menu1 = cursor.getString(0);
String price1= cursor.getString(1);
Result += (menu1 + " "+ price1 + "\n");
}
// TextView menu1 = (TextView)findViewById(R.id.showmenu);
menu.setText(Result.toString());
cursor.close();
mHelper.close();
break;
case 2:
cursor = db.rawQuery("SELECT menu, price FROM one WHERE day='수요일'",null);
while (cursor.moveToNext()){
String menu1 = cursor.getString(0);
String price1= cursor.getString(1);
Result += (menu1 + " "+ price1 + "\n");
}
// TextView menu1 = (TextView)findViewById(R.id.showmenu);
menu.setText(Result.toString());
cursor.close();
mHelper.close();
break;
case 3:
cursor = db.rawQuery("SELECT menu, price FROM one WHERE day='목요일'",null);
while (cursor.moveToNext()){
String menu1 = cursor.getString(0);
String price1= cursor.getString(1);
Result += (menu1 + " "+ price1 + "\n");
}
// TextView menu1 = (TextView)findViewById(R.id.showmenu);
menu.setText(Result.toString());
cursor.close();
mHelper.close();
break;
case 4:
cursor = db.rawQuery("SELECT menu, price FROM one WHERE day='금요일'",null);
while (cursor.moveToNext()){
String menu1 = cursor.getString(0);
String price1= cursor.getString(1);
Result += (menu1 + " "+ price1 + "\n");
}
// TextView menu1 = (TextView)findViewById(R.id.showmenu);
menu.setText(Result.toString());
cursor.close();
mHelper.close();
break;
}