/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

1 vote251 views1 answer
Java date with T
Java
2 votes306 views1 answer
Make recycler view non scrollable
Java
0 vote261 views1 answer
IsEmpty java code
Java
0 vote346 views1 answer
Spring data elasticsearch aggregation max
Java Spring
2 votes254 views1 answer
Character.getNumericValue['z']
Java
1 vote268 views1 answer
How to check keyboard is open or not in android
Java
1 vote266 views1 answer
This project uses AndroidX dependencies, but the 'android.useAndroidX' property is not enabled. Set this property to true in the gradle.properties file and retry.
Java
35 votes267 views6 answers
Check java version
Java
0 vote308 views1 answer
Adding entity to calenderfx
Java
0 vote280 views1 answer
Android studio Toast usage
Java