读取并显示oracle中的blob字段.docx

《读取并显示oracle中的blob字段.docx》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、读取并显示oracle中的blob字段1.java连接Oracle具体代码如下： importjava.sql.*;importjava.io.*; importjavax.imageio.ImageIO;importjava.awt.image.BufferedImage;importjava.awt.image.AffineTransformOp;importjava.awt.geom.AffineTransform; publicclassOracleQueryBean{   privatefinalStringoracleD

2、riverName="oracle.jdbc.driver.OracleDriver";   privateConnectionmyConnection=null;   /*图片表名*/   privateStringstrTabName;   /*图片ID字段名*/   privateStringstrIDName;   /*图片字段名*/   privateStringstrImgName;   /**    *加载java连接Oracle的jdbc驱动    */   publicOracleQueryBean(){     

3、  try{           Class.forName(oracleDriverName);       }catch(ClassNotFoundExceptionex){           System.out.println("加载jdbc驱动失败,原因:"+ex.getMessage());       }   }   /**    *获取Oracle连接对象    *@returnConnection    */   publicConnectiongetConnection(){       try{       

4、//用户名+密码;以下使用的Test就是Oracle里的表空间       //从配置文件中读取数据库信息       GetParaoGetPara=newGetPara();       StringstrIP=oGetPara.getPara("serverip");       StringstrPort=oGetPara.getPara("port");       StringstrDBName=oGetPara.getPara("dbname");       StringstrUser=oGetPara.getPar

5、a("user");       StringstrPassword=oGetPara.getPara("password");              this.strTabName=oGetPara.getPara("tablename");       this.strIDName=oGetPara.getPara("imgidname");       this.strImgName=oGetPara.getPara("imgname");              StringoracleUrlToConnect="jd

6、bc:oracle:thin:@"+strIP+":"+strPort+":"+strDBName;           this.myConnection=DriverManager.getConnection(oracleUrlToConnect,strUser,strPassword);       }catch(Exceptionex){           System.out.println("Cannotgetconnection:"+ex.getMessage());           System.out.pri

7、ntln("请检测配置文件中的数据库信息是否正确.");       }       returnthis.myConnection;   }} 2.读取blob字段 在OracleQueryBean类中增加一个函数，来进行读取，具体代码如下：/**    *根据图片在数据库中的ID进行读取    *@paramstrID 图片字段ID    *@paramw     需要缩到的宽度    *@paramh     需要缩到高度    *@return    */   publicbyte[]GetImgByteById(Strin

8、gstrID,intw,inth){   //System.out.println("Getimgdatawhichidis"+nID);   if(myConnection==null)       this.getConnecti