How to Insert an Image in Database using Java JDBC
by TechVidvan Team
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);
}
}
}
Tags: advanced javaadvanced java practicaladvanced java programhow to insert an imagehow to insert an image in database using java jdbcimage insertion in database using java jdbcjava database connectivity
TechVidvan Team
TechVidvan Team provides high-quality content & courses on AI, ML, Data Science, Data Engineering, Data Analytics, programming, Python, DSA, Android, Flutter, full stack web dev, MERN, and many latest technology.