Mysql直接插入json数据

来源：互联网发布：小众知乎编辑：程序博客网时间：2024/06/16 10:08
import java.sql.*;import java.text.SimpleDateFormat;
import org.codehaus.jettison.json.JSONObject;
/** * Created by Administrator on 2016/9/9. */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=new JSONObject(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();            // 要执行的SQL语句//            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";            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();            conn.close();        } catch (SQLException e) {            System.out.println("MySQL操作错误");            e.printStackTrace();        } catch (Exception e) {            e.printStackTrace();        }    }              }
0 0