hi,i use mysql database, and i want to save an image to the database using JDBC.Should i set the data type as blob? i know getting the image from the database use ResultSet.getBinaryStream(),but i don't know how to save it to the database.who can tell what to do? please help! thanks you!!!
On a side note, it is my opinion that saving images in a database is not the best idea unless that is your only option. I will typically create an entry in the database as to a location on the hard drive of the image. You will maintain better performance on your Tables if you do it this way.
A good file system alternative would not use the true filename as the filename on the file system. It would use a unique ID as the filename on the hard-drive, and store the real filename in a table... EX - table name "IMAGES" columns "ID" and "FILENAME". However, this is only good when the image only needs to be read by code residing on the server. If you are writing client/server with swing or something - it woun't be able to use it as a file. You'd have to setup shares, or some type of stream to the client. If this is the case, I'd store it in the DB.