科技成果转化网站建设方案,网站页面布局图片,工艺品网站建设,东莞哪家网站建设专业展开全部有两种方法一是用上传的组建jspSmartUpload的Request#xff0c;还有一种不用组建#xff0c;但在e69da5e6ba9062616964757a686964616f31333238653233form表单中不能加入ENCTYPE multipart/form-data 我给你的案例吧建立后台数据库if exists (select * f…展开全部有两种方法一是用上传的组建jspSmartUpload的Request还有一种不用组建但在e69da5e6ba9062616964757a686964616f31333238653233form表单中不能加入ENCTYPE multipart/form-data 我给你的案例吧建立后台数据库if exists (select * from dbo.sysobjectswhere id object_id(N[dbo].[p]) and OBJECTPROPERTY(id, NIsUserTable) 1)drop table [dbo].[p]GOCREATE TABLE [dbo].[p] ([picid] [int] IDENTITY (1, 1) NOT NULL ,[picname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[pic] [image] NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO3.向数据库存储二进制图片启动Dreamweaver MX后新建一个JSP文件。其代码如下所示。String path request.getContextPath();String basePath request.getScheme()://request.getServerName():request.getServerPort()path/;%My JSP InputImage.jsp starting page题目图片将此文件保存为InputImage.jsp文件其中testimage.jsp文件是用来将图片数据存入数据库的具体代码如下所示String path request.getContextPath();String basePath request.getScheme()://request.getServerName():request.getServerPort()path/;%My JSP testimage.jsp starting pagerequest.setCharacterEncoding(gb2312);//建立Statement对象String picnamerequest.getParameter(picname);String picrequest.getParameter(pic);//获得所要显示图片的标题、存储路径、内容并进行中文编码FileInputStream strnew FileInputStream(pic);String sqlinsert into p(picname,pic) values(?,?);PreparedStatement pstmtconn.getPreparedStatement(sql);pstmt.setString(1,picname);pstmt.setBinaryStream(2,str,str.available());pstmt.execute();//将数据存入数据库out.println(Success,You Have Insert an Image Successfully);%4. 网页中动态显示图片接下来我们要编程从数据库中取出图片其代码如下所示。String path request.getContextPath();String basePath request.getScheme()://request.getServerName():request.getServerPort()path/;%My JSP testimageout.jsp starting pageint id Integer.parseInt(request.getParameter(picid));String sql select pic from p WHERE picidid;ResultSet rsconn.getResult(sql);while(rs.next()){ServletOutputStream sout response.getOutputStream();//图片输出的输出流InputStream in rs.getBinaryStream(1);byte b[] new byte[0x7a120];for(int i in.read(b); i ! -1;){sout.write(b);//将缓冲区的输入输出到页面in.read(b);}sout.flush();//输入完毕清除缓冲sout.close();}%将此文件保存为testimageout.jsp文件。下一步要做的工作就是使用HTML标记String path request.getContextPath();String basePath request.getScheme()://request.getServerName():request.getServerPort()path/;%My JSP lookpic.jsp starting pageString sql select * from p;ResultSet rsconn.getResult(sql);while(rs.next()){% width100 height100}rs.close();%已赞过已踩过你对这个回答的评价是评论收起
