关于图片上传到服务器并保存到数据库,然后读出显示到页面上的一

1、关于图片上传到服务器并保存到数据库,然后读出显示到页面上的一系列例子 (2007-02-03 09:08:23转载分类： JAVA一、addImg.jsp 类似网易邮箱的多附件上传，无刷新动态添加<% page language="java" contentType="text/html; charset=gbk" pageEncoding="gbk" import="mon.*,com.tianai.system.core.dao.*,com.tianai.system.cor

2、e.domain.*,java.util.*"%><% String path = request.getContextPath(; BookDAO bdao = new BookDAO(; Book b = new Book(; List booklist = bdao.findAll(; if (booklist = null | booklist.size( = 0   booklist = new ArrayList(; %>    

3、60;                     上传文件信息        对应文档                   

4、;     来自书目             <%       for(int i=0;i        b=(Bookbooklist.get(i;       %> 

5、0;            <%                    %>                

6、开始页码                        图片                 添加文件" onclick="addUploadFile(;"&g

7、t;         确认上传" onclick="submitPage(;">            重置">  二、UploadImage.servlet doPost方法  /实例化上载bean  com.jspsmart.upload.SmartUpload mySma

8、rtUpload = new com.jspsmart.upload.SmartUpload(;  /初始化  mySmartUpload.initialize(this.getServletConfig(,request,response;  request.setCharacterEncoding("gbk"    /设置上载的最大值  mySmartUpload.setMaxFileSize(500 * 1024 * 1024;  

9、;/上载文件  try    mySmartUpload.upload(;   catch (SmartUploadException e    / TODO 自动生成 catch 块   e.printStackTrace(;    /循环取得所有上载的文件  for (int i = 0; i < mySmartUpload.getFiles(.getCount(; i+   

10、 /取得上载的文件   com.jspsmart.upload.File myFile = mySmartUpload.getFiles(   .getFile(i;      if (!myFile.isMissing(     /取得上载的文件的文件名    String myFileName = myFile.getFileName(;    

11、;/取得不带后缀的文件名    String suffix = myFileName.substring(0, myFileName    .lastIndexOf('.'    /取得后缀名    String ext = mySmartUpload.getFiles(.getFile(0    .getFileExt(;    /取得文件

12、的大小     int fileSize = myFile.getSize(;    /保存路径    String aa = getServletContext(.getRealPath("/" + "jsp"    System.out.println(aa;    String trace = aa + myFileName; &#

13、160;  /取得别的参数/    String explain = (String mySmartUpload.getRequest(/    .getParameter("text"/    String send = (String mySmartUpload.getRequest(/    .getParameter("send"   &#

14、160;String sBook_id = (StringmySmartUpload.getRequest(.getParameter("book_id"    System.out.println("book id is "+sBook_id;    int iBook_id = 0;    if (sBook_id != null && sBook_id.trim(.length( != 0   

15、   iBook_id = Integer.parseInt(sBook_id;            String sFile_id = (StringmySmartUpload.getRequest(.getParameter("file_id"    System.out.println("file_id is "+sFile_id;  &#

16、160; int iFile_id = 0;    if (sFile_id != null && sFile_id.trim(.length( != 0      iFile_id = Integer.parseInt(sFile_id;            String sStartPage_no = (StringmySmartUpload.getReq

17、uest(.getParameter("start_page_no"    int iStartPage_no = 0;    if (sStartPage_no != null && sStartPage_no.trim(.length( != 0      iStartPage_no = Integer.parseInt(sStartPage_no;      

18、60; int iPage_no=0;    if(iStartPage_no!=0    iPage_no=iStartPage_no+i;    /将文件保存在服务器端    try      myFile.saveAs(trace, mySmartUpload.SAVE_PHYSICAL;     catch (SmartUploa

19、dException e      e.printStackTrace(;        /下面的是将上载的文件保存到数据库中    /将文件读到流中    java.io.File file = new java.io.File(trace;    java.io.FileInputStream fis = new java.io.FileInp

20、utStream(    file;    System.out.println(file.length(;    /打开数据库    Image image = new Image(0, iFile_id, fis, iBook_id,    iPage_no;    ImageDAO idao = new ImageDAO(;  &#

21、160; idao.add(image;           到此，图片就已经存进数据库了，接着看怎么把他显示到页面上三、showImage( servlet中使用private void ShowImage(String id, HttpServletRequest request,   HttpServletResponse response throws IOException   Connection conn = n

22、ull;  final String CONTENT_TYPE = "image/*"  ResultSet rs = null;  Statement stmt = null;  String SQLString = "" / 定义查询语句  String M_EorrMenage = "" / 定义错误信息变量  InputStream in = null; / 定义输入流  int len

23、= 10 * 1024 * 1024; / 定义字符数组长度  / Initialize global variables  response.setContentType(CONTENT_TYPE;  / PrintWriter out = response.getWriter(;  try    SQLString = "select * from image where id=" + id;   catch (Exception e

24、60;  e.printStackTrace(;   response.setContentType("text/html; charset=gbk"   M_EorrMenage = "请输入图片ID号"   M_EorrMenage = new String(M_EorrMenage.getBytes("ISO8859_1", "GBK"   / out.println(&

25、quot;<% page contentType='text/html; charset=gbk' %>"   / out.println(""   / out.println(""   / out.println(""   / out.println("" + M_EorrMenage + ""    / o

26、ut.println(""      try    conn = DBConnection.newInstacne(.getConnection(;    stmt = conn.createStatement(;    rs = stmt.executeQuery(SQLString;    catch (SQLException ex    System.err.println("a

27、q.executeUpdate:" + ex.getMessage(;    M_EorrMenage = " 对不起，数据库无法完成此操作！ "    M_EorrMenage = new String(M_EorrMenage.getBytes("ISO8859_1", "GBK"    response.setContentType("text/html; charset=gb2312"   

28、; / out.println(""    / out.println(""    / out.println(""    / out.println("" + M_EorrMenage + ""    / out.println(""      try    if (rs.ne

29、xt(     in = rs.getBinaryStream("pic"     response.reset(; / 返回在流中被标记过的位置     response.setContentType("image/jpg" / 或 gif 等     / int len=in.available(;/ 得到文件大小     OutputStream to

30、Client = response.getOutputStream(;     byte P_Buf = new bytelen;     int i;     while (i = in.read(P_Buf != -1      toClient.write(P_Buf, 0, i;          in.close(;  

31、0;  toClient.flush(; / 强制清出缓冲区 r     toClient.close(;     else     M_EorrMenage = " 无此图片！ "     M_EorrMenage = new String(M_EorrMenage.getBytes("ISO8859_1",       &q

32、uot;GBK"     response.setContentType("text/html; charset=gb2312"     / out.println(""     / out     / .println(""     / out.println(""     / out.println("" + M_EorrMenage + ""     / out.println(""        rs.close(;    catch (Exception e