質問編集履歴
2
誤字
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -164,14 +164,16 @@
|
|
|
164
164
|
this,
|
|
165
165
|
android.R.layout.simple_list_item_1
|
|
166
166
|
);
|
|
167
|
+
|
|
168
|
+
if(cursor.moveToFirst()){
|
|
169
|
+
do{
|
|
170
|
+
adapter.add(String.valueOf(cursor.getInt(0)) + ":" +cursor.getString(1));
|
|
167
|
-
|
|
171
|
+
}while(cursor.moveToNext());
|
|
168
|
-
adapter.add(String.valueOf(cursor.getInt(0)));
|
|
169
|
-
|
|
172
|
+
}
|
|
170
|
-
|
|
173
|
+
memolist.setAdapter(adapter);
|
|
171
|
-
//終了処理
|
|
172
|
-
|
|
174
|
+
cursor.close();
|
|
173
|
-
|
|
175
|
+
sdb.close();
|
|
174
|
-
|
|
176
|
+
|
|
175
177
|
}
|
|
176
178
|
@Override
|
|
177
179
|
public void onClick(View v) {
|
1
コードの変更
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -136,9 +136,17 @@
|
|
|
136
136
|
|
|
137
137
|
SQLiteDatabase sdb = MSSQLhelper.getReadableDatabase();
|
|
138
138
|
|
|
139
|
+
// DBから取得部分
|
|
139
|
-
|
|
140
|
+
Cursor cursor = sdb.query("Memo",
|
|
141
|
+
new String[]{"content","memo"},
|
|
142
|
+
null,
|
|
143
|
+
null,
|
|
144
|
+
null,
|
|
145
|
+
null,
|
|
146
|
+
"content ASC");
|
|
140
147
|
|
|
141
148
|
|
|
149
|
+
|
|
142
150
|
/*String[] columns = new String[]{"_content", "memo" };
|
|
143
151
|
|
|
144
152
|
String[] headers = new String[]{"content", "memo"};
|