sample JSP code to upload file into database?

[rahul saxena]

hey all,
please give me the sample JSP source code to upload file as object into database.

thanks,
rahul

[Ben Keeping]

I take it you mean as a binary BLOB field in the db ?

  
File f = new File("myfile");
byte[] data = new byte[(int)f.length()];
FileInputStream fis = new FileInputStream(f);
fis.read(data);
fis.close();
 
Connection c = ...
PreparedStatement p = c.prepareStatement("insert into bla values (?)");
p.setBytes(1, data);
p.exectute();
p.close();
c.close();

[rahul saxena]

hi what for FileInputStream object used in the following code???

thanks

Originally posted by Ben Keeping:
I take it you mean as a binary BLOB field in the db ?

  
File f = new File("myfile");
byte[] data = new byte[(int)f.length()];
FileInputStream fis = new FileInputStream(f);
fis.read(data);
fis.close();
 
Connection c = ...
PreparedStatement p = c.prepareStatement("insert into bla values (?)");
p.setBytes(1, data);
p.exectute();
p.close();
c.close();

[sandip mense]

Rahul,

The FileInputStream is used to read streams of raw bytes such as image data. It obtains input bytes from a file in a file system.

Sandip

[Ben Keeping]

Your question is "how to upload file into a database" - so you use the FileInputStream to read the file ! Try out the API docs ...

Also, please do not crosspost threads (Servlet forum and JSP forum).

[David O'Meara]

This thread is a duplicate of the one here.

Please don't post the same question in multiple forums, it creates duplicate conversations and wastes the time of the people trying to help you. Like we have here.

Personally I think they should both be closed and one copy moved to JDBC, but since I have no control over the other forum this thread is closed.

Dave