How to save images provided by a user to a database using Java

Question

I am planning how I to write a GUI Java application that displays a form to the user to add information about themselves. One of the things I want to include is the ability for the user to add a picture to the form. Upon submission the picture and the rest of the info will then be saved to a database. Being new to java I was hoping for some instructional Links or tips as to how to accomplish this. I was thinking of setting one of my columns in my table as a 'BLOB' type and then saving them to it, but that is just a shot in the dark. I really don't know what the column type should be (byte, blob, ect...), or how to code so that the picture will be saved to my database for display later. I guess my question is how to get and save a picture to a database from a form. I am going to attempt this using eclipse, and am still unsure what I will use for the database. Sorry about any confusion, and thanks for reading!!

Drew

I cant find anything on how to save a picture that a USER inputs, only how to save hard-coded images — Drew B
– Drew B, Commented Mar 25, 2013 at 21:45
Will this help How to upload an image and save it in database? — Smit
– Smit, Commented Mar 25, 2013 at 21:47
use html tag <input type="file"> to get the file corresponding to the image. Then do what you want with the file on server side (minimize, change encoding, store somewhere etc) — user2147970
– user2147970, Commented Mar 25, 2013 at 21:49
@Smit, another good read, but it is for Java-scripting and browsers. I am just going to create a simple Java application! — Drew B
– Drew B, Commented Mar 25, 2013 at 21:50

user2147970 · Accepted Answer · 2013-03-25 21:47:02Z

1

If you really want to store your image in the database, BLOB seems to be the most adapted type for the column holding the image.

But IMHO, those types of files do not have to be stored in a database. Just store them somewhere in a directory and just keep the image names (or a generated id) in your database.

answered Mar 25, 2013 at 21:47

user2147970

4122 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joni · Accepted Answer · 2013-03-25 21:45:36Z

0

You will need two columns in the database: a BLOB to hold the binary image data, and a text type (VARCHAR most likely) to store the file format. If you plan to use an API that automatically detects the image format you can use just the BLOB.

answered Mar 25, 2013 at 21:45

Joni

112k14 gold badges151 silver badges201 bronze badges

Collectives™ on Stack Overflow

How to save images provided by a user to a database using Java

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related