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);
}
}
}