Re: Insert picture in MySQL using JDBC
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();
}
}