DB 다루기

str = Environment.getExternalStorageDirectory().getAbsolutePath();
        SQLiteDatabase _db = openOrCreateDatabase(str + "/jusoList.db", SQLiteDatabase.CREATE_IF_NECESSARY , null);
        if(_db == null){
         tvResult.setText("DB 생성 오류!!");
         return;
        }
       /*
        String query = "create table DuzonJuso (id integer primary key autoincrement,codeNo text,Sangho text,Bonjeom text,OwnerName text," +
          "euptae text,jongmok text,gubun text,Usable text,gowse text,saeupja text,OffiAddr text,jumin text,telNO text," +
          "bonjeomAddr text,saupGowanhal text,jusoGowanhal text,damdang text,damdangTel text,duzonID text,juminNapse text)";
        db.execSQL(query);
         */
        str = etOfficeName.getText().toString();
        String query = "SELECT Sangho, OffiAddr, telNO FROM DuzonJuso WHERE Sangho LIKE '%" + str + "%'";
        Cursor c = _db.rawQuery(query, null);
         str = "";
         while(c.moveToNext()){
          /*
          n = c.getColumnIndex("Sangho");
          str = c.getString(n);
          n = c.getColumnIndex("OffiAddr");
          str = str + " " + c.getString(n);
          n = c.getColumnIndex("telNO");
          str = str + " " + c.getString(n);
          */
          str = c.getString(0) + "\r\n" + c.getString(1) + "\r\n" + c.getString(2);
          arrayList.add(str);
          //String strOfficeAddr = c.getString(1);
          //String strTelNo = c.getString(2);
          //tvResult.setText(strOfficeName + " " + strOfficeAddr + " " + strTelNo);
         }
         c.close();
         _db.close();