EmployeeInit.java Source code

Introduction

Here is the source code for EmployeeInit.java

Source

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();
    }
}