oralc 中图片的存储与读取

 

ai0709编写，joker_yao整理

// 数据类型 long row
// 存储
SaveImg
public   void  insertr_save_img(String img_no,String imgpath)  throws  Exception{
    PreparedStatement pstmt  =   null ;
     try {
        
        File file  =   new  File(imgpath); 
         int  fileLength  = ( int ) file.length(); 
        InputStream fin  =   new  FileInputStream(file); 
        
        
                
        String query  =   " Insert into save_img(  "   +
                               " img_no, emp_pict " +
                        "  ) values (  " +
                               " ?, ?) " ;
        pstmt  =  connection.prepareStatement(query);
        pstmt.setString( 1 ,img_no);
        pstmt.setBinaryStream ( 2 , fin, fileLength); 
              int  affected  =  pstmt.executeUpdate();
      
    } catch (Exception e){
        
    }
     finally  {
         try {pstmt.close();} catch (Exception e){}
    }  //  try-finally

}  //  end insert

// 读取
Readimg
public   byte []  select_img(String emp_no)  throws  Exception{
    PreparedStatement pstmt  =   null ;
     byte [] bo;
    ResultSet rs  =   null ;
     try {
        String query  =   " Select  emp_pict  "   +
                        "   from save_img "   +
                        "   where serial_no =?   " ;
        pstmt  =  connection.prepareStatement(query);
        pstmt.setString( 1 ,emp_no); 
        rs  =  pstmt.executeQuery();
        if (rs.next()) { 
           bo = rs.getBytes( 1 );
        }  //  end While
         else  { 
            bo = new   byte [ 0 ];}
    }  finally  {
         try {rs.close();} catch (Exception e){}
         try {pstmt.close();} catch (Exception e){}
    }  //  try-finally
         return  bo;
}  //  end select
// jsp显示

<%      
                    
         try {   
              Class.forName( " oracle.jdbc.driver.OracleDriver " ).newInstance();         
             String   url = " jdbc:oracle:thin:@127.0.0.1:1521:oracle?      user=scott&password=tiger&useUnicode=true&characterEncoding=8859_1 " ;         
            Connection   conn =    DriverManager.getConnection(url);         
            String   sql    =     " select emp_pict from ee.ba020m where emp_no= " + emp_no_imge;         
            Readimg img =   new  Readimg(conn);
            String img_no = " 1 " ;
             byte [] bo  =  img.select_img(img_no);     
            
              response.reset();     
            response.setContentType( " image/jpeg " );    
            
            ServletOutputStream   sout    =    response.getOutputStream();     
            
                for ( int  i =   0  ; i <  bo.length; i ++ ){   
                           sout.write(bo[i]);   
                }     
              sout.flush();     
              sout.close();     
                  
          }     
           catch (Exception   e){System.out.println(e);}  
           finally {
           try {rs.close();} catch (Exception e){}
               if  ( conn !=   null  ) conn.close();
          }   
       %>