﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>语源科技BlogJava-langhuaname</title><link>http://www.blogjava.net/langhuaname/</link><description /><language>zh-cn</language><lastBuildDate>Sun, 26 Apr 2026 14:05:56 GMT</lastBuildDate><pubDate>Sun, 26 Apr 2026 14:05:56 GMT</pubDate><ttl>60</ttl><item><title>目录虚拟磁盘命令</title><link>http://www.blogjava.net/langhuaname/archive/2009/09/15/295216.html</link><dc:creator>WIN</dc:creator><author>WIN</author><pubDate>Tue, 15 Sep 2009 13:55:00 GMT</pubDate><guid>http://www.blogjava.net/langhuaname/archive/2009/09/15/295216.html</guid><wfw:comment>http://www.blogjava.net/langhuaname/comments/295216.html</wfw:comment><comments>http://www.blogjava.net/langhuaname/archive/2009/09/15/295216.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/langhuaname/comments/commentRss/295216.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/langhuaname/services/trackbacks/295216.html</trackback:ping><description><![CDATA[目录虚拟磁盘命令方法：<br />
1.网上查找，网上说有dos命令可以实现。<br />
2.dos窗口，输入help，回车，显示所有命令，可以看到subst命令是将一个驱动目录跟一个驱动器号关联。<br />
3.输入subst /? ，回车，可以看到建立虚拟磁盘的参数，很容易就可以看懂了。<br />
4.想要删除已经建成的虚拟磁盘，同样的方法：subst /?<br />
<br />
注意：要学会一种方法，而不是一种命令！<br />
<br />
<img src ="http://www.blogjava.net/langhuaname/aggbug/295216.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/langhuaname/" target="_blank">WIN</a> 2009-09-15 21:55 <a href="http://www.blogjava.net/langhuaname/archive/2009/09/15/295216.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>stinrg &lt;------&gt;inputstream </title><link>http://www.blogjava.net/langhuaname/archive/2009/07/25/288281.html</link><dc:creator>WIN</dc:creator><author>WIN</author><pubDate>Fri, 24 Jul 2009 16:51:00 GMT</pubDate><guid>http://www.blogjava.net/langhuaname/archive/2009/07/25/288281.html</guid><description><![CDATA[<table x:str="" style="border-collapse: collapse; width: 54pt;" width="72" border="0" cellpadding="0" cellspacing="0">
    <tbody>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt; width: 54pt;" width="72" height="19">1. String --&gt;
            InputStream</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">InputStream String2InputStream(String
            str){</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">&nbsp;&nbsp; ByteArrayInputStream stream
            = new ByteArrayInputStream(str.getBytes());</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">&nbsp;&nbsp; return stream;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">}</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">2. InputStream --&gt; String</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">String inputStream2String(InputStream
            is){</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">&nbsp;&nbsp; BufferedReader in = new
            BufferedReader(new InputStreamReader(is));</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">&nbsp;&nbsp; StringBuffer buffer = new
            StringBuffer();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">&nbsp;&nbsp; String line = "";</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">&nbsp;&nbsp; while ((line =
            in.readLine()) != null){</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">&nbsp;&nbsp;&nbsp;&nbsp;
            buffer.append(line);</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">&nbsp;&nbsp; }</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">&nbsp;&nbsp; return buffer.toString();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">}</td>
        </tr>
    </tbody>
</table>
<img src ="http://www.blogjava.net/langhuaname/aggbug/288281.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/langhuaname/" target="_blank">WIN</a> 2009-07-25 00:51 <a href="http://www.blogjava.net/langhuaname/archive/2009/07/25/288281.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>DB2 BLOB java读写</title><link>http://www.blogjava.net/langhuaname/archive/2009/07/25/288280.html</link><dc:creator>WIN</dc:creator><author>WIN</author><pubDate>Fri, 24 Jul 2009 16:50:00 GMT</pubDate><guid>http://www.blogjava.net/langhuaname/archive/2009/07/25/288280.html</guid><description><![CDATA[<table x:str="" style="border-collapse: collapse; width: 54pt;" width="72" border="0" cellpadding="0" cellspacing="0">
    <tbody>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt; width: 54pt;" width="72" height="19">package net.qysoft;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">import java.io.File;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">import java.io.FileOutputStream;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">import java.sql.Blob;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">import java.sql.Connection;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">import java.sql.SQLException;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">/**</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*
            java 中对Blob数据的操作数据库的创建代码:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">* (1)db2 =&gt; create table blobTest (
            id int not null generated always as identity, image blob<span>&nbsp; </span>)</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*添加用户java,密码java</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*
            (2) db2=&gt;! net</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*
            user java java /add java分配权限</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*(3)db2 =&gt; grant
            select,insert,update,delete on</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*
            table weihuachao.blobTest to user java</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*
            @author weihuachao</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*<span>&nbsp;
            </span>以下代码在microsoft 2003 系统,DB2 9.0中测试成功.</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>*/</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">//类的定义开始------------------------------------------------------------</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">public class Test {</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>public static void main(String[] args)
            throws Exception {</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>Test test = new Test();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>Connection conn = test.createConnection();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>// Blob对象的插入的方法:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>try {</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>// 创建插入语句.</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>java.sql.PreparedStatement preparedStatement = conn</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;&nbsp;
            </span>.prepareStatement("insert into
            weihuachao.blobTest(image)values(?)");</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>//创建文件对象:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" x:str="   " height="19"><span>&nbsp;&nbsp;&nbsp;</span></td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>File file=new File("c:/a.jpg");</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>// 创建流对象:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>java.io.BufferedInputStream imageInput = new
            java.io.BufferedInputStream(</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;&nbsp;
            </span>new java.io.FileInputStream(file));</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>//参数赋值:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>preparedStatement.setBinaryStream(1, imageInput,(int) file.length());</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>//执行语句</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>preparedStatement.executeUpdate();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" x:str="   " height="19"><span>&nbsp;&nbsp;&nbsp;</span></td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" x:str="   " height="19"><span>&nbsp;&nbsp;&nbsp;</span></td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" x:str="   " height="19"><span>&nbsp;&nbsp;&nbsp;</span></td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>//------------------------------------------------------------------</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>//Blob的读取工作:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>java.sql.Statement st=conn.createStatement();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>java.sql.ResultSet rs=st.executeQuery("select image from
            weihuachao.blobTest");</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>while(rs.next())</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>{</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>//读取Blob对象</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>Blob blob= (Blob) rs.getBlob(1);</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>//Blob对象转化为InputStream流</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>java.io.InputStream inputStream =blob.getBinaryStream();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>//要写入的文件</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>File fileOutput = new File("c:/backa.jpg");</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>//文件的写入流的定义</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>FileOutputStream fo = new FileOutputStream(fileOutput);</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>int c;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>//读取流并写入到文件中</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>while ((c = inputStream.read()) != -1)</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>fo.write(c);</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>//流的关闭:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>fo.close();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>}</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>} catch (SQLException e) {</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>// TODO 自动生成 catch 块</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>e.printStackTrace();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>}catch(java.io.FileNotFoundException ex)</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" x:str="  " height="19"><span>&nbsp;&nbsp;</span></td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>{</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" x:str="   " height="19"><span>&nbsp;&nbsp;&nbsp;</span></td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>ex.printStackTrace();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>}catch(java.io.IOException ex)</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>{</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" x:str="   " height="19"><span>&nbsp;&nbsp;&nbsp;</span></td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>ex.printStackTrace();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>}</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>finally</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>{</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>try {</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>conn.close();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>} catch (SQLException e) {</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>// TODO 自动生成 catch 块</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>e.printStackTrace();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>}</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" x:str="   " height="19"><span>&nbsp;&nbsp;&nbsp;</span></td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>}</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>}</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>/**</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>* 定义数据库连接的方法</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>*</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>* @return</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>*/</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>private Connection createConnection() {</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>Connection conn = null;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>try {</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>conn =
            java.sql.DriverManager.getConnection("jdbc:db2:sample",</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;&nbsp;
            </span>"java", "java");</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>} catch (SQLException ex1) {</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>ex1.printStackTrace();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>} catch (ClassNotFoundException ex) {</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>ex.printStackTrace();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>}</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>return conn;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span>}</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">}//结束.</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;</span></td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">总结: JAVA
            对DB2中的BLOB对象的操作,主要是使用流的技术实现.对BLOB的实现主要步骤有:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">(1)定义要写入的文件<span>&nbsp; </span>File file=new File("c:/a.jpg");</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">(2)定义文件的写入流</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;
            </span>java.io.BufferedInputStream imageInput = new
            java.io.BufferedInputStream(</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;&nbsp;
            </span>new java.io.FileInputStream(file));</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">(3)使用函数写入:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>preparedStatement.setBinaryStream(1, imageInput,(int) file.length());</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">(4)执行SQL语句:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">对BLOB的读取采取的步骤有:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">(1)读取Blob的对象:<span>&nbsp; </span>Blob blob= (Blob) rs.getBlob(1);</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">(2)把Blob的对象转化为流:</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>java.io.InputStream inputStream =blob.getBinaryStream();</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">(3)定义要写入的文件</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>File fileOutput = new File("c:/backa.jpg");</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">(4)文件的写入流的定义</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>FileOutputStream fo = new FileOutputStream(fileOutput);</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19">(5)写入文件(流的写入技术,就不多讲了)</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>int c;</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>while ((c = inputStream.read()) != -1)</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>{</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>fo.write(c);</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;
            </span>}</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><span>&nbsp;&nbsp;&nbsp;
            </span>//END</td>
        </tr>
        <tr style="height: 14.25pt;" height="19">
            <td style="height: 14.25pt;" height="19"><br />
            </td>
        </tr>
    </tbody>
</table>
<img src ="http://www.blogjava.net/langhuaname/aggbug/288280.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/langhuaname/" target="_blank">WIN</a> 2009-07-25 00:50 <a href="http://www.blogjava.net/langhuaname/archive/2009/07/25/288280.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>