将图片数据插入oracle数据库中_file1.docxVIP

Oracle中插入图片并显示(用BLOB类型) Oracle中插入图片并显示(用BLOB类型)要在oracle里面存入图片 用 blob类型首先在数据库里建立：--连接到管理员conn sys/tbsoft as sysdba;--为scott用户授权grant create any directory to scott;--回到scott用户conn scott/tiger;--创建存储图片的表CREATE TABLE IMAGE_LOB (T_ID VARCHAR2 (5) NOT NULL,T_IMAGE BLOB NOT NULL);--创建存储图片的目录CREATE OR REPLACE DIRECTORY IMAGES AS C:\picture;--在c：下自己建一个叫picture的文件夹CREATE OR REPLACE PROCEDURE IMG_INSERT (TID VARCHAR2,FILENAME VARCHAR2) ASF_LOB BFILE;--文件类型B_LOB BLOB;BEGINiNSERT INTO IMAGE_LOB (T_ID, T_IMAGE)VALUES (TID,EMPTY_BLOB ()) RETURN T_IMAGE INTO B_LOB;--插入空的blobF_LOB:= BFILENAME (IMAGES, FILENAME);--获取指定目录下的文件DBMS_LOB.FILEOPEN(F_LOB, DBMS_LOB.FILE_READONLY);--以只读的方式打开文件DBMS_LOB.LOADFROMFILE (B_LOB, F_LOB,DBMS_LOB.GETLENGTH (F_LOB));--传递对象DBMS_LOB.FILECLOSE (F_LOB);--关闭原始文件COMMIT;END;/--在C:\picture下放一张图片1.gif--将该图片存入表call IMG_INSERT(1,1.gif);然后创建一个web项目 连接数据库后 创建一个BlobDAO类 用来取出表中的blob类型图片Java代码? 收藏代码 public class BlobDAO {?? private static final BlobDAO instance = new BlobDAO();?? private Connection conn = null;?? private BlobDAO() {?? }?? public static BlobDAO getInstance() {? return instance;? }?? private void initConn() {? conn = DBAccess.getInstance().getConn();? }??? public byte[] getImage(String imgname) {? BufferedInputStream ins;//取得BLOB的IO流? byte[] bt = null;?? initConn();? Blob bo = null;? PreparedStatement ps = null;? ResultSet rs = null;? String sql = select T_IMAGE from IMAGE_LOB where t_id=?;? try {? ps = conn.prepareStatement(sql);? ps.setString(1, imgname);? rs = ps.executeQuery();? if (rs.next()) {? bo = rs.getBlob(T_IMAGE);?? try {? ins = new BufferedInputStream(bo.getBinaryStream());? int bufferSize = (int) bo.length();//取得BLOB的长度? bt = new byte[bufferSize];? try {? ins.read(bt, 0, bufferSize);? } catch (IOException e) {? // TODO Auto-generated catch block? e.printStackTrace();? }? //建立字节缓存? } catch (SQLException e) {? // TODO Auto-generated catch block? e.printStackTrace();? }?? }? } catch (SQLException e) {? // TODO Auto-generated catch block? e.pri