额外篇:保存html内容到数据库,点击打开链接
一、js发送读取html内容请求
var url = "...", data = {id:".."};
$.ajax({
url: url,
type : "post",
data : data,
dataType: "json",
success: function(data, textStatus, jqXHR){
//返回html内容结果,并显示到当前页面
var htmlContent = data;
window.document.body.innerHTML = "";
//document.close();
document.write(htmlContent);
},
error : function(jqXHR, textStatus, errorThrown){
alert(jqXHR + "," + textStatus + "," + errorThrown);
}
});
二、读取数据库的html内容
//本例使用ORACLE数据库
String sql = "...";
List> lists =
jdbcTemplate().query(sql, new RowMapper>(){
@Override
public Map mapRow(ResultSet rs, int rowNum) throws SQLException {
Map row = new HashMap();
row.put("CONTENT", lobHandler.getBlobAsBinaryStream(rs, "CONTENT"));//字段CONTENT是BLOB类型
return row;
}});
String htmlContent = null;
InputStream inputStream = null;
try{
inputStream = (InputStream) files.get(0).get("CONTENT");
htmlContent = IOUtils.toString(inputStream);//IOUtils是commons-io.jar的一个类
}finally{
if(inputStream != null) inputStream.close();
}
return htmlContent;