sql_i = "insert into gcb_File(gcb01,gcb02,gcb03,gcb04,gcb09) values(?,?,?,?, EMPTY_BLOB() )";
//sql_i ="INSERT INTO aa VALUES(?, EMPTY_BLOB())" ;
java.lang.System.out.println("======sql_i======="+sql_i); // 先存入Blob/Clob空欄位
pstmt = conn.prepareStatement(sql_i);
pstmt.setString(1,"DOC-98624-20090624-090000");
pstmt.setString(2,"DOC");
pstmt.setString(3,"01");
pstmt.setString(4,"01");
pstmt= conn.prepareStatement("SELECT * FROM gcb_File where gcb01= ? for update");
//pstmt= conn.prepareStatement("SELECT * FROM aa where a= ? for update");
pstmt.setString(1,"DOC-98624-20090624-090000");
pstmt = conn.prepareStatement("UPDATE gcb_File set gcb09=? where gcb01= ? ");
java.lang.System.out.println("======用更新的方式新增Blob/Clob資料======="+pstmt);
pstmt.setBlob(1, blob);
pstmt.setString(2,"DOC-98624-20090624-090000");
sql_i = "insert into gcb_File(gcb01,gcb02,gcb03,gcb04,gcb09)
0 Comments
