forum

home / developersection / forums / problem related to image..

problem related to image..

Anonymous User 2605 18-Dec-2010

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.

java

Updated on 20-Dec-2010

Anonymous User

Other

I am a content writter !

Message

Can you answer this question?

Answer

1 Answers

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();

forum

problem related to image..

Anonymous User

Can you answer this question?

1 Answers

Liked By