Mysql直接插入json数据

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;

import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Date;

public class Testmain {
    public static void main(String[] args) throws Exception {
        Connection conn = null;
        String topic = "1";
        String csv = "3";
        String cd = "{'namespace': 'example.avro', 'type': 'record', 'name': 'User', 'fields': [ { 'name': 'name', 'type': 'string' }, { 'name': 'favorite_number', 'type': [ 'int', 'null' ] }, { 'name': 'favorite_color', 'type': [ 'string', 'null' ] } ] }";
        JSONObject cds = JSON.parseObject(cd);
        //String avros = "'" + avro + "'";
        //replaceAll("[a-zA-Z0-9_!@#$%^&*()-=+~.;:,\\Q[\\E\\Q]\\E<>{}\\/?\\\\\"' ]", "");
        String url = "";
        Date date = new Date();
        //获得系统时间.
        String nowTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(date);
        //将时间格式转换成符合Timestamp要求的格式.
        Timestamp goodsC_date = Timestamp.valueOf(nowTime);
        try {
            Class.forName("com.mysql.jdbc.Driver");
            // 动态加载mysql驱
            System.out.println("成功加载MySQL驱动程序");
            conn = DriverManager.getConnection(InitConfig.MYSqlURL);
            conn = DriverManager.getConnection(InitConfig.URLMYSQL, InitConfig.USERMYSQL, "");
            //conn=DriverManager.getConnection(InitConfig.MYSqlURL,InitConfig.MYSqlUser,"");
            System.out.println("远程Mysql连接测试：" + conn);
            Statement statement = conn.createStatement();
            // String sql="INSERT INTO Topicinfo (topic,csv,avro,ctime) values ("+topic,+csv,+avro",NOW()+);";
            String sql1 = "INSERT INTO Topicinfo (avro,csv,topic,ctime) values (" + "'" + cds + "'" + "," + "'" + csv + "'" + "," + "'" + topic + "'" + ",NOW());"; // 结果集 /
            String sqltest = "select * from Topicinfo";
            boolean success=statement.execute(sql1);
            //ResultSet rs=statement.executeQuery(sqltest);
            // while(rs.next()) {
            // // 选择Name这列数据//
            // String name = rs.getString("topic");
            // // 输出结果//
            // System.out.println(rs.getString("ID") + "\t" + name+"\t"+rs.getString("csv") + "\t" +rs// .getString("avro")+"\t"+rs.getString("ctime"));//
            // }//
            // rs.close();
            if(success){
                System.out.println("插入成功");
            }else {
                System.out.println("插入失败");
            }
            conn.close();
        } catch (SQLException e) {
            System.out.println("MySQL操作错误");
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}