Retrieving data from Database into an ArrayList

Question

I am trying to store data into arraylist and retrieve it in another activity. I am able to get data from database but not able to retrieve it .I am getting the path name instead of the result i have posted my logcat below kindly give me any suggestion on how to get it done

DBhelper class:

public ArrayList<LocationHelper> getAlllocations()
{
    ArrayList<LocationHelper> array_list = new ArrayList<LocationHelper>();

    //hp = new HashMap();
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor c =  db.rawQuery( "select * from "+ TABLE_LOCATION, null );
    c.moveToFirst();

    while(c.isAfterLast() == false){
        LocationHelper locationHelper = new LocationHelper();
        locationHelper.setNum(c.getString(1));

        locationHelper.setPresent_lat(c.getString(4));
        Log.e("Database lat: ", locationHelper.getPresent_lat());

        locationHelper.setPresent_lon(c.getString(5));
        Log.e("Database lon: ", locationHelper.getPresent_lon());

        array_list.add(locationHelper);
        Log.e("Database Data: ", String.valueOf(array_list.get(i)));

        c.moveToNext();
        i++;
    }
    return array_list;
}

LocationHelper:

public class LocationHelper {
String num;

public String getNative_lat() {
    return native_lat;
}

public void setNative_lat(String native_lat) {
    this.native_lat = native_lat;
}

public String getNative_lon() {
    return native_lon;
}

public void setNative_lon(String native_lon) {
    this.native_lon = native_lon;
}

public String getPresent_lat() {
    return present_lat;
}

public void setPresent_lat(String present_lat) {
    this.present_lat = present_lat;
}

public String getPresent_lon() {
    return Present_lon;
}

public void setPresent_lon(String present_lon) {
    Present_lon = present_lon;
}

public String getNum() {
    return num;
}

public void setNum(String num) {
    this.num = num;
}

String native_lat;
String  native_lon;
String present_lat;
String Present_lon;
}

Logcat:

08-21 15:28:51.364  25317-25317/? E/dalvikvm﹕ >>>>>  
com.example.xxx.xxx[ userId:0 | appId:10309 ]
08-21 15:28:51.684  25317-25317/? E/Database lat:﹕ 9.08613
08-21 15:28:51.684  25317-25317/? E/Database lon:﹕ 76.4888
08-21 15:28:51.684  25317-25317/? E/Database Data:﹕ 
com.example.xxx.xxx.LocationHelper@4215d348
08-21 15:28:51.684  25317-25317/? E/Database lat:﹕ 9.08613
08-21 15:28:51.684  25317-25317/? E/Database lon:﹕ 76.9888
08-21 15:28:51.684  25317-25317/? E/Database Data:﹕ 
com.example.xxx.xxx.LocationHelper@4215d868
08-21 15:28:51.684  25317-25317/? E/Database lat:﹕ 9.58613
08-21 15:28:51.684  25317-25317/? E/Database lon:﹕ 76.4888
08-21 15:28:51.684  25317-25317/? E/Database Data:﹕  
com.example.xxx.xxx.LocationHelper@4215db50
08-21 15:28:51.684  25317-25317/? E/Database lat:﹕ 9.58613
08-21 15:28:51.684  25317-25317/? E/Database lon:﹕ 76.9888
08-21 15:28:51.684  25317-25317/? E/Database Data:﹕   
com.example.xxx.xxx.LocationHelper@4215de38

It is not a path. It's an object of ArrayList. You are getting lat and lon then what you want to do? — Sridhar
– Sridhar, Commented Aug 21, 2015 at 10:05
i Just want to know how to access the lat and lon from arraylist in another activity — Nikhil Kumar
– Nikhil Kumar, Commented Aug 21, 2015 at 10:10
I don't see you doing anything wrong nor can understand what you're trying to do. — JanithaR
– JanithaR, Commented Aug 21, 2015 at 10:11
why dont you just retrieve the ArrayList in the desired activity — M090009
– M090009, Commented Aug 21, 2015 at 10:12

Rajesh Jadav · Accepted Answer · 2015-08-21 10:33:51Z

1

Try

Log.e("Database Data: ", String.valueOf(array_list.get(i).getPresent_lat()));

or

Log.e("Database Data: ", String.valueOf(array_list.get(i).getPresent_lon()));

instead of

Log.e("Database Data: ", String.valueOf(array_list.get(i)));

You are trying to print arraylist object not values.

EDIT:

In first activity pass arraylist through Intent

intent.putExtra("array_list", array_list);

then in second activity get arraylist like this.

ArrayList<LocationHelper> myList = (ArrayList<LocationHelper>) getIntent().getSerializableExtra("array_list");

Hope this helps!

edited Aug 21, 2015 at 10:33

answered Aug 21, 2015 at 10:16

Rajesh Jadav

12.9k5 gold badges56 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nikhil Kumar Over a year ago

thank you rajeev its working for me but can you tell me how to access the same from diff activity

Pramod Gaikwad · Accepted Answer · 2015-08-21 10:23:52Z

1

As @gmetax said it the hashcode which is getting printed. Your ArrayList is getting populated exactly as you want. You need to pass that list to another activity using an Intent (for eg: intent.addExtras(list)) and iterate the list in another activity.

answered Aug 21, 2015 at 10:23

Pramod Gaikwad

1851 gold badge2 silver badges16 bronze badges

Comments

Sridhar · Accepted Answer · 2015-08-21 10:34:12Z

1

Try this in your Activity

ArrayList<LocationHelper> locatioHelper = new ArrayList<LocationHelper>();
LocationHelper locHelper = new LocationHelper();
DBHelper db = new DBHelper();
locationHelper=db.getAlllocations();
for(int i=0;i<locationHelper.size();i++)
{
  Log.i("latvalue",locHelper.get(i).getPresent_lat());
  Log.i("lonvalue",locHelper.get(i).getgetPresent_lon());
}

answered Aug 21, 2015 at 10:34

Sridhar

6681 gold badge11 silver badges22 bronze badges

Comments

gmetax · Accepted Answer · 2015-08-21 10:14:41Z

0

Your problem is that you haven't override the toString method, you are retrieving the content from db fine.

the default toString method from the object class returns

package.Class@Hashcode

add to your LocationHelper class that code

@Override
public String toString() {
    return "lat : " + getPresent_lat() + ", lon : " + getPresent_lon();
}

edited Aug 21, 2015 at 10:14

answered Aug 21, 2015 at 10:06

gmetax

3,9732 gold badges34 silver badges50 bronze badges

4 Comments

gmetax Over a year ago

go override to get what you want and you are gonna be ok

JanithaR Over a year ago

It's not what @Nikhil wants. His question is so vague.

Nikhil Kumar Over a year ago

normally arraylist.get(i) gives you what data is present in that array at that postion but in my case i am getting my file path instead of values that i saved into it. i think there is something wrong with my code but not able to find it

gmetax Over a year ago

YOU DON'T HAVE toString method on your class, so it returns package.Class@Hashcode as "string output" do you even read my answer? do you even try anything?

Collectives™ on Stack Overflow

Retrieving data from Database into an ArrayList

4 Answers 4

1 Comment

Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related