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