java导入导出pdf文档实践

1:mysql数据库存储pdf流字段为:filed name: filestream   type: MEDIUMBLOB

2:导入pdf文件到mysql 数据库 

private   void  doWrite()  ... {
        try ...{
            
            if (new File("D:/Sun.pdf").exists()) ...{
                FileInputStream fis = new FileInputStream(new File(
                        "D:/Sun.pdf"));
                PreparedStatement pstmt = cnn
                        .prepareStatement("insert into tb(filestream) values(?) ");
                pstmt.setBinaryStream(1, fis, 1024);
                pstmt.execute();
            }
        } catch (Exception e) ...{
            e.printStackTrace();
        }
    }

 

3:从mysql数据库读取pdf流到网页客户端显示

private   void  doRead(HttpServletRequest request, HttpServletResponse response)  ... {
        try ...{
            ByteArrayOutputStream ba = new ByteArrayOutputStream();
            Statement stmt = cnn.createStatement();
            ResultSet rs = stmt.executeQuery("select filestream from tb where id=1");
            rs.next();
            InputStream is = rs.getBinaryStream(1);