oracle复制blob字段,ORACLE操作BLOB字段

上传javabean

/**

* Oracle 上传文件至BLOB字段

* @param myUpload 上传类对象

* @param path 上传路径

* @param serialNo 序列号

* @throws Exception

*/

public void InsertMsg(SmartUpload myUpload, String path, String serialNo)

throws Exception {

/* 设定不自动提交 */

Connection conn = getConnection();

Statement stmt = conn.createStatement();

PreparedStatement ps = null;

boolean defaultCommit = conn.getAutoCommit();

conn.setAutoCommit(false);

String strSQL = "";

try {

com.jspsmart.upload.File myFile = myUpload.getFiles().getFile(0);

if (!myFile.isMissing()) {

String FileName = myFile.getFileName();

String Filesize = myFile.getSize() + "";

/**

* 插入除blob外的其他信息

*/

strSQL =

"insert into T_CommFiles (serialNo,filename,filesize) values('"

+ serialNo

+ "','"

+ FileName

+ "','"

+ Filesize

+ "')";

ps = conn.prepareStatement(strSQL);

ps.executeUpdate();

ps.close();

ps = null;

String fileType = myFile.getContentType();

String ByteLen = String.valueOf(myFile.getSize());

java.io.File folder = new java.io.File(path);

if (!folder.exists() || folder.isFile())

folder.mkdirs();

myFile.saveAs(path + FileName);

java.io.File file = new java.io.File(path + FileName);

/**

* 清空BLOB字段

*/

String resetClob =

"UPDATE T_CommFiles SET files=EMPTY_BLOB() WHERE serialNo='"

+ serialNo

+ "'";

stmt.executeUpdate(resetClob);

strSQL =

"select files from T_CommFiles where serialNo='"

+ serialNo

+ "' for update";

ResultSet rs = stmt.executeQuery(strSQL);

/**

* 写入BLOB

*/

while (rs.next()) {

/* 取出此BLOB对象 */

oracle.sql.BLOB blob =

(oracle.sql.BLOB) rs.getBlob("files");

/* 向BLOB对象中写入数据 */

BufferedOutputStream out =

new BufferedOutputStream(blob.getBinaryOutputStream());

BufferedInputStream in =

new BufferedInputStream(new FileInputStream(file));

//blob.putBytes(1,b);

int c;

while ((c = in.read()) != -1) {

out.write(c);

}

in.close();

out.close();

}

file.delete();

/* 正式提交 */

conn.commit();

rs.close();

stmt.close();

}

} catch (Exception ex) {

/* 出错回滚 */

System.out.println(ex.getMessage());

conn.rollback();

throw ex;

}

/* 恢复原提交状态 */

conn.setAutoCommit(defaultCommit);

conn.close();

}

download.jsp从BLOB读取文件

String serialNo=request.getParameter("serialNo");

java.sql.Connection con = null;

DbConnection dbCon=new DbConnection();

try{

//连接数据库

con = dbCon.connectByIplanet();

//查询数据库

String str="select files from T_COMMFILES where serialNo='"+serialNo+"'";

PreparedStatement pst=con.prepareStatement(str);

ResultSet rs=pst.executeQuery();

while(rs.next())

{

//读取

oracle.sql.BLOB files = (oracle.sql.BLOB)rs.getBlob("files");

InputStream in = files.getBinaryStream();

response.setContentType("application/x-msdownload");

OutputStream os = response.getOutputStream();

byte[] b = new byte[1024];

int len;

while((len=in.read(b))  >0)

os.write(b,0,len);

//释放资源

os.close();

in.close();

}

rs.close();

con.close();

}catch(Exception  e)

{

System.out.println(e);

}

%>