java对blob的存取.docVIP

java对blob的存取 作者:未知 时间:2005-09-13 23:33 出处:Blog.ChinaUnix.net 责编:chinaitpower ??????????????摘要：java对blob的存取 此实现为用java访问mysql的blob,对图片进行存取 /**?* Title:???????? BlobPros.java?* Project:?????? test?* Description:? 把图片存入mysql中的blob字段，并取出?* Call Module:? mtools数据库中的tmp表? ?* File:???????? C:downloadsluozsh.jpg?* Copyright:??? Copyright (c) 2003-2003?* Company:????? uniware?* Create Date:? 2002.12.5?* @Author:????? ChenQH?* @version 1.0 版本*????? ?* ?*? Revision history?*? Name???????? Date???? Description?*? ----??? ? ----??????? -----------?*?Chenqh?? 2003.12.5??????? 对图片进行存取?*?* note:???????? 要把数据库中的Blob字段设为longblob??????? ?*?*/ //package com.uniware; import java.io.*;import java.util.*;import java.sql.*; public class BlobPros{??? private static final String URL = jdbc:mysql://10.144.123.63:3306/mtools?user=windpassword=123useUnicode=true;??? private Connection conn = null;??? private PreparedStatement pstmt = null;??? private ResultSet rs = null;??? private File file = null;??? ??? public BlobPros()??? {??? } ??? /**??? * 向数据库中插入一个新的BLOB对象(图片)??? * @param infile 要输入的数据文件??? * @throws java.lang.Exception??? */?? public void blobInsert(String infile) throws Exception?? {?????? FileInputStream fis = null;?? ?????????? try ?????????? {?????????????? Class.forName(org.gjt.mm.mysql.Driver).newInstance();?????????????? conn = DriverManager.getConnection(URL);??????????? ?????????????? file = new File(infile);?????????????? fis = new FileInputStream(file);?????????????? //InputStream fis = new FileInputStream(infile);???? ??? pstmt = conn.prepareStatement(insert into tmp(descs,pic) values(?,?));???? ??? pstmt.setString(1,file.getName());??? //把传过来的第一个参数设为文件名?????????????? //pstmt.setBinaryStream(2,fis,(int)file.length());?? //这种方法原理上会丢数据，因为file.length()返回的是long型???? ??? pstmt.setBinaryStream(2,fis,fis.available());? //第二个参数为文件的内容???? ??? pstmt.executeUpdate();???? ?}?????????? catch(Exception ex)?????????? {?????