How to read JSON String in Spring data and write to a database MySql

If you have file wit JSON type data in it and have in Back-End three classes which should be filled with Json Data so I suggest the following:

1. use Gson library: https://github.com/google/gson
2. List item
3. Create DTO classs (consisting all three classes)

4. With file read get data from file to String: String fileString = new String(Files.readAllBytes(Paths.get("manifest.mf")), StandardCharsets.UTF_8);

5. Then combine Gson library, DTO class and this line: Data data = new Gson().fromJson(fileString, Data.class);

Now you will have DTO object filled with data

You need to use the RestTemplate in Spring.

The steps are

1. If you are too lazy to create the classes that will be mapped to your json object, then you can use this website http://pojo.sodhanalibrary.com/ it will create it for you. Lets assume that the class created is Page.class

2. Create a Repository class like

   import org.springframework.web.client.RestTemplate;
   
   @Repository
   public class OfficeRepository{
   
     public Page getSomething() {
       RestTemplate restTemplate = new RestTemplate();
       Page page = restTemplate.getForObject("http://your-url-goes-here", Page.class);
       return page;
     }
   }
   

This will return your JSON contents into the Page object created.

This was the hard part. The easy part is to save it to the DB. Please use this guide by spring https://spring.io/blog/2011/02/10/getting-started-with-spring-data-jpa/ in order to save it and if you have any questions feel free to ask.