質問編集履歴
4
エラーメッセージの修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -12,7 +12,101 @@
|
|
12
12
|
|
13
13
|
```
|
14
14
|
|
15
|
+
E/AndroidRuntime: FATAL EXCEPTION: main
|
16
|
+
|
17
|
+
Process: com.example.innovation.f_featnote, PID: 2899
|
18
|
+
|
15
|
-
java.lang.NullPointerException: Attempt to invoke virtual method 'java.lang.String java.lang.Object.toString()' on a null object reference
|
19
|
+
java.lang.NullPointerException: Attempt to invoke virtual method 'java.lang.String java.lang.Object.toString()' on a null object reference
|
20
|
+
|
21
|
+
at android.widget.ArrayAdapter.createViewFromResource(ArrayAdapter.java:394)
|
22
|
+
|
23
|
+
at android.widget.ArrayAdapter.getView(ArrayAdapter.java:362)
|
24
|
+
|
25
|
+
at android.widget.AbsListView.obtainView(AbsListView.java:2344)
|
26
|
+
|
27
|
+
at android.widget.ListView.makeAndAddView(ListView.java:1864)
|
28
|
+
|
29
|
+
at android.widget.ListView.fillDown(ListView.java:698)
|
30
|
+
|
31
|
+
at android.widget.ListView.fillFromTop(ListView.java:759)
|
32
|
+
|
33
|
+
at android.widget.ListView.layoutChildren(ListView.java:1673)
|
34
|
+
|
35
|
+
at android.widget.AbsListView.onLayout(AbsListView.java:2148)
|
36
|
+
|
37
|
+
at android.view.View.layout(View.java:15596)
|
38
|
+
|
39
|
+
at android.view.ViewGroup.layout(ViewGroup.java:4966)
|
40
|
+
|
41
|
+
at android.widget.LinearLayout.setChildFrame(LinearLayout.java:1703)
|
42
|
+
|
43
|
+
at android.widget.LinearLayout.layoutVertical(LinearLayout.java:1557)
|
44
|
+
|
45
|
+
at android.widget.LinearLayout.onLayout(LinearLayout.java:1466)
|
46
|
+
|
47
|
+
at android.view.View.layout(View.java:15596)
|
48
|
+
|
49
|
+
at android.view.ViewGroup.layout(ViewGroup.java:4966)
|
50
|
+
|
51
|
+
at android.widget.FrameLayout.layoutChildren(FrameLayout.java:573)
|
52
|
+
|
53
|
+
at android.widget.FrameLayout.onLayout(FrameLayout.java:508)
|
54
|
+
|
55
|
+
at android.view.View.layout(View.java:15596)
|
56
|
+
|
57
|
+
at android.view.ViewGroup.layout(ViewGroup.java:4966)
|
58
|
+
|
59
|
+
at android.widget.LinearLayout.setChildFrame(LinearLayout.java:1703)
|
60
|
+
|
61
|
+
at android.widget.LinearLayout.layoutVertical(LinearLayout.java:1557)
|
62
|
+
|
63
|
+
at android.widget.LinearLayout.onLayout(LinearLayout.java:1466)
|
64
|
+
|
65
|
+
at android.view.View.layout(View.java:15596)
|
66
|
+
|
67
|
+
at android.view.ViewGroup.layout(ViewGroup.java:4966)
|
68
|
+
|
69
|
+
at android.widget.FrameLayout.layoutChildren(FrameLayout.java:573)
|
70
|
+
|
71
|
+
at android.widget.FrameLayout.onLayout(FrameLayout.java:508)
|
72
|
+
|
73
|
+
at android.view.View.layout(View.java:15596)
|
74
|
+
|
75
|
+
at android.view.ViewGroup.layout(ViewGroup.java:4966)
|
76
|
+
|
77
|
+
at android.view.ViewRootImpl.performLayout(ViewRootImpl.java:2072)
|
78
|
+
|
79
|
+
at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:1829)
|
80
|
+
|
81
|
+
at android.view.ViewRootImpl.doTraversal(ViewRootImpl.java:1054)
|
82
|
+
|
83
|
+
at android.view.ViewRootImpl$TraversalRunnable.run(ViewRootImpl.java:5779)
|
84
|
+
|
85
|
+
at android.view.Choreographer$CallbackRecord.run(Choreographer.java:767)
|
86
|
+
|
87
|
+
at android.view.Choreographer.doCallbacks(Choreographer.java:580)
|
88
|
+
|
89
|
+
at android.view.Choreographer.doFrame(Choreographer.java:550)
|
90
|
+
|
91
|
+
at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:753)
|
92
|
+
|
93
|
+
at android.os.Handler.handleCallback(Handler.java:739)
|
94
|
+
|
95
|
+
at android.os.Handler.dispatchMessage(Handler.java:95)
|
96
|
+
|
97
|
+
at android.os.Looper.loop(Looper.java:135)
|
98
|
+
|
99
|
+
at android.app.ActivityThread.main(ActivityThread.java:5221)
|
100
|
+
|
101
|
+
at java.lang.reflect.Method.invoke(Native Method)
|
102
|
+
|
103
|
+
at java.lang.reflect.Method.invoke(Method.java:372)
|
104
|
+
|
105
|
+
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:899)
|
106
|
+
|
107
|
+
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:694)
|
108
|
+
|
109
|
+
|
16
110
|
|
17
111
|
```
|
18
112
|
|
3
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -26,98 +26,166 @@
|
|
26
26
|
|
27
27
|
|
28
28
|
|
29
|
+
|
30
|
+
|
29
31
|
import android.app.Activity;
|
30
32
|
|
33
|
+
|
34
|
+
|
31
35
|
import android.app.ListActivity;
|
32
36
|
|
37
|
+
|
38
|
+
|
33
39
|
import android.content.Context;
|
34
40
|
|
41
|
+
|
42
|
+
|
35
43
|
import android.content.Intent;
|
36
44
|
|
45
|
+
|
46
|
+
|
37
47
|
import android.database.Cursor;
|
38
48
|
|
49
|
+
|
50
|
+
|
39
51
|
import android.database.sqlite.SQLiteDatabase;
|
40
52
|
|
53
|
+
|
54
|
+
|
41
55
|
import android.database.sqlite.SQLiteException;
|
42
56
|
|
57
|
+
|
58
|
+
|
43
59
|
import android.database.sqlite.SQLiteOpenHelper;
|
44
60
|
|
61
|
+
|
62
|
+
|
45
63
|
import android.os.Bundle;
|
46
64
|
|
65
|
+
|
66
|
+
|
47
67
|
import android.provider.ContactsContract;
|
48
68
|
|
69
|
+
|
70
|
+
|
49
71
|
import android.util.Log;
|
50
72
|
|
73
|
+
|
74
|
+
|
51
75
|
import android.view.LayoutInflater;
|
52
76
|
|
77
|
+
|
78
|
+
|
53
79
|
import android.view.View;
|
54
80
|
|
81
|
+
|
82
|
+
|
55
83
|
import android.view.ViewGroup;
|
56
84
|
|
85
|
+
|
86
|
+
|
57
87
|
import android.widget.AdapterView;
|
58
88
|
|
89
|
+
|
90
|
+
|
59
91
|
import android.widget.ArrayAdapter;
|
60
92
|
|
93
|
+
|
94
|
+
|
61
95
|
import android.widget.BaseAdapter;
|
62
96
|
|
97
|
+
|
98
|
+
|
63
99
|
import android.widget.Button;
|
64
100
|
|
101
|
+
|
102
|
+
|
65
103
|
import android.widget.ListView;
|
66
104
|
|
105
|
+
|
106
|
+
|
67
107
|
import android.widget.TextView;
|
68
108
|
|
109
|
+
|
110
|
+
|
69
111
|
import android.widget.Toast;
|
70
112
|
|
71
113
|
|
72
114
|
|
115
|
+
|
116
|
+
|
73
117
|
import com.example.innovation.f_featnote.SubOpenHelper;
|
74
118
|
|
119
|
+
|
120
|
+
|
75
121
|
import com.example.innovation.f_featnote.MainActivity;
|
76
122
|
|
77
123
|
|
78
124
|
|
125
|
+
|
126
|
+
|
79
127
|
import java.util.ArrayList;
|
80
128
|
|
129
|
+
|
130
|
+
|
81
131
|
import java.util.Arrays;
|
82
132
|
|
133
|
+
|
134
|
+
|
83
135
|
import java.util.List;
|
84
136
|
|
85
137
|
|
86
138
|
|
87
|
-
/**
|
88
|
-
|
89
|
-
* Created by Innovation on 2017/01/26.
|
90
|
-
|
91
|
-
*/
|
92
|
-
|
93
139
|
|
94
140
|
|
95
141
|
public class SqlLoad extends Activity {
|
96
142
|
|
143
|
+
|
144
|
+
|
97
145
|
ListView lv;
|
98
146
|
|
147
|
+
|
148
|
+
|
99
149
|
static String[][] list;
|
100
150
|
|
151
|
+
|
152
|
+
|
101
153
|
static String[] Did = new String[2];
|
102
154
|
|
155
|
+
|
156
|
+
|
103
157
|
static long id_;
|
104
158
|
|
159
|
+
|
160
|
+
|
105
161
|
static boolean[] flg;
|
106
162
|
|
163
|
+
|
164
|
+
|
107
165
|
static String[] Data;
|
108
166
|
|
167
|
+
|
168
|
+
|
109
169
|
private final int WC = ViewGroup.LayoutParams.WRAP_CONTENT;
|
110
170
|
|
111
171
|
|
112
172
|
|
173
|
+
|
174
|
+
|
113
175
|
@Override
|
114
176
|
|
115
177
|
protected void onCreate(Bundle savedInstanceState) {
|
116
178
|
|
179
|
+
|
180
|
+
|
117
181
|
super.onCreate(savedInstanceState);
|
118
182
|
|
183
|
+
|
184
|
+
|
119
185
|
setContentView(R.layout.sql_load);
|
120
186
|
|
187
|
+
|
188
|
+
|
121
189
|
// final boolean[] flg = new boolean[1];
|
122
190
|
|
123
191
|
|
@@ -128,6 +196,8 @@
|
|
128
196
|
|
129
197
|
|
130
198
|
|
199
|
+
|
200
|
+
|
131
201
|
Main();
|
132
202
|
|
133
203
|
}
|
@@ -142,44 +212,78 @@
|
|
142
212
|
|
143
213
|
// lv = new ListView(this);
|
144
214
|
|
215
|
+
|
216
|
+
|
145
217
|
// ArrayList<String> Data = new ArrayList<>(Arrays.asList(SQLDataGet()));
|
146
218
|
|
219
|
+
|
220
|
+
|
147
221
|
lv = (ListView)findViewById(R.id.sql_load_main);
|
148
222
|
|
223
|
+
|
224
|
+
|
149
|
-
ArrayAdapter<String> adapter = new ArrayAdapter<>(this,
|
225
|
+
ArrayAdapter<String> adapter = new ArrayAdapter<>(this,
|
226
|
+
|
227
|
+
android.R.layout.simple_expandable_list_item_1, Data);
|
228
|
+
|
229
|
+
|
150
230
|
|
151
231
|
lv.setAdapter(adapter);//リスト表示
|
152
232
|
|
233
|
+
|
234
|
+
|
153
235
|
// setContentView(lv,new ViewGroup.LayoutParams(WC,WC));
|
154
236
|
|
155
237
|
|
156
238
|
|
239
|
+
|
240
|
+
|
157
241
|
lv.setOnItemClickListener(new AdapterView.OnItemClickListener(){
|
158
242
|
|
159
243
|
@Override
|
160
244
|
|
161
245
|
public void onItemClick(AdapterView<?> parent,View view,int position,long id){
|
162
246
|
|
247
|
+
|
248
|
+
|
163
249
|
// ListView listView = (ListView) parent;
|
164
250
|
|
251
|
+
|
252
|
+
|
165
253
|
// String item = (String)listView.getItemAtPosition(position);
|
166
254
|
|
255
|
+
|
256
|
+
|
167
257
|
Log.d("id",""+id);
|
168
258
|
|
259
|
+
|
260
|
+
|
169
261
|
id_ = id;
|
170
262
|
|
171
263
|
SQLDContentGet();
|
172
264
|
|
265
|
+
|
266
|
+
|
173
267
|
SQLDataSet();
|
174
268
|
|
269
|
+
|
270
|
+
|
175
271
|
finish();
|
176
272
|
|
273
|
+
|
274
|
+
|
177
275
|
// Toast.makeText(getApplicationContext(),item + "clicked",Toast.LENGTH_LONG).show();
|
178
276
|
|
277
|
+
|
278
|
+
|
179
279
|
}
|
180
280
|
|
281
|
+
|
282
|
+
|
181
283
|
});
|
182
284
|
|
285
|
+
|
286
|
+
|
183
287
|
}
|
184
288
|
|
185
289
|
|
@@ -194,52 +298,96 @@
|
|
194
298
|
|
195
299
|
public String[] SQLDataGet(){
|
196
300
|
|
301
|
+
|
302
|
+
|
197
303
|
MainActivity main = new MainActivity();
|
198
304
|
|
305
|
+
|
306
|
+
|
199
307
|
Context con = this;
|
200
308
|
|
309
|
+
|
310
|
+
|
201
311
|
List ls = null;
|
202
312
|
|
313
|
+
|
314
|
+
|
203
315
|
SQLiteDatabase sdb = main.SQLopen(con.getApplicationContext());//MainActivity参照
|
204
316
|
|
317
|
+
|
318
|
+
|
205
319
|
final String[] columns = new String[]{"title","content","date"};//列名
|
206
320
|
|
321
|
+
|
322
|
+
|
207
323
|
String where = null;//条件
|
208
324
|
|
325
|
+
|
326
|
+
|
209
327
|
String[] Args = new String[]{""};//?の置き換え
|
210
328
|
|
329
|
+
|
330
|
+
|
211
331
|
Cursor c = sdb.query("MemoContents", columns,where, null, null, null, null);
|
212
332
|
|
333
|
+
|
334
|
+
|
213
335
|
int startPostion = c.getPosition();
|
214
336
|
|
337
|
+
|
338
|
+
|
215
339
|
c.moveToFirst();
|
216
340
|
|
341
|
+
|
342
|
+
|
217
343
|
list = new String[c.getCount()][columns.length];
|
218
344
|
|
345
|
+
|
346
|
+
|
219
347
|
String[] Dlist = new String[c.getCount()];
|
220
348
|
|
349
|
+
|
350
|
+
|
221
351
|
for (int i = 0; i< list[0].length-1; i++){
|
222
352
|
|
353
|
+
|
354
|
+
|
223
355
|
for (int j = 0; j < list[1].length; j++){
|
224
356
|
|
357
|
+
|
358
|
+
|
225
359
|
list[i][j] = c.getString(j);
|
226
360
|
|
361
|
+
|
362
|
+
|
227
363
|
Log.d(i+"-"+j,list[i][j]);//デバッグ
|
228
364
|
|
365
|
+
|
366
|
+
|
229
367
|
Dlist[i] = list[i][0];
|
230
368
|
|
369
|
+
|
370
|
+
|
231
371
|
}
|
232
372
|
|
373
|
+
|
374
|
+
|
233
375
|
c.moveToNext();
|
234
376
|
|
377
|
+
|
378
|
+
|
235
379
|
}
|
236
380
|
|
381
|
+
|
382
|
+
|
237
383
|
c.moveToPosition(startPostion);
|
238
384
|
|
239
385
|
|
240
386
|
|
241
387
|
// finish();
|
242
388
|
|
389
|
+
|
390
|
+
|
243
391
|
return Dlist;
|
244
392
|
|
245
393
|
}
|
@@ -248,38 +396,72 @@
|
|
248
396
|
|
249
397
|
public void SQLDContentGet(){
|
250
398
|
|
399
|
+
|
400
|
+
|
251
401
|
Did[0] = list[(int)id_][0];
|
252
402
|
|
403
|
+
|
404
|
+
|
253
405
|
Did[1] = list[(int)id_][1];
|
254
406
|
|
407
|
+
|
408
|
+
|
255
409
|
}
|
256
410
|
|
257
411
|
|
258
412
|
|
259
413
|
public void SQLDataSet(){
|
260
414
|
|
415
|
+
|
416
|
+
|
261
417
|
Intent data = new Intent();
|
262
418
|
|
419
|
+
|
420
|
+
|
263
421
|
Bundle bundle = new Bundle();
|
264
422
|
|
423
|
+
|
424
|
+
|
265
425
|
data.putExtra("key.data",Did);
|
266
426
|
|
427
|
+
|
428
|
+
|
267
429
|
data.putExtras(bundle);
|
268
430
|
|
431
|
+
|
432
|
+
|
433
|
+
|
434
|
+
|
269
435
|
setResult(RESULT_OK,data);
|
270
436
|
|
437
|
+
|
438
|
+
|
271
439
|
finish();
|
272
440
|
|
441
|
+
|
442
|
+
|
273
443
|
}
|
274
444
|
|
275
445
|
|
276
446
|
|
277
447
|
@Override
|
278
448
|
|
449
|
+
|
450
|
+
|
279
451
|
public void finish() {
|
280
452
|
|
453
|
+
|
454
|
+
|
281
455
|
super.finish();
|
282
456
|
|
457
|
+
|
458
|
+
|
283
|
-
}
|
459
|
+
}
|
460
|
+
|
461
|
+
|
462
|
+
|
284
|
-
|
463
|
+
}
|
464
|
+
|
465
|
+
|
466
|
+
|
285
|
-
|
467
|
+
```
|
2
微修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -28,136 +28,84 @@
|
|
28
28
|
|
29
29
|
import android.app.Activity;
|
30
30
|
|
31
|
-
|
32
|
-
|
33
31
|
import android.app.ListActivity;
|
34
32
|
|
35
|
-
|
36
|
-
|
37
33
|
import android.content.Context;
|
38
34
|
|
39
|
-
|
40
|
-
|
41
35
|
import android.content.Intent;
|
42
36
|
|
43
|
-
|
44
|
-
|
45
37
|
import android.database.Cursor;
|
46
38
|
|
47
|
-
|
48
|
-
|
49
39
|
import android.database.sqlite.SQLiteDatabase;
|
50
40
|
|
51
|
-
|
52
|
-
|
53
41
|
import android.database.sqlite.SQLiteException;
|
54
42
|
|
55
|
-
|
56
|
-
|
57
43
|
import android.database.sqlite.SQLiteOpenHelper;
|
58
44
|
|
59
|
-
|
60
|
-
|
61
45
|
import android.os.Bundle;
|
62
46
|
|
63
|
-
|
64
|
-
|
65
47
|
import android.provider.ContactsContract;
|
66
48
|
|
67
|
-
|
68
|
-
|
69
49
|
import android.util.Log;
|
70
50
|
|
71
|
-
|
72
|
-
|
73
51
|
import android.view.LayoutInflater;
|
74
52
|
|
75
|
-
|
76
|
-
|
77
53
|
import android.view.View;
|
78
54
|
|
79
|
-
|
80
|
-
|
81
55
|
import android.view.ViewGroup;
|
82
56
|
|
83
|
-
|
84
|
-
|
85
57
|
import android.widget.AdapterView;
|
86
58
|
|
87
|
-
|
88
|
-
|
89
59
|
import android.widget.ArrayAdapter;
|
90
60
|
|
91
|
-
|
92
|
-
|
93
61
|
import android.widget.BaseAdapter;
|
94
62
|
|
95
|
-
|
96
|
-
|
97
63
|
import android.widget.Button;
|
98
64
|
|
99
|
-
|
100
|
-
|
101
65
|
import android.widget.ListView;
|
102
66
|
|
103
|
-
|
104
|
-
|
105
67
|
import android.widget.TextView;
|
106
68
|
|
107
|
-
|
108
|
-
|
109
69
|
import android.widget.Toast;
|
110
70
|
|
111
71
|
|
112
72
|
|
113
73
|
import com.example.innovation.f_featnote.SubOpenHelper;
|
114
74
|
|
115
|
-
|
116
|
-
|
117
75
|
import com.example.innovation.f_featnote.MainActivity;
|
118
76
|
|
119
77
|
|
120
78
|
|
121
79
|
import java.util.ArrayList;
|
122
80
|
|
123
|
-
|
124
|
-
|
125
81
|
import java.util.Arrays;
|
126
82
|
|
127
|
-
|
128
|
-
|
129
83
|
import java.util.List;
|
130
84
|
|
131
85
|
|
132
86
|
|
87
|
+
/**
|
88
|
+
|
89
|
+
* Created by Innovation on 2017/01/26.
|
90
|
+
|
91
|
+
*/
|
92
|
+
|
93
|
+
|
94
|
+
|
133
95
|
public class SqlLoad extends Activity {
|
134
96
|
|
135
|
-
|
136
|
-
|
137
97
|
ListView lv;
|
138
98
|
|
139
|
-
|
140
|
-
|
141
|
-
static String[][] list;
|
99
|
+
static String[][] list;
|
142
|
-
|
143
|
-
|
144
100
|
|
145
101
|
static String[] Did = new String[2];
|
146
102
|
|
147
|
-
|
148
|
-
|
149
103
|
static long id_;
|
150
104
|
|
151
|
-
|
152
|
-
|
153
105
|
static boolean[] flg;
|
154
106
|
|
155
|
-
|
156
|
-
|
157
107
|
static String[] Data;
|
158
108
|
|
159
|
-
|
160
|
-
|
161
109
|
private final int WC = ViewGroup.LayoutParams.WRAP_CONTENT;
|
162
110
|
|
163
111
|
|
@@ -166,17 +114,11 @@
|
|
166
114
|
|
167
115
|
protected void onCreate(Bundle savedInstanceState) {
|
168
116
|
|
169
|
-
|
170
|
-
|
171
117
|
super.onCreate(savedInstanceState);
|
172
118
|
|
173
|
-
|
174
|
-
|
175
119
|
setContentView(R.layout.sql_load);
|
176
120
|
|
177
|
-
|
178
|
-
|
179
|
-
// final boolean[] flg = new boolean[1];
|
121
|
+
// final boolean[] flg = new boolean[1];
|
180
122
|
|
181
123
|
|
182
124
|
|
@@ -198,82 +140,42 @@
|
|
198
140
|
|
199
141
|
Data = SQLDataGet();
|
200
142
|
|
201
|
-
|
202
|
-
|
203
143
|
// lv = new ListView(this);
|
204
144
|
|
205
|
-
|
206
|
-
|
207
145
|
// ArrayList<String> Data = new ArrayList<>(Arrays.asList(SQLDataGet()));
|
208
146
|
|
209
|
-
|
210
|
-
|
211
147
|
lv = (ListView)findViewById(R.id.sql_load_main);
|
212
148
|
|
213
|
-
|
214
|
-
|
215
|
-
ArrayAdapter<String> adapter = new ArrayAdapter<>(this,
|
149
|
+
ArrayAdapter<String> adapter = new ArrayAdapter<>(this, android.R.layout.simple_expandable_list_item_1, Data);
|
216
|
-
|
217
|
-
|
218
|
-
|
219
|
-
android.R.layout.simple_expandable_list_item_1, Data);
|
220
|
-
|
221
|
-
|
222
150
|
|
223
151
|
lv.setAdapter(adapter);//リスト表示
|
224
152
|
|
225
|
-
|
226
|
-
|
227
153
|
// setContentView(lv,new ViewGroup.LayoutParams(WC,WC));
|
228
154
|
|
229
155
|
|
230
156
|
|
231
|
-
|
232
|
-
|
233
157
|
lv.setOnItemClickListener(new AdapterView.OnItemClickListener(){
|
234
158
|
|
235
|
-
|
236
|
-
|
237
159
|
@Override
|
238
160
|
|
239
|
-
|
240
|
-
|
241
161
|
public void onItemClick(AdapterView<?> parent,View view,int position,long id){
|
242
162
|
|
243
|
-
|
244
|
-
|
245
163
|
// ListView listView = (ListView) parent;
|
246
164
|
|
247
|
-
|
248
|
-
|
249
165
|
// String item = (String)listView.getItemAtPosition(position);
|
250
166
|
|
251
|
-
|
252
|
-
|
253
167
|
Log.d("id",""+id);
|
254
168
|
|
255
|
-
|
256
|
-
|
257
169
|
id_ = id;
|
258
170
|
|
259
|
-
|
260
|
-
|
261
171
|
SQLDContentGet();
|
262
172
|
|
263
|
-
|
264
|
-
|
265
173
|
SQLDataSet();
|
266
174
|
|
267
|
-
|
268
|
-
|
269
175
|
finish();
|
270
176
|
|
271
|
-
|
272
|
-
|
273
177
|
// Toast.makeText(getApplicationContext(),item + "clicked",Toast.LENGTH_LONG).show();
|
274
178
|
|
275
|
-
|
276
|
-
|
277
179
|
}
|
278
180
|
|
279
181
|
});
|
@@ -292,170 +194,92 @@
|
|
292
194
|
|
293
195
|
public String[] SQLDataGet(){
|
294
196
|
|
295
|
-
|
296
|
-
|
297
197
|
MainActivity main = new MainActivity();
|
298
198
|
|
299
|
-
|
300
|
-
|
301
199
|
Context con = this;
|
302
200
|
|
303
|
-
|
304
|
-
|
305
201
|
List ls = null;
|
306
202
|
|
307
|
-
|
308
|
-
|
309
203
|
SQLiteDatabase sdb = main.SQLopen(con.getApplicationContext());//MainActivity参照
|
310
204
|
|
311
|
-
|
312
|
-
|
313
205
|
final String[] columns = new String[]{"title","content","date"};//列名
|
314
206
|
|
315
|
-
|
316
|
-
|
317
207
|
String where = null;//条件
|
318
208
|
|
319
|
-
|
320
|
-
|
321
209
|
String[] Args = new String[]{""};//?の置き換え
|
322
210
|
|
323
|
-
|
324
|
-
|
325
211
|
Cursor c = sdb.query("MemoContents", columns,where, null, null, null, null);
|
326
212
|
|
327
|
-
|
328
|
-
|
329
213
|
int startPostion = c.getPosition();
|
330
214
|
|
331
|
-
|
332
|
-
|
333
215
|
c.moveToFirst();
|
334
216
|
|
335
|
-
|
336
|
-
|
337
217
|
list = new String[c.getCount()][columns.length];
|
338
218
|
|
339
|
-
|
340
|
-
|
341
219
|
String[] Dlist = new String[c.getCount()];
|
342
220
|
|
343
|
-
|
344
|
-
|
345
221
|
for (int i = 0; i< list[0].length-1; i++){
|
346
222
|
|
347
|
-
|
348
|
-
|
349
223
|
for (int j = 0; j < list[1].length; j++){
|
350
224
|
|
351
|
-
|
352
|
-
|
353
225
|
list[i][j] = c.getString(j);
|
354
226
|
|
355
|
-
|
356
|
-
|
357
227
|
Log.d(i+"-"+j,list[i][j]);//デバッグ
|
358
228
|
|
359
|
-
|
360
|
-
|
361
229
|
Dlist[i] = list[i][0];
|
362
230
|
|
363
|
-
|
364
|
-
|
365
231
|
}
|
366
232
|
|
367
|
-
|
368
|
-
|
369
233
|
c.moveToNext();
|
370
234
|
|
371
|
-
|
372
|
-
|
373
235
|
}
|
374
236
|
|
375
|
-
|
376
|
-
|
377
237
|
c.moveToPosition(startPostion);
|
378
238
|
|
379
239
|
|
380
240
|
|
381
241
|
// finish();
|
382
242
|
|
383
|
-
|
384
|
-
|
385
243
|
return Dlist;
|
386
244
|
|
387
|
-
|
388
|
-
|
389
245
|
}
|
390
246
|
|
391
247
|
|
392
248
|
|
393
249
|
public void SQLDContentGet(){
|
394
250
|
|
395
|
-
|
396
|
-
|
397
251
|
Did[0] = list[(int)id_][0];
|
398
252
|
|
399
|
-
|
400
|
-
|
401
253
|
Did[1] = list[(int)id_][1];
|
402
254
|
|
403
|
-
|
404
|
-
|
405
255
|
}
|
406
256
|
|
407
257
|
|
408
258
|
|
409
259
|
public void SQLDataSet(){
|
410
260
|
|
411
|
-
|
412
|
-
|
413
261
|
Intent data = new Intent();
|
414
262
|
|
415
|
-
|
416
|
-
|
417
263
|
Bundle bundle = new Bundle();
|
418
264
|
|
419
|
-
|
420
|
-
|
421
265
|
data.putExtra("key.data",Did);
|
422
266
|
|
423
|
-
|
424
|
-
|
425
267
|
data.putExtras(bundle);
|
426
268
|
|
427
|
-
|
428
|
-
|
429
269
|
setResult(RESULT_OK,data);
|
430
270
|
|
431
|
-
|
432
|
-
|
433
271
|
finish();
|
434
272
|
|
435
|
-
|
436
|
-
|
437
273
|
}
|
438
274
|
|
439
275
|
|
440
276
|
|
441
277
|
@Override
|
442
278
|
|
443
|
-
|
444
|
-
|
445
279
|
public void finish() {
|
446
280
|
|
447
|
-
|
448
|
-
|
449
281
|
super.finish();
|
450
282
|
|
451
|
-
|
452
|
-
|
453
|
-
}
|
283
|
+
}
|
454
|
-
|
455
|
-
|
456
|
-
|
457
|
-
|
284
|
+
|
458
|
-
|
459
|
-
|
460
|
-
|
461
|
-
```
|
285
|
+
}```
|
1
すみません 修正しました
test
CHANGED
File without changes
|
test
CHANGED
@@ -18,7 +18,9 @@
|
|
18
18
|
|
19
19
|
|
20
20
|
|
21
|
-
###
|
21
|
+
###java
|
22
|
+
|
23
|
+
```
|
22
24
|
|
23
25
|
package com.example.innovation.f_featnote;
|
24
26
|
|