image.jsp

来自「一、 网站名称:旅游信息管理网站 二、 编程语言:JSP+javabean+s」· JSP 代码 · 共 56 行

JSP
56
字号
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.io.*"%>


<html>
<head>

</head>
<body>

<jsp:useBean id="j" scope="application" class="jdbc.jdbc"/>
<%

String image=(String)session.getValue("image");

try{
Connection con=j.getConnection();

Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select tour_line_image from tour_line_info where tour_line_name='"+image+"'";

ResultSet r=statement.executeQuery(sql);    

while(r.next())
  {
    
	InputStream in = r.getBinaryStream("tour_line_image");      
	response.setContentType("image/jpeg");      
	ServletOutputStream sout = response.getOutputStream();     
	byte b[] = new byte[1024];      
	int length = 1024;      
	while((length = in.read(b)) != -1){       
              sout.write(b,0,length);
   } 
        sout.close();      
	r.close();    
   }  

  
 j.releaseConnection(con);
  
}

catch(SQLException ee){out.print("数据库连接失败!");}




%>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?