Read and Write large fields (Oracle, JDBC)

Package test; </P> <p> Import Java. io. bufferedreader; <br/> Import Java. io. file; <br/> Import Java. io. fileinputstream; <br/> Import Java. io. filenotfoundexception; <br/> Import Java. io. ioexception; <br/> Import Java. io. inputstreamreader; <br/> Import Java. io. reader; <br/> Import Java. SQL. clob; <br/> Import Java. SQL. connection; <br/> Import Java. SQL. drivermanager; <br/> Import Java. SQL. preparedstatement; <br/> imp ORT Java. SQL. resultset; <br/> Import Java. SQL. sqlexception; </P> <p> // write a large field to the database <br/> public class clob_test {<br/> static {<br/> try {<br/> class. forname ("oracle. JDBC. driver. oracledriver "); </P> <p>} catch (classnotfoundexception e) {<br/> E. printstacktrace (); <br/>}</P> <p> Public static void main (string [] ARGs) {<br/> // insertclob (); <br/> readclob (); </P> <p >}</P> <p> // insert large text <br/> Private Static Void insertclob () {<br/> string url = "JDBC: oracle: thin: @ 127.0.0.1: 1521: Oracle"; <br/> string user = "chenl "; <br/> string Password = "chenl"; <br/> string SQL = "insert into c_lob_blob (c) values (?) "; <Br/> connection conn = NULL; <br/> preparedstatement pstmt = NULL; <br/> fileinputstream input = NULL; <br/> try {<br/> conn = drivermanager. getconnection (URL, user, password); <br/> pstmt = Conn. preparestatement (SQL); <br/> file = new file ("src/COM/csdnswing. java "); <br/> input = new fileinputstream (File); <br/> reader = new inputstreamreader (input); </P> <p> pstmt. setcharacterstream (1, Reade R, (INT) file. length (); </P> <p> pstmt.exe cuteupdate (); <br/> Conn. commit (); <br/> system. out. println ("writer OK! "); <Br/>} catch (filenotfoundexception e) {<br/> E. printstacktrace (); <br/>} catch (sqlexception e) {<br/> E. printstacktrace (); <br/>}finally {<br/> If (pstmt! = NULL) {<br/> try {<br/> pstmt. close (); <br/>}catch (sqlexception e) {<br/> E. printstacktrace (); <br/>}< br/> If (Conn! = NULL) {<br/> try {<br/> Conn. close (); <br/>}catch (sqlexception e) {<br/> E. printstacktrace (); <br/>}</P> <p >}< br/>}</P> <p> Private Static void readclob () {<br/> string url = "JDBC: oracle: thin: @ 127.0.0.1: 1521: Oracle"; <br/> string user = "chenl "; <br/> string Password = "chenl"; <br/> connection conn = NULL; <br/> preparedstatement pstmt = NULL; <br/> resultset rs = NULL; </P> <p> try {<br/> Conn = Drivermanager. getconnection (URL, user, password); <br/> string SQL = "select C from c_lob_blob"; <br/> pstmt = Conn. preparestatement (SQL); <br/> rs = pstmt.exe cutequery (); </P> <p> system. out. println (RS); </P> <p> while (RS. next () {<br/> clob = Rs. getclob (1); <br/> reader = clob. getcharacterstream (); </P> <p> bufferedreader buff = new bufferedreader (Reader); <br/> system. out. println (buff); <br/> S Tring temp = ""; <br/> while (temp = buff. Readline ())! = NULL) {<br/> system. out. println (temp); <br/>}</P> <p >}catch (sqlexception e) {<br/> E. printstacktrace (); <br/>}catch (ioexception e) {<br/> E. printstacktrace (); <br/>}</P> <p >}< br/>