How to split the data in json file using java?

Question

I have a json file that contains lots of field which i want to seperate so that i can use it as each different field.Basically i want to split them and store them as each individual field so that i can use that file with the mysql.

Answer 1

It looks like that this are JSONObjects line by line (no arrays). Read the file line by line and create a JSONObject with that line.

BufferedReader br = new BufferedReader(new FileReader(file));
String line;
while ((line = br.readLine()) != null) {
  JSONObject json = new JSONObject(line);
  //json.getString("Slaves");
  //json.getStrng("Job Reader");

//and so on..

//if you want to get all avilable keys.. use
    Iterator<?> keys = json.keys();

    while( keys.hasNext() ){
        String key = (String)keys.next();
        if( json.get(key) instanceof JSONObject ){
            //key = the key and json.get(key) the value.
        }
    }
}
br.close();