67,537
社区成员
发帖
与我相关
我的任务
分享急求!!!!望各位高手帮忙
通过Struts实现图片上传，并且将该图片保存到ORACLE数据库里，要求保存该图片的二进制数据，不是保存图片路径。
感谢大家了...
感谢大家了...
...全文
请发表友善的回复…
发表回复
胡矣 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>
<%@ 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;
}
}
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;
}
}
tsxzscj 2008-06-12
- 打赏
- 举报
强烈建议你看一下
http://www.life369.cn/bbs/dispbbs.asp?boardid=17&id=107&star=1&page=1
http://www.life369.cn/bbs/dispbbs.asp?boardid=17&id=107&star=1&page=1
forerver121 2008-06-12
- 打赏
- 举报
代码贴出来
千秋大秋一壶茶 2008-06-12
- 打赏
- 举报
你把写的代码贴出来看看
luzhangfang 2008-06-12
- 打赏
- 举报
我用bolb存的，但是无法读取呢
读不出来啊
读不出来啊
