图片文件流入库

package com.to.go.jdbc.test;

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

import com.to.go.jdbc.util.JDBCUtil;

/**
 * 把图片以二进制流模式存入数据库
 * @author lsh
 *
 */
public class ImgTest {

    public static void main(String[] args) throws Exception {
        Connection conn = JDBCUtil.getConn();

        String sql = "INSERT INTO img (img) VALUES(?)";
        
        PreparedStatement ps = conn.prepareStatement(sql);
        //二进制流
        FileInputStream fin = new FileInputStream("G:/success.jpg");
        ps.setBlob(1,fin);
        ps.executeUpdate();
        //关闭流
        fin.close();
        //释放资源
        JDBCUtil.close(conn, ps, null);

    }
}

 

 

 

 

转载于:https://www.cnblogs.com/itBulls/articles/9098862.html