create table image 
(id int primary key auto_increment , 
 name varchar(30) COMMENT '名稱', 
 content mediumblob COMMENT '圖片');

package jdbc_imagetest;

import java.io.*;
import java.sql.*;
/**
 * 將本地文件的圖片傳到數(shù)據(jù)庫的test的image表中并下載到本機(jī)桌面
 */
public class Test1 {

  private static String url="jdbc:mysql://localhost:3306/test";
  private static String user="root";
  private static String password="123456";
  private static Connection con;

  public static void main(String[] args) throws Exception {
    Class.forName("com.mysql.jdbc.Driver");
    con=DriverManager.getConnection(url,user,password);
    shangchuan();
    xiazai();    
  }
  //添加圖片到數(shù)據(jù)庫test4的file表
  public static void shangchuan() throws Exception{
    String sql="insert into image(name,content) values(?,?)";
    PreparedStatement ptmt=con.prepareStatement(sql);
    ptmt.setString(1, "美女.jpg");
    InputStream is=null;
    is=new FileInputStream("D:\\Pictures\\3.jpg");
    ptmt.setBinaryStream(2, is,is.available());
    //方法說明：PreparedStatement.setBinaryStream(int parameterIndex, InputStream x, int length)
    ptmt.execute();
    System.out.println("圖片添加成功！");

  }
  //從數(shù)據(jù)庫中把圖片下載至桌面
  public static void xiazai() throws Exception{
    String sql="select content from image where id=3";//在我這里3.jpg是第三張圖片
    Statement stmt=con.createStatement();
    ResultSet rs=stmt.executeQuery(sql);//將查詢結(jié)果給rs
    if(rs.next()){
      InputStream is=rs.getBinaryStream("fcontent");
      //.getBinaryStream():a Java input stream that delivers the database column value as a stream of uninterpreted bytes
      FileOutputStream fos=new FileOutputStream("C:\\Users\\Desktop\\美女.jpg");
      byte[] buffer=new byte[1024];
      int len=0;
      while((len=is.read(buffer))!=-1){
        fos.write(buffer,0,len);//將數(shù)據(jù)庫的圖片寫出
      }
      System.out.println("下載成功！已下載至桌面，請(qǐng)查看");
    }else{
      System.out.println("圖片不存在！");
    }
    con.close();
  }


}