mysql blob类型插入图片,往Blob类型字段插入图片，使用与MySql或者Oracle

/*

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();

}

}

}