使用jar包：

mysql-connector-java-5.1.7-bin.jar
fastjson-1.2.53.jar

讀取文件：

代碼：

package degisn1;

import java.io.File;
import java.io.IOException;
import java.sql.DriverManager;

import org.apache.commons.io.FileUtils;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.ssm.po.Word;

/**
 * @ClassName: Test
 * @description: 用于讀取json數(shù)據(jù)，并將次數(shù)記錄在數(shù)據(jù)庫中。
 * @author: 
 * @Date: Apr 15, 2019 4:12:34 PM
 */

public class Test {

    public static JSONArray getJSONArray(String url) {
        // input存放json內(nèi)容
        String input = null;

        // 讀取json文件
        File myFile = new File(url);
        try {
            input = FileUtils.readFileToString(myFile, "UTF-8");
        } catch (IOException e) {
            e.printStackTrace();
        }

        // 將數(shù)組json轉(zhuǎn)換為JSON數(shù)組對象
        JSONArray jsonArray = JSON.parseArray(input);
    
        return jsonArray;
    }

    public static void main(String[] args) throws Exception {
        Connection con = null;
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/mvcAndMybatis?characterEncoding=utf-8";
        String user = "root";
        String password = "123456";
        PreparedStatement psql;
        
        try {
            Class.forName(driver);
            con = (Connection) DriverManager.getConnection(url, user, password);
            if (!con.isClosed())
                System.out.println("連接成功");

            // 得到json數(shù)據(jù)
            Word word = new Word();
            JSONArray jsonArray = getJSONArray("H:/json1.json");
            psql = (PreparedStatement) con.prepareStatement("insert into wordCount(word, times) values(?,?)");
            for (Object obj : jsonArray) {
                JSONObject jsonObject = (JSONObject) obj;
                psql.setString(1, jsonObject.getString("word"));
                psql.setInt(2, jsonObject.getInteger("times"));
                psql.executeUpdate();
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            con.close();
            System.out.println("執(zhí)行成功");
        }
    }
}

運行結(jié)果：