Mixing
I am getting only last row while loading data from sqlite to arraylist. How do I get all records?
0
I am trying to populate the sqlite data to recyclerview by adding the sqlite data to arraylist. I am not getting all records but only last row of the database table.
cursor = sqLiteHelper.getData("SELECT * FROM news");
while (cursor.moveToNext()) {
String image = cursor.getString(cursor.getColumnIndex("image"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String category = cursor.getString(cursor.getColumnIndex("category"));
mExampleList.add(new ExampleItem(image, title, category));
}
mExampleAdapter = new ExampleAdapter(MainActivity.this, mExampleList);
mRecyclerView.setAdapter(mExampleAdapter);
java
android asked Jan 2 at 14:27
sunil chaudharysunil chaudhary
1
add a comment |
0
I am trying to populate the sqlite data to recyclerview by adding the sqlite data to arraylist. I am not getting all records but only last row of the database table.
cursor = sqLiteHelper.getData("SELECT * FROM news");
while (cursor.moveToNext()) {
String image = cursor.getString(cursor.getColumnIndex("image"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String category = cursor.getString(cursor.getColumnIndex("category"));
mExampleList.add(new ExampleItem(image, title, category));
}
mExampleAdapter = new ExampleAdapter(MainActivity.this, mExampleList);
mRecyclerView.setAdapter(mExampleAdapter);
java
android asked Jan 2 at 14:27
sunil chaudharysunil chaudhary
1
I know that doesnt really help, but why not use some ORM, like room for example? Mapping sql to objects manually seems like alot of work and might be error prone
– estn
Jan 2 at 14:42
add a comment |
0
0
0
I am trying to populate the sqlite data to recyclerview by adding the sqlite data to arraylist. I am not getting all records but only last row of the database table.
cursor = sqLiteHelper.getData("SELECT * FROM news");
while (cursor.moveToNext()) {
String image = cursor.getString(cursor.getColumnIndex("image"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String category = cursor.getString(cursor.getColumnIndex("category"));
mExampleList.add(new ExampleItem(image, title, category));
}
mExampleAdapter = new ExampleAdapter(MainActivity.this, mExampleList);
mRecyclerView.setAdapter(mExampleAdapter);
java
android asked Jan 2 at 14:27
sunil chaudharysunil chaudhary
1
I am trying to populate the sqlite data to recyclerview by adding the sqlite data to arraylist. I am not getting all records but only last row of the database table.
cursor = sqLiteHelper.getData("SELECT * FROM news");
while (cursor.moveToNext()) {
String image = cursor.getString(cursor.getColumnIndex("image"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String category = cursor.getString(cursor.getColumnIndex("category"));
mExampleList.add(new ExampleItem(image, title, category));
}
mExampleAdapter = new ExampleAdapter(MainActivity.this, mExampleList);
mRecyclerView.setAdapter(mExampleAdapter);
java
android java
android asked Jan 2 at 14:27
sunil chaudharysunil chaudhary
1
asked Jan 2 at 14:27
sunil chaudharysunil chaudhary
1
asked Jan 2 at 14:27
sunil chaudharysunil chaudhary
1
asked Jan 2 at 14:27
sunil chaudharysunil chaudhary
1
asked Jan 2 at 14:27
sunil chaudharysunil chaudhary
1
1
I know that doesnt really help, but why not use some ORM, like room for example? Mapping sql to objects manually seems like alot of work and might be error prone
– estn
Jan 2 at 14:42
add a comment |
I know that doesnt really help, but why not use some ORM, like room for example? Mapping sql to objects manually seems like alot of work and might be error prone
– estn
Jan 2 at 14:42
I know that doesnt really help, but why not use some ORM, like room for example? Mapping sql to objects manually seems like alot of work and might be error prone
– estn
Jan 2 at 14:42
I know that doesnt really help, but why not use some ORM, like room for example? Mapping sql to objects manually seems like alot of work and might be error prone
– estn
Jan 2 at 14:42
add a comment |
2 Answers
2
active
oldest
votes
1
Did you try this?
// Move first to be sure
cursor.moveToFirst()
while(!cursor.isAfterLast()) { // Dont jump to the next before first iteration
String image = cursor.getString(cursor.getColumnIndex("image"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String category = cursor.getString(cursor.getColumnIndex("category"));
mExampleList.add(new ExampleItem(image, title, category));
// And then
cursor.moveToNext()
}
cursor.close()
How many records are in your storage? Because if there are 2 the first call to cursor.moveToNext() of the while might jump to the last.
edited Jan 3 at 4:15
Prince
1,2611030
answered Jan 2 at 14:35
Quentin KleinQuentin Klein
743622
There are three records. But only getting the last one. Didn't work same problem
– sunil chaudhary
Jan 2 at 14:48
Can you debug your code, add a breakpoint and check what is the result ofcursor.getCount()? Just before the loop
– Quentin Klein
Jan 2 at 14:53
add a comment |
-1
if (cursor.moveToFirst()) {
while (!cursor.isAfterLast()) {
String name = cursor.getString(cursor.getColumnIndex(countyname));
list.add(name);
cursor.moveToNext();
}
}
edited Jan 3 at 0:28
Paulo Scardine
40.4k892118
answered Jan 2 at 14:33
Hardik MehtaHardik Mehta
697
2
Do not add code only. Describe what you have done and why. Also indent your code properbly
– Jens
Jan 2 at 14:34
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54008097%2fi-am-getting-only-last-row-while-loading-data-from-sqlite-to-arraylist-how-do-i%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Did you try this?
// Move first to be sure
cursor.moveToFirst()
while(!cursor.isAfterLast()) { // Dont jump to the next before first iteration
String image = cursor.getString(cursor.getColumnIndex("image"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String category = cursor.getString(cursor.getColumnIndex("category"));
mExampleList.add(new ExampleItem(image, title, category));
// And then
cursor.moveToNext()
}
cursor.close()
How many records are in your storage? Because if there are 2 the first call to cursor.moveToNext() of the while might jump to the last.
edited Jan 3 at 4:15
Prince
1,2611030
answered Jan 2 at 14:35
Quentin KleinQuentin Klein
743622
There are three records. But only getting the last one. Didn't work same problem
– sunil chaudhary
Jan 2 at 14:48
Can you debug your code, add a breakpoint and check what is the result ofcursor.getCount()? Just before the loop
– Quentin Klein
Jan 2 at 14:53
add a comment |
1
Did you try this?
// Move first to be sure
cursor.moveToFirst()
while(!cursor.isAfterLast()) { // Dont jump to the next before first iteration
String image = cursor.getString(cursor.getColumnIndex("image"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String category = cursor.getString(cursor.getColumnIndex("category"));
mExampleList.add(new ExampleItem(image, title, category));
// And then
cursor.moveToNext()
}
cursor.close()
How many records are in your storage? Because if there are 2 the first call to cursor.moveToNext() of the while might jump to the last.
edited Jan 3 at 4:15
Prince
1,2611030
answered Jan 2 at 14:35
Quentin KleinQuentin Klein
743622
There are three records. But only getting the last one. Didn't work same problem
– sunil chaudhary
Jan 2 at 14:48
Can you debug your code, add a breakpoint and check what is the result ofcursor.getCount()? Just before the loop
– Quentin Klein
Jan 2 at 14:53
add a comment |
1
1
1
Did you try this?
// Move first to be sure
cursor.moveToFirst()
while(!cursor.isAfterLast()) { // Dont jump to the next before first iteration
String image = cursor.getString(cursor.getColumnIndex("image"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String category = cursor.getString(cursor.getColumnIndex("category"));
mExampleList.add(new ExampleItem(image, title, category));
// And then
cursor.moveToNext()
}
cursor.close()
How many records are in your storage? Because if there are 2 the first call to cursor.moveToNext() of the while might jump to the last.
edited Jan 3 at 4:15
Prince
1,2611030
answered Jan 2 at 14:35
Quentin KleinQuentin Klein
743622
Did you try this?
// Move first to be sure
cursor.moveToFirst()
while(!cursor.isAfterLast()) { // Dont jump to the next before first iteration
String image = cursor.getString(cursor.getColumnIndex("image"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String category = cursor.getString(cursor.getColumnIndex("category"));
mExampleList.add(new ExampleItem(image, title, category));
// And then
cursor.moveToNext()
}
cursor.close()
How many records are in your storage? Because if there are 2 the first call to cursor.moveToNext() of the while might jump to the last.
edited Jan 3 at 4:15
Prince
1,2611030
answered Jan 2 at 14:35
Quentin KleinQuentin Klein
743622
edited Jan 3 at 4:15
Prince
1,2611030
edited Jan 3 at 4:15
Prince
1,2611030
edited Jan 3 at 4:15
Prince
1,2611030
1,2611030
answered Jan 2 at 14:35
Quentin KleinQuentin Klein
743622
answered Jan 2 at 14:35
Quentin KleinQuentin Klein
743622
answered Jan 2 at 14:35
Quentin KleinQuentin Klein
743622
743622
There are three records. But only getting the last one. Didn't work same problem
– sunil chaudhary
Jan 2 at 14:48
Can you debug your code, add a breakpoint and check what is the result ofcursor.getCount()? Just before the loop
– Quentin Klein
Jan 2 at 14:53
add a comment |
There are three records. But only getting the last one. Didn't work same problem
– sunil chaudhary
Jan 2 at 14:48
Can you debug your code, add a breakpoint and check what is the result ofcursor.getCount()? Just before the loop
– Quentin Klein
Jan 2 at 14:53
There are three records. But only getting the last one. Didn't work same problem
– sunil chaudhary
Jan 2 at 14:48
There are three records. But only getting the last one. Didn't work same problem
– sunil chaudhary
Jan 2 at 14:48
Can you debug your code, add a breakpoint and check what is the result of
cursor.getCount() ? Just before the loop– Quentin Klein
Jan 2 at 14:53
Can you debug your code, add a breakpoint and check what is the result of
cursor.getCount() ? Just before the loop– Quentin Klein
Jan 2 at 14:53
add a comment |
-1
if (cursor.moveToFirst()) {
while (!cursor.isAfterLast()) {
String name = cursor.getString(cursor.getColumnIndex(countyname));
list.add(name);
cursor.moveToNext();
}
}
edited Jan 3 at 0:28
Paulo Scardine
40.4k892118
answered Jan 2 at 14:33
Hardik MehtaHardik Mehta
697
2
Do not add code only. Describe what you have done and why. Also indent your code properbly
– Jens
Jan 2 at 14:34
add a comment |
-1
if (cursor.moveToFirst()) {
while (!cursor.isAfterLast()) {
String name = cursor.getString(cursor.getColumnIndex(countyname));
list.add(name);
cursor.moveToNext();
}
}
edited Jan 3 at 0:28
Paulo Scardine
40.4k892118
answered Jan 2 at 14:33
Hardik MehtaHardik Mehta
697
2
Do not add code only. Describe what you have done and why. Also indent your code properbly
– Jens
Jan 2 at 14:34
add a comment |
-1
-1
-1
if (cursor.moveToFirst()) {
while (!cursor.isAfterLast()) {
String name = cursor.getString(cursor.getColumnIndex(countyname));
list.add(name);
cursor.moveToNext();
}
}
edited Jan 3 at 0:28
Paulo Scardine
40.4k892118
answered Jan 2 at 14:33
Hardik MehtaHardik Mehta
697
if (cursor.moveToFirst()) {
while (!cursor.isAfterLast()) {
String name = cursor.getString(cursor.getColumnIndex(countyname));
list.add(name);
cursor.moveToNext();
}
}
edited Jan 3 at 0:28
Paulo Scardine
40.4k892118
answered Jan 2 at 14:33
Hardik MehtaHardik Mehta
697
edited Jan 3 at 0:28
Paulo Scardine
40.4k892118
edited Jan 3 at 0:28
Paulo Scardine
40.4k892118
edited Jan 3 at 0:28
Paulo Scardine
40.4k892118
40.4k892118
answered Jan 2 at 14:33
Hardik MehtaHardik Mehta
697
answered Jan 2 at 14:33
Hardik MehtaHardik Mehta
697
answered Jan 2 at 14:33
Hardik MehtaHardik Mehta
697
697
2
Do not add code only. Describe what you have done and why. Also indent your code properbly
– Jens
Jan 2 at 14:34
add a comment |
2
Do not add code only. Describe what you have done and why. Also indent your code properbly
– Jens
Jan 2 at 14:34
2
2
Do not add code only. Describe what you have done and why. Also indent your code properbly
– Jens
Jan 2 at 14:34
Do not add code only. Describe what you have done and why. Also indent your code properbly
– Jens
Jan 2 at 14:34
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54008097%2fi-am-getting-only-last-row-while-loading-data-from-sqlite-to-arraylist-how-do-i%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I know that doesnt really help, but why not use some ORM, like room for example? Mapping sql to objects manually seems like alot of work and might be error prone
– estn
Jan 2 at 14:42