📄 showimage.jsp

📁 jsp 应用开发技术光盘是《jsp应用开发技术》这本书的源代码

💻 JSP

字号:

<%@ page language="java" contentType="image/jpeg;charset=GB2312"%>
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.awt.image.*"%>
<%@ page import="javax.imageio.*"%>
<%@ page import="com.sun.image.codec.jpeg.*"%>

<%@ page import="ch14.datasource.*"%>

<html>
  
  <head>
    <meta http-equiv="Content-Type" content="image/jpeg; charset=GB2312">
    <title>showDBImage.jsp</title>
  </head>

  <body>
<%
	String showImage = " select * "+
                       " from picture_table "+
                       " where file_name='01' " ;
	Connection conn = null;
	BufferedInputStream inputImage = null;
	
	try{
		conn = SqlTestDS.getConnection();
		Statement st = conn.createStatement();
		ResultSet rs=st.executeQuery(showImage);
		while(rs.next()) {
			Blob blob = (Blob)rs.getBlob("content");
			inputImage = new BufferedInputStream(blob.getBinaryStream()); 
		}
		
  		BufferedImage image = null;
  		image=ImageIO.read(inputImage);
		
		ServletOutputStream sos = response.getOutputStream();
		JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(sos);
		encoder.encode(image);
		inputImage.close();
	} catch(SQLException se) {
		se.printStackTrace();
	} catch(IOException ie) {
		ie.printStackTrace();
	}
%>
  
  </body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -