¶ÔoracleÊý¾Ý¿âÖÐCLOB×ֶεÄÏà¹Ø²Ù×÷

import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * ´Ë´¦²åÈëÀàÐÍ˵Ã÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:55:06)
 * @author£ºzhubin
 */
public class BLOBUtil {
/**
 * ¹¦ÄÜ˵Ã÷£º±àÂ뷽ʽ
 * È¡Öµ·¶Î§£º
 * ÒÀÀµÊôÐÔ£º
 * ×îºóÐÞ¸Äʱ¼ä£º(2002-2-27 15:30:40)
 */
private static String codeSet;
/**
 * ´Ë´¦²åÈë·½·¨ËµÃ÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:58:15)
 * @return java.lang.String
 * @param result java.sql.ResultSet
 * @param index int
 */
public static String readBLOB(ResultSet result, int index) throws IOException,
 SQLException
{
String strValue = null;
// ¶ÔÓÚSQL NULL£¬·½·¨getBinaryStream½«·µ»Ønull
InputStream in = result.getBinaryStream(index);
if (in == null) {
return "";
}
byte[] ba = new byte[8192];
ByteArrayOutputStream b = new ByteArrayOutputStream();
int i;
while((i = in.read(ba)) != -1){
b.write(ba, 0, i);
}
try{
strValue = b.toString(codeSet);
}catch(Exception e){
strValue = b.toString();
}
return strValue;
}
/**
 * ´Ë´¦²åÈë·½·¨ËµÃ÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:59:52)
 * @return java.lang.String
 * @param result java.sql.ResultSet
 * @param name java.lang.String
 */
public static String readBLOB(ResultSet result, String name) throws IOException,
SQLException
{
String strValue;
// ¶ÔÓÚSQL NULL£¬·½·¨getBinaryStream½«·µ»Ønull
InputStream in = result.getBinaryStream(name);
if (in == null) {
return "";
}
byte[] ba = new byte[8192];
ByteArrayOutputStream b = new ByteArrayOutputStream();
int i;
while((i = in.read(ba)) != -1){
b.write(ba, 0, i);
}
try{
strValue = b.toString(codeSet);
}catch(Exception e){
strValue = b.t