我把你的代码稍微改造了下,我这边是可以显示图片的。代码如下:
数据库操作部分:
package com.database;
import java.io.InputStream;
import java.sql.*;
/**
* @作者 王建明
* @创建日期 13-10-7
* @创建时间 下午12:32
* @版本号 V 1.0
*/
public class DataBaseUtil {
public static InputStream getImageStreamFromDataBase() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn =
DriverManager.getConnection("jdbc:mysql://localhost/quickstart", "root", "123456");
Statement stmt = conn.createStatement();
String sql = "select book_image from tbl_book where id=1 ";
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
return rs.getBinaryStream("book_image");
}
} catch (Exception e) {
System.out.println("出现异常: " + e.getMessage());
} finally {
try {
if (conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return null;
}
}
servlet部分:
package com.servlet;
import com.database.DataBaseUtil;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
/**
* @作者 王建明
* @创建日期 13-10-7
* @创建时间 下午12:18
* @版本号 V 1.0
*/
public class ShowImage extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
InputStream in = DataBaseUtil.getImageStreamFromDataBase();
OutputStream toClient = response.getOutputStream();
response.reset();
response.setContentType("image/jpg");//或gif
int len = 10*1024*1024;
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();
}
}
web.xml中的servlet配置:
ShowImage
com.servlet.ShowImage
ShowImage
/showImage
页面中加载图片方式:
希望对你有帮助O(∩_∩)O~
数据保存文件的路径,上传下载文件的时候把文件拷贝到指定的位置,最好在数据库中设置两个名字,一个是文件的原始名字,一个是不会重复的名字,如:已上传的时间精确到毫秒命名,最好用java类库中的UUID类。你可以把文件保存到项目的根目录下,这样方便读写