display.jsp

JSP+ORACLE网站开发实例（下）.rar

<%@  page  language="java"%>  
<%@  page  contentType="text/html;charset=gb2312"  %>  
<%@  page  import="java.util.*"  %>  
<%@  page  import="java.sql.*"%>  
<%@  page  import="java.text.*"%>    
<%@  page  import="java.io.*"%>  
 
<%    
Class.forName("oracle.jdbc.driver.OracleDriver");    
String  url="jdbc:oracle:thin:@localhost:1521:friend";    
Connection  con=DriverManager.getConnection(url,"system","manager");     
String  image_id=request.getParameter("id");   
   
PreparedStatement  sql=con.prepareStatement("select  *  from  scott.friendimg  WHERE  fid='"+image_id+"'");    
ResultSet  rs=sql.executeQuery();    
 
rs.next();    
//输入img字段内容到in  
InputStream  in=rs.getBinaryStream("img");    
 
//以下可是任何处理,比如向页面输出:    
 
response.reset();    
//此处的image/jpeg似乎与显示的图片格式无关  
//因为我显示jsp和gif都没有错误。icech不是很懂，都是参考别人的。  
response.setContentType("image/jpeg");    
byte[]  b=new  byte[1024];    
int  len;    
while((len=in.read(b))>0)    
response.getOutputStream().write(b,0,len);    
 
in.close();    
rs.close();    
%>