iframe图片上传接口（某项目中的图片接口，图片存成oracle中的Blob）

package com.lianke.action; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.PreparedStatement; import java.util.UUID; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import javax.servlet.jsp.JspFactory; import javax.servlet.jsp.JspWriter; import javax.servlet.jsp.PageContext; import com.jspsmart.upload.SmartUploadException; import com.lianke.util.DbConnection; public class UpImageNew extends HttpServlet { /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request * the request send by the client to the server * @param response * the response send by the server to the client * @throws ServletException * if an error occurred * @throws IOException * if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to * post. * * @param request * the request send by the client to the server * @param response * the response send by the server to the client * @throws ServletException * if an error occurred * @throws IOException * if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Connection conn = null; PreparedStatement ps = null; //HttpSession session = request.getSession(); //String sessionID = session.getId(); // // 实例化上载bean com.jspsmart.upload.SmartUpload mySmartUpload = new com.jspsmart.upload.SmartUpload(); // 初始化 response.getContentType(); JspFactory fac = JspFactory.getDefaultFactory(); PageContext pageContext = fac.getPageContext(this, request, response, null, false, JspWriter.DEFAULT_BUFFER, true); mySmartUpload.initialize(pageContext); // 设置上载的最大值 mySmartUpload.setMaxFileSize(500 * 1024 * 1024); // 上载文件 try { mySmartUpload.upload(); // 循环取得所有上载的文件 for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) { // 取得上载的文件 com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile( i); if (!myFile.isMissing()) { // 取得文件全名 String myFileName = myFile.getFileName(); // 取得不带后缀的文件名 String suffix = myFileName.substring(0, myFileName .lastIndexOf(".")); // 取得后缀名 String ext = mySmartUpload.getFiles().getFile(0).getFileExt(); if (ext.equals("exe ")) { System.out.println("上传文件不能为EXE文件 "); return; } // 取得文件的大小 int fileSize = myFile.getSize(); // 保存路径 String aa = getServletContext().getRealPath("/") + "upfile\\"; String trace = aa + myFileName; // 取得别的参数 String explain = (String) mySmartUpload.getRequest().getParameter("text "); String send = (String) mySmartUpload.getRequest().getParameter("send"); // 将文件保存在服务器端 System.out.println(trace); myFile.saveAs(trace,com.jspsmart.upload.File.SAVEAS_PHYSICAL); // 将上载的文件保存到数据库中 // 将文件读到流中 java.io.File file = new java.io.File(trace); java.io.FileInputStream fis = new java.io.FileInputStream(file); // 打开数据库 UUID idSno=UUID.randomUUID(); conn = DbConnection.getConnection(); ps = conn.prepareStatement("insert into SDLY_PIC(ID_SNO,OC_FLAG,C_PIC,OC_YXBZ,DT_SCSJ,OC_CZY) values (?,?,?,?,sysdate,?)"); ps.setString(1, idSno.toString()); ps.setString(2, "01"); ps.setBinaryStream(3, fis, (int)file.length()); ps.setString(4, "T"); ps.setString(5, "admin"); ps.execute(); fis.close(); } } }catch(Exception e){ e.printStackTrace(); }finally{ try{ if(ps!=null)ps.close(); if(conn!=null)conn.close(); }catch(Exception e){ e.printStackTrace(); } } } }