Mega Code Archive

 

Categories / Java / Database SQL JDBC

 

Save image to derby database

import java.io.ObjectOutputStream; import java.sql.Blob; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import javax.swing.ImageIcon; public class EmployeeInit {   public static void main(String[] args) throws Exception {     Connection con;     con = DriverManager.getConnection("jdbc:derby://localhost:1527/" + "c:\\db\\employee");     PreparedStatement ps;     ps = con.prepareStatement("insert into employee(name,photo) " + "values(?,?)");     ps.setString(1, "Duke");     Blob blob = con.createBlob();     ImageIcon ii = new ImageIcon("duke.png");     ObjectOutputStream oos;     oos = new ObjectOutputStream(blob.setBinaryStream(1));     oos.writeObject(ii);     oos.close();     ps.setBlob(2, blob);     ps.execute();     blob.free();     ps.close();   } }