python: Reading and Writing JSON to a File

®Geovin Du Dream Park™ / 2023-06-21 / 原文

    #import json
    jsondata = {
        'sqlserver': [
            {
                "server": "DESKTOP-NQK85G5\GEOVIN2008",
                "useid": "sa",
                "password": "geovindu",
                "database": "Student"
            }
        ],
        'mysql':[
            {
                "server": "loacalhost",
                "useid": "root",
                "password": "geovindu",
                "database": "Student"
            }
        ]
    }
    json_string = json.dumps(jsondata)
    print(json_string)
    # Using a JSON string
    with open('json_data.json', 'w') as outfile:
        outfile.write(json_string)

    # Directly from dictionary
    with open('json_data2.json', 'w') as outfile:
        json.dump(json_string, outfile)

    with open('json_data.json') as json_file:
        readdata = json.load(json_file)
        print(type(readdata))
        print(readdata['sqlserver'])

    dictionary = {
        "server": "DESKTOP-NQK85G5\GEOVIN2008",
        "useid": "sa",
        "password": "geovindu",
        "database": "Student"
    }
    with open("databaseconfig.json", "w") as outfile:
        json.dump(dictionary, outfile)

    with open('databaseconfig.json', 'r') as openfile:

        # Reading from json file
        json_object = json.load(openfile)

    print(json_object)
    print(type(json_object))

Serializes

JSON encoder and decoder