Jumat, 10 April 2015

JAVA - How To Insert Image In MySQL Database Using Java

JAVA - How To Insert Image In MySQL Database In Java

__________________________________________________________________________

In this java Tutorial we will see How To Add Picture To MySQL database
In Java NetBeans .

*Java Courses : Java Complete Course

Java Swing Course

Project Source Code:


package JavaDB_001; import java.awt.Image; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import javax.swing.*; import javax.swing.filechooser.FileNameExtensionFilter; import java.io.File; import java.io.FileInputStream; import java.io.InputStream;   public class Work extends JFrame{     JButton button ;     JButton button2;     JLabel label;     JTextField textID;     JTextField textNAME;     JTextArea area;     String s;           public Work(){         super("insert image to database in java");          button = new JButton("ADD");     button.setBounds(200,300,100,40);          button2 = new JButton("Browse");     button2.setBounds(80, 300, 100, 40);          textID = new JTextField("ID");     textID.setBounds(320,290,100,20);      textNAME = new JTextField("Name");     textNAME.setBounds(320,330,100,20);      area = new JTextArea("DESCRIPTION",100, 100);          JScrollPane pane = new JScrollPane(area);     pane.setBounds(450, 270, 200, 100);          label = new JLabel();     label.setBounds(10,10,670,250);           //button to browse the image into jlabel     button2.addActionListener(new ActionListener(){         @Override      public void actionPerformed(ActionEvent e){          JFileChooser fileChooser = new JFileChooser();          fileChooser.setCurrentDirectory(new File(System.getProperty("user.home")));          FileNameExtensionFilter filter = new FileNameExtensionFilter("*.IMAGE", "jpg","gif","png");          fileChooser.addChoosableFileFilter(filter);          int result = fileChooser.showSaveDialog(null);          if(result == JFileChooser.APPROVE_OPTION){              File selectedFile = fileChooser.getSelectedFile();              String path = selectedFile.getAbsolutePath();              label.setIcon(ResizeImage(path));              s = path;               }          else if(result == JFileChooser.CANCEL_OPTION){              System.out.println("No Data");          }      }     });      //button to insert image and some data into mysql database     button.addActionListener(new ActionListener(){             @Override        public void actionPerformed(ActionEvent e){            try{                Connection con = DriverManager.getConnection("jdbc:mysql://localhost/db_images","root","");                PreparedStatement ps = con.prepareStatement("insert into myimages(ID,Name,Description,Image) values(?,?,?,?)");                InputStream is = new FileInputStream(new File(s));                ps.setString(1, textID.getText());                ps.setString(2, textNAME.getText());                ps.setString(3, area.getText());                ps.setBlob(4,is);                ps.executeUpdate();                JOptionPane.showMessageDialog(null, "Data Inserted");            }catch(Exception ex){                ex.printStackTrace();            }        }     });      add(label);     add(textID);     add(textNAME);     add(pane);     add(button);     add(button2);     setLayout(null);     setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);     setSize(700,420);     setVisible(true);     }          //Methode To Resize The ImageIcon     public ImageIcon ResizeImage(String imgPath){         ImageIcon MyImage = new ImageIcon(imgPath);         Image img = MyImage.getImage();         Image newImage = img.getScaledInstance(label.getWidth(), label.getHeight(),Image.SCALE_SMOOTH);         ImageIcon image = new ImageIcon(newImage);         return image;     }       public static void main(String[] args){         new Work();     }    } 
/////////////////////  END
///////////////OUTPUT:

Image From JLabel To MySQL Database