The Greek lowercase omega (ω) character is use...

Reference Rose India.

This is detailed simple java code that how save image into mysql database. Before running this java code you need to create data base and table to save image in same database. In the example given below we have used database ‘mahendra’ and table ‘save_image’.

Structure of table ‘save_image’

First create database named ‘mahendra’ by query given below:

mysql> create database mahendra;

and create table by query given below:

CREATE TABLE save_image (             
              id int(5) NOT NULL auto_increment,  
              name varchar(25) default NULL,      
              city varchar(20) default NULL,      
              image blob,                         
              Phone varchar(15) default NULL,     
              PRIMARY KEY  (`id`)                   
 );

Save table ‘save_image‘ in database ‘mahendra‘. Before running this java code you need mysql connector jar in the jdk1.6.0_01./lib.

SaveImageToDatabase java file provides full code for uploading image in database.

SaveImageToDatabase.java

import java.sql.*;
import java.io.*;
class SaveImageToDatabase {
public static void main(String[] args) throws SQLException {
// declare a connection by using Connection interface 
Connection connection = null;
/* Create string of connection url within specified format with machine 
name, port number and database name. Here machine name id localhost 
and database name is mahendra. */
String connectionURL = "jdbc:mysql://localhost:3306/mahendra";
/*declare a resultSet that works as a table resulted by execute a specified 
sql query. */
ResultSet rs = null;
// Declare prepare statement.
PreparedStatement psmnt = null;
// declare FileInputStream object to store binary stream of given image.
FileInputStream fis;
try {
// Load JDBC driver "com.mysql.jdbc.Driver"
Class.forName("com.mysql.jdbc.Driver").newInstance();
/* Create a connection by using getConnection() method that takes 
parameters of string type connection url, user name and password to 
connect to database. */
connection = DriverManager.getConnection(connectionURL, "root", "root");
// create a file object for image by specifying full path of image as parameter.
File image = new File("C:/image.jpg");
/* prepareStatement() is used for create statement object that is 
used for sending sql statements to the specified database. */
psmnt = connection.prepareStatement
("insert into save_image(name, city, image, Phone) "+ "values(?,?,?,?)");
psmnt.setString(1,"mahendra");
psmnt.setString(2,"Delhi");
psmnt.setString(4,"123456");
fis = new FileInputStream(image);
psmnt.setBinaryStream(3, (InputStream)fis, (int)(image.length()));
/* executeUpdate() method execute specified sql query. Here this query 
insert data and image from specified address. */ 
int s = psmnt.executeUpdate();
if(s>0) {
System.out.println("Uploaded successfully !");
}
else {
System.out.println("unsucessfull to upload image.");
}
}
// catch if found any exception during rum time.
catch (Exception ex) {
System.out.println("Found some error : "+ex);
}
finally {
// close all the connections.
connection.close();
psmnt.close();
}
}
}

Output of the program:

Download Source Code

Advertisements
Comments
  1. Dipendra Kumar says:

    Hello Zeeshan, your code provided above running successfully, but can u tell me how to retrieve the image from database onto jsp page ??????

    • use that code in Servlet

      protected void processRequest(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {

      java.sql.Connection con = null;
      try {

      con = DbConnection.getDbConnection();
      Statement st1 = con.createStatement();
      ResultSet rs1 = st1.executeQuery(“SELECT images FROM forecupdatereport where IDUPDATEREPORT='” + request.getParameter(“url”) + “‘”);
      String imgLen = “”;

      if (rs1.next()) {
      imgLen = rs1.getString(1);
      //System.out.println(imgLen.length());
      int len = imgLen.length();
      byte[] rb = new byte[len];
      InputStream readImg = rs1.getBinaryStream(1);
      int index = readImg.read(rb, 0, len);
      //System.out.println(“index”+index);
      st1.close();
      response.reset();
      response.setContentType(“image/jpg”);
      response.getOutputStream().write(rb, 0, len);
      response.getOutputStream().flush();
      }
      } catch (Exception e) {
      e.printStackTrace();
      } finally {
      try {
      con.close();
      } catch (Exception ex) {
      ex.printStackTrace();
      }
      }
      }

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s