数据库图片的存储和显示

//****************************************************************** //(C)Copyright xxx （恒森科技） //****************************************************************** /** * * PicOutAction 继承BaseAction，实现显示图片 * * @author zhang-hongjing */ //****************************************************************** //Modification History // //Date Name Reason for change //---------- ----------- ------------------------------------------- //2008/1/8 zhang-hongjing 新建 // // //****************************************************************** package action; import java.sql.ResultSet; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import common.action.BaseAction; import common.conn.DBconn; import java.io.*; /** * @author zhang-hongjing * */ public class PicOutAction extends BaseAction { /** * @param mapping * @param form * @param request * @param response * @return */ public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { // 新建DBconn对象 DBconn dbconn = new DBconn(); dbconn.getCon(); //获取图片名称 String picname = request.getParameter("picname"); //执行SQL语句 String sql = "select pic from p where picname='" + picname + "'"; ResultSet rs = dbconn.getStmt().executeQuery(sql); //判断查询结果中是否有值 if (rs.next()) { //图片输出的输出流 ServletOutputStream sout = response.getOutputStream(); //将缓冲区的输入输出到页面 InputStream in = rs.getBinaryStream(1); byte b[] = new byte[1024]; for (int i = in.read(b); i != -1;) { sout.write(b); in.read(b); } //输入完毕，清除缓冲 sout.flush(); sout.close(); //返回"welcome"标签 return mapping.findForward("welcome"); } return null; } }