sqlite에서 데이터를 읽어와서 listview에 뿌려주려고 하는데 sdk실행에는 어떤 오류도 안뜨지만 출력이 안되네요
좀 도와 주시면 안될까요? ㅜㅜ
import java.util.ArrayList;
import android.view.View.OnClickListener;
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class HighScoreActivity extends Activity implements OnClickListener {
DataBaseTableConnect myDB;
SQLiteDatabase mDatabase;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.high_score);
myDB = new DataBaseTableConnect(this);
findViewById(R.id.list_highscore_btn).setOnClickListener(this);
findViewById(R.id.exit_ok).setOnClickListener(this);
}
public void onClick(View v)
{
switch(v.getId())
{
case R.id.list_highscore_btn :
mDatabase = myDB.getReadableDatabase();
Cursor cur;
String Str_Line;
cur = mDatabase.rawQuery("SELECT bun, name, score FROM HighScore", null);
ArrayList<String> ar = new ArrayList<String>();
while(cur.moveToNext())
{
String sbun = cur.getString(0);
String sname = cur.getString(1);
String sscore = cur.getString(2);
Str_Line = String.format("%4s%10s%10s", sbun, sname, sscore);
ar.add(Str_Line);
}
ArrayAdapter<String> adapt;
adapt = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, ar);
ListView list = (ListView)findViewById(R.id.list_highscore);
list.setAdapter(adapt);
Toast.makeText(this, "Complete inquiry", Toast.LENGTH_SHORT).show();
break;
case R.id.exit_ok :
Toast.makeText(this, "Thank you -SY, SJ-", Toast.LENGTH_LONG).show();
finish();
break;
}
}
/********데이터베이스 연결, 테이블 생성 클래스**********/
class DataBaseTableConnect extends SQLiteOpenHelper {
public DataBaseTableConnect(Context context){
super(context, "High_Score.db", null, 1);
}
public void onCreate(SQLiteDatabase mDatabase){
mDatabase.execSQL("CREATE TABLE HighScore (bun INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, score NUMERIC);");
}
public void onUpgrade(SQLiteDatabase mDatabase, int oldVersion, int newVersion){
mDatabase.execSQL("DROP TABLE IF EXISTS HighScore");
onCreate(mDatabase);
}
}
}