Uploading and Downloading Images in MaxDB Database

[Former Member]

Uploading and Downloading Images in MaxDB Database

This weblog discusses the simple steps to upload and download images to MaxDB Database server. The necessary java programs used to perform the above operation are also available for further reference. This is a continuation of the previous blog but just shows how easy it is to save images in MaxDB and retrive the same.

Upload Images into MaxDB Database

The below given program performs the image upload into MaxDB. The result of the same is also given below. /* * Created on Jun 20, 2005 * * To change the template for this generated file go to * Window>Preferences>Java>Code Generation>Code and Comments */package com.MaxDBImage;import java.sql.*;import java.io.*;/** * @author kathirvel * * To change the template for this generated type comment go to * Window>Preferences>Java>Code Generation>Code and Comments */public class InsertImageToMaxDB { /**  * The required variables are being declared here.   */ String fileId = null; String fileDes = null; String fileName = null;  String  Server = "localhost",Database="TEST",User="DBADMIN",Password="maxdb"; PreparedStatement preStatement = null;  /**  * The constructors are created for the program.   */ public InsertImageToMaxDB(String fileId,String fileDes, String fileName) {  this.fileId = fileId;  this.fileDes = fileDes;  this.fileName = fileName;   }  /**  * This is will establish a connection with MaxDB server and will insert the  * image into it.   */ public void insertImage(){    System.out.println("Establishing connection to Server: "+Server);    try{   Connection connection = DriverManager.getConnection("jdbc:sapdb://" + Server + "/" +  Database, User, Password);   // Preparing the query to be executed   preStatement = connection.prepareStatement("insert into addimage values(?,?,?)");               // Setting the actual values in the query   preStatement.setString(1,fileId);   preStatement.setString(2,fileDes);      // A file reader to get the contents of image   FileInputStream fi=new FileInputStream(fileName);   byte[] Img= new byte[fi.available()+1];   fi.read(Img);   preStatement.setBytes(3,Img);      // Executing the SQL Query   preStatement.execute();   System.out.println("Image Successfully inserted into MaxDB!");               // Closing the connection parameters   connection.close();   preStatement.close();  } catch(Exception e) {   // Prints if any exception is raised   System.out.println(" Exceptions : "+e);  } } public static void main(String[] args) {    String fileId = null;  String fileDes = null;  String fileName = null;      // Loading the MaxDB JDBC driver class  System.out.println("Loading JDBC Driver for MaxDB");     try {   // This is where we load the driver   Class.forName("com.sap.dbtech.jdbc.DriverSapDB");   System.out.println("The JDBC Driver has been loaded");  } catch (ClassNotFoundException e) {   // Prints if any exception is raised   System.out.println("Unable to load JDBC Driver");   return;  }    // Reading input values for the fileId, fileDes and fileName  try{   BufferedReader br = new BufferedReader(new InputStreamReader(System.in));   System.out.print("\nPlease enter the fileId:");   fileId = br.readLine();   System.out.print("\nPlease enter the fileDes:");   fileDes = br.readLine();   System.out.print("\nPlease enter the fileName(With Full path):");   fileName = br.readLine();     }catch(Exception ex){   System.out.println("Exception Raised:"+ex.toString());  }    // Creating a new instance for the   InsertImageToMaxDB Ins = new InsertImageToMaxDB(fileId,fileDes,fileName);  Ins.insertImage();   }}

Executing the Program

Checking the Entry

Download Image from MaxDB Database

The below given program performs the image download from MaxDB. The result of the same is also given below. /* * Created on Jun 20, 2005 * * To change the template for this generated file go to * Window>Preferences>Java>Code Generation>Code and Comments */package com.MaxDBImage;import java.sql.*;import java.io.*;/** * @author kathirvel * * To change the template for this generated type comment go to * Window>Preferences>Java>Code Generation>Code and Comments */public class DownloadImageFromMaxDB {  String fileId = null; String fileName = null; String  Server = "localhost",Database="TEST",User="DBADMIN",Password="maxdb"; ResultSet rs = null;   /**  * The constructors are created for the program.   */ public DownloadImageFromMaxDB(String fileId, String fileName) {  this.fileId = fileId;  this.fileName = fileName; }  public void downloadImage(){    System.out.println("Establishing connection to Server: "+Server);    try{   //Establishing the connection with the database   Connection connection = DriverManager.getConnection("jdbc:sapdb://" + Server + "/" +  Database, User, Password);          Statement statement = connection.createStatement();       // Executing the SQL Query   rs = statement.executeQuery("select * from addimage where imgId ='"+fileId+"'");   // Processing the resultset and downloading image to the local system      while (rs.next()) {    System.out.println("Downloading image from MaxDB!");    System.out.println(rs.getString(1)+"\t"+rs.getString(2));    byte[] image = rs.getBytes(3);    FileOutputStream fos = new FileOutputStream(new File(fileName));     fos.write(image);    System.out.println("The Image has been successfully downloaded!");   }   // Closing the connection parameters   rs.close();   statement.close();   connection.close();  } catch(Exception e) {   // Prints if any exception is raised   System.out.println(" Exceptions : "+e);  }   }  public static void main(String[] args) {  // Declaring the variables for passing the inputs  String fileId = null;  String fileName = null;    BufferedReader in = new BufferedReader(new InputStreamReader(System.in));    // Loading the MaxDB driver for database access  try{   Class.forName("com.sap.dbtech.jdbc.DriverSapDB");   System.out.println("The Driver has been loaded successfully!");  }catch(Exception e1){   System.out.println("Unable to load the error!");   System.out.println("Exceptions:"+e1.toString());  }    // Reading the necessaary inputs for the processing  try{   System.out.print("Enter the fileId:");   fileId = in.readLine();   System.out.print("\nEnter the FileName(with full path):");   fileName = in.readLine();   System.out.println("The Values entered are:"+fileId+" "+fileName);  }catch(Exception e2){   System.out.println("Exceptions:"+e2.toString());  }     // Creating a new instance for processing  DownloadImageFromMaxDB downLoad = new DownloadImageFromMaxDB(fileId,fileName);  downLoad.downloadImage(); }}

Executing the Program

Checking the Downloaded file

This is a very simple weblog. Hope this was useful to you.