jsp提取orcal数据库中二进制图片的方法

最新推荐文章于 2024-05-04 09:38:05 发布

雨恨

最新推荐文章于 2024-05-04 09:38:05 发布

阅读量476

点赞数

分类专栏： jsp 文章标签： jsp 数据库 string import stylesheet exception

本文链接：https://blog.csdn.net/wjz1029/article/details/7598790

版权

jsp 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.io.*"%>

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+
":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'testimageout.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

<%!Connection con=null;%>
<%!Statement sql=null;%>
<%!ResultSet rs=null;%>
</head>
<body>
<%
String userid=(String)session.getAttribute("userid");
String sqlword="select midfront from TRN_MID where owuserid='"+userid+"'";
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","WJZwjz1029");
sql=con.createStatement();
rs=sql.executeQuery(sqlword);

if(rs.next())
{
    ServletOutputStream sout = response.getOutputStream();
//图片输出的输出流
     InputStream in = rs.getBinaryStream(1);
     byte b[] = new byte[0x7a120];
     for(int i = in.read(b); i != -1;)
   {
     sout.write(b);
//将缓冲区的输入输出到页面
     in.read(b);
   }
     sout.flush();
//输入完毕，清除缓冲
      sout.close();

//否则会很卡
        out.clear();
         out = pageContext.pushBody();


}
}catch(Exception e)
{
out.print(e);
}
finally
{   rs.close();
    sql.close();
    con.close();
}
%>
</body>
</html>

雨恨

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jsp提取orcal数据库中二进制图片的方法

String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>">My JSP 'testimageout.jsp' starting p
复制链接

扫一扫