Create a JSON file by reading a mySQL table in java

Question

I want to select my data's table and store its content inside a JSON file. But my JSON file content only the last row of my table multiple time. Can you help me to identify where i'm wrong? Thank you...

Here is a part of my java code :

 JSONObject obj = new JSONObject();
 JSONArray array = new JSONArray();

 try {
    conn = DriverManager.getConnection(url, utilisateur, motDePasse);
    preparedStatement = conn.prepareStatement("SELECT idUser, emailUser, motPassUser FROM utilisateur;");
    result = preparedStatement.executeQuery("SELECT idUser, emailUser, motPassUser FROM utilisateur;");

    obj = new JSONObject();
    array = new JSONArray();

    while (result.next()) {
        obj.put("id", result.getInt("idUser"));
        obj.put("email", result.getString("emailUser"));
        obj.put("password", result.getString("motPassUser"));
        array.add(obj);
    }

    try {
        FileWriter file = new FileWriter("user.json");
        file.write(((JSONArray) array).toJSONString());
        file.flush();
        file.close();
    } catch (IOException e) {
        e.printStackTrace();
    }
} catch (SQLException e) {

} finally {
    if (result != null) {
        try {
            result.close();
        } catch (SQLException ignore) {
        }
    }
    if (preparedStatement != null) {
        try {
            preparedStatement.close();
        } catch (SQLException ignore) {
        }
    }
    if (conn != null) {
        try {
            conn.close();
        } catch (SQLException ignore) {
        }
    }
}

And this the output of my JSON file :

[{"id":3,"email":"[email protected]","password":"ludovic1992"},
{"id":3,"email":"[email protected]","password":"ludovic1992"},
{"id":3,"email":"[email protected]","password":"ludovic1992"}]

It contents only the last row of my table...

Shantaram Tupe · Accepted Answer · 2016-09-09 12:02:43Z

1

create JSON object inside while loop as

while (result.next()) {

obj = new JSONObject();

        obj.put("id", result.getInt("idUser"));

        obj.put("email", result.getString("emailUser"));

        obj.put("password", result.getString("motPassUser"));

        array.add(obj);
    }

answered Sep 9, 2016 at 12:02

Shantaram Tupe

1,6664 gold badges17 silver badges44 bronze badges

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

Comments

Naveen Ramawat · Accepted Answer · 2016-09-09 12:02:19Z

1

Put this line inside your while loop -

obj = new JSONObject();

answered Sep 9, 2016 at 12:02

Naveen Ramawat

1,4431 gold badge15 silver badges27 bronze badges

1 Comment

Naveen Ramawat Over a year ago

can you please accept it as answer if it is working.

Collectives™ on Stack Overflow

Create a JSON file by reading a mySQL table in java

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related