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();
}
}
}