How to Retrieve an Image From Database using Java JDBC
by TechVidvan Team
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);
}
}
}
Tags: advanced javaadvanced java practicaladvanced java programhow to retrieve an image from databasehow to retrieve an image from database using java jdbcjava database connectivityjava jdbcretrieve an image from database using java jdbc
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.