📄 imageout.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.io.*"%>
<html>
<body>
<%
request.setCharacterEncoding("GBK");
String url=new String();
//url="jdbc:db2://127.0.0.1:6789/imis";
// Class.forName("COM.ibm.db2.jdbc.net.DB2Driver");
url="jdbc:sybase:Tds:10.0.7.12:4000/wei";
Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
Connection con=DriverManager.getConnection(url,"wmj","197555");
Statement stmt=con.createStatement();
ResultSet rs=null;
//建立ResultSet（结果集）对象
String markname=request.getParameter("markname");
//获得所要显示图片的编号id，并转换为整型
String sql = "select navigationimage from navigationmark WHERE mark_name='"+markname+"'";
//要执行查询的SQL语句
rs=stmt.executeQuery(sql);
if(rs==null)
response.sendRedirect("../../error/queryerror.html");
else{
while(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();
}
%>
</body>
</html>
<%
rs.close();
con.close();
}%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -