跨库插入数据

最新推荐文章于 2024-06-06 09:33:20 发布

小蚂蚁hjk

最新推荐文章于 2024-06-06 09:33:20 发布

阅读量497

点赞数 1

分类专栏： java

本文链接：https://blog.csdn.net/weixin_43167662/article/details/118959195

版权

java 专栏收录该内容

112 篇文章 3 订阅

订阅专栏

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数据，并将次数记录在数据库中。
 * @author: 
 * @Date: Apr 15, 2019 4:12:34 PM
 */

public class Test {

    public static JSONArray getJSONArray(String url) {
        // input存放json内容
        String input = null;

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

        // 将数组json转换为JSON数组对象
        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数据
            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("执行成功");
        }
    }
}