/Java/Retrieve Image from java database.

Retrieve Image from java database.

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: thecrazyprogrammer.com

Similar codes

0 vote228 views1 answer
Java resultset.absolute
Java
0 vote217 views1 answer
T implements comparable
Java
4 votes265 views1 answer
Select a random element from a list java
Java
9 votes231 views2 answers
I have AdoptOpenJDK 8 but java --version gettinbg Unrecognized option: --version Error: Could not create the Java Virtual Machine. Error: A fatal exception has occurred. Program will exit.
Java
0 vote235 views1 answer
Int in double umwandeln java
Java
1 vote226 views1 answer
Caused by: java.lang.noclassdeffounderror: could not initialize class com.android.sdklib.repositoryv2.androidsdkhandler
Java
0 vote227 views1 answer
Can't run 1.18 Server jar file
Java
0 vote239 views1 answer
Primitive vs wrapper classes in java
Java
1 vote233 views2 answers
Bootstrap 4 Navbar Dropdown Menu Items Right
Java
-1 vote233 views1 answer
React-cheat-sheet
Java