String timestamp = df.format(new Date());
String sql = "CREATE TABLE if not exists rmtb_temp_siteMapXML"
+ " (id int unsigned not null auto_increment primary key,"
+ " file blob,"
+ " create_time timestamp,"
+ " Integer"
+ ")ENGINE=MyISAM DEFAULT CHARSET=utf8";
dataSource.execute(sql);String insertSql = "insert into rmtb_temp_siteMapXML(file,create_time,) values ('" + buffer + "','" + timestamp + "',0)";
dataSource.execute(insertSql);其中file为blob字段,这样存,存进去的是buffer的地址,或者不应该用blob? 这个buffer.length为74000+
String sql = "CREATE TABLE if not exists rmtb_temp_siteMapXML"
+ " (id int unsigned not null auto_increment primary key,"
+ " file blob,"
+ " create_time timestamp,"
+ " Integer"
+ ")ENGINE=MyISAM DEFAULT CHARSET=utf8";
dataSource.execute(sql);String insertSql = "insert into rmtb_temp_siteMapXML(file,create_time,) values ('" + buffer + "','" + timestamp + "',0)";
dataSource.execute(insertSql);其中file为blob字段,这样存,存进去的是buffer的地址,或者不应该用blob? 这个buffer.length为74000+
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货