This tutorial guide to insert image into mysql database using java project (JFrame). in next tutorial show you, how to display image using java code from MySQL database. Please note that I used LONG BLOB that can handle up to 2,048 KiB of data.
Do you need help to remotely set up my any project on your machine or customize any project with your requirement please contact syntech1994@gmail.com
Follow these steps to insert image into mysql database
Step 01 Open New java project
Step 02 Create Database
Should create a database and a table to store the images. The image store field of the table should be LONG BLOB data type.
Step 03 creates a database connection with java project
Database Connections of insert image into mysql database project
package image;
import java.sql.Connection;
import java.sql.DriverManager;
public class DBConnect {
public static Connection connect()
{
Connection con=null;
try {
Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/yourDatabaseNameHere?","DatabaseUserNameHere","DatabasePasswordHere");
}
catch (Exception e)
{
System.out.println("inter.DBConnect.connect()");
}
return con;
} Add “MySQL.jdbc.Driver” to the project library.
If you need more information to connect Netbeans with Mysql database please watch this video
Step 04 Add new JFrame to project
Add a label and two buttons to JFrame
Source code for insert image into mysql database
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import javax.swing.ImageIcon;
import javax.swing.JFileChooser;
import java.awt.Image;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Main extends javax.swing.JFrame {
private ImageIcon format=null;
String fname=null;
int s=0;
byte[] pimage=null;
Connection conn=null;
public Main() {
initComponents();
conn=DBConnect.connect();
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// using this code you can brows image and image set to lable
JFileChooser fchoser=new JFileChooser();
fchoser.showOpenDialog(null);
File f=fchoser.getSelectedFile();
fname=f.getAbsolutePath();
ImageIcon micon=new ImageIcon(fname);
try {
File image=new File(fname);
FileInputStream fis=new FileInputStream(image);
ByteArrayOutputStream baos=new ByteArrayOutputStream();
byte[] buf=new byte[1024];
for(int readnum; (readnum=fis.read(buf)) !=-1;)
{
baos.write(buf,0,readnum);
}
pimage=baos.toByteArray();
lableVeriableName.setIcon(resizeImage(fname, buf));
} catch (Exception e) {
}
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// This code use to insert image to database
String id=txtid.getText();
try {
String q= "INSERT INTO `img`(`id`, `image`) VALUES (?,?)";
PreparedStatement pst=conn.prepareStatement(q);
pst.setString(1, id);
pst.setBytes(2, pimage);
pst.execute();
} catch (Exception e) {
}
}
// This code use to resize image to fit lable
public ImageIcon resizeImage(String imagePath, byte[] pic){
ImageIcon myImage=null;
if(imagePath !=null)
{
myImage=new ImageIcon(imagePath);
}else{
myImage=new ImageIcon(pic);
}
Image img=myImage.getImage();
Image img2=img.getScaledInstance(lblimage.getHeight(), lblimage.getWidth(), Image.SCALE_SMOOTH);
ImageIcon image=new ImageIcon(img2);
return image;
}