大数据处理（Large data processing）.docVIP

大数据处理（Large data processing） b LOB and CLOB operations are basically the same. (1) Perform an insert operation on a database CLOB type ************************************************* java. sql. PreparedStatement pstmt = null; ResultSet rs = null; string query = ; Conn Setautocommit (FALSE); query = INSERT into clobtest_table (ID, PICSTR) VALUES (?, Empty_clob ()); java. sql. preparedstatement pstmt = conn. preparestatement (query); Pstmt setstring (1, 001; Pstmt executeupdate (); PSTMT = null query = Select Picstr from clobtest_table where id = $number for Update; Pstmt = con. Preparestatement (query) rs= pstmt. executequery (); Oracle. sql. CLOB CLOBTT = null; if (Rs. Next ()) { CLOBTT = (Oracle. SQL. Clob) Rs. getclob (1); } Writer WR = CLOBTT getcharacteroutputstream (); WR. Write (STRTMP); WR Flush (); WR. Close (); Rs. close (); Con. commit (); (2) Through Sql/plus query whether the database has been successfully inserted ************************************************* /packet Dbms_lob to handle LOB data. See if the insertion was successful. Use the getlength of the DBMS_LOB packet to detect whether STR has been deposited in the Picstr field. As： sql Select Dbms_lob. GetLength (PICSTR) from clobtest_table; (3) Performing read operations on database Clob ************************************************* Its easy to read relative inserts. There is not much difference between the basic steps and half of the database data. String description = query = Select Picstr from clobtest_table where id = 001 ; Pstmt = con. preparestatement (query); ResultSet result = pstmt. ExecuteQuery (); if (result. Next ()) { Oracle. jdbc. driver. Oracleresultset ors = (Oracle. jdbc. driver. Oracleresultset) result; Oracle. sql. CLOB clobtmp = (Oracle. SQL. CLOB) ors. GETCLOB (1); if (Clobtmp==null | | clobtmp. Length () =) { System. Out. println (======clob object is empty; Description = ; }else{ Description=clobtmp. Getsubstring ((Long) 1, (int) clobtmp. Length ()); System. Ou