Site icon DataFlair

How to Retrieve an Image From Database using Java JDBC

Program 1

package view;
import java.io.*;
import java.sql.*;
public class TestImage1 
{
    public static void main(String[] args) 
    {
     try
     {     
       File F=new File("F://myimages/newdog.jpg");    
       FileOutputStream fos=new FileOutputStream(F);
       Connection con=null;
       PreparedStatement ps=null;
       ResultSet rs=null;
        Class.forName("com.mysql.cj.jdbc.Driver");
        System.out.println("Driver load....");
        con=DriverManager.getConnection("jdbc:mysql:/dataflair", "root", "root@data");
        System.out.println("Database connected....");
        String sql;
        sql="select * from imagedata where img_name='dog'";
        ps=con.prepareStatement(sql);
        rs=ps.executeQuery();
        if(rs.next())
        {
             byte b[];
            System.out.println("Iamge Name: "+rs.getString(1));
            b=rs.getBytes(2);
            fos.write(b);
            System.out.println("Image retrive......");
        }
        else
             System.out.println("Image not found......");
        
     }
     catch(Exception e)
     {
         System.out.println(e);
     }   
    }
    
}

 

Exit mobile version