主要思路:
<img src="showImage.do?name=mall&column=image"/>通过src访问servlet,由response的流输出图片到页面。
流的方式一:
- response.setHeader("Cache-Control", "no-store");
- response.setHeader("Pragma", "no-cache");
- response.setDateHeader("Expires", 0);
- response.setContentType("image/jpg");
- ServletOutputStream responseOutputStream = response.getOutputStream();
- String name = request.getParameter("mall_name");
- PreparedStatement ps = null;
- ResultSet rs = null;
- Connection con;
- String sql = "select MALL_LOGO from trustsg_mall_info where MALL_NAME = ?";
- try {
- Class.forName("com.mysql.jdbc.Driver");
- con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ofbiz","ofbiz","ofbiz");
- ps = con.prepareStatement(sql);