retrieve picture database

[Nouf Nassri]

Hi ,

I inserted a picture into oracle 8i database but I encountered a problem I do not know why the image does not appear in label.

registration code:

  
   String name,path = null;
   FileInputStream input = null;
      JFileChooser fc= new JFileChooser();
        int returnVal = fc.showOpenDialog(this);

            if (returnVal == JFileChooser.APPROVE_OPTION) {
                File file = fc.getSelectedFile();
                //This is where a real application would open the file.
              name= file.getName() ;
             path= file.getAbsolutePath() ;

            }
           File fBlob = null;
         try {
            fBlob = new File ( path );
   
 input = new FileInputStream ( fBlob );

         } catch (Exception ex) {
                JOptionPane.showMessageDialog(null, ex.getMessage());
        }
       try {

          Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection  cn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:master","system","manager");
         PreparedStatement pst=cn.prepareStatement("insert into picture values(?)");
     

 pst.setBinaryStream (1, input, (int) fBlob.length() );

            int value=pst.executeUpdate();
            if(value!=0){
              JOptionPane.showMessageDialog(null, "piicture");
            }




        } catch (Exception e) {
                JOptionPane.showMessageDialog(null, e.getMessage());
        }

                /

			-----------------------------------------------------------------
			
			
			
  

display code:

   

        Connection cn;=null
	ResultSet rs;
	BufferedInputStream is = null;
 

		try
		{
			
		  Class.forName("oracle.jdbc.driver.OracleDriver");
      cn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:master","system","manager");
			
			Statement stmt = con.createStatement();
			rs = stmt.executeQuery("select * from picture );
			
			rs.next();
 
			Blob blob = rs.getBlob(*);
			is = new BufferedInputStream(blob.getBinaryStream());
			 
			Image raw = ImageIO.read(is);
			
			
			fenetre.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
			label.setIcon(new ImageIcon(raw));
			
 
 
			
		}
		catch(Exception e)
		{
		
		  JOptionPane.showMessageDialog(null, e.getMessage());
		}
  

thanks.

[Olivier Legat]

fenetre.setVisible(true) maybe?

Also, please try to keep the identifiers you use in english so it can be easier for others to understand.