No
Yes
0 Rates / 125 Views
Bookmark and Share
Posted by:
asuka
Posted date:
sql_i = "insert into gcb_File(gcb01,gcb02,gcb03,gcb04,gcb09)

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");

Comments

Refresh

Add Comment

0 Comments