jdbc向数据库中保存图片

示例一：

package com;

import java.sql.*;
import java.io.*;
public class SavePic {
  public static void main(String[] args) {
    Connection conn = null;
    PreparedStatement stmt = null;
    String sql = "insert into stu_ning(id, name, photo)  values (stu_ning_seq.nextval, ?, ?)";
    try {
      conn = ConnectionUtils.openConnection();
      stmt = conn.prepareStatement(sql);
      stmt.setString(1, "peter");
      File f = new File("src\\sunjpg");
      FileInputStream fis = new FileInputStream(f);
      stmt.setBinaryStream(2, fis, (int)f.length());
      int n = stmt.executeUpdate();
      System.out.println(n + "条记录被插入");
    } catch (Exception e) {
      e.printStackTrace();
    } finally{
      ConnectionUtils.closeStatement(stmt);
      ConnectionUtils.closeConnection(conn);
    }
  }
}

引自：http://a0102051365.iteye.com/blog/938795

 

示例二：

Connection conn = null;   
try{   
    DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());   
    conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://IP:1433;DataBaseName=Moftec","sa","mymm");   
} catch(Exception e ) {   
    //捕捉异常并抛出IOException   
    out.println("Can not connec to the database! The exception is " + e.toString());   
}   
FileInputStream fis=null;   
File file = new File("E:/java/chart.jpg");   
try{   
    fis = new FileInputStream(file);   
}catch(FileNotFoundException e){   
    out.println("Not find file!");   
}   
PreparedStatement ps = conn.prepareStatement("Insert into gs_img (lei,years,img) values (?,?,?)");   
ps.setString(1,"ivan");   
ps.setInt(2,4);   
ps.setBinaryStream(3,fis,(int)file.length());
ps.executeUpdate();   
ps.close();   
try{   
    fis.close();   
    out.println("写进去了！");   
}catch(IOException e){   
    out.println("fis cann't cloase!");   
}  

引自：http://wison.iteye.com/blog/201269