problem related to image..

Anonymous User 2711 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.

Ask by Anonymous User

Updated 20 Dec 2010

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

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

problem related to image..

Can you answer this question?

1 Answers