Java & MySQL

 
// insertion image dans Base de données
 public void imageWrite(File file) {
try {

FileInputStream io = new FileInputStream(file);
String query = "insert into image(IMG) values(?)";
java.sql.PreparedStatement stmt = con.prepareStatement(query);
stmt.setBinaryStream(1, (InputStream)io,(int)file.length());
stmt.executeUpdate();
}
catch(Exception ex) {
System.out.println(ex.getMessage());
}
}

// lire image depuis base de données

public BufferedImage getImageById(int id) {
String query = "select IMG from image where IMG_ID = ?";
BufferedImage buffimg = null;
try {
PreparedStatement stmt = con.prepareStatement(query);
stmt.setInt(1,id);
ResultSet result = stmt.executeQuery();
result.next();
InputStream img = result.getBinaryStream(1); // lire l'image comme un InputStream
buffimg= ImageIO.read(img); // decodage de  l'inputstream comme BufferedImage

}
catch(Exception ex) {
System.out.println(ex.getMessage());
}
return buffimg;
}