forum

Home / DeveloperSection / Forums / problem related to image..

Ask Question

problem related to image..

Anonymous User 2344 18-Dec-2010
 problem related to image..i am creating web application in j2ee, and i used oracle in backend
i have insert the image in oracle by using blob datatype
problem in fetching the image from oracle
how we write the code in java to fetching the image and show in image box. problem related to image..
java java 
Updated on 20-Dec-2010
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Amit Singh

Amit Singh

20-Dec-2010
we use the following syntax :
ps.setBinaryStream(int parameterIndex, InputStream x, int length)
where ps is the object of prepared statement

use this code
example:
file=new File("C:/Picture/Sun.jpg"); 
fleInStream=new FileInputStream(file); 

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
c=DriverManager.getConnection("Jdbc:Odbc:image","scott","tiger"); 
s=c.createStatement(); 

ps=c.prepareStatement("insert into tblImage values(?,?)"); 
ps.setInt(1,2); 
ps.setBinaryStream(2,fleInStream,(int)file.length()); 
System.out.println("success"); 
ps.execute(); 
ps.close(); 
c.close();

Liked By