问题描述:

I'm working on a database project using Oracle Express Edition and using JDBC. I have an excel spreadsheet within the database that I am working with (editing, updating, etc.) I recently started reading about BLOBS, so I just have a general idea about what it is, but I would like to know if it's possible to use the BLOB library in my project in order to download the updated spreadsheet and save it to my computer. I need the updated files saved, and I would prefer if I did it by code. Is this possible, by importing the BLOB class into my project, and if so, how would I go about doing that?

网友答案:

I assume your question relates to this class.

It is important to note that a BLOB is a "Binary Large OBject", and it's a database term used to describe storing arbitrary serialized data into a database. The Java class here allows you to more easily access and modify such an object in a database. It is not referring to the database itself - or the similar spreadsheet you're using.

Your general question (while very broad and likely to get closed) is easily answered; yes. But you'd have to implement several parts:

  • Download the spreadsheet
  • Import updates into your database

The class you cite is useful for the latter, but perhaps not the former.

相关阅读:
Top