showImage.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<%@page import="java.sql.*" %>
<%@page import="java.util.*" %>
<%@page import="java.text.*" %>
<%@page import="java.io.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'showImage.jsp' starting page</title>
</head> <body>
<%
String url="jdbc:mysql://localhost:3306/student?useSSL=true";
String useName="root";
String password="2277092";
String sql="select binfile from bindata where name='01'"; try{
Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){
out.print(e);
} Connection conn=null;//连接数据库
Statement stmt=null;//执行SQL语句
ResultSet rs=null;//取得结果集 conn=DriverManager.getConnection(url,useName,password); try{
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}catch(SQLException e){
out.print(e);
} try{
while(rs.next()){
response.setContentType("image/jpeg");//设置返回给客户端的内容的类型
//给客户端提供一个输出二进制的输出流
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();
}
sout.flush();
sout.close();
}
out.clear();
out=pageContext.pushBody();
}
catch(Exception e){
out.print(e);
}
%>
</body>
</html>
MySQL上传图片类型设置