急求!!!!望各位高手帮忙

luzhangfang 2008-06-11 08:01:22

通过Struts实现图片上传，并且将该图片保存到ORACLE数据库里，要求保存该图片的二进制数据，不是保存图片路径。
　感谢大家了...

...全文

59 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

胡矣 2008-06-12

打赏
举报

BLOB 存就行了

luzhangfang 2008-06-12

打赏
举报

读取:
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="gb2312"%>
<%@ page import="com.imti.struts.util.Dbutil" %>
<%@page import=" org.apache.struts.upload.FormFile" %>
<%@ page import="com.imti.struts.dao.*" %>
<%@ page import=" com.imti.struts.form.UploadForm" %>
<%@ page import="java.io.BufferedOutputStream" %>
<%@ page import= "java.io.BufferedInputStream" %>
<%@ page import="java.io.ByteArrayInputStream" %>

<html>
<%
UploadForm file=new UploadForm();
FormFile phoneForm=file.getFile();
Dbutil db=new Dbutil();

String sql="select * from photoform";
System.out.println(sql);
ResultSet rs=db.QuerySql(sql);
System.out.println("2222222222");
while(rs.next())
{
System.out.println("1111111111");
oracle.sql.BLOB bolophoto=(oracle.sql.BLOB)rs.getBlob(1);
System.out.println("122222222222222222222");
byte[] bophoto=phoneForm.getFileData();
BufferedOutputStream photoOut=new BufferedOutputStream(bolophoto.getBinaryOutputStream());
BufferedInputStream photoIn = new BufferedInputStream(new ByteArrayInputStream(bophoto));
int c;
while ((c = photoIn.read()) != -1) {
photoOut.write(c);
}
photoIn.close();
photoOut.close();
}

%>
</html>

luzhangfang 2008-06-12

打赏
举报

上传图片:
package com.imti.struts.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import javax.naming.NamingException;

import org.apache.struts.upload.FormFile;

import com.imti.struts.form.UploadForm;
import com.imti.struts.util.Dbutil;

public class Dao
{
public int ifSuccess(UploadForm form) throws NamingException, SQLException
{
FormFile file=form.getFile();
Dbutil db=new Dbutil();
String sql="insert into photoform values(message_s.nextval,EMPTY_BLOB())";
int count=db.UpdateSql(sql);
return count;

}

}