数据库的html内容显示到页面

额外篇：保存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<Map<String, Object>> lists =
        jdbcTemplate().query(sql, new RowMapper<Map<String,Object>>(){
            @Override
            public Map<String,Object> mapRow(ResultSet rs, int rowNum) throws SQLException {
                Map<String,Object> row = new HashMap<String,Object>();
                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;