Re: Insert picture in MySQL using JDBC

From:

=?ISO-8859-1?Q?Arne_Vajh=F8j?= <arne@vajhoej.dk>

Newsgroups:

comp.lang.java.programmer

Date:

Wed, 01 Aug 2007 19:41:15 -0400

Message-ID:

<46b11a0d$0$90263$14726298@news.sunsite.dk>

reexana wrote:

I'm working on a project using Netbeans IDE 5.5 with Visual Web Pack
and MySQL as its database.

The project is about displaying the information about an item selected
by a user from a drop-down list.

I managed to display the information in the database when a user
selected the keyword but don't know how to store picture in the
database and retrieve it to display to the user along with the
information.

I tried to use BLOB, but it didn't work out. Maybe, I did the wrong
way.

BLOB should work for pictures.

Attached below is a small demo program that stores and
retrieves a picture in a BLOB field in MySQL.

Arne

import java.io.*;
import java.sql.*;

public class BlobTest {
    public static void main(String[] args) throws Exception {
       byte[] b = new byte[(int)(new File("C:\\elogo.png")).length()];
       InputStream is = new FileInputStream("C:\\elogo.png");
       is.read(b);
       is.close();
       Class.forName("com.mysql.jdbc.Driver");
       Connection con =
DriverManager.getConnection("jdbc:mysql://localhost/Test", "", "");
       PreparedStatement ins = con.prepareStatement("INSERT INTO
BlobTest VALUES (?,?)");
       ins.setInt(1, 123);
       ins.setBytes(2, b);
       ins.executeUpdate();
       PreparedStatement sel = con.prepareStatement("SELECT Picture FROM
BlobTest WHERE ID=?");
       sel.setInt(1, 123);
       ResultSet rs = sel.executeQuery();
       rs.next();
       byte[] b2 = rs.getBytes(1);
       con.close();
       OutputStream os = new FileOutputStream("C:\\elogo2.png");
       os.write(b2);
       os.close();
    }
}