怪,为什么取不出数据库中的图形???
各位大侠、高手:
我想用showImgservlet从数据库取出图形(图形可以上传到数据库),但不知道为什么屏幕上总是空白。我在一个jsp程序中加入代码<img src="showImgservlet"> ,该servlet的主要代码如下,我将service改成doGet、doPost也不行。我的配置:mysql、tomcat4.1.24。
public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("image/*");
PrintWriter out = response.getWriter();
String sql="select content from unitinfo where id=32";
commJDBC myconn=new commJDBC(sql);
try {
ResultSet rs=myconn.executeQuery();
if (rs.next()) {
InputStream contentImg = rs.getBinaryStream(1);
response.reset();
response.setContentType("image/jpg");
OutputStream toClient = response.getOutputStream();
int size = contentImg.available();
byte[] bzp = new byte[size];
contentImg.read(bzp);
contentImg.close();
toClient.flush();
toClient.close();
}
......