標籤：os io 檔案 資料 ar cti new sql
<body>
<%
//擷取圖片對象(根據主鍵)的sql語句
String showImage = " select * "+
" from 存放圖片的表 "+
" where id=‘1‘ " ;
BufferedInputStream inputImage = null;
try{
//conn為一個Connection對象
Statement st = conn.createStatement();
//擷取結果集
ResultSet rs=st.executeQuery(showImage);
//輸出檔案名
String filename="";
if(rs.next()) {
Blob blob = (Blob)rs.getBlob("BINARYFILE");
filename=rs.getString("FILENAME");
//讀取圖片位元組到資料流中
inputImage = new BufferedInputStream(blob.getBinaryStream());
}
BufferedImage image = null;
image=ImageIO.read(inputImage);
//擷取響應的輸出資料流
ServletOutputStream so = response.getOutputStream();
//建立圖片到頁面
JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(so);
encoder.encode(image);
inputImage.close();
}
%>
</body>
<%
catch(Exception e){
}
finally{
closeConn(conn);
}
%>
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
