×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

Upload PDF File MySQL DataBase

0
0
 
0
Language: Java
Posted by: Yts 95
Added: Feb 28, 2021 1:26 PM
Views: 4927
Tags: no tags
  1. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        
  2.         JFileChooser chooser = new JFileChooser();
  3.         chooser.showOpenDialog(null);
  4.         File f = chooser.getSelectedFile();
  5.         String filename = f.getAbsolutePath();
  6.         path = filename;
  7.          newpath = path.replace('\\', '/');
  8.     }                                        
  9.  
  10.  
  11.  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
  12.  
  13.         try{
  14.         File newpdf = new File(newpath);
  15.         FileInputStream fis = new FileInputStream(newpdf);
  16.         ByteArrayOutputStream baos= new ByteArrayOutputStream();
  17.         byte[] buff = new byte[2048000];
  18.         for(int readNum; (readNum=fis.read(buff)) !=-1 ; ){
  19.             baos.write(buff,0,readNum);
  20.         }
  21.  
  22.         userpdf=baos.toByteArray();
  23.  
  24.  
  25.     }
  26.     catch(Exception e){
  27.         JOptionPane.showMessageDialog(null, e);
  28.     }
  29.  PreparedStatement pstmt = null;
  30.  
  31.         try{
  32.              Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ppl","root","");
  33.              String proj_name = JOptionPane.showInputDialog("Please enter name of the file");
  34.              /*
  35.              String insert = "INSERT INTO project VALUES ('" + login.admission + "','" + login.yr + "','" + proj_name + "','" + userpdf + "')";
  36.  
  37.              java.sql.PreparedStatement pst = con.prepareStatement(insert);
  38.              pst.executeUpdate(insert);*/
  39.  
  40.              String sql = "INSERT INTO project"+"VALUES (?,?,?,?)";
  41.  
  42.  
  43.         pstmt = (PreparedStatement) con.prepareStatement(sql);
  44.         pstmt.setString(1, login.admission);
  45.         pstmt.setString(2, login.yr);
  46.         pstmt.setString(3, proj_name);
  47.         pstmt.setBlob(4, userpdf); //This line has an error may be because of userpdf.Plz //suggest
  48.  
  49.         pstmt.executeUpdate();
  50.  
  51.  
  52.         JOptionPane.showMessageDialog(null, "Saved");
  53.     }
  54.     catch(Exception e){
  55.         JOptionPane.showMessageDialog(null, e);
  56.     }

1 comment

ankita gupta 7 days ago
Reply
Can you post the complete code please?

Write a comment

To post comments, please log in or register.