How to add all row elements in database to JSON object

Question

I'm trying to retrieve all elements in database and display in webpage.But with my code it able to retrieve only one row element. Problem is, it retrieves all element but it adds the last row element to the object. I think all elements retrieved first are overwritten Because of that it displays last row element. Can anyone tell me how add all row elements to the JSON object. Please help me.

code :

            while(rs.next()){
                ImageFile.setName(rs.getString("imagename").trim());
                ImageFile.setDisc(rs.getString("imagedisc").trim());
                ImageFile.setImageid(rs.getInt("imageid"));
                ImageFile.setalbumid(rs.getInt("albumid"));

                byte imageData[] = rs.getBytes("imagethumb");
                String encoded = DatatypeConverter.printBase64Binary(imageData);
                ImageFile.setThumb(encoded);

                byte image1Data[] = rs.getBytes("imagethumb");
                String encoded1 = DatatypeConverter.printBase64Binary(image1Data);

                ImageFile.setFull(encoded1);
            }

The complete source code is in this question

Please help me........Thanks....

Subhrajyoti Majumder · Accepted Answer · 2013-02-09 07:59:20Z

1

Use a list Collection to keep all the row-values of db, like - List<ImageFileInfo> which denotes List containing of ImageFileInfo Objects . And then serialize the list to json String.

List<ImageFileInfo> imageFileList = new ArrayList<ImageFileInfo>();
while(rs.next()){
    ImageFileInfo info = new ImageFileInfo();
    info..setName(rs.getString("imagename").trim());
    ...
    imageFileList.add(info);
}

Json serialization -

Type typeOfList= new TypeToken<List<ImageFileInfo>>(){}.getType();
String s = gson.toJson(imageFileList , typeOfList);

answered Feb 9, 2013 at 7:59

Subhrajyoti Majumder

41.3k13 gold badges84 silver badges103 bronze badges

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

5 Comments

James Over a year ago

Is it ArrayList<ImageFileInfo> imageFileList = new ArrayList<ImageFileInfo>(); or List<ImageFileInfo> imageFileList = new ArrayList<ImageFileInfo>(); <- this was showing error. Tell me just confused Thanks...

James Over a year ago

Error is The type List is not generic; it cannot be parameterized with arguments <ImageFileInfo> if i remove arguments. Then tells to change it to ArrayList<ImageFileInfo> imageFileList = new ArrayList<ImageFileInfo>();

Subhrajyoti Majumder Over a year ago

Seems to be very funny :) because same syntax working here(List<ImageFileInfo> imageFileList = new ArrayList<ImageFileInfo>();) And you can use suggested way.

James Over a year ago

Sorry sir, Now the servlet producing the error

java.lang.NoClassDefFoundError: com/google/gson/Gson 	skypark.RetriveIm.doGet(RetriveIm.java:64) 	javax.servlet.http.HttpServlet.service(HttpServlet.java:621) 	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

What this means...

James Over a year ago

In firebug the response received from the server is {"success":true,"imageInfo":[]} is this means imageInfo is null. The image is not displaying. I'm struggling with this ....

Collectives™ on Stack Overflow

How to add all row elements in database to JSON object

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related