如何读取保存在SQL数据库中图片,我搜索了很多贴子,都没解决!
oolin 2004-10-14 01:26:18 我的使用sql 2000数据库,数据表就两个字段,id及image
我的servlet代码。
public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {
String id = request.getParameter("id");
if (id==null) id="1";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String URL="jdbc:microsoft:sqlserver://127.0.0.1:1433;User=sa;Password=123;DatabaseName=jsp";
Connection conn=DriverManager.getConnection(URL);
String cmd="select image from jsp where id="+id;
PreparedStatement sql=conn.prepareStatement(cmd);
ResultSet rs = sql.executeQuery();
if (rs.next()){
response.reset();
response.setContentType("image/*");
ServletOutputStream out = response.getOutputStream();
InputStream inStream = rs.getBinaryStream("image");
byte[] b = new byte[1024];
int len;
while((len=inStream.read(b)) >0){
out.write(b,0,len);
}
out.close();
inStream.close();
}
}catch (Exception e){
System.out.println(e);
}
}
可是运行后的结果确是:
-----------------------------7d465a1d0544 Content-Disposition: form-data; name="filename"; filename="D:\web\logo.jpg" Content-Type: image/pjpeg ?JFIFHH?逧..............(还有很多)....
请各位帮忙一下了,我找不到解决的办法,搜索了很多贴子,都没解决。