teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問androidアプリでSQLiteDatabaseに情報を書きこみ失敗。

編集履歴

質問編集履歴

6

言語のmarkdown記法修正

2018/07/29 14:07

投稿

tk2635842
tk2635842

スコア8

test CHANGED
File without changes
test CHANGED
@@ -34,420 +34,420 @@
34
34
 
35
35
 
36
36
 
37
+ ```lang-Java
38
+
39
+ MainActivity
40
+
41
+
42
+
43
+ DatabaseHelper.java
44
+
45
+ import android.content.ContentValues;
46
+
47
+ import android.content.Context;
48
+
49
+ import android.database.Cursor;
50
+
51
+ import android.database.sqlite.SQLiteDatabase;
52
+
53
+ import android.database.sqlite.SQLiteOpenHelper;
54
+
55
+
56
+
57
+ public class DatabaseHelper extends SQLiteOpenHelper{
58
+
59
+
60
+
61
+ public static final String DATABASE_NAME = "supplement.db";
62
+
63
+ public static final String TABLE_NAME = "supplement_table";
64
+
65
+ public static final String COL1 = "ID";
66
+
67
+ public static final String COL2 = "NAME";
68
+
69
+ public static final String COL3 = "DAILY_SERVING";
70
+
71
+ public static final String COL4 = "DAYS_IN_WEEK_YOU_USE";
72
+
73
+ public static final String COL5 = "SERVING_PER_CONTAINER";
74
+
75
+ public static final String COL6 = "NUMBER_OF_CONTAINER";
76
+
77
+ public static final String COL7 = "PRICE_OF_CONTAINER";
78
+
79
+ public static final String COL8 = "MONTHLY_EXPENSE";
80
+
81
+ public static final String COL9 = "DAYS_UNTIL_EXPIRE";
82
+
83
+ public static final String COL10 = "EXPIRE_DATE";
84
+
85
+
86
+
87
+ public DatabaseHelper(Context context) {
88
+
89
+ super(context, DATABASE_NAME, null, 1);
90
+
91
+ }
92
+
93
+
94
+
95
+ @Override
96
+
97
+ public void onCreate(SQLiteDatabase db) {
98
+
99
+ String createTable = "CREATE TABLE " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
100
+
101
+ " NAME TEXT, DAILY_SERVING TEXT, DAYS_IN_WEEK_YOU_USE TEXT, SERVING_PER_CONTAINER TEXT," +
102
+
103
+ " NUMBER_OF_CONTAINER TEXT, PRICE_OF_CONTAINER TEXT, MONTHLY_EXPENSE TEXT, " +
104
+
105
+ "DAYS_UNTIL_EXPIRE TEXT, EXPIRE_DATE TEXT)";
106
+
107
+
108
+
109
+ db.execSQL(createTable);
110
+
111
+
112
+
113
+ }
114
+
115
+
116
+
117
+ @Override
118
+
119
+ public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
120
+
121
+ db.execSQL("DROP IF TABLE EXISTS " + TABLE_NAME);
122
+
123
+ onCreate(db);
124
+
125
+
126
+
127
+ }
128
+
129
+
130
+
131
+ public boolean addData(String name, String daily_serving, String days_in_a_week_you_use,
132
+
133
+ String serving_per_container, String number_of_container, String price_of_container,
134
+
135
+ String monthly_expense, String days_until_expire, String expire_date){
136
+
137
+ SQLiteDatabase db = this.getWritableDatabase();
138
+
139
+ ContentValues contentValues = new ContentValues();
140
+
141
+ contentValues.put(COL2,name);
142
+
143
+ contentValues.put(COL3,daily_serving);
144
+
145
+ contentValues.put(COL4,days_in_a_week_you_use);
146
+
147
+ contentValues.put(COL5,serving_per_container);
148
+
149
+ contentValues.put(COL6,number_of_container);
150
+
151
+ contentValues.put(COL7,price_of_container);
152
+
153
+ contentValues.put(COL8,monthly_expense);
154
+
155
+ contentValues.put(COL9,days_until_expire);
156
+
157
+ contentValues.put(COL10,expire_date);
158
+
159
+
160
+
161
+ long result = db.insert(TABLE_NAME, null, contentValues);
162
+
163
+
164
+
165
+ if(result == -1){
166
+
167
+ return false;
168
+
169
+ }else {
170
+
171
+ return true;
172
+
173
+ }
174
+
175
+ }
176
+
177
+
178
+
179
+ public Cursor showData(){
180
+
181
+ SQLiteDatabase db = this.getWritableDatabase();
182
+
183
+ Cursor data = db.rawQuery("SELECT * FROM " + TABLE_NAME, null);
184
+
185
+ return data;
186
+
187
+ }
188
+
189
+
190
+
191
+ public boolean updateData(String id,String name, String daily_serving, String days_in_a_week_you_use,
192
+
193
+ String serving_per_container, String number_of_container, String price_of_container,
194
+
195
+ String monthly_expense, String days_until_expire, String expire_date){
196
+
197
+ SQLiteDatabase db = this.getWritableDatabase();
198
+
199
+ ContentValues contentValues = new ContentValues();
200
+
201
+ contentValues.put(COL1, id);
202
+
203
+ contentValues.put(COL2,name);
204
+
205
+ contentValues.put(COL3,daily_serving);
206
+
207
+ contentValues.put(COL4,days_in_a_week_you_use);
208
+
209
+ contentValues.put(COL5,serving_per_container);
210
+
211
+ contentValues.put(COL6,number_of_container);
212
+
213
+ contentValues.put(COL7,price_of_container);
214
+
215
+ contentValues.put(COL8,monthly_expense);
216
+
217
+ contentValues.put(COL9,days_until_expire);
218
+
219
+ contentValues.put(COL10,expire_date);
220
+
221
+ db.update(TABLE_NAME, contentValues, "ID = ?", new String[] {id});
222
+
223
+ return true;
224
+
225
+ }
226
+
227
+
228
+
229
+ public Integer deleteData(String id){
230
+
231
+ SQLiteDatabase db = this.getWritableDatabase();
232
+
233
+ return db.delete(TABLE_NAME, "ID = ?", new String[] {id});
234
+
235
+ }
236
+
237
+
238
+
239
+ }
240
+
241
+
242
+
243
+
244
+
245
+ DatabaseHelper.java
246
+
247
+
248
+
249
+ import android.content.ContentValues;
250
+
251
+ import android.content.Context;
252
+
253
+ import android.database.Cursor;
254
+
255
+ import android.database.sqlite.SQLiteDatabase;
256
+
257
+ import android.database.sqlite.SQLiteOpenHelper;
258
+
259
+
260
+
261
+ public class DatabaseHelper extends SQLiteOpenHelper{
262
+
263
+
264
+
265
+ public static final String DATABASE_NAME = "supplement.db";
266
+
267
+ public static final String TABLE_NAME = "supplement_table";
268
+
269
+ public static final String COL1 = "ID";
270
+
271
+ public static final String COL2 = "NAME";
272
+
273
+ public static final String COL3 = "DAILY_SERVING";
274
+
275
+ public static final String COL4 = "DAYS_IN_WEEK_YOU_USE";
276
+
277
+ public static final String COL5 = "SERVING_PER_CONTAINER";
278
+
279
+ public static final String COL6 = "NUMBER_OF_CONTAINER";
280
+
281
+ public static final String COL7 = "PRICE_OF_CONTAINER";
282
+
283
+ public static final String COL8 = "MONTHLY_EXPENSE";
284
+
285
+ public static final String COL9 = "DAYS_UNTIL_EXPIRE";
286
+
287
+ public static final String COL10 = "EXPIRE_DATE";
288
+
289
+
290
+
291
+ public DatabaseHelper(Context context) {
292
+
293
+ super(context, DATABASE_NAME, null, 1);
294
+
295
+ }
296
+
297
+
298
+
299
+ @Override
300
+
301
+ public void onCreate(SQLiteDatabase db) {
302
+
303
+ String createTable = "CREATE TABLE " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
304
+
305
+ " NAME TEXT, DAILY_SERVING TEXT, DAYS_IN_WEEK_YOU_USE TEXT, SERVING_PER_CONTAINER TEXT," +
306
+
307
+ " NUMBER_OF_CONTAINER TEXT, PRICE_OF_CONTAINER TEXT, MONTHLY_EXPENSE TEXT, " +
308
+
309
+ "DAYS_UNTIL_EXPIRE TEXT, EXPIRE_DATE TEXT)";
310
+
311
+
312
+
313
+ db.execSQL(createTable);
314
+
315
+
316
+
317
+ }
318
+
319
+
320
+
321
+ @Override
322
+
323
+ public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
324
+
325
+ db.execSQL("DROP IF TABLE EXISTS " + TABLE_NAME);
326
+
327
+ onCreate(db);
328
+
329
+
330
+
331
+ }
332
+
333
+
334
+
335
+ public boolean addData(String name, String daily_serving, String days_in_a_week_you_use,
336
+
337
+ String serving_per_container, String number_of_container, String price_of_container,
338
+
339
+ String monthly_expense, String days_until_expire, String expire_date){
340
+
341
+ SQLiteDatabase db = this.getWritableDatabase();
342
+
343
+ ContentValues contentValues = new ContentValues();
344
+
345
+ contentValues.put(COL2,name);
346
+
347
+ contentValues.put(COL3,daily_serving);
348
+
349
+ contentValues.put(COL4,days_in_a_week_you_use);
350
+
351
+ contentValues.put(COL5,serving_per_container);
352
+
353
+ contentValues.put(COL6,number_of_container);
354
+
355
+ contentValues.put(COL7,price_of_container);
356
+
357
+ contentValues.put(COL8,monthly_expense);
358
+
359
+ contentValues.put(COL9,days_until_expire);
360
+
361
+ contentValues.put(COL10,expire_date);
362
+
363
+
364
+
365
+ long result = db.insert(TABLE_NAME, null, contentValues);
366
+
367
+
368
+
369
+ if(result == -1){
370
+
371
+ return false;
372
+
373
+ }else {
374
+
375
+ return true;
376
+
377
+ }
378
+
379
+ }
380
+
381
+
382
+
383
+ public Cursor showData(){
384
+
385
+ SQLiteDatabase db = this.getWritableDatabase();
386
+
387
+ Cursor data = db.rawQuery("SELECT * FROM " + TABLE_NAME, null);
388
+
389
+ return data;
390
+
391
+ }
392
+
393
+
394
+
395
+ public boolean updateData(String id,String name, String daily_serving, String days_in_a_week_you_use,
396
+
397
+ String serving_per_container, String number_of_container, String price_of_container,
398
+
399
+ String monthly_expense, String days_until_expire, String expire_date){
400
+
401
+ SQLiteDatabase db = this.getWritableDatabase();
402
+
403
+ ContentValues contentValues = new ContentValues();
404
+
405
+ contentValues.put(COL1, id);
406
+
407
+ contentValues.put(COL2,name);
408
+
409
+ contentValues.put(COL3,daily_serving);
410
+
411
+ contentValues.put(COL4,days_in_a_week_you_use);
412
+
413
+ contentValues.put(COL5,serving_per_container);
414
+
415
+ contentValues.put(COL6,number_of_container);
416
+
417
+ contentValues.put(COL7,price_of_container);
418
+
419
+ contentValues.put(COL8,monthly_expense);
420
+
421
+ contentValues.put(COL9,days_until_expire);
422
+
423
+ contentValues.put(COL10,expire_date);
424
+
425
+ db.update(TABLE_NAME, contentValues, "ID = ?", new String[] {id});
426
+
427
+ return true;
428
+
429
+ }
430
+
431
+
432
+
433
+ public Integer deleteData(String id){
434
+
435
+ SQLiteDatabase db = this.getWritableDatabase();
436
+
437
+ return db.delete(TABLE_NAME, "ID = ?", new String[] {id});
438
+
439
+ }
440
+
441
+
442
+
443
+ }
444
+
445
+
446
+
447
+
448
+
37
449
  ```
