服务器 频道

用JAVA实现ORACLE数据库的文件上传与下载

  文件下载: 

  文件名: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(); 

  %>

0
相关文章