java對blob的存取

1、javajava對blobblob的存取的存取作者:未知時間:2005091323:33出處:Blog.責(zé)編:chinaitpower摘要：java對blob的存取此實現(xiàn)為用java訪問mysql的blob對圖片進行存取Title:BlobPros.javaProject:testDeion:把圖片存入mysql中的blob字段，并取出CallModule:mtools數(shù)據(jù)庫中的tmp表File:C:downloadsluozsh.jp

2、gCopyright:Copyright(c)20032003Company:uniwareCreateDate:2002.12.5@Auth:ChenQH@version1.0版本RevisionhistyNameDateDeionChenqh2003.12.5對圖片進行存取note:要把數(shù)據(jù)庫中的Blob字段設(shè)為longblobpackagecom.uniwareimptjava.io.imptjava.util.imptjava.

3、sql.publicclassBlobProsprivatestaticfinalStringURL=“jdbc:mysql:10.144.123.63:3306mtoolsuser=windprivateConnectionconn=nullprivatePreparedStatementpstmt=null從數(shù)據(jù)庫中讀出BLOB對象@paramoutfile輸出的數(shù)據(jù)文件@parampicID要取的圖片在數(shù)據(jù)庫中的ID@throws

4、java.lang.ExceptionpublicvoidblobRead(StringoutfileintpicID)throwsExceptionFileOutputStreamfos=nullInputStreamis=nullbyte[]Buffer=newbyte[4096]tryClass.fName(“g.gjt.mm.mysql.Driver“).newInstance()conn=DriverManager.getCo

5、nnection(URL)pstmt=conn.prepareStatement(“picfromtmpwhereid=“)pstmt.setInt(1picID)傳入要取的圖片的IDrs=pstmt.executeQuery()rs.next()file=newFile(outfile)if(!file.exists())file.createNewFile()如果文件不存在，則創(chuàng)建fos=newFileOutputStream(fi

6、le)is=rs.getBinaryStream(“pic“)intsize=0while(size!=1)size=is.read(Buffer)從數(shù)據(jù)庫中一段一段的讀出數(shù)據(jù)System.out.println(size)if(size!=1)1表示讀到了文件末fos.write(Buffer0size)while((size=is.read(Buffer))!=1)System.out.println(size)fos.write(