아래를 실행하면 테이블 SFOOD의 첫째열 한칸만 출력되는데 테이블 전체를 출력햘려면 어떻게 해야 하나요?
답변 부탁드립니다.
public class ActivitytestDB extends Activity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
initialize(getApplicationContext());
try{
SQLiteDatabase db = openOrCreateDatabase("food.sqlite", Context.MODE_PRIVATE, null);
Cursor cur = db.rawQuery("SELECT * From SFOOD", null);
cur.moveToFirst();
Log.i("move!!!",""+cur.getString(0));
TextView tv = (TextView)findViewById(R.id.textView);
tv.setText(cur.getString(0));
}catch(Exception e){
Log.i("_)",""+e.toString());
}
}
public static final String PACKAGE_DIR = "/data/data/com.test.db/";
public static final String DATABASE_NAME = "food.sqlite";
public static final String COPY2DATABASE_NAME = "food.sqlite";
public static void initialize(Context ctx) {
// check
File folder = new File(PACKAGE_DIR + "databases");
folder.mkdirs();
File outfile = new File(PACKAGE_DIR + "databases/" + COPY2DATABASE_NAME);
if (outfile.length() <= 0) {
AssetManager assetManager = ctx.getResources().getAssets();
try {
InputStream is = assetManager.open(DATABASE_NAME, AssetManager.ACCESS_BUFFER);
long filesize = is.available();
byte [] tempdata = new byte[(int)filesize];
is.read(tempdata);
is.close();
outfile.createNewFile();
FileOutputStream fo = new FileOutputStream(outfile);
fo.write(tempdata);
fo.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
TextView tv = (TextView)findViewById(R.id.textView);
if (cur.moveToFirst()) {
do {
tv.setText(tv.getText() + cur.getString(0) + "\r\n");
} while (cur.moveToNext());
}