Question

如何在oracle中的blob字段下读取jpg格式文件保存

一张jpg图片以二进制保存在blob字段中，现在需要读出，并保存文件。请问如何实现，谢谢
最好用java程序，读出那张图片，然后可以保存成文件形式，而不是网上很多的直接在jsp页面显示出来

Answer 1

$conn = oci_connect($user, $password);
$lob = oci_new_descriptor($conn, OCI_D_LOB);
$stmt = oci_parse($conn, "insert into $table (id, the_blob)
values(my_seq.NEXTVAL, EMPTY_BLOB()) returning the_blob into :the_blob");
oci_bind_by_name($stmt, ':the_blob', $lob, -1, OCI_B_BLOB);
oci_execute($stmt, OCI_DEFAULT);
if ($lob->savefile($lob_upload)){
oci_commit($conn);
echo "Blob successfully uploaded\n";
}else{
echo "Couldn't upload Blob\n";
}
oci_free_descriptor($lob);
oci_free_statement($stmt);
oci_close($conn);