質問編集履歴
1
情報の追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -61,4 +61,40 @@
|
|
|
61
61
|
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305)
|
|
62
62
|
E/AndroidRuntime(13543): ... 5 more
|
|
63
63
|
|
|
64
|
+
```
|
|
65
|
+
Helper派生クラス追記しときます
|
|
66
|
+
```lang-＜java＞
|
|
67
|
+
import android.content.Context;
|
|
68
|
+
import android.database.sqlite.SQLiteDatabase;
|
|
69
|
+
import android.database.sqlite.SQLiteOpenHelper;
|
|
70
|
+
import android.content.ContentValues;
|
|
71
|
+
|
|
72
|
+
public class SQLite extends SQLiteOpenHelper{
|
|
73
|
+
static final private String DBNAME = "test.sqlite";
|
|
74
|
+
static final private int VERSION = 1;
|
|
75
|
+
|
|
76
|
+
|
|
77
|
+
//コンストラクタ
|
|
78
|
+
public SQlite(Context context){
|
|
79
|
+
super(context, DBNAME, null, VERSION);
|
|
80
|
+
}
|
|
81
|
+
|
|
82
|
+
@Override
|
|
83
|
+
public void onOpen(SQLiteDatabase db){
|
|
84
|
+
super.onOpen(db);
|
|
85
|
+
}
|
|
86
|
+
|
|
87
|
+
@Override
|
|
88
|
+
public void onCreate(SQLiteDatabase db){
|
|
89
|
+
db.execSQL("CREATE TABLE test" +
|
|
90
|
+
"(id integer, spot integer, type integer,date date, usrmsg text, numgood integer)");
|
|
91
|
+
}
|
|
92
|
+
|
|
93
|
+
@Override
|
|
94
|
+
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
|
|
95
|
+
// TODO 自動生成されたメソッド・スタブ
|
|
96
|
+
|
|
97
|
+
}
|
|
98
|
+
|
|
99
|
+
}
|
|
64
100
|
```
|