// 保存request信息

    public void saveRequestInfo(HttpServletRequest request){

        Connection conn = null;

        PreparedStatement pstmt = null;    

        BaseDao baseDao = new BaseDao();

        try {

            conn = baseDao.dbConnection();

        } catch (SQLException e1) {

            e1.printStackTrace();

        }

        StringBuffer sqlBf = new StringBuffer();

        sqlBf.setLength(0);

        sqlBf.append("INSERT INTO REQUEST_INFO (REQUEST_INFO_SEQ               \n");

        sqlBf.append("                        , CHARACTER_ENCODING             \n");

        sqlBf.append("                        , CONTENT_TYPE                   \n");

        sqlBf.append("                        , CONTEXT_PATH                   \n");

        sqlBf.append("                        , LOCAL_ADDR                     \n");

        sqlBf.append("                        , LOCAL_NAME                     \n");

        sqlBf.append("                        , LOCAL_PORT                     \n");

        sqlBf.append("                        , METHOD                         \n");

        sqlBf.append("                        , REMOTE_ADDR                    \n");

        sqlBf.append("                        , REMOTE_HOST                    \n");

        sqlBf.append("                        , REMOTE_PORT                    \n");

        sqlBf.append("                        , REMOTE_USER                    \n");

        sqlBf.append("                        , REQUEST_URI                    \n");

        sqlBf.append("                        , REQUESTED_SESSION_ID           \n");

        sqlBf.append("                        , LOCALE                         \n");

        sqlBf.append("                        , REGI_DT)                       \n");

        sqlBf.append("VALUES(SEQ_REQUEST_INFO.NEXTVAL                          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , ?          \n");

        sqlBf.append("     , SYSDATE)   \n");

        System.out.println(sqlBf.toString());

        try {

            pstmt = conn.prepareStatement(sqlBf.toString());

            idx = 1;

            pstmt.setString(idx++, request.getCharacterEncoding());

            pstmt.setString(idx++, request.getContentType());

            pstmt.setString(idx++, request.getContextPath());

            pstmt.setString(idx++, request.getLocalAddr());

            pstmt.setString(idx++, request.getLocalName());

            pstmt.setInt(idx++, request.getLocalPort());

            pstmt.setString(idx++, request.getMethod());

            pstmt.setString(idx++, request.getRemoteAddr());

            pstmt.setString(idx++, request.getRemoteHost());

            pstmt.setInt(idx++, request.getRemotePort());

            pstmt.setString(idx++, request.getRemoteUser());

            pstmt.setString(idx++, request.getRequestURI());

            pstmt.setString(idx++, request.getRequestedSessionId());

            pstmt.setString(idx++, request.getLocale().toString());

            int i = pstmt.executeUpdate();

            if (i == 1) {

                System.out.println("##### save request success \n");

            } else {

                System.out.println("##### save request fail \n");

            }

        } catch (SQLException e) {

            e.printStackTrace();

        }

        try {

            baseDao.dbDisconnection();

        } catch (SQLException e) {

            e.printStackTrace();

        }

    }

CREATE TABLE SCOTT.REQUEST_INFO

(

    REQUEST_INFO_SEQ       NUMBER NOT NULL,

    CHARACTER_ENCODING     VARCHAR2 (10),

    CONTENT_TYPE           VARCHAR2 (10),

    CONTEXT_PATH           VARCHAR2 (50),

    LOCAL_ADDR             VARCHAR2 (50),

    LOCAL_NAME             VARCHAR2 (50),

    LOCAL_PORT             NUMBER,

    METHOD                 VARCHAR2 (10),

    REMOTE_ADDR            VARCHAR2 (20),

    REMOTE_HOST            VARCHAR2 (20),

    REMOTE_PORT            NUMBER,

    REMOTE_USER            VARCHAR2 (20),

    REGI_DT                DATE,

    REQUEST_URI            VARCHAR2 (50),

    REQUESTED_SESSION_ID   VARCHAR2 (100),

    LOCALE                 VARCHAR2 (20)

)

ALTER TABLE SCOTT.REQUEST_INFO ADD(

    CONSTRAINT PK_REQUEST_INFO_SEQ PRIMARY KEY (REQUEST_INFO_SEQ));

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        RequestInfoService ris = new RequestInfoService();

        ris.saveRequestInfo(request);

        EmpService es = new EmpService();

        EmpBean eb = new EmpBean();

        eb.setEname(request.getParameter("searchTxt"));

        ArrayList<EmpBean> empBean = es.getEmpList(eb);

        request.setAttribute("empBean", empBean);

        request.getRequestDispatcher("/view/empList.jsp").forward(request, response);

    }