Retrieve Image From Java Database

[Solved] Retrieve Image From Java Database | Scala - Code Explorer | yomemimo.com
Question : Retrieve Image from java database.

Answered by : zain-8z5vpbts6137

package com;
 
import java.io.*;
import java.sql.*;
 
public class DatabaseImageExample {	public static void main(String args[]){	try{	Class.forName("com.mysql.jdbc.Driver");	Connection con=DriverManager.getConnection("jdbc:mysql://localhost/demo","root","root");	File file=new File("E:\\image1.png");	FileOutputStream fos=new FileOutputStream(file);	byte b[];	Blob blob;	PreparedStatement ps=con.prepareStatement("select * from image_table");	ResultSet rs=ps.executeQuery();	while(rs.next()){	blob=rs.getBlob("image");	b=blob.getBytes(1,(int)blob.length());	fos.write(b);	}	ps.close();	fos.close();	con.close();	} catch(Exception e){	e.printStackTrace();	}	}
}

Source : https://www.thecrazyprogrammer.com/2016/01/save-and-retrieve-image-from-mysql-database-using-java.html | Last Update : Tue, 01 Feb 22

Answers related to retrieve image from java database

Code Explorer Popular Question For Scala