38
450
 
39
- MainActivity
40
-
41
-
42
-
43
- DatabaseHelper.java
44
-
45
- import android.content.ContentValues;
46
-
47
- import android.content.Context;
48
-
49
- import android.database.Cursor;
50
-
51
- import android.database.sqlite.SQLiteDatabase;
52
-
53
- import android.database.sqlite.SQLiteOpenHelper;
54
-
55
-
56
-
57
- public class DatabaseHelper extends SQLiteOpenHelper{
58
-
59
-
60
-
61
- public static final String DATABASE_NAME = "supplement.db";
62
-
63
- public static final String TABLE_NAME = "supplement_table";
64
-
65
- public static final String COL1 = "ID";
66
-
67
- public static final String COL2 = "NAME";
68
-
69
- public static final String COL3 = "DAILY_SERVING";
70
-
71
- public static final String COL4 = "DAYS_IN_WEEK_YOU_USE";
72
-
73
- public static final String COL5 = "SERVING_PER_CONTAINER";
74
-
75
- public static final String COL6 = "NUMBER_OF_CONTAINER";
76
-
77
- public static final String COL7 = "PRICE_OF_CONTAINER";
78
-
79
- public static final String COL8 = "MONTHLY_EXPENSE";
80
-
81
- public static final String COL9 = "DAYS_UNTIL_EXPIRE";
82
-
83
- public static final String COL10 = "EXPIRE_DATE";
84
-
85
-
86
-
87
- public DatabaseHelper(Context context) {
88
-
89
- super(context, DATABASE_NAME, null, 1);
90
-
91
- }
92
-
93
-
94
-
95
- @Override
96
-
97
- public void onCreate(SQLiteDatabase db) {
98
-
99
- String createTable = "CREATE TABLE " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
100
-
101
- " NAME TEXT, DAILY_SERVING TEXT, DAYS_IN_WEEK_YOU_USE TEXT, SERVING_PER_CONTAINER TEXT," +
102
-
103
- " NUMBER_OF_CONTAINER TEXT, PRICE_OF_CONTAINER TEXT, MONTHLY_EXPENSE TEXT, " +
104
-
105
- "DAYS_UNTIL_EXPIRE TEXT, EXPIRE_DATE TEXT)";
106
-
107
-
108
-
109
- db.execSQL(createTable);
110
-
111
-
112
-
113
- }
114
-
115
-
116
-
117
- @Override
118
-
119
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
120
-
121
- db.execSQL("DROP IF TABLE EXISTS " + TABLE_NAME);
122
-
123
- onCreate(db);
124
-
125
-
126
-
127
- }
128
-
129
-
130
-
131
- public boolean addData(String name, String daily_serving, String days_in_a_week_you_use,
132
-
133
- String serving_per_container, String number_of_container, String price_of_container,
134
-
135
- String monthly_expense, String days_until_expire, String expire_date){
136
-
137
- SQLiteDatabase db = this.getWritableDatabase();
138
-
139
- ContentValues contentValues = new ContentValues();
140
-
141
- contentValues.put(COL2,name);
142
-
143
- contentValues.put(COL3,daily_serving);
144
-
145
- contentValues.put(COL4,days_in_a_week_you_use);
146
-
147
- contentValues.put(COL5,serving_per_container);
148
-
149
- contentValues.put(COL6,number_of_container);
150
-
151
- contentValues.put(COL7,price_of_container);
152
-
153
- contentValues.put(COL8,monthly_expense);
154
-
155
- contentValues.put(COL9,days_until_expire);
156
-
157
- contentValues.put(COL10,expire_date);
158
-
159
-
160
-
161
- long result = db.insert(TABLE_NAME, null, contentValues);
162
-
163
-
164
-
165
- if(result == -1){
166
-
167
- return false;
168
-
169
- }else {
170
-
171
- return true;
172
-
173
- }
174
-
175
- }
176
-
177
-
178
-
179
- public Cursor showData(){
180
-
181
- SQLiteDatabase db = this.getWritableDatabase();
182
-
183
- Cursor data = db.rawQuery("SELECT * FROM " + TABLE_NAME, null);
184
-
185
- return data;
186
-
187
- }
188
-
189
-
190
-
191
- public boolean updateData(String id,String name, String daily_serving, String days_in_a_week_you_use,
192
-
193
- String serving_per_container, String number_of_container, String price_of_container,
194
-
195
- String monthly_expense, String days_until_expire, String expire_date){
196
-
197
- SQLiteDatabase db = this.getWritableDatabase();
198
-
199
- ContentValues contentValues = new ContentValues();
200
-
201
- contentValues.put(COL1, id);
202
-
203
- contentValues.put(COL2,name);
204
-
205
- contentValues.put(COL3,daily_serving);
206
-
207
- contentValues.put(COL4,days_in_a_week_you_use);
208
-
209
- contentValues.put(COL5,serving_per_container);
210
-
211
- contentValues.put(COL6,number_of_container);
212
-
213
- contentValues.put(COL7,price_of_container);
214
-
215
- contentValues.put(COL8,monthly_expense);
216
-
217
- contentValues.put(COL9,days_until_expire);
218
-
219
- contentValues.put(COL10,expire_date);
220
-
221
- db.update(TABLE_NAME, contentValues, "ID = ?", new String[] {id});
222
-
223
- return true;
224
-
225
- }
226
-
227
-
228
-
229
- public Integer deleteData(String id){
230
-
231
- SQLiteDatabase db = this.getWritableDatabase();
232
-
233
- return db.delete(TABLE_NAME, "ID = ?", new String[] {id});
234
-
235
- }
236
-
237
-
238
-
239
- }
240
-
241
-
242
-
243
-
244
-
245
- DatabaseHelper.java
246
-
247
-
248
-
249
- import android.content.ContentValues;
250
-
251
- import android.content.Context;
252
-
253
- import android.database.Cursor;
254
-
255
- import android.database.sqlite.SQLiteDatabase;
256
-
257
- import android.database.sqlite.SQLiteOpenHelper;
258
-
259
-
260
-
261
- public class DatabaseHelper extends SQLiteOpenHelper{
262
-
263
-
264
-
265
- public static final String DATABASE_NAME = "supplement.db";
266
-
267
- public static final String TABLE_NAME = "supplement_table";
268
-
269
- public static final String COL1 = "ID";
270
-
271
- public static final String COL2 = "NAME";
272
-
273
- public static final String COL3 = "DAILY_SERVING";
274
-
275
- public static final String COL4 = "DAYS_IN_WEEK_YOU_USE";
276
-
277
- public static final String COL5 = "SERVING_PER_CONTAINER";
278
-
279
- public static final String COL6 = "NUMBER_OF_CONTAINER";
280
-
281
- public static final String COL7 = "PRICE_OF_CONTAINER";
282
-
283
- public static final String COL8 = "MONTHLY_EXPENSE";
284
-
285
- public static final String COL9 = "DAYS_UNTIL_EXPIRE";
286
-
287
- public static final String COL10 = "EXPIRE_DATE";
288
-
289
-
290
-
291
- public DatabaseHelper(Context context) {
292
-
293
- super(context, DATABASE_NAME, null, 1);
294
-
295
- }
296
-
297
-
298
-
299
- @Override
300
-
301
- public void onCreate(SQLiteDatabase db) {
302
-
303
- String createTable = "CREATE TABLE " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
304
-
305
- " NAME TEXT, DAILY_SERVING TEXT, DAYS_IN_WEEK_YOU_USE TEXT, SERVING_PER_CONTAINER TEXT," +
306
-
307
- " NUMBER_OF_CONTAINER TEXT, PRICE_OF_CONTAINER TEXT, MONTHLY_EXPENSE TEXT, " +
308
-
309
- "DAYS_UNTIL_EXPIRE TEXT, EXPIRE_DATE TEXT)";
310
-
311
-
312
-
313
- db.execSQL(createTable);
314
-
315
-
316
-
317
- }
318
-
319
-
320
-
321
- @Override
322
-
323
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
324
-
325
- db.execSQL("DROP IF TABLE EXISTS " + TABLE_NAME);
326
-
327
- onCreate(db);
328
-
329
-
330
-
331
- }
332
-
333
-
334
-
335
- public boolean addData(String name, String daily_serving, String days_in_a_week_you_use,
336
-
337
- String serving_per_container, String number_of_container, String price_of_container,
338
-
339
- String monthly_expense, String days_until_expire, String expire_date){
340
-
341
- SQLiteDatabase db = this.getWritableDatabase();
342
-
343
- ContentValues contentValues = new ContentValues();
344
-
345
- contentValues.put(COL2,name);
346
-
347
- contentValues.put(COL3,daily_serving);
348
-
349
- contentValues.put(COL4,days_in_a_week_you_use);
350
-
351
- contentValues.put(COL5,serving_per_container);
352
-
353
- contentValues.put(COL6,number_of_container);
354
-
355
- contentValues.put(COL7,price_of_container);
356
-
357
- contentValues.put(COL8,monthly_expense);
358
-
359
- contentValues.put(COL9,days_until_expire);
360
-
361
- contentValues.put(COL10,expire_date);
362
-
363
-
364
-
365
- long result = db.insert(TABLE_NAME, null, contentValues);
366
-
367
-
368
-
369
- if(result == -1){
370
-
371
- return false;
372
-
373
- }else {
374
-
375
- return true;
376
-
377
- }
378
-
379
- }
380
-
381
-
382
-
383
- public Cursor showData(){
384
-
385
- SQLiteDatabase db = this.getWritableDatabase();
386
-
387
- Cursor data = db.rawQuery("SELECT * FROM " + TABLE_NAME, null);
388
-
389
- return data;
390
-
391
- }
392
-
393
-
394
-
395
- public boolean updateData(String id,String name, String daily_serving, String days_in_a_week_you_use,
396
-
397
- String serving_per_container, String number_of_container, String price_of_container,
398
-
399
- String monthly_expense, String days_until_expire, String expire_date){
400
-
401
- SQLiteDatabase db = this.getWritableDatabase();
402
-
403
- ContentValues contentValues = new ContentValues();
404
-
405
- contentValues.put(COL1, id);
406
-
407
- contentValues.put(COL2,name);
408
-
409
- contentValues.put(COL3,daily_serving);
410
-
411
- contentValues.put(COL4,days_in_a_week_you_use);
412
-
413
- contentValues.put(COL5,serving_per_container);
414
-
415
- contentValues.put(COL6,number_of_container);
416
-
417
- contentValues.put(COL7,price_of_container);
418
-
419
- contentValues.put(COL8,monthly_expense);
420
-
421
- contentValues.put(COL9,days_until_expire);
422
-
423
- contentValues.put(COL10,expire_date);
424
-
425
- db.update(TABLE_NAME, contentValues, "ID = ?", new String[] {id});
426
-
427
- return true;
428
-
429
- }
430
-
431
-
432
-
433
- public Integer deleteData(String id){
434
-
435
- SQLiteDatabase db = this.getWritableDatabase();
436
-
437
- return db.delete(TABLE_NAME, "ID = ?", new String[] {id});
438
-
439
- }
440
-
441
-
442
-
443
- }
444
-
445
-
446
-
447
-
448
-
449
- ```
450
-
451
451
 
452
452
 
453
453
  ### 試したこと

5

markdown記法修正

2018/07/29 14:07

投稿

tk2635842
tk2635842

スコア8

test CHANGED
File without changes
test CHANGED
@@ -10,9 +10,7 @@
10
10
 
11
11
  データベースに保存するコラムを増やすために自分で編集しました。
12
12
 
13
- こちらのコードを元に書いています。
14
-
15
- [https://github.com/mitchtabian/SQLiteSaveUserData/tree/master/app/src/main/java/practice/application/sqlitesaveuserdata]
13
+ [こちらのコードを元に書いています。](https://github.com/mitchtabian/SQLiteSaveUserData/tree/master/app/src/main/java/practice/application/sqlitesaveuserdata)
16
14
 
17
15
 
18
16
 

4

markdownを使ってURLを表記。

2018/07/29 11:25

投稿

tk2635842
tk2635842

スコア8

test CHANGED
File without changes
test CHANGED
@@ -12,7 +12,7 @@
12
12
 
13
13
  こちらのコードを元に書いています。
14
14
 
15
- https://github.com/mitchtabian/SQLiteSaveUserData/tree/master/app/src/main/java/practice/application/sqlitesaveuserdata
15
+ [https://github.com/mitchtabian/SQLiteSaveUserData/tree/master/app/src/main/java/practice/application/sqlitesaveuserdata]
16
16
 
17
17
 
18
18
 

3

タイトルを詳しく。

2018/07/29 11:15

投稿

tk2635842
tk2635842

スコア8

test CHANGED
@@ -1 +1 @@
1
- SQLiteDatabaseを利用したandroidアプリ
1
+ androidアプリでSQLiteDatabaseに情報を書きこみ失敗。
test CHANGED
File without changes

2

誤字修正等

2018/07/29 10:38

投稿

tk2635842
tk2635842

スコア8

test CHANGED
File without changes
test CHANGED
@@ -8,6 +8,14 @@
8
8
 
9
9
 
10
10
 
11
+ データベースに保存するコラムを増やすために自分で編集しました。
12
+
13
+ こちらのコードを元に書いています。
14
+
15
+ https://github.com/mitchtabian/SQLiteSaveUserData/tree/master/app/src/main/java/practice/application/sqlitesaveuserdata
16
+
17
+
18
+
11
19
  ### 発生している問題・エラーメッセージ
12
20
 
13
21
 
@@ -30,7 +38,7 @@
30
38
 
31
39
  ```
