I am new to database. Can u plz guide me to store excel file in blob column.
You already were 'guided' by the article provided in the link above.
Repeating your question will not get you any help. If you don't understand that article then you have to ask specific questions.
If you don't know how to connect to or use a database we can't help you. You will need to search the net for a tutorial and follow the training it provides.
I mean that I have design a jsp page. There is a excel file on my system. A browse button on jsp page. When i browse excel file on my system n hit Read
file button it shows all the contents ofexcel file on jsp page. Now my requirement is when i do some changes on excel file which is on jsp,changes also
made in my database on save the file.so how to load excel file in database. . . .
> I mean that I have...
Still isn't clear...
Perhaps your question is really nothing more than that currently your server (system?) is reading an excel file from the file system and now you what to read it from a database. However note that that statement has nothing at all to do with JSP nor "showing" it. If that is your question then you would store the excel file as a blob in the database and you would query the blob from the database to get it. If you google just for examples for reading and writing blobs then you will find plenty of examples. And the examples do NOT need to be about excel, the type of data is irrelevant.
I never store Excel documents in a database. I extract the information from the excel document and store it in properly normalized database tables. This way, the data can be queried (SQL). If I then need to, I can pull the data out of the database and populate a new Excel spreadsheet and send it to the customer. Also, by not putting an Excel document in the database via a blob, I'm not storing some increasingly old version of Excel. Additionally, instead of returning an Excel document to the user, you might consider returning a comma delimited file. That way, the user can open it in whatever he wants. Note if your data contains commas, you have to escape them correctly in a comma delimited file.
By the way, I do a full validation on the excel data before accepting it into my database (shouldn't trust external sources of data).