01.<%@page import="java.io.PrintWriter"%>
02.<%@page import="java.io.OutputStream"%>
03.<%@page import="java.io.InputStream"%>
04.<%@page import="java.sql.ResultSet"%>
05.<%@page import="net.sysmain.common.ConnectionManager"%>
06.<%@page import="java.sql.PreparedStatement"%>
07.<%@page import="java.sql.Connection"%>
08.<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
09.<%
10. response.reset();
11. String guid = request.getParameter("guid");
12. Connection conn = null;
13. PreparedStatement ps = null;
14. ResultSet rs = null;
15. InputStream is = null;
16. OutputStream os = null;
17. try{
18. conn = ConnectionManager.getInstance().getConnection();
19. ps = conn.prepareStatement("select img from user where guid=?");
20. ps.setString(1, guid);
21. rs = ps.executeQuery();
22. if(rs.next()){
23. is = rs.getBinaryStream(1);
24. }
25. response.setContentType("image/jpeg");
26. os = response.getOutputStream();
27. int num;
28. byte buf[] = new byte[1024];
29. while( (num=is.read(buf))!=-1 ){
30. os.write(buf, 0, num);
31. }
32. os.flush();
33. is.close();
34. os.close();
35. }catch(Exception e){
36. e.printStackTrace();
37. }finally{
38. ConnectionManager.close(conn,ps,rs);
39. }
40.%>