JSONArray（数组）对象如何插入到MySQL中？

Question

excel解析成json，然后想放到mysql数据库中如何插入，

public static void main(String[] args) {

    Connection conn = null;
    Statement stmt = null;
    try {
        Class.forName(JDBC_DRIVER);
        conn = DriverManager.getConnection(URL, USER, PASSWORD);
        stmt = conn.createStatement();
        String sql = "CREATE TABLE laugh" +
                "(id SMALLINT UNSIGNED NOT NULL PRIMARY KEY," +
                "content VARCHAR(1000)," +
                "source CHAR(20)," +
                "url VARCHAR(255)," +
                "score FLOAT(3,1))";
        stmt.executeUpdate(sql);
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    }

}

Answer 1

用mysql5.7的话有json字段类型的，直接可以插入，还能使用相关函数直接查询json中的字段

Answer 2

JSONArray 转换成json string存入一个字段

Answer 3

先定义相应的Bean然后
List<Bean> list = JSON.parseArray(jsonArray.toString, Bean.class);