How to upload an image into database ?

Question

0.00/5 (No votes)

See more:

Hello everyone,

I am completing my project. That is last corner. But During the day(8 hours) I couldnt step a step. Please help me. I will explain clearly.

I want to add instructors into my database which is an jdbc. I created database it is working there is no problem with connection.

An instructor will have this information.
*Name
*Surname
*Title
*İmage (This is so important)

I have created Jpanel in netbeans.

http://www.imagetoo.com/images/untitlqfq.png[^]

As you can see in this picture, I cant put a picturebox or whatever it is. I want something like filechooser.

Namely my first problem is this.

Second problem is how to create a table with image. Namely I have used varchar or integers. Based on my research I have seen blob? but I didint understand I am making my image column type as blob but errors.
Last problem is with 'ID' column. I am taking an error similar ID column can not be assigned to a null value.

And here is my database view.

http://www.imagetoo.com/images/untitlkhk.png[^]

ID > Integer
Image > BLOB
Others >Varchar

If someone helps me I will be very very happy. This is very important for me. I am adding my java code.
SAVE BUTTON CODE

Java

try {
           //1.Kısım Baglantı Saglıyoruz
           this.host = "jdbc:derby://localhost:1527/EMRE";
           this.Name = "emre";
           this.Pass = "2561";
           Connection con = DriverManager.getConnection(host,Name,Pass);

           //2.Kısım Statement Olusturuyorum

           Statement cumle = con.createStatement();


           cumle.executeUpdate("INSERT INTO INSTRUCTOR " + " (INAME, ISURNAME, ITITLE,ID)" + " VALUES ('"+txtInstName.getText()+"','"+txtInstSurname.getText()+"','"+cmbInstTitle.getSelectedItem()+"')");
           JOptionPane.showMessageDialog(null, cmbInstTitle.getSelectedItem()+txtInstName.getText()+ " " + txtInstSurname.getText()+"Has Been Added");
           }
       catch (SQLException ex) {
           JOptionPane.showMessageDialog(null, ex);
       }
   }

EDIT: A DESKTOP APPLICATION

IMPROVEMENT
**********************************************************************************
Hello again,

I have found something on the web modified with(really difficult for me :))

Under the save button

Java

try {
          //1.Kısım Baglantı Saglıyoruz
          this.host = "jdbc:derby://localhost:1527/EMRE";
          this.Name = "emre";
          this.Pass = "2561";
          Connection con = DriverManager.getConnection(host,Name,Pass);

          //2.Kısım Statement Olusturuyorum

          Statement cumle = con.createStatement();
          ResultSet rs = null;
          PreparedStatement psmnt = null;
          FileInputStream fis;
          Class.forName("org.apache.derby.jdbc.ClientDriver");
          /* Create a connection by using getConnection() method that takes parameters of string type connection url, user name and password to connect to database. */

          // create a file object for image by specifying full path of image as parameter.
          File image = new File("C:\\Documents and Settings\\temre\\Desktop\\IMAGE\\image.jpg");/* prepareStatement() is used for create statement object that is used for sending sql statements to the specified database. */
          psmnt = con.prepareStatement("insert into INSTRUCTOR(INAME, ISURNAME, IMAGE, ITITLE) "+ "values(DEFAULT)");
          psmnt.setString(1,"EMRE");
          psmnt.setString(2,"emre");
          psmnt.setString(4,"2561");
          fis = new FileInputStream(image);
          psmnt.setBinaryStream(3, (InputStream)fis, (int)(image.length()));/* executeUpdate() method execute specified sql query. Here this query insert data and image from specified address. */
          int s = psmnt.executeUpdate();
          if(s>0)
          {JOptionPane.showMessageDialog(null,"Uploaded successfully !");}
          else
          {JOptionPane.showMessageDialog(null," nooo :( !");}
         }

   catch (Exception ex)  {JOptionPane.showMessageDialog(null,"ERROR !"+ex);}

I am taking an error such as "the number of values assigned is not the same as the number of specified or implied columns" This is why because I don't have a box to upload image.

Please give me hand. And one more, I didint understand defining a path inside code ? Why do I need such a path? Where the images go?

Posted 13-Aug-12 5:09am

FoxRoot

Updated 14-Aug-12 21:47pm

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Andrei Straut** · Answer 1 · 2012-08-13T07:05:00

