showpic.jad

在线考试软件。 在线考试软件详细设计说明书：说明在线测试这一模块各部分的功能和结构

// Decompiled by DJ v3.2.2.67 Copyright 2002 Atanas Neshkov  Date: 2005-6-15 22:09:07
// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   ShowPic.java

package jinghua;

import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;

// Referenced classes of package jinghua:
//            JinghuaConn

public class ShowPic extends HttpServlet
{

    public ShowPic()
    {
    }

    public void service(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException
    {
        response.setContentType("image/gif");
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        String sql = null;
        Connection conn = (new JinghuaConn()).getConnection();
        String ID = request.getParameter("ID");
        String sql = "select photo from photos where ID=" + ID;
        PreparedStatement pstmt = conn.prepareStatement(sql);
        ResultSet rs = pstmt.executeQuery();
        rs.next();
        byte buffer[] = rs.getBytes(1);
        BufferedOutputStream out = new BufferedOutputStream(response.getOutputStream());
        out.write(buffer);
        out.flush();
        out.close();
        rs.close();
        pstmt.close();
        conn.close();
        break MISSING_BLOCK_LABEL_169;
        Exception e;
        e;
        System.out.println(e.toString());
        return;
    }

    private static final String CONTENT_TYPE = "image/gif";
}