teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問android studioでのSQLiteからの出力

編集履歴

質問編集履歴

1

文法の修正

2018/10/17 15:19

投稿

taku_
taku_

スコア13

test CHANGED
File without changes
test CHANGED
@@ -8,344 +8,350 @@
8
8
 
9
9
  SubActivity.java
10
10
 
11
+ ```java
12
+
13
+ import android.database.Cursor;
14
+
15
+ import android.database.sqlite.SQLiteDatabase;
16
+
17
+ import android.support.v7.app.AppCompatActivity;
18
+
19
+ import android.os.Bundle;
20
+
21
+ import android.view.View;
22
+
23
+ import android.widget.Button;
24
+
25
+ import android.widget.TextView;
26
+
27
+
28
+
29
+ import com.example.manga.R;
30
+
31
+ import com.example.manga.TestOpenHelper;
32
+
33
+
34
+
35
+ public class SubActivity extends AppCompatActivity {
36
+
37
+
38
+
39
+ private TextView textView;
40
+
41
+ private TestOpenHelper helper;
42
+
43
+
44
+
45
+ @Override
46
+
47
+ protected void onCreate(Bundle savedInstanceState) {
48
+
49
+ super.onCreate(savedInstanceState);
50
+
51
+ setContentView(R.layout.activity_sub);
52
+
53
+
54
+
55
+ // DB作成
56
+
57
+ helper = new TestOpenHelper(getApplicationContext());
58
+
59
+
60
+
61
+ Button readButton = findViewById(R.id.button);
62
+
63
+ readButton.setOnClickListener(new View.OnClickListener() {
64
+
65
+ @Override
66
+
67
+ public void onClick(View v) {
68
+
69
+ readData();
70
+
71
+ }
72
+
73
+ });
74
+
75
+
76
+
77
+ textView = findViewById(R.id.text_view);
78
+
79
+
80
+
81
+ }
82
+
83
+
84
+
85
+ private void readData(){
86
+
87
+ SQLiteDatabase db = helper.getReadableDatabase();
88
+
89
+ Cursor cursor = db.query(
90
+
91
+ "testdb",
92
+
93
+ new String[] { "haika", "subname","name","title","subtitle","sum","sort","jene","tana" },
94
+
95
+ null,
96
+
97
+ null,
98
+
99
+ null,
100
+
101
+ null,
102
+
103
+ null
104
+
105
+ );
106
+
107
+
108
+
109
+ cursor.moveToFirst();
110
+
111
+
112
+
113
+ StringBuilder sbuilder = new StringBuilder();
114
+
115
+
116
+
117
+ for (int i = 0; i < cursor.getCount(); i++) {
118
+
119
+ sbuilder.append(cursor.getString(0));
120
+
121
+ sbuilder.append("配架:");
122
+
123
+ sbuilder.append(cursor.getInt(1));
124
+
125
+ sbuilder.append("かな作者名:");
126
+
127
+ sbuilder.append(cursor.getInt(2));
128
+
129
+ sbuilder.append("作者名:");
130
+
131
+ sbuilder.append(cursor.getInt(3));
132
+
133
+ sbuilder.append("タイトル:");
134
+
135
+ sbuilder.append(cursor.getInt(4));
136
+
137
+ sbuilder.append("かなタイトル:");
138
+
139
+ sbuilder.append(cursor.getInt(5));
140
+
141
+ sbuilder.append("巻数:");
142
+
143
+ sbuilder.append(cursor.getInt(6));
144
+
145
+ sbuilder.append("巻ソート:");
146
+
147
+ sbuilder.append(cursor.getInt(7));
148
+
149
+ sbuilder.append("年代:");
150
+
151
+ sbuilder.append(cursor.getInt(1));
152
+
153
+ sbuilder.append("棚:");
154
+
155
+ cursor.moveToNext();
156
+
157
+ }
158
+
159
+
160
+
161
+ textView.setText(sbuilder.toString());
162
+
163
+ cursor.close();
164
+
165
+ }
166
+
167
+ }
168
+
169
+
170
+
171
+ ```
172
+
173
+
174
+
175
+ TestOpenHelper.java
176
+
177
+ ```java
178
+
11
179
  package com.example.manga;
12
180
 
13
181
 
14
182
 
183
+ import android.content.ContentValues;
184
+
15
- import android.database.Cursor;
185
+ import android.content.Context;
16
186
 
17
187
  import android.database.sqlite.SQLiteDatabase;
18
188
 
19
- import android.support.v7.app.AppCompatActivity;
20
-
21
- import android.os.Bundle;
22
-
23
- import android.view.View;
24
-
25
- import android.widget.Button;
26
-
27
- import android.widget.TextView;
28
-
29
-
30
-
31
- import com.example.manga.R;
32
-
33
- import com.example.manga.TestOpenHelper;
189
+ import android.database.sqlite.SQLiteOpenHelper;
34
-
35
-
36
-
190
+
191
+
192
+
37
- public class SubActivity extends AppCompatActivity {
193
+ public class TestOpenHelper extends SQLiteOpenHelper {
194
+
195
+
196
+
38
-
197
+ // データーベースのバージョン
39
-
40
-
198
+
41
- private TextView textView;
199
+ private static final int DATABASE_VERSION = 1;
200
+
201
+
202
+
42
-
203
+ // データーベース名
204
+
205
+ private static final String DATABASE_NAME = "TestDB.db";
206
+
207
+ private static final String TABLE_NAME = "testdb";
208
+
209
+ private static final String _ID = "_id";
210
+
211
+ private static final String COLUMN_NAME_TITLE = "title";
212
+
213
+ private static final String COLUMN_NAME_SUBTITLE = "subtitle";
214
+
215
+ private static final String COLUMN_NAME_NAME = "name";
216
+
217
+ private static final String COLUMN_NAME_SUBNAME = "subname";
218
+
219
+ private static final String COLUMN_NAME_NUM = "num";
220
+
221
+ private static final String COLUMN_NAME_HAIKA = "haika";
222
+
223
+ private static final String COLUMN_NAME_SORT = "sort";
224
+
225
+ private static final String COLUMN_NAME_JANE = "jene";
226
+
227
+ private static final String COLUMN_NAME_TANA = "tana";
228
+
229
+
230
+
231
+ private static final String SQL_CREATE_ENTRIES =
232
+
233
+ "CREATE TABLE " + TABLE_NAME + " (" +
234
+
235
+ _ID + " INTEGER PRIMARY KEY," +
236
+
237
+ COLUMN_NAME_HAIKA+"INTEGER" +
238
+
239
+ COLUMN_NAME_SUBNAME+"TEXT" +
240
+
241
+ COLUMN_NAME_NAME+"TEXT" +
242
+
243
+ COLUMN_NAME_TITLE + " TEXT," +
244
+
245
+ COLUMN_NAME_SUBTITLE+"TEXT" +
246
+
247
+ COLUMN_NAME_NUM+"INTEGER" +
248
+
249
+ COLUMN_NAME_SORT+"INTEGER" +
250
+
251
+ COLUMN_NAME_JANE+"INTEGER" +
252
+
253
+ COLUMN_NAME_TANA + " TEXT)";
254
+
255
+
256
+
257
+ private static final String SQL_DELETE_ENTRIES =
258
+
259
+ "DROP TABLE IF EXISTS " + TABLE_NAME;
260
+
261
+
262
+
263
+
264
+
43
- private TestOpenHelper helper;
265
+ TestOpenHelper(Context context) {
266
+
267
+ super(context, DATABASE_NAME, null, DATABASE_VERSION);
268
+
269
+
270
+
271
+ }
44
272
 
45
273
 
46
274
 
47
275
  @Override
48
276
 
49
- protected void onCreate(Bundle savedInstanceState) {
277
+ public void onCreate(SQLiteDatabase db) {
50
-
51
- super.onCreate(savedInstanceState);
278
+
52
-
53
- setContentView(R.layout.activity_sub);
54
-
55
-
56
-
57
- // DB作成
279
+ // テーブル作成
58
-
59
- helper = new TestOpenHelper(getApplicationContext());
280
+
60
-
61
-
62
-
63
- Button readButton = findViewById(R.id.button);
64
-
65
- readButton.setOnClickListener(new View.OnClickListener() {
66
-
67
- @Override
281
+ db.execSQL(
68
-
69
- public void onClick(View v) {
282
+
70
-
71
- readData();
72
-
73
- }
74
-
75
- });
76
-
77
-
78
-
79
- textView = findViewById(R.id.text_view);
80
-
81
-
82
-
83
- }
84
-
85
-
86
-
87
- private void readData(){
88
-
89
- SQLiteDatabase db = helper.getReadableDatabase();
90
-
91
- Cursor cursor = db.query(
92
-
93
- "testdb",
283
+ SQL_CREATE_ENTRIES
94
-
95
- new String[] { "haika", "subname","name","title","subtitle","sum","sort","jene","tana" },
96
-
97
- null,
98
-
99
- null,
100
-
101
- null,
102
-
103
- null,
104
-
105
- null
106
284
 
107
285
  );
108
286
 
109
287
 
110
288
 
111
- cursor.moveToFirst();
112
-
113
-
114
-
115
- StringBuilder sbuilder = new StringBuilder();
116
-
117
-
118
-
119
- for (int i = 0; i < cursor.getCount(); i++) {
120
-
121
- sbuilder.append(cursor.getString(0));
122
-
123
- sbuilder.append("配架:");
124
-
125
- sbuilder.append(cursor.getInt(1));
126
-
127
- sbuilder.append("かな作者名:");
128
-
129
- sbuilder.append(cursor.getInt(2));
130
-
131
- sbuilder.append("作者名:");
132
-
133
- sbuilder.append(cursor.getInt(3));
134
-
135
- sbuilder.append("タイトル:");
136
-
137
- sbuilder.append(cursor.getInt(4));
138
-
139
- sbuilder.append("かなタイトル:");
140
-
141
- sbuilder.append(cursor.getInt(5));
142
-
143
- sbuilder.append("巻数:");
144
-
145
- sbuilder.append(cursor.getInt(6));
146
-
147
- sbuilder.append("巻ソート:");
148
-
149
- sbuilder.append(cursor.getInt(7));
150
-
151
- sbuilder.append("年代:");
152
-
153
- sbuilder.append(cursor.getInt(1));
154
-
155
- sbuilder.append("棚:");
156
-
157
- cursor.moveToNext();
158
-
159
- }
160
-
161
-
162
-
163
- textView.setText(sbuilder.toString());
164
-
165
- cursor.close();
166
-
167
- }
289
+ saveData(db, 1, "ヤママツユウキチ","山松ゆうきち","ああ!あとがない","アアアトガナイ",1,1,2000,"2000");
290
+
291
+
292
+
293
+ }
294
+
295
+
296
+
297
+ @Override
298
+
299
+ public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
300
+
301
+ // アップデートの判別
302
+
303
+ db.execSQL(
304
+
305
+ SQL_DELETE_ENTRIES
306
+
307
+ );
308
+
309
+ onCreate(db);
310
+
311
+ }
312
+
313
+
314
+
315
+ // public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
316
+
317
+ // onUpgrade(db, oldVersion, newVersion);
318
+
319
+ // }
320
+
321
+
322
+
323
+ void saveData(SQLiteDatabase db, int haika, String subname,String name,String title,String subtitle,int num,int sort,int jene,String tana ){
324
+
325
+ ContentValues values = new ContentValues();
326
+
327
+ values.put("haika", haika);
328
+
329
+ values.put("subname", subname);
330
+
331
+ values.put("name", name);
332
+
333
+ values.put("title", title);
334
+
335
+ values.put("subtitle", subtitle);
336
+
337
+ values.put("num", num);
338
+
339
+ values.put("sort", sort);
340
+
341
+ values.put("jene", jene);
342
+
343
+ values.put("tana", tana);
344
+
345
+
346
+
347
+ db.insert("testdb", null, values);
348
+
349
+ }
350
+
351
+
168
352
 
169
353
  }
170
354
 
171
-
172
-
173
- TestOpenHelper.java
174
-
175
- package com.example.manga;
176
-
177
-
178
-
179
- import android.content.ContentValues;
180
-
181
- import android.content.Context;
182
-
183
- import android.database.sqlite.SQLiteDatabase;
184
-
185
- import android.database.sqlite.SQLiteOpenHelper;
186
-
187
-
188
-
189
- public class TestOpenHelper extends SQLiteOpenHelper {
190
-
191
-
192
-
193
- // データーベースのバージョン
194
-
195
- private static final int DATABASE_VERSION = 1;
196
-
197
-
198
-
199
- // データーベース名
200
-
201
- private static final String DATABASE_NAME = "TestDB.db";
202
-
203
- private static final String TABLE_NAME = "testdb";
204
-
205
- private static final String _ID = "_id";
206
-
207
- private static final String COLUMN_NAME_TITLE = "title";
208
-
209
- private static final String COLUMN_NAME_SUBTITLE = "subtitle";
210
-
211
- private static final String COLUMN_NAME_NAME = "name";
212
-
213
- private static final String COLUMN_NAME_SUBNAME = "subname";
214
-
215
- private static final String COLUMN_NAME_NUM = "num";
216
-
217
- private static final String COLUMN_NAME_HAIKA = "haika";
218
-
219
- private static final String COLUMN_NAME_SORT = "sort";
220
-
221
- private static final String COLUMN_NAME_JANE = "jene";
222
-
223
- private static final String COLUMN_NAME_TANA = "tana";
224
-
225
-
226
-
227
- private static final String SQL_CREATE_ENTRIES =
228
-
229
- "CREATE TABLE " + TABLE_NAME + " (" +
230
-
231
- _ID + " INTEGER PRIMARY KEY," +
232
-
233
- COLUMN_NAME_HAIKA+"INTEGER" +
234
-
235
- COLUMN_NAME_SUBNAME+"TEXT" +
236
-
237
- COLUMN_NAME_NAME+"TEXT" +
238
-
239
- COLUMN_NAME_TITLE + " TEXT," +
240
-
241
- COLUMN_NAME_SUBTITLE+"TEXT" +
242
-
243
- COLUMN_NAME_NUM+"INTEGER" +
244
-
245
- COLUMN_NAME_SORT+"INTEGER" +
246
-
247
- COLUMN_NAME_JANE+"INTEGER" +
248
-
249
- COLUMN_NAME_TANA + " TEXT)";
250
-
251
-
252
-
253
- private static final String SQL_DELETE_ENTRIES =
254
-
255
- "DROP TABLE IF EXISTS " + TABLE_NAME;
256
-
257
-
258
-
259
-
260
-
261
- TestOpenHelper(Context context) {
262
-
263
- super(context, DATABASE_NAME, null, DATABASE_VERSION);
264
-
265
-
266
-
267
- }
268
-
269
-
270
-
271
- @Override
272
-
273
- public void onCreate(SQLiteDatabase db) {
274
-
275
- // テーブル作成
276
-
277
- db.execSQL(
278
-
279
- SQL_CREATE_ENTRIES
280
-
281
- );
355
+ ```
282
-
283
-
284
-
285
- saveData(db, 1, "ヤママツユウキチ","山松ゆうきち","ああ!あとがない","アアアトガナイ",1,1,2000,"2000");
286
-
287
-
288
-
289
- }
290
-
291
-
292
-
293
- @Override
294
-
295
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
296
-
297
- // アップデートの判別
298
-
299
- db.execSQL(
300
-
301
- SQL_DELETE_ENTRIES
302
-
303
- );
304
-
305
- onCreate(db);
306
-
307
- }
308
-
309
-
310
-
311
- // public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
312
-
313
- // onUpgrade(db, oldVersion, newVersion);
314
-
315
- // }
316
-
317
-
318
-
319
- void saveData(SQLiteDatabase db, int haika, String subname,String name,String title,String subtitle,int num,int sort,int jene,String tana ){
320
-
321
- ContentValues values = new ContentValues();
322
-
323
- values.put("haika", haika);
324
-
325
- values.put("subname", subname);
326
-
327
- values.put("name", name);
328
-
329
- values.put("title", title);
330
-
331
- values.put("subtitle", subtitle);
332
-
333
- values.put("num", num);
334
-
335
- values.put("sort", sort);
336
-
337
- values.put("jene", jene);
338
-
339
- values.put("tana", tana);
340
-
341
-
342
-
343
- db.insert("testdb", null, values);
344
-
345
- }
346
-
347
-
348
-
349
- }
350
356
 
351
357
  よろしくお願いいたします。