使用JAVA读取ORACLE BLOB字段（国外英文资料）.doc

使用JAVA读取ORACLE BLOB字段（国外英文资料） Topic: download the ORACLE BLOB field implementation using JAVA By caiyi0903@ Time: 2005-6-22 A summary of BLOB Large object type BLOB is known as Binary Large Objects, or Binary Large Objects. The BLOB can be distinguished from three forms: sound like data, binary data, and large text data. Therefore, the most common application is stored graphics, sound, such as object, in addition to large binary objects, the OLE object can also be through the BLOB types in the database, if the text object is too large, beyond the specified length of text type, must be stored in a BLOB field. We cant directly support BLOB fields in a frequently used programming environment, so we need to call the appropriate function to complete the use of the BLOB. The process of the actual Struts project The process of inserting the BLOB field The presentation layer: Upload the HTML: file property = draw file / tag that USES struts, and submit the Action to the specified processing, using the FormFile from struts in ActionForm Save the file. The core code: HTML: form action = / DrawingInputMultiAction enctype = multipart/form - data HTML: file property = drawingFile / ... omit The / HTML: form Control layer: The file field in the ActionForm passed in in Action is assigned to the VO value object and invokes the upload method of the business agent class. The core code: / / new If (actionType. Equals ( insert )) {1 / / get the file type The int iFileType = this.getfiletype. (drawinginputform.getfileextendname ()); If (iFileType = = 0) { / / the file type is not supported This.adderror (request, drawing. Errors. } else { DrawingVO objDrawingVO = new DrawingVO (); / / the basic properties of the drawing (drawinginputform.getdrawingname ()); ... Omit other set methods / / execute new (upload) An int iRt = objDrawingMan. ... omit } The Facade appearance: The client is fully transparent to the client by calling the upload method in the DAO through the business prox