public class RangKingActivity extends Activity {
private static final String TAG = "MainActivity";
private SQLiteDatabase db = null;

boolean first = true;
EditText et;
String name,name1,cha,cha1;
int score;
String score1;
int str;
ArrayList<MyItem> data;
MyAdapter adapter;
MyItem item;
ListView list1;
LinearLayout lay;

View.OnClickListener bHandler = new View.OnClickListener() {

public void onClick(View v) {
switch(v.getId()){
case R.id.save :
Intent intent1 = getIntent();
   str = intent1.getIntExtra("cnt",0);   
   cha = intent1.getStringExtra("cha");
   score = str;
name = et.getText().toString();
insertRecord(name,score,cha);
lay.setVisibility(View.GONE);
break;
case R.id.rank :
selectRecorAll();
break;
case R.id.button1 :
Intent intent = new Intent(RangKingActivity.this, MainActivity.class);
startActivityForResult(intent, 1111);
finish();
break;
}

}
};

void selectRecorAll()
{
opendb();

Cursor c = db.query("moktb", null, null, null, null, null, "age desc");

while(c.moveToNext());
{
name1 = c.getString(1);
score1 = c.getString(2);
cha1 = c.getString(3);
data.add(new MyItem(name1,score1,cha1));
list1.setAdapter(adapter);
}
cloesedb();
//select * from moktb order fname, age desc;
}
void insertRecord (String str1,int num, String ch)
{
opendb();

ContentValues row  = new ContentValues();
row.put("fname", str1);
row.put("age", num);
row.put("lname", ch);

db.insert("moktb", null, row);
cloesedb();

}
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, 
WindowManager.LayoutParams.FLAG_FULLSCREEN);
requestWindowFeature(Window.FEATURE_NO_TITLE);
setContentView(R.layout.rangking);
//hideView();
data = new ArrayList<MyItem>();
adapter = new MyAdapter(this,R.layout.item1,data);

findViewById(R.id.save).setOnClickListener(bHandler);
findViewById(R.id.button1).setOnClickListener(bHandler);
findViewById(R.id.rank).setOnClickListener(bHandler);
et = (EditText)findViewById(R.id.EditText);
list1 = (ListView)findViewById(R.id.listView1);
lay = (LinearLayout)findViewById(R.id.lay);
SharedPreferences sp = getSharedPreferences("mokwon", 0);
first  = sp.getBoolean("fitst", true);       
if(first)
{
init();
}
}
void init()
{
SharedPreferences sp = getSharedPreferences("mokwon", 0); 
SharedPreferences.Editor editer = sp.edit();     
editer.putBoolean("fitst"  , false);    
editer.commit();
String sql = "create table mokTB(_id integer primary key autoincrement,";  
sql+="fname Text,age integer,lname Text);";  

opendb();

db.execSQL(sql);
insertRecord(name,score,cha);
insertRecord(name,score,cha);
insertRecord(name,score,cha);
insertRecord(name,score,cha);
insertRecord(name,score,cha);
insertRecord(name,score,cha);
insertRecord(name,score,cha);
insertRecord(name,score,cha);
insertRecord(name,score,cha);
insertRecord(name,score,cha);
cloesedb();
}

void cloesedb()
{
if (db != null)
{
db.close();
}

}
void opendb()
{
db  = openOrCreateDatabase("mokwon.db", SQLiteDatabase.CREATE_IF_NECESSARY, null);
}
}














오류
08-12 19:21:36.378: ERROR/AndroidRuntime(2746): FATAL EXCEPTION: main
08-12 19:21:36.378: ERROR/AndroidRuntime(2746): android.database.CursorIndexOutOfBoundsException: Index 10 requested, with a size of 10
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at android.database.AbstractCursor.checkPosition(AbstractCursor.java:580)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at android.database.AbstractWindowedCursor.checkPosition(AbstractWindowedCursor.java:214)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at android.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:41)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at kr.dkfakshd.RangKingActivity.selectRecorAll(RangKingActivity.java:70)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at kr.dkfakshd.RangKingActivity$1.onClick(RangKingActivity.java:49)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at android.view.View.performClick(View.java:2408)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at android.view.View$PerformClick.run(View.java:8816)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at android.os.Handler.handleCallback(Handler.java:587)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at android.os.Handler.dispatchMessage(Handler.java:92)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at android.os.Looper.loop(Looper.java:123)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at android.app.ActivityThread.main(ActivityThread.java:4627)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at java.lang.reflect.Method.invokeNative(Native Method)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at java.lang.reflect.Method.invoke(Method.java:521)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
08-12 19:21:36.378: ERROR/AndroidRuntime(2746):     at dalvik.system.NativeStart.main(Native Method)

이 게시물을