Question

oracle数据库中 BLOB字段的照片 怎么 导成 JPG格式

Answer 1

往oracle里面类型为blob写入时，必须先插入一个empty_blob，实行update……
具体java里面写入blob的代码如下：

public class applyPhotoBLOB {
final static String sDBDriver = "oracle.jdbc.driver.OracleDriver";

public static void main(String[] args) {
// TODO Auto-generated method stub
Connection connSDC = null;
Connection conn = null;
String sConnStr = "jdbc:oracle:thin:@127 0.0 1 1521:sledu";
String sConnStrSDC = "jdbc:oracle:thin:@10 10 8.12:1521:rac2";
String sDBUid = "test";
String sDBPwd = "test";
String sDBUidSDC = "sdcmanager";
String sDBPwdSdc = "sdcmanager_888";

try
{