在java中向mysql插入BLOB数据

import com.atguigu1.util.JDBCUtils;
import org.apache.commons.dbutils.DbUtils;
import org.junit.Test;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class exe {
    @Test
    public void exe() {
        //获取连接
        Connection conn = null;

        String sql = "insert into customers(name,email,birth,photo)values(?,?,?,?)";
        PreparedStatement ps = null;
        try {
            conn=JDBCUtils.getConnection3();
            ps = conn.prepareStatement(sql);

            // 填充占位符
            ps.setString(1, "徐海强");
            ps.setString(2, "xhq@126.com");
            ps.setDate(3, new Date(new java.util.Date().getTime()));
            // 操作Blob类型的变量
            FileInputStream fis = new FileInputStream("xhq.png");
            ps.setBlob(4, fis);
            //执行
            ps.execute();

            fis.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }finally {
            DbUtils.closeQuietly(conn,ps,null);
        }

    }
}