mysql 取 第一张 图片_MyEclipse------从MySQL取出图片

Stringpath=request.getContextPath();StringbasePath=request.getScheme()+ "://"

+request.getServerName()+ ":" +request.getServerPort()+path+ "/";%>

">

My JSP 'showImage.jsp' starting page

Stringurl="jdbc:mysql://localhost:3306/student?useSSL=true";StringuseName="root";Stringpassword="2277092";Stringsql="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);byteb[]=new byte[0x7a120];for(inti=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);

}%>