okbtn1.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
String a = "yes";
// TODO Auto-generated method stub
sqldb = db.getWritableDatabase();
db.onUpgrade(sqldb, 1, 2);
sqldb.close();
sqldb = db.getWritableDatabase();
sqldb.execSQL("INSERT INTO CallDB VALUES("
+number1.getText().toString()+");");
sqldb.close();
Toast.makeText(getApplicationContext(),a , Toast.LENGTH_SHORT).show();
}
});
btn1.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
cursor = sqldb.rawQuery("SELECT * FROM CallDB;",null);
String b = cursor.getString(0);
test1.setText(b);
cursor.close();
sqldb.close();
}
});
그냥생각나는대로 써봣는데요 DB에 하나만 저장해야되서 버튼1클릭하면 초기화시키고 하나만 입력받게 해놧고 버튼2 클릭하면 뭐가 들어있는지 출력하게 했는데 안돼요.. 뭐가 문제일가요??
12-03 23:48:30.147: W/dalvikvm(2247): threadid=1: thread exiting with uncaught exception (group=0x414c4700)
12-03 23:48:30.407: E/AndroidRuntime(2247): FATAL EXCEPTION: main
12-03 23:48:30.407: E/AndroidRuntime(2247): java.lang.IllegalStateException: attempt to re-open an already-closed object: SQLiteDatabase: /data/data/com.example.jiminjimin/databases/CallDB
12-03 23:48:30.407: E/AndroidRuntime(2247): at android.database.sqlite.SQLiteClosable.acquireReference(SQLiteClosable.java:55)
12-03 23:48:30.407: E/AndroidRuntime(2247): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1310)
12-03 23:48:30.407: E/AndroidRuntime(2247): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
12-03 23:48:30.407: E/AndroidRuntime(2247): at com.example.jiminjimin.Edit$2.onClick(Edit.java:53)
12-03 23:48:30.407: E/AndroidRuntime(2247): at android.view.View.performClick(View.java:4240)
12-03 23:48:30.407: E/AndroidRuntime(2247): at android.view.View$PerformClick.run(View.java:17721)
12-03 23:48:30.407: E/AndroidRuntime(2247): at android.os.Handler.handleCallback(Handler.java:730)
12-03 23:48:30.407: E/AndroidRuntime(2247): at android.os.Handler.dispatchMessage(Handler.java:92)
12-03 23:48:30.407: E/AndroidRuntime(2247): at android.os.Looper.loop(Looper.java:137)
12-03 23:48:30.407: E/AndroidRuntime(2247): at android.app.ActivityThread.main(ActivityThread.java:5103)
12-03 23:48:30.407: E/AndroidRuntime(2247): at java.lang.reflect.Method.invokeNative(Native Method)
12-03 23:48:30.407: E/AndroidRuntime(2247): at java.lang.reflect.Method.invoke(Method.java:525)
12-03 23:48:30.407: E/AndroidRuntime(2247): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:737)
12-03 23:48:30.407: E/AndroidRuntime(2247): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
12-03 23:48:30.407: E/AndroidRuntime(2247): at dalvik.system.NativeStart.main(Native Method)