How to insert images into database using JDBC?

How to insert images into database table by using JDBC? To know about these topic follow the below lines,

          Before going to write a JDBC program for inserting images into database table, we need to create a specific table for inserting images column datatype. For creating the database table, execute the below command in MySQL command prompt.

1 2 3 4

CREATE TABLE `images` ( `image_id` int(11) NOT NULL AUTO_INCREMENT, `image_flag` int(11) NOT NULL, `image` longblob NOT NULL, PRIMARY KEY (`image_id`));

          After executing the above query in MySQL command prompt, execute the below query to know weather the above table query is created or not.

1	Show tables;

          When you have executed the above query that will show you the list of table which all exists in the current database. Current table is present in that list, then we will move to write the JDBC program to insert images. Otherwise execute the above Create table query one more time and see the tables list.

          The above IMAGES table contains the columns as image_id, image_flag, image.

• Image_id is the primary key and not null. This is also auto increment column, means you no need to pass the value through the JDBC program for this column. 
• Image_flag represents the integer type value, this also refers the not null column. 
•  Inserting images will save in the image column. This is the LongBlob data type.

          Here is the JDBC program which will save the images into database table.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67

package com.javatbrains.jdbc; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; /** * @author SUBBU */ public class InsertImages { static String URL = "jdbc:mysql://localhost:3306/jbdc"; static String userName = "root"; static String password = "root"; public static void main(String[] args) { try { // Loads the MySQL Driver Class.forName("org.gjt.mm.mysql.Driver"); // get's Connection by using DriverManager class Connection con = DriverManager.getConnection( URL, userName, password); // images directory path String filePath = "D:/images"; // Creating File object with directory path File path = new File(filePath); /* * getting the list of files path under * directory and saving into * String type of array */ String[] pathList = path.list(); String query = "insert into images (image_flag, image) values(?,?)"; // Loading each file using for loop for (int i = 0; i < pathList.length; i++) { String filepath =filePath+"/"+ pathList[i]; System.out.println(filePath+"/"+ pathList[i]); FileInputStream inputStream = new FileInputStream (new File(filepath)); // creating prepared statement PreparedStatement ps = con.prepareStatement(query); ps.setInt(1, 1); ps.setBinaryStream(2, (InputStream) inputStream, filepath.length()); // Executing the prepared Statement int rows = ps.executeUpdate(); if (rows > 0) { System.out.println("Image Inserted Successfully"); } } } catch (FileNotFoundException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } }

Steps:

•  In this program we are using first type JDBC driver. Load the JDBC driver by using Class.forName() method. 
• Create connection by passing the URL, username and password in DriverManager class getConnection method. 
• Mention images directory path in String type of variable. 
• Pass images directories path in File to load all the images list. 
• Store list of images into an array, by using the array size we will execute the for loop. 
• Create the prepared statement and set the Image by using the setBinaryStream() method. 
• Execute the prepared statement by using the executeUpdate() method. 
• Execute the Insert images program to insert images into IMAGES table.

Do you know?

• JDBC Architecture and insertion example
• Downloading images from MySQL database by using JDBC
• Retrieve data from MySQL table using JDBC example
• Store files into MySQL database table by using JDBC example
• Retrieve file from MySQL database table by using JDBC example