3.28每日学习

所花时间：1h
代码量：5行
博客量：1
了解的知识点：1.用读取文件的方法完成数据库部分

 

package org.example;
import org.json.JSONArray;
import org.json.JSONObject;

import java.io.FileReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Main {
    public static void main(String[] args) {
        try {
            // 读取 JSON 数据文件
            FileReader reader = new FileReader("D:\\软件工程\\dbjava\\src\\main\\java\\data2.json");
            StringBuilder jsonString = new StringBuilder();
            int character;
            while ((character = reader.read()) != -1) {
                jsonString.append((char) character);
            }
            reader.close();

            // 解析 JSON 数据
            JSONArray jsonArray = new JSONArray(jsonString.toString());

            // 连接数据库
            Class.forName("com.mysql.jdbc.Driver");
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/less-code?useUnicode=true&characterEncoding=UTF-8", "root", "123456");

            // 将数据存入数据库
            String sql = "INSERT INTO route (id, fromId, toId, dist) VALUES (?, ?, ?, ?)";
            PreparedStatement statement = connection.prepareStatement(sql);
            for (int i = 0; i < jsonArray.length(); i++) {
                JSONObject jsonObject = jsonArray.getJSONObject(i);
                statement.setInt(1, jsonObject.getInt("id"));
                statement.setString(2, jsonObject.getString("fromId"));
                statement.setString(3, jsonObject.getString("toId"));
                statement.setString(4, jsonObject.getString("dist"));
                statement.executeUpdate();
            }

            System.out.println("数据已成功存入数据库");

            // 关闭连接
            statement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}