文件下载:
文件名:jspsmartdownload.jsp
文件内容:
<meta http-equiv="Content-Type" content="application/msword; charset=gb2312"
> //注意这里,如果你没有设置成“GB2312”结果你会明白的。
<%@ page language="java" import="java.sql.*,com.jspsmart.upload.*"%>
<jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.Smar
tUpload" />
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con = DriverManager.getConnection("jdbc:oracle:thin10.231.234.2
52:1521:cepic", "cepic", "lpsc");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM UPLOADS");
if (rs.next()){
mySmartUpload.initialize(pageContext);
mySmartUpload.downloadField(rs,"BINARYFILE","application/msword","");
//mySmartUpload.fieldToFile(rs,"BINARYFILE","c:/sample.DOC");
}
rs.close();
stmt.close();
con.close();
%>