ÓÃJAVAдÈëºÍ¶ÁÈ¡MYSQLµÄͼƬµÄʵÀý

Ö÷ÒªµÄ³ÌÐò£º
package greeds.jdbc.sample;
import greeds.jdbc.util.JDBCUtil;
import java.io.*;
import java.sql.*;
public class MySQLBlobSample {
 public static void main(String[] args) throws Exception {
  // дÈëÊý¾Ý¿â
  /*
   *
   * Connection conn = null; PreparedStatement pstm = null;
   *
   * try { String filepath = "D:\\strahovski-ep201-011.jpg"; File file =
   * new File(filepath); FileInputStream fin = new FileInputStream(file);
   * conn = JDBCUtil.getConnection();
   *
   * String sql = "insert into Dish(id,photo) values(?,?)"; pstm =
   * conn.prepareStatement(sql); pstm.setInt(1, 3);
   * pstm.setBinaryStream(2, fin,(int)file.length());
   *
   * int r = pstm.executeUpdate(); System.out.println("INSERT"+r+"ROW");
   *
   * fin.close();
   *
   *
   * } catch (FileNotFoundException e) { e.printStackTrace(); } finally{
   * //JDBCUtil.release(null, pstm, conn); }
   */
  // ´ÓÊý¾Ý¿â¶ÁÈ¡Îļþ
  Connection conn = null;
  Statement stm = null;
  ResultSet rs = null;
  try {
   conn = JDBCUtil.getConnection();
   stm = conn.createStatement();
   String sql = "select * from Dish where id=1";
   rs = stm.executeQuery(sql);
   rs.next();
   Blob blob = rs.getBlob("photo");
   FileOutputStream out = new FileOutputStream(new File("E:/my.jpg"));
   InputStream in = blob.getBinaryStream();
   int i;
   while ((i = in.read()) != -1) {
    out.write(i);
   }
   in.close();
   out.close();
  } catch (Exception e) {
   e.pr