To upload an image using Java (or any programming language, for that matter), you basically have two options:
- Upload the picture as a blob (what you're trying to do, BUT, you need to turn the picture into a stream -> see example here[^] for instance), or:
- Upload the picture to your server, retrieve its path and store that path into your database.

Now, both approaches have advantages and disadvantages (see here[^] for a more in-depth discussion)

In most of the projects I've worked on (including my current one) we've gone with uploading the pictures to the server and storing the path into the database. It tends to be much, much faster when you're dealing with lots of users that retrieve an average of 10-15 pictures per request. It also comes more naturally to the webserver to deliver a file at a path, versus you retrieving the blob from the database, recomposing it as a file, and returning it to the user.

Although you said it's for a school project, I'd advise you to go with the option of storing them on the server and saving their paths in the database. You can find some examples here[^] and here[^]

**Andrei Straut** · Answer 2 · 2012-08-14T23:11:00

I'm posting this as a solution, and not as a comment, because i think it is a larger explanation, and not a comment in itself

This line:

psmnt = con.prepareStatement("insert into INSTRUCTOR(INAME, ISURNAME, IMAGE, ITITLE) "+ "values(DEFAULT)");

PreparedStatements don't work that way. You need to bind the same number of parameters as specified by the columns in the insert statement. (Even if they are default values for the column, which is what the DEFAULT key word is).

In your specific case, the insert statement would be:

psmnt = con.prepareStatement("insert into INSTRUCTOR(INAME, ISURNAME, IMAGE, ITITLE) "+ "values(DEFAULT, DEFAULT, DEFAULT, DEFAULT)");

You need to have the same number of placeholder values (default) as the number of columns specified. This is why it's throwing you an error.

As for defining a path inside your code, let's start here:

File image = new File("C:\\Documents and Settings\\temre\\Desktop\\IMAGE\\image.jpg");

So, you have defined a path to where is picture is. BUT, what if someone else (I, for instance) get the application and want to run it? I don't have that path in my computer and defining it would be a hassle, and the closest corresponding path (for my computer) would be

File image = new File("C:\\Users\\Andrei-PC\\Desktop\\IMAGE\\image.jpg");

Defining a path means specifying a default file/folder path, which is likely to work on most computers, on most operating systems, be it Linux, Mac, or Windows.

You have an API in Java to do that, and you can start with the System Properties API. For instance, you can issue this, and it will work under both Linux and Windows (haven't tested it with MAC):

System.getProperty("user.home")

Under Windows, this will return C:\\Users\\Andrei-PC\\, while under Linux it will return /home/Andrei-PC/

Now, having that path, you can start from there, and create a folder where to store your files.

Good luck!

**Andrei Straut** · Answer 3 · 2012-08-15T00:15:00

About the fileChooser - You don't display it directly, that's bad practice. You need a "Browse" button, and when your user presses that button, the you display the fileChooser in a modal window. Check below (working example, tested on my computer).

First, declare and instantiate your file chooser:

Java

javax.swing.JFileChooser jFileChooser1 = new javax.swing.JFileChooser();
jFileChooser1.setDialogTitle("Choose file....");

Then, create a button to serve as your browse button (also add actionListener to it, so the button knows what to do when clicked):

javax.swing.JButton jButton1 = new javax.swing.JButton();
jButton1.setText("Browse");
jButton1.addActionListener(new java.awt.event.ActionListener() {
   public void actionPerformed(java.awt.event.ActionEvent evt) {
      jButton1ActionPerformed(evt);
  }
});

And finally, define what actually happens when the button is clicked:

Java

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
    int returnValue = jFileChooser1.showOpenDialog(this);
    jFileChooser1.setVisible(true);
    
    if (returnValue == JFileChooser.APPROVE_OPTION) {
        File file = jFileChooser1.getSelectedFile();
        //Now you have the file, serialize it and upload it to database
    } else {
        //Do what you want to do when user doesn't upload anything
    }
}

Also, I have no idea how soon I will be able to respond if you have any further problems, as I need to go and take care of some issues.
I do hope another member can come along and help you. You can also post a link to this question in the programming forums, in the Java section (DO NOT POST A FULL QUESTION!). Say what you've tried, you still need help, and link it to this question, maybe someone else will take a look at it.

TuranEmre wrote:
Sorry I forgot. Thank you for your consideration.

No problem. If by what I did here I helped someone understand how something works and maybe solve a problem, it's all ok. CodeProject has helped me when I needed it, so I'm just giving that back

How to upload an image into database ?

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0