请帮忙解决，在jsp中怎样将图片存入数据库?

[zhuolili]

请大家帮忙啦！小女子不胜感激！！！用什么方法啊？

[zhuolili]

用上传附件的方法？应该怎么做呀。。。。。。多谢各位啦！

[宵云]

可以上传的数据库的blob字段，网上有好多这样的组件，java用到的有javazoom的fileupload,还有smartupload等,很多你可以到网上找找

[zhuolili]

请问，你能举个例子吗？

[宵云]

给你一段代码你参考一下
public boolean saveFileInRecord(String filename) throws Exception {
BLOB blob;
File binFile;
FileInputStream instream;
OutputStream outstream;

ResultSet rset = null;
Statement stmt = null;
Statement stmt1=null;
try {
stmt = conn.createStatement();
stmt.executeUpdate("insert into BLOB_B(ID,CONTENT) values('1',empty_blob())");
conn.commit();

String sqlStr ="SELECT CONTENT FROM BLOB_B WHERE id='1' FOR UPDATE";
rset = stmt.executeQuery(sqlStr);
rset.next();

blob = ( (OracleResultSet) rset).getBLOB(1);

binFile = new File(filename);
instream = new FileInputStream(binFile);
outstream = blob.getBinaryOutputStream();
byte[] chunk = new byte[blob.getChunkSize()];
int i = -1;

while ( (i = instream.read(chunk)) != -1) {
outstream.write(chunk, 0, i);
System.out.print('.');
}

outstream.close();
instream.close();
rset.close();
stmt.close();

return true;
}
catch (Exception e) {
System.out.println("AddBlob.saveFileInRecord error:"+e.getMessage());
return false;
}
finally {
conn.close();
}

}

[宵云]

这段代码什么文件都可以上传,filename是要上传的文件名,blob_b是数据库存放文件的表名,conten是blob类型字段用于存放文件