Creating json objects from sqlite database

Question

I need to create JSON OBJECT from sqlite database. And further I want to store that JSON OBJECT in my server. And I want to convert an entire table in my sqlite database to JSON object so that my data doesn't occupy much space in my server.Is this possible?? If so, can someone help me by providing proper resources for doing this?

Srikanth Roopa · Accepted Answer · 2013-05-30 10:18:39Z

4

Create JSON OBJECT from sqlite database-I've tried something like this.What do u mean by converting entire table in my sqlite database to Json object???

JSONObject jsonObject = new JSONObject();

ArrayList<DrugDetails> drugDetails = DataInterface
            .getSelectedDrugDetails();//this should be ur db query which returns the arraylist                          
    if (drugDetails != null && drugDetails.size() > 0) {
        JSONArray array = new JSONArray();
        for (DrugDetails selectedDrugDetails : drugDetails) {
            JSONObject json = new JSONObject();
            json.put(APPOINTMENT_ID, ""+"selectedDrugDetails.getAppoinmentID()");
            json.put(DOCUMENT_ID, ""+selectedDrugDetails.getId());
            array.put(json);
        }
        jsonObject.put(COLLATERAL_LIST, array);
    }

answered May 30, 2013 at 10:18

Srikanth Roopa

1,7902 gold badges13 silver badges19 bronze badges

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

1 Comment

gamma Over a year ago

I meant all the rows in a table.

FabiF · Accepted Answer · 2013-05-30 10:19:58Z

1

JSON "object" is no more than a String so you can store them in a DB as a String.

Nevertheless I had never seen this and I don't think it's a good practice. If you are looking for a simple and efficient JSON parser/reader, look at Jackson.

Maybe I misunderstood you question.

answered May 30, 2013 at 10:19

FabiF

2,8062 gold badges20 silver badges27 bronze badges

3 Comments

shemsu Over a year ago

Or GSON. A better choice IMHO. You are right, it's not a good practice. But so much efficient.

gamma Over a year ago

can u tell me how to read and convert all the rows in a table of sqlite to json object??

FabiF Over a year ago

For Jackson, you need to write json models, fill them and the framework provides method to build the JSON string. If you want use Jackson, start with this. Else you can try with GSON as suggested by Shemsu-Hor or build you own JSON reader.

Collectives™ on Stack Overflow

Creating json objects from sqlite database

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related