P29 向表中插入Blob数据和读取表中的Blob类型数据

查询数据表customers中Blob类型的字段

//查询数据表customers中Blob类型的字段
@Test
public void testQuery()  {
    Connection conn = null;
    PreparedStatement ps = null;
    InputStream is= null;
    FileOutputStream fos= null;
    ResultSet rs = null;
    try {
        conn = JDBCUtil.getConnection();
        String sql="select id,name,email,birth,photo from customers where id=?";
        ps = conn.prepareStatement(sql);
        ps.setObject(1, 21);

        is = null;
        fos = null;
        rs = ps.executeQuery();

        if (rs.next()){

            int id = (int) rs.getObject(1);
            String name = rs.getString(2);
            String email = rs.getString(3);
            Date birth = rs.getDate(4);

            Customer cust = new Customer(id, name, email, birth);
            System.out.println(cust);
            //将blob类型的字段下载下来，以文件的方式保存在本地
            Blob photo = rs.getBlob(5);
             is = photo.getBinaryStream();
             fos = new FileOutputStream("cxy.jpg");
            byte[] buffer = new byte[1024];
            int len;
            while ((len=is.read(buffer))!=-1){
                fos.write(buffer, 0, len);
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        JDBCUtil.closeResource(conn, ps,rs);
        try {
            if (is !=null)
            is.close();
        } catch (IOException e) {
            e.printStackTrace();
        }

        try {
            if (fos !=null)
            fos.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }


}

向数据表customers中插入Blob类型的字段

//向数据表customers中插入Blob类型的字段
@Test
public void testInsert() throws Exception {
    Connection conn = JDBCUtil.getConnection();
    String sql="insert into customers(name,email,birth,photo)values(?,?,?,?)";
    PreparedStatement ps = conn.prepareStatement(sql);

    ps.setObject(1, "cxy");
    ps.setObject(2, "cxy@qq.com");
    ps.setObject(3, "1998-08-18");
    FileInputStream is = new FileInputStream(new File("C:\\Users\\63096\\Desktop\\相关性分析热力图.png"));
    ps.setBlob(4, is);

    ps.execute();

    JDBCUtil.closeResource(conn, ps);
}