How to insert Image in MySQL Database using Java in NetBeansIDE
How to insert Image in MySQL Database with Java in NetBeansIDE.
1. Open NetBeansIDE
2. Make a new Java Application project.
3. Make a JFrame Form and Design it as in this project.
4. Right Click on 'Choose File' button and Goto events~action~actionPerformed
5. Make a table in your MySQL DB say 'Image' with one Image column of LongBlob type.
6. Enter the code in it(in actionPerformed for Choose File Button).
(Fix all imports)
JFileChooser fc=new JFileChooser();
fc.showOpenDialog(this);
File f=fc.getSelectedFile();
String path=f.getAbsolutePath();
jLabel1.setIcon(new ImageIcon(path));
try{
FileInputStream fin=new FileInputStream(f);
int len=(int)f.length();
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/new", "root", "root");
PreparedStatement ps=con.prepareStatement("insert into `Image` values(?)");
ps.setBinaryStream(1, fin, len);
int status=ps.executeUpdate();
if(status is greater than 0)
{
jLabel2.setText("Successfully inserted in DB");
}else{
jLabel2.setText("Image not inserted!");
}
}catch(Exception e){System.out.println(e);
}
6. Run the JFrame Form.
7. Choose the file to insert in DB.
8. Check the File in DB.
9. Finish.
Thank You :)
#java #NetBeansIDE #programming #coding #developer #mysql
Watch video How to insert Image in MySQL Database using Java in NetBeansIDE online without registration, duration hours minute second in high quality. This video was added by user raksrahul 22 August 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 13,727 once and liked it 43 people.