Java 将本地文件保存到数据库

    public void Send(){

        try {

            FileInputStream fis = new FileInputStream(file);

            System.out.println(file);

            System.out.println(fis);

            String AttachID=null; //附件ID

            String sql="select newid() 'ID'";

            PreparedStatement pst=cn.prepareStatement(sql);

            ResultSet rs=pst.executeQuery();

            if(rs.next()){

                AttachID=rs.getString("ID").trim();

            }

            rs.close();

            pst.close();

            if(AttachID!=null){

                /*开启事务*/

                cn.setAutoCommit(false);

                /*插入附件表*/

                String sql1="insert into SESSION_ATTACHMENT values('"+ AttachID +"','"+ gbl_SessionID +"',?,getdate(),'"+ gbl_SenderID +"','"+ file.getName() +"')";

                PreparedStatement pst1=cn.prepareStatement(sql1);

                pst1.setBinaryStream(1, fis,(int)(file.length()));

                pst1.executeUpdate();

                pst1.close();

                /*插入附件接收者*/

                for(int i=0;i
  
  

                    //NODE_OBJECT no=(NODE_OBJECT) gbl_vtReceiver.get(i);

                    sql1="insert into SESSION_ATTACHMENT_RECEIVER (ATTACH_ID,SESSION_ID,RECEIVER) VALUES ('"+ AttachID +"','"+ gbl_SessionID +"','"+ gbl_vtReceiverID.get(i).toString() +"')";

                    pst1=cn.prepareStatement(sql1);

                    pst1.executeUpdate();

                    pst1.close();

                }

                cn.commit();

                cn.setAutoCommit(true);

                JOptionPane.showMessageDialog(this, "文件"+file.getName()+"发送成功！","提示",JOptionPane.INFORMATION_MESSAGE);

                this.dispose();

            }

        } catch (SQLException ex) {

            try {

                cn.rollback();

                cn.setAutoCommit(true);

            } catch (SQLException ex1) {

                Logger.getLogger(SEND_FILE.class.getName()).log(Level.SEVERE, null, ex1);

            }

            JOptionPane.showMessageDialog(this, "出错！原因："+ex.getMessage(),"提示",JOptionPane.ERROR_MESSAGE);

            Logger.getLogger(SEND_FILE.class.getName()).log(Level.SEVERE, null, ex);

        } catch (FileNotFoundException ex) {

            JOptionPane.showMessageDialog(this, "出错！原因："+ex.getMessage(),"提示",JOptionPane.ERROR_MESSAGE);

            Logger.getLogger(SEND_FILE.class.getName()).log(Level.SEVERE, null, ex);

        }

    }