JSON complex data processing JSON tree structure data to Java objects and stored in the database

Cascade data display is often encountered in website development, such as the pop-up interface for selecting provinces and counties when selecting cities. Many front-end producers are used to obtaining provincial, city and county data from JSON rather than from the database. When a city in a province, city or county is selected, the code of the selected city needs to be stored in the database. Therefore, we need a function that can import all the structures of JSON data (generally stored in JavaScript scripts) into the database.

JSON is characterized by supporting hierarchy and objects represented by arrays. The following example describes how to save JSON provincial, municipal and county data to the database. The implementation principle is very simple. It is to use JSON's Java toolkit API to recursively convert the hierarchical JSON object array into a Java object array, and then save it to the database.

The implementation steps are:

（1） First define a jsonitem entity class:

（2） Define a tool class, read the JSON data file in the tool class, and make recursive calls:

Sample data (partial):

The above is the implementation of JSON tree structure data conversion to Java objects and stored in the database for JSON complex data processing