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?

Comments

Post a Comment

Popular posts from this blog

Hibernate auto increment with example

how to count the page views by using JSP

Multithreading in java with example

How to retrieve data from table by using JDBC with example

Prime, Fibonacci and Factorial number with example in java

How to sort list of objects in java with examples

String interview questions and answers

Exception in thread "main" java.lang.NoClassDefFoundError: javax/transaction/SystemException

Store file into table by using JDBC with example