java附件上传下载大字段版

最新推荐文章于 2024-10-17 10:27:13 发布

weixin_30549175

最新推荐文章于 2024-10-17 10:27:13 发布

阅读量93

点赞数

文章标签： java

原文链接：http://www.cnblogs.com/fxfly/p/4784809.html

版权

public int up2(Map map) {
        StringBuffer insertSQL = new StringBuffer();
        insertSQL.append("insert T_Sys_Attachment");
        insertSQL.append("(Id,A_OwnerId,A_Size,A_Title,A_Body,Type,A_Category,A_OwnerXh");
        insertSQL.append(")values(?,?,?,?,?,?,?,?) ");

        InputStream is = null;
        int row = 0;
        try {
            con.setAutoCommit(false);
            ps = con.prepareStatement(insertSQL.toString());
            /*
             * this.del(String.valueOf(map.get("a_ownerid")),
             * String.valueOf(map.get("type")));
             */
            ps.setObject(1, map.get("id"));
            ps.setObject(2, map.get("a_ownerid"));
            ps.setObject(3, map.get("a_size"));
            ps.setObject(4, map.get("a_title"));
            is = new FileInputStream((File) map.get("a_body"));
            ps.setBinaryStream(5, is, is.available());
            ps.setObject(6, map.get("type"));
            ps.setObject(7, map.get("a_category"));
            ps.setObject(8, map.get("a_ownerxh"));
            row = ps.executeUpdate();
            con.commit();

        } catch (SQLException e) {
            e.printStackTrace();
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            this.close();
        }
        return row;
    }