How to Insert an Image in Database using Java JDBC

Program 1

package view;
import java.io.*;
import java.sql.*;
public class TestMainImage 
{
    public static void main(String[] args) 
    {
        try
        {    
          File F=new File("F://myimages/dog.jpg");
          FileInputStream fis=new FileInputStream(F);
          Class.forName("com.mysql.cj.jdbc.Driver");
          System.out.println("Driver load");
          Connection con=null;
          PreparedStatement ps=null;
          con=DriverManager.getConnection("jdbc:mysql:/dataflair", "root", "root@data");
          System.out.println("Database  connect");
          String sql;
          sql="insert into imagedata values(?,?)";
          ps=con.prepareStatement(sql);
          ps.setString(1, "dog");
          ps.setBinaryStream(2, fis);
          if(ps.executeUpdate()>0)
                System.out.println("Image Inserted.....");
        }
        catch(Exception e)
        {
            System.out.println(e);
        }    
    }
    
    
}

 

follow dataflair on YouTube

Leave a Reply

Your email address will not be published. Required fields are marked *