Displaying Image stored in MSSQL Server

[deshdeep divakar]

Hi,
There I have written a piece of code for storing the image
into database and retriving it.

import java.io.*; 
import java.sql.*; 
import java.util.*; 
 

 
public class StoreFile 
{ 
Connection con=null; 
//DataBase db = null; 
String filename=null; 
String filedesc=null; 
 
public StoreFile() 
{ 
 
} 
 
public StoreFile(String filedesc,String filename) 
{ 
this.filedesc = filedesc; 
this.filename=filename; 
} 
 
public void storeFile() throws Exception 
{ 
System.out.println("Before DataBase Connection "); 
PreparedStatement pst = null; 
 
try 
{ 
                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                                     con=DriverManager.getConnection("jdbc :-o	 dbc:RT"," "," ");
                 
pst = con.prepareStatement("insert into pic values(?,?)"); 

pst.setString(1,filedesc); 
FileInputStream fis=new FileInputStream(filename); 
byte[] b= new byte[fis.available()+1]; 
fis.read(b); 
pst.setBytes(2,b); 
pst.executeUpdate(); 
System.out.println("File Stored Successfully"); 
} 
catch(Exception e) 
{ 
System.out.println(" Problem : "+e); 
} 

finally 
{ 
con.close(); 
pst.close(); 
} 
 
} 
 
public void getFile(String filename1) throws Exception 
{ 
System.out.println("Before DataBase Connection1"); 
PreparedStatement pst = null; 
ResultSet rs=null; 
try 
{ 
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                          con=DriverManager.getConnection("jdbc :-o	 dbc:RT"," "," ");
      
      pst = con.prepareStatement("select images from pic where ftype=?"); 
     pst.setString(1,filename1); 
                        rs=pst.executeQuery();       
      while(rs.next()) 
      { 
byte[] b=rs.getBytes("images"); 
                                    System.out.println("b size= "+b.length);
FileOutputStream fos=new FileOutputStream(new File("new1.html")); 
fos.write(b);
System.out.println("size= "+fos);
fos.flush(); 
fos.close();

       } 

System.out.println("File Written Successfully"); 
} 
catch(Exception e) 
{ 
System.out.println(" Problem : "+e); 
} 
finally 
{ 
con.close(); 
pst.close(); 
} 
 
} 
 

 
public static void main(String args[]) throws Exception 
{ 
System.out.println("What is The File Description "); 
String filedesc =new BufferedReader(new 
 
InputStreamReader(System.in)).readLine(); 
System.out.println("What is The File Name"); 
String filename = new BufferedReader(new 
 
InputStreamReader(System.in)).readLine(); 
StoreFile store = new StoreFile(filedesc,filename); 
store.storeFile(); 
System.out.println("What is The File Description ");
String filename1 = new BufferedReader(new 
 
InputStreamReader(System.in)).readLine(); 
store.getFile(filename1); 

} 
 
}   

Data Base have following fields:
ftype varchar attribute and images image

Code is fetching the image but could'nt able to display that

Check Out

[deshdeep divakar]

I have changed the code as follows:

import java.io.*; 
import java.sql.*; 
import java.util.*; 
 
public class StoreFile 
{ 
Connection con=null; 
String filename=null; 
String filedesc=null; 
 
public StoreFile() 
{ 
 
} 
 
public StoreFile(String filedesc,String filename) 
{ 
this.filedesc = filedesc; 
this.filename=filename; 
} 
 
public void storeFile() throws Exception 
{ 
System.out.println("Before DataBase Connection "); 
PreparedStatement pst = null; 
 
try 
{ 
                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                                     con=DriverManager.getConnection("jdbc :-o	 dbc:RT"," "," ");
                 
pst = con.prepareStatement("insert into pic values(?,?)"); 

pst.setString(1,filedesc); 
FileInputStream fis=new FileInputStream(filename); 
byte[] b= new byte[fis.available()+1]; 
fis.read(b); 
pst.setBytes(2,b); 
pst.executeUpdate(); 
System.out.println("File Stored Successfully"); 
} 
catch(Exception e) 
{ 
System.out.println(" Problem : "+e); 
} 

finally 
{ 
con.close(); 
pst.close(); 
} 
 
} 
 
public void getFile(String filename1) throws Exception 
{ 
System.out.println("Before DataBase Connection1"); 
PreparedStatement pst = null; 
ResultSet rs=null; 
String s1="gif";
try 
{ 
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                          con=DriverManager.getConnection("jdbc :-o	 dbc:RT"," "," ");
      
      pst = con.prepareStatement("select images from pic where ftype=?"); 
      pst.setString(1,filename1); 
                        rs=pst.executeQuery();       
      while(rs.next()) 
      { 
byte[] b=rs.getBytes("images"); 
                                    System.out.println("b size= "+b.length);
if(filename1.equals(s1))
{
                                    FileOutputStream fos=new FileOutputStream(new File(".gif ")); 
 
                  fos.write(b,0,b.length);
fos.flush(); 
fos.close();
}
else
{
                                                      FileOutputStream fos=new FileOutputStream(new File(".jpg ")); 
fos.write(b,0,b.length);
fos.flush(); 
fos.close();
}

       } 

System.out.println("File Written Successfully"); 
} 
catch(Exception e) 
{ 
System.out.println(" Problem : "+e); 
} 
finally 
{ 
con.close(); 
pst.close(); 
} 
 
} 
 

 
public static void main(String args[]) throws Exception 
{ 
System.out.println("What is The File Description "); 
String filedesc =new BufferedReader(new 
 
InputStreamReader(System.in)).readLine(); 
System.out.println("What is The File Name"); 
String filename = new BufferedReader(new 
 
InputStreamReader(System.in)).readLine(); 
StoreFile store = new StoreFile(filedesc,filename); 
store.storeFile(); 
System.out.println("What is The File Description ");
String filename1 = new BufferedReader(new 
 
InputStreamReader(System.in)).readLine(); 
store.getFile(filename1); 

} 
 
}   

now problem is its not diplaying the Filename passed as
command line