/*   
  
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();    
    }    
  }    
}