안녕하세요.안드로이드에서 질문이 있습니다.
public class intro extends Activity implements OnChildClickListener{
MyDBHelper myDBHelper;
ExpandableListView eList;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.nudle);
//데이타베이스에서 내용을 읽어와서 daic 배열과, soc 배열내용을 채워준다.
// SQLOpenHelper의 도움을 받아 데이타베이스와 테이블을 생성한다.
myDBHelper = new MyDBHelper(this, "nuli.DB", null, 1);
//sql 데이터 결과 얻기
SQLiteDatabase db = myDBHelper.getReadableDatabase();
String sql;
//Log.i("SQLiteTest1", "길이:" + searchWord.length());
sql = "SELECT daic, count(*) FROM nudle GROUP BY daic;";
Log.i("nudleTest1", sql);
Cursor cursor;
Cursor cursor1;
cursor = db.rawQuery(sql, null);
//그룹데이터
//String daic[];
//그룹 상세데이타
//String soc[][];
//그룹데이터
String daic[] = new String[8];
int countArr[] = new int[8];
int k=0;
while(cursor.moveToNext()){
daic[k] = cursor.getString(0);
countArr[k] = cursor.getInt(1);
Log.i("nudleTest1", daic[k] + " " + countArr[k]);
k++;
}
//그룹 상세데이타
//String soc[][] = new String[10][10];
for( int i = 0; i< daic.length; i++){
String category = daic[i];
String sql1;
sql1 = "SELECT soc FROM nudle WHERE daic = '" + category + "';";
Log.i("nudleTest1", sql1);
cursor1 = db.rawQuery(sql1, null);
//실행시킨 커서 객체를
String soc[][] = new String[i][10];
int countArr1[][] = new int[i][10];
int v = 0;
while(cursor1.moveToNext()){
for( int u = 0; u< daic.length; u++){
String category2 = soc[i][v];
//i행 v열에 값기억
String sql2;
sql2 = "SELECT soc FROM nudle WHERE daic = '" + category + "';";
Log.i("nudleTest2", sql2);
//soc배열 i행과 v열
soc[i][v] = cursor1.getString(0);
Log.i("nudleTest3", soc[i][v]);
//u는 0이고 u가 대카테고리의 길이보다 작은동안 u는 늘어난다.
v++;
}
}
}
}
이 라는 부분을 만들고 있습니다. ExpandableListView에 넣으려고 daic[],soc[][] 를 선언했는데 sql에서 daic부분에는 제가 원하는 부분이
들어가는데 soc 부분에는 들어가지 않아서 질문을 드립니다.
05-23 15:59:17.791: W/ActivityThread(1901): Application com.jica.nudle is waiting for the debugger on port 8100...
05-23 15:59:17.841: I/System.out(1901): Sending WAIT chunk
05-23 15:59:17.862: I/dalvikvm(1901): Debugger is active
05-23 15:59:18.041: I/System.out(1901): Debugger has connected
05-23 15:59:18.052: I/System.out(1901): waiting for debugger to settle...
05-23 15:59:18.251: I/System.out(1901): waiting for debugger to settle...
05-23 15:59:18.451: I/System.out(1901): waiting for debugger to settle...
05-23 15:59:18.651: I/System.out(1901): waiting for debugger to settle...
05-23 15:59:18.851: I/System.out(1901): waiting for debugger to settle...
05-23 15:59:19.051: I/System.out(1901): waiting for debugger to settle...
05-23 15:59:19.296: I/System.out(1901): waiting for debugger to settle...
05-23 15:59:19.491: I/System.out(1901): waiting for debugger to settle...
05-23 15:59:19.691: I/System.out(1901): waiting for debugger to settle...
05-23 15:59:19.929: I/System.out(1901): waiting for debugger to settle...
05-23 15:59:20.133: I/System.out(1901): debugger has settled (1392)
05-23 15:59:21.751: D/gralloc_goldfish(1901): Emulator without GPU emulation detected.
05-23 15:59:24.951: I/nudleTest1(1901): SELECT daic, count(*) FROM nudle GROUP BY daic;
05-23 15:59:24.971: I/nudleTest1(1901): 국수 2
05-23 15:59:24.981: I/nudleTest1(1901): 라면 3
05-23 15:59:24.981: I/nudleTest1(1901): 컵라면 3
05-23 15:59:24.981: I/nudleTest1(1901): 파스타 2
05-23 15:59:24.981: I/nudleTest1(1901): SELECT soc FROM nudle WHERE daic = '국수';
로그인데 daic에 포함된 soc 부분이 나오지 않고 여기서 디버깅이 멈추네요. 부탁드립니다.
wnsrjs23@naver.com으로 부탁드려도 될까요?