blob字段存储world内容在页⾯上显⽰blob字段存储着world内容，并显⽰在页⾯上
整体思路：取出blob字段并写⼊world⾥，然后通过openoffice将world转化成pdf并显⽰在页⾯股评家
下载Apache_OpenOffice_4.1.3_Win_x86_
下载jodconverter-2.2.2.zip，并导⼊相关jar包
commons-cli-1.2.jar
commons-io-1.4.jar
jodconverter-2.2.2.jar
jodconverter-cli-2.2.2.jar
juh-3.0.1.jar
jurt-3.0.1.jar
ridl-3.0.1.jar
slf4j-api-1.5.6.jar
slf4j-jdk14-1.5.6.jar
unoil-3.0.1.jar
xstream-1.3.1.jar
页⾯显⽰需引⽤pdfobject.js
安装完后需要在cmd⾥执⾏cd C:\Program Files (x86)\OpenOffice 4\program进⼊⽂件夹
然后执⾏soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;" -nofirststartwizard启动服务（不启动不会进⾏转换）
action:
private String ZW_PATH="E:/Urs/testupload/UpFiles/";//world保存路径，可改为配置⽂件获取
private String ZW_PDF_PATH="E:/Urs/admin/apache-tomcat-7/webapps/wz/";//pdf保存路径，可改为配置⽂件获取
/**
*跳转⾄⽂档查看页⾯
**/
@Action(value = "wendang", results = { @Result(name = "haveZw", location = "wendangForZw.jsp")})
usb什么意思public String toWendang(){
《孝经》全文
2021年中国gdpMap Zw(paramMap);
if(zwMap!= null && ("FILEBODY")!=null){
Blob blob=(("FILEBODY");//获取存储的blob字段
String wh=(("WH");//获取⽂件名
//⽣成doc⽂件，返回地址
String zw=convertBlobToString(blob,wh);//将blob字段值写⼊world并返回存储地址String pdfPath=ZW_PDF_PATH+wh+".pdf";
office2PDF(zw,pdfPath);//将world转成pdf
request.tAttribute("wh", wh);
return "haveZw";
}
}
util:
/**
* 根据blob获取发⽂正⽂
* @param blob blob字段
* @param wh ⽂件名
* @return
* @throws SQLException
*/
public String convertBlobToString(Blob blob,String wh) throws SQLException{
String path=ZW_PATH+wh+".doc";
FileOutputStream fop = null;
File file;
try {
file = new File(path);
fop = new FileOutputStream(file);
// if file doesnt exists, then create it
if (!ists()) {
}
// get the content in bytes
byte[] contentInBytes = Bytes((long)1, (int)blob.length());
fop.write(contentInBytes);
fop.flush();
fop.clo();
System.out.println("Done");
} catch (Exception e) {
e.printStackTrace();
} finally {
try {QRA
if (fop != null) {
fop.clo();
}
} catch (IOException e) {
e.printStackTrace();
}
}
return path;
}
/虎刺梅怎么养
**
* world转pdf
* @param sourceFile world⽂件地址
* @param destFile pdf存放地址
* @return
*/
public int office2PDF(String sourceFile, String destFile) {
try {
File inputFile = new File(sourceFile);
婚礼对唱if (!ists()) {
return -1;// 找不到源⽂件, 则返回-1
你是我的主角
}
// 如果⽬标路径不存在, 则新建该路径
File outputFile = new File(destFile);
if (!ParentFile().exists()) {
}
// connect to an OpenOffice instance running on port 8100
OpenOfficeConnection connection = new SocketOpenOfficeConnection( "127.0.0.1", 8100);
// convert
DocumentConverter converter = new OpenOfficeDocumentConverter( connection);
// clo the connection
connection.disconnect();
return 0;
} catch (Exception e) {
e.printStackTrace();
}
return 1;
}
页⾯:
<html>
<div id="test" >
</div>
</html>
<script type="text/javascript" src="${ctx}/static/js/pdfobject.js"></script>
