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