java存储和读取oracleclob类型字段.docx
JAVA存储和读取ORACLECLOB类型字段20080822150838转载▼标签杂谈PACKAGEORACLECLOBIMPORTJAVAIOBUFFEREDREADERIMPORTJAVAIOFILEIMPORTJAVAIOFILEREADERIMPORTJAVAIOIOEXCEPTIONIMPORTJAVAIOREADERIMPORTJAVAIOSTRINGREADERIMPORTJAVASQLCONNECTIONIMPORTJAVASQLDRIVERMANAGERIMPORTJAVASQLPREPAREDSTATEMENTIMPORTJAVASQLRESULTSETIMPORTJAVASQLSQLEXCEPTIONIMPORTORACLEJDBCDRIVERORACLEDRIVERIMPORTORACLESQLCLOBPUBLICCLASSCLOBTEST{STRINGURL“JDBCORACLETHIN19216821571521ORCL“STRINGUSER“XJ“STRINGPWD“XJ“STRINGTEXT“这是要插入到CLOB里面的数据“PRIVATEVOIDCLOBIMPORTTHROWSCLASSNOTFOUNDEXCEPTION,SQLEXCEPTION{//TODOAUTOGENERATEDSTUBDRIVERMANAGERREGISTERDRIVERNEWORACLEDRIVERCONNECTIONCONNDRIVERMANAGERGETCONNECTIONURL,USER,PWD//得到连接对象STRINGSQL“INSERTINTOCLOB_TESTID,STRVALUES 1 ,“//要执行的SQL语句PREPAREDSTATEMENTSTMTCONNPREPARESTATEMENTSQL//加载SQL语句//PREPAREDSTATEMENT支持SQL带有问号,可以动态替换的内容。READERCLOBREADERNEWSTRINGREADERTEXT//将TEXT转成流形式STMTSETCHARACTERSTREAM1,CLOBREADER,TEXTLENGTH//替换SQL语句中的INTNUMSTMTCUTEUPDATE//执行SQLIFNUM0{SYSTEMOUTPRINTLN“OK“}ELSE{SYSTEMOUTPRINTLN“NO“}STMTCLOSECONNCLOSE}PRIVATEVOIDCLOBEXPORTTHROWSCLASSNOTFOUNDEXCEPTION,SQLEXCEPTION,IOEXCEPTION{//TODOAUTOGENERATEDSTUBCLOBCLOBNULLSTRINGSQL“SELECTFROMCLOB_TESTWHEREID1“DRIVERMANAGERREGISTERDRIVERNEWORACLEDRIVERCONNECTIONCONNDRIVERMANAGERGETCONNECTIONURL,USER,PWD//得到连接对象PREPAREDSTATEMENTSTMTCONNPREPARESTATEMENTSQLRESULTSETRSSTMTCUTEQUERYSTRINGID““STRINGCONTENT““IFRSNEXT{IDRSGETSTRING“ID“//获得IDCLOBORACLESQLCLOBRSGETCLOB“STR“//获得CLOB字段STR//注释用RSGETSTRING“STR“无法得到数据,返回的是NULLCONTENTCLOBTOSTRINGCLOB}STMTCLOSECONNCLOSE//输出结果SYSTEMOUTPRINTLNIDSYSTEMOUTPRINTLNCONTENT}//将字CLOB转成STRING类型PUBLICSTRINGCLOBTOSTRINGCLOBCLOBTHROWSSQLEXCEPTION,IOEXCEPTION{STRINGRESTRING““READERISCLOBGETCHARACTERSTREAM//得到流BUFFEREDREADERBRNEWBUFFEREDREADERISSTRINGSBRREADLINESTRINGBUFFERSBNEWSTRINGBUFFERWHILESNULL{//执行循环将字符串全部取出付值给STRINGBUFFER由STRINGBUFFER转成STRINGSBAPPENDSSBRREADLINE}RESTRINGSBTOSTRINGRETURNRESTRING}//TODOAUTOGENERATEDSTUBPUBLICSTATICVOIDMAINSTRINGARGSTHROWSIOEXCEPTION,CLASSNOTFOUNDEXCEPTION,SQLEXCEPTION{//TODOAUTOGENERATEDSTUBCLOBTESTCLOBTESTNEWCLOBTEST//READFILEFILEREADER_FRDNEWFILEREADERNEWFILE“D\\DOSTXT“BUFFEREDREADER_BRDNEWBUFFEREDREADER_FRDSTRING_RS_BRDREADLINESTRINGBUFFER_NEWSTRINGBUFFERWHILE_RSNULL{_APPEND_RS_RS_BRDREADLINE}//SYSTEMOUTPRINTLN_TOSTRING//输入测试CLOBTESTTEXT_TOSTRINGCLOBTESTCLOBIMPORT//输出测试//CLOBTESTCLOBEXPORT}}分享0喜欢阅读3564┊评论0┊收藏0┊转载1┊喜欢▼┊打印┊举报已投稿到排行榜圈子前一篇如何避免不小心关掉WEB浏览器窗口后一篇RESIN配置文件详解评论重要提示警惕虚假中奖信息|美术设计糖纸课后反思发评论做第一个评论者吧抢沙发发评论走火入魔说作家|天路客闲谈韩熙载夜宴图登录名密码找回密码注册记住登录状态分享到微博评论并转载此博文验证码请点击后输入验证码收听验证码发评论以上网友发言只代表其个人观点,不代表新浪网的观点或立场。RESIN配置文件详解