怎么将图片添加到mysql中

CREATE TABLE `photo` (
 `id` int(11) NOT NULL,
 `name` varchar(255) DEFAULT NULL,
 `photo` blob,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/**
 * 
 */
package JdbcImgTest;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * @author Administrator
 * 
 */
public class DBUtil
{
 // 定义数据库连接参数
 public static final String DRIVER_CLASS_NAME = "com.mysql.jdbc.Driver";
 
 public static final String URL = "jdbc:mysql://localhost:3306/test";
 
 public static final String USERNAME = "root";
 
 public static final String PASSWORD = "root";
 
 // 注册数据库驱动
 static
 {
 try
 {
 Class.forName(DRIVER_CLASS_NAME);
 }
 catch (ClassNotFoundException e)
 {
 System.out.println("注册失败！");
 e.printStackTrace();
 }
 }
 
 // 获取连接
 public static Connection getConn() throws SQLException
 {
 return DriverManager.getConnection(URL, USERNAME, PASSWORD);
 }
 
 // 关闭连接
 public static void closeConn(Connection conn)
 {
 if (null != conn)
 {
 try
 {
 conn.close();
 }
 catch (SQLException e)
 {
 System.out.println("关闭连接失败！");
 e.printStackTrace();
 }
 }
 }
 
 //测试
/* public static void main(String[] args) throws SQLException
 {
 System.out.println(DBUtil.getConn());
 }
 */
}

package JdbcImgTest;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;

/**
 * @author Administrator
 * 
 */
public class ImageUtil
{
 
 // 读取本地图片获取输入流
 public static FileInputStream readImage(String path) throws IOException
 {
 return new FileInputStream(new File(path));
 }
 
 // 读取表中图片获取输出流
 public static void readBin2Image(InputStream in, String targetPath)
 {
 File file = new File(targetPath);
 String path = targetPath.substring(0, targetPath.lastIndexOf("/"));
 if (!file.exists())
 {
 new File(path).mkdir();
 }
 FileOutputStream fos = null;
 try
 {
 fos = new FileOutputStream(file);
 int len = 0;
 byte[] buf = new byte[1024];
 while ((len = in.read(buf)) != -1)
 {
 fos.write(buf, 0, len);
 }
 fos.flush();
 }
 catch (Exception e)
 {
 e.printStackTrace();
 }
 finally
 {
 if (null != fos)
 {
 try
 {
 fos.close();
 }
 catch (IOException e)
 {
 e.printStackTrace();
 }
 }
 }
 }
}

package JdbcImgTest;

import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * @author Administrator 测试写入数据库以及从数据库中读取
 */
public class ImageDemo
{
 
 // 将图片插入数据库
 public static void readImage2DB()
 {
 String path = "D:/Eclipse/eclipseWorkspace/TestProject/Img/mogen.jpg";
 Connection conn = null;
 PreparedStatement ps = null;
 FileInputStream in = null;
 try
 {
 in = ImageUtil.readImage(path);
 conn = DBUtil.getConn();
 String sql = "insert into photo (id,name,photo)values(?,?,?)";
 ps = conn.prepareStatement(sql);
 ps.setInt(1, 1);
 ps.setString(2, "Tom");
 ps.setBinaryStream(3, in, in.available());
 int count = ps.executeUpdate();
 if (count > 0)
 {
 System.out.println("插入成功！");
 }
 else
 {
 System.out.println("插入失败！");
 }
 }
 catch (Exception e)
 {
 e.printStackTrace();
 }
 finally
 {
 DBUtil.closeConn(conn);
 if (null != ps)
 {
 try
 {
 ps.close();
 }
 catch (SQLException e)
 {
 e.printStackTrace();
 }
 }
 }
 
 }
 
 // 读取数据库中图片
 public static void readDB2Image()
 {
 String targetPath = "C:/Users/Jia/Desktop/mogen.jpg";
 Connection conn = null;
 PreparedStatement ps = null;
 ResultSet rs = null;
 try
 {
 conn = DBUtil.getConn();
 String sql = "select * from photo where id =?";
 ps = conn.prepareStatement(sql);
 ps.setInt(1, 1);
 rs = ps.executeQuery();
 while (rs.next())
 {
 InputStream in = rs.getBinaryStream("photo");
 ImageUtil.readBin2Image(in, targetPath);
 }
 }
 catch (Exception e)
 {
 e.printStackTrace();
 }
 finally
 {
 DBUtil.closeConn(conn);
 if (rs != null)
 {
 try
 {
 rs.close();
 }
 catch (SQLException e)
 {
 e.printStackTrace();
 }
 }
 if (ps != null)
 {
 try
 {
 ps.close();
 }
 catch (SQLException e)
 {
 e.printStackTrace();
 }
 }
 
 }
 }
 
 //测试
 public static void main(String[] args)
 {
 //readImage2DB();
 readDB2Image();
 }
}