jdbc向数据库中保存图片

来源：互联网发布：无法连接到steam网络编辑：程序博客网时间：2024/05/22 11:15

示例一：

package com;

import java.sql.*;
import java.io.*;
public class SavePic {
public static void main(String[] args) {
    Connectionconn = 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(newcom.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 = newFileInputStream(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