- /*
- Defining the Table: Oracle and MySql
- create table MyPictures (
- id INT PRIMARY KEY,
- name VARCHAR(0),
- photo BLOB
- );
- */
- import java.io.File;
- import java.io.FileInputStream;
- import java.io.IOException;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.SQLException;
- public class InsertPictureToMySql {
- public static void main(String[] args) throws Exception, IOException, SQLException {
- Class.forName("org.gjt.mm.mysql.Driver");
- Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/databaseName", "root", "root");
- String INSERT_PICTURE = "insert into MyPictures(id, name, photo) values (?, ?, ?)";
- FileInputStream fis = null;
- PreparedStatement ps = null;
- try {
- conn.setAutoCommit(false);
- File file = new File("myPhoto.png");
- fis = new FileInputStream(file);
- ps = conn.prepareStatement(INSERT_PICTURE);
- ps.setString(1, "001");
- ps.setString(2, "name");
- ps.setBinaryStream(3, fis, (int) file.length());
- ps.executeUpdate();
- conn.commit();
- } finally {
- ps.close();
- fis.close();
- }
- }
- }