import java.sql.Connection;
import java.sql.Statement;

import javax.naming.InitialContext;
import javax.sql.DataSource;

import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUpload;

public void insertImg(FileItem item) {

    // DB接続用
    Connection con = null;
    PreparedStatement stmt = null;

    try {
        // DataSourceを使用しています
        InitialContext ic = new InitialContext();
        DataSource ds = (DataSource)ic.lookup("java:comp/env/jdbc/postgres");
        con = ds.getConnection();

        // AutoCommit解除
        con.setAutoCommit(false);

        // 画像登録用SQL
        String sql = "insert into image values(?,?,?)";

        stmt = con.prepareStatement(sql);

        // パラメータ設定
        stmt.setInt(1,1);
        stmt.setString(2,"image");
        stmt.setBinaryStream(3,item.getInputStream(), (int)item.getSize());

        // SQL実行
        stmt.executeUpdate();

        // コミット
        con.commit();

        // AutoCommit設定
        con.setAutoCommit(true);
    } catch (Exception ex) {
        ex.printStackTrace();
    } finally {
        //切断
        try{stmt.close();} catch(Exception e){}
        try{con.close(); } catch(Exception e){}
    }
}