InsertPictureToMySql.java Source code

Java tutorial

Introduction

Here is the source code for InsertPictureToMySql.java

Source

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