pic_show.jsp~1~
来自「JSP版的在线相册系统」· JSP~1~ 代码 · 共 38 行
JSP~1~
38 行
<%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*" %> <%@ page import="java.util.*"%> <%@ page import="java.text.*"%> <%@ page import="java.io.*"%> <html> <body> <jsp:useBean id="dbconn" class="org.DBConnection" scope="page"></jsp:useBean><%int picture_id=Integer.parseInt(request.getParameter("picture_id"));Connection conn=dbconn.getConnection();//String sql="select picture_name from pictures where picture_id="; //Statement stmt=null; //ResultSet rs=null; try { String sql="select picture_name from pictures WHERE picture_id="+picture_id; PreparedStatement stmt=conn.prepareStatement(sql); ResultSet rs = stmt.executeQuery(); //rs.next();while(rs.next()) { InputStream in = rs.getBinaryStream("picture_name"); response.reset(); response.setContentType("image/jpeg"); byte[] b = new byte[1024]; int len; while((len=in.read(b)) >0) response.getOutputStream().write(b,0,len); in.close(); rs.close(); } }catch(Exception e){ out.println(e);} %></body> </html> ⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?