32
40
 
33
- MainAA
41
+ MainActivity
34
42
 
35
43
 
36
44
 
@@ -234,6 +242,212 @@
234
242
 
235
243
 
236
244
 
245
+
246
+
247
+ DatabaseHelper.java
248
+
249
+
250
+
251
+ import android.content.ContentValues;
252
+
253
+ import android.content.Context;
254
+
255
+ import android.database.Cursor;
256
+
257
+ import android.database.sqlite.SQLiteDatabase;
258
+
259
+ import android.database.sqlite.SQLiteOpenHelper;
260
+
261
+
262
+
263
+ public class DatabaseHelper extends SQLiteOpenHelper{
264
+
265
+
266
+
267
+ public static final String DATABASE_NAME = "supplement.db";
268
+
269
+ public static final String TABLE_NAME = "supplement_table";
270
+
271
+ public static final String COL1 = "ID";
272
+
273
+ public static final String COL2 = "NAME";
274
+
275
+ public static final String COL3 = "DAILY_SERVING";
276
+
277
+ public static final String COL4 = "DAYS_IN_WEEK_YOU_USE";
278
+
279
+ public static final String COL5 = "SERVING_PER_CONTAINER";
280
+
281
+ public static final String COL6 = "NUMBER_OF_CONTAINER";
282
+
283
+ public static final String COL7 = "PRICE_OF_CONTAINER";
284
+
285
+ public static final String COL8 = "MONTHLY_EXPENSE";
286
+
287
+ public static final String COL9 = "DAYS_UNTIL_EXPIRE";
288
+
289
+ public static final String COL10 = "EXPIRE_DATE";
290
+
291
+
292
+
293
+ public DatabaseHelper(Context context) {
294
+
295
+ super(context, DATABASE_NAME, null, 1);
296
+
297
+ }
298
+
299
+
300
+
301
+ @Override
302
+
303
+ public void onCreate(SQLiteDatabase db) {
304
+
305
+ String createTable = "CREATE TABLE " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
306
+
307
+ " NAME TEXT, DAILY_SERVING TEXT, DAYS_IN_WEEK_YOU_USE TEXT, SERVING_PER_CONTAINER TEXT," +
308
+
309
+ " NUMBER_OF_CONTAINER TEXT, PRICE_OF_CONTAINER TEXT, MONTHLY_EXPENSE TEXT, " +
310
+
311
+ "DAYS_UNTIL_EXPIRE TEXT, EXPIRE_DATE TEXT)";
312
+
313
+
314
+
315
+ db.execSQL(createTable);
316
+
317
+
318
+
319
+ }
320
+
321
+
322
+
323
+ @Override
324
+
325
+ public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
326
+
327
+ db.execSQL("DROP IF TABLE EXISTS " + TABLE_NAME);
328
+
329
+ onCreate(db);
330
+
331
+
332
+
333
+ }
334
+
335
+
336
+
337
+ public boolean addData(String name, String daily_serving, String days_in_a_week_you_use,
338
+
339
+ String serving_per_container, String number_of_container, String price_of_container,
340
+
341
+ String monthly_expense, String days_until_expire, String expire_date){
342
+
343
+ SQLiteDatabase db = this.getWritableDatabase();
344
+
345
+ ContentValues contentValues = new ContentValues();
346
+
347
+ contentValues.put(COL2,name);
348
+
349
+ contentValues.put(COL3,daily_serving);
350
+
351
+ contentValues.put(COL4,days_in_a_week_you_use);
352
+
353
+ contentValues.put(COL5,serving_per_container);
354
+
355
+ contentValues.put(COL6,number_of_container);
356
+
357
+ contentValues.put(COL7,price_of_container);
358
+
359
+ contentValues.put(COL8,monthly_expense);
360
+
361
+ contentValues.put(COL9,days_until_expire);
362
+
363
+ contentValues.put(COL10,expire_date);
364
+
365
+
366
+
367
+ long result = db.insert(TABLE_NAME, null, contentValues);
368
+
369
+
370
+
371
+ if(result == -1){
372
+
373
+ return false;
374
+
375
+ }else {
376
+
377
+ return true;
378
+
379
+ }
380
+
381
+ }
382
+
383
+
384
+
385
+ public Cursor showData(){
386
+
387
+ SQLiteDatabase db = this.getWritableDatabase();
388
+
389
+ Cursor data = db.rawQuery("SELECT * FROM " + TABLE_NAME, null);
390
+
391
+ return data;
392
+
393
+ }
394
+
395
+
396
+
397
+ public boolean updateData(String id,String name, String daily_serving, String days_in_a_week_you_use,
398
+
399
+ String serving_per_container, String number_of_container, String price_of_container,
400
+
401
+ String monthly_expense, String days_until_expire, String expire_date){
402
+
403
+ SQLiteDatabase db = this.getWritableDatabase();
404
+
405
+ ContentValues contentValues = new ContentValues();
406
+
407
+ contentValues.put(COL1, id);
408
+
409
+ contentValues.put(COL2,name);
410
+
411
+ contentValues.put(COL3,daily_serving);
412
+
413
+ contentValues.put(COL4,days_in_a_week_you_use);
414
+
415
+ contentValues.put(COL5,serving_per_container);
416
+
417
+ contentValues.put(COL6,number_of_container);
418
+
419
+ contentValues.put(COL7,price_of_container);
420
+
421
+ contentValues.put(COL8,monthly_expense);
422
+
423
+ contentValues.put(COL9,days_until_expire);
424
+
425
+ contentValues.put(COL10,expire_date);
426
+
427
+ db.update(TABLE_NAME, contentValues, "ID = ?", new String[] {id});
428
+
429
+ return true;
430
+
431
+ }
432
+
433
+
434
+
435
+ public Integer deleteData(String id){
436
+
437
+ SQLiteDatabase db = this.getWritableDatabase();
438
+
439
+ return db.delete(TABLE_NAME, "ID = ?", new String[] {id});
440
+
441
+ }
442
+
443
+
444
+
445
+ }
446
+
447
+
448
+
449
+
450
+
237
451
  ```
238
452
 
239
453
 
@@ -242,7 +456,7 @@
242
456
 
243
457
 
244
458
 
245
- ここに問題に対して試したことを記載してください。
459
+ プロジェクトのクリーン等
246
460
 
247
461
 
248
462
 

1

2018/07/29 04:50

投稿

tk2635842
tk2635842

スコア8

test CHANGED
File without changes
test CHANGED
File without changes