图片链接:::img src="ShowImage?bookname=<%=su.getRequest().getParameter("bookname") %>
&author=<%=su.getRequest().getParameter("author") %>
&publisher=<%=su.getRequest().getParameter("publisher")%>
这个是链接数据库读取图片的类
public class ShowImage extends HttpServlet {
public void service(ServletRequest request,ServletResponse response)
throws ServletException,IOException {
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn=
DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseNmae=master","sa","123456");
Statement stmt = conn.createStatement();
String sql="select bookImage from book where bookName='"+codeToString(request.getParameter("bookname"))+
"' and author='"+codeToString(request.getParameter("author"))+
"'and publisher='"+
codeToString(request.getParameter("publisher"))+"' ";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
int len = 10*1024*1024;
InputStream in = rs.getBinaryStream("bookImage");
OutputStream toClient = response.getOutputStream();
response.reset();
response.setContentType("image/jpg");//或gif
byte[] P_Buf = new byte[len];
int i;
while((i = in.read(P_Buf)) != -1){
toClient.write(P_Buf, 0, i);
}
in.close();
toClient.flush();
toClient.close();
}
conn.close();
}catch(Exception e){
System.out.println("出现异常: "+e.getMessage());
}
}
//public String codeToString(String str){
//return (new String(s.getBytes("UTF-8")));
//}
private String codeToString(String parameter) {
// TODO Auto-generated method stub
return null;
}
}
我把你的代码稍微改造了下,我这边是可以显示图片的。代码如下:
数据库操作部分:
package com.database;servlet部分:
package com.servlet;web.xml中的servlet配置:
<servlet>页面中加载图片方式:
<img src="showImage" />希望对你有帮助O(∩_∩)O~