/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 vote139 views1 answer
Generate infinity steam java
Java
1 vote92 views1 answer
System.out.println giving error syntax error on token ".", @ expected after this token
Java
1 vote145 views1 answer
Chenge font android studio
Java
0 vote149 views1 answer
Keytool error: java.io.FileNotFoundException: my-release-key.keystore (Access is denied) java.io.FileNotFoundException: my-release-key.keystore (Access is denied)
Java
2 votes161 views1 answer
Taking date as input in java
Java
0 vote134 views1 answer
How does java knows where it has stored primitive data type
Java
32 votes135 views10 answers
Translate
Java
0 vote132 views1 answer
Intent pick action video android
Java
1 vote152 views2 answers
Use findviewbyid in fragment
Java
1 vote158 views1 answer
Linear layout background color
Java