toretopic.java~1~

一个oracle和JSP做的论坛

package hcit.servlet;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import hcit.common.*;

public class ToReTopic extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GBK";

    //Initialize global variables
    public void init() throws ServletException {
    }

    //Process the HTTP Get request
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        ArrayList al = new ArrayList();
        PrintWriter out = response.getWriter();
        HttpSession s = request.getSession();
        String m_tid = request.getParameter("m_tid");
        String m_topic = request.getParameter("m_topic");
        String m_content = request.getParameter("m_content");
        ResultSet rs = GetReturn(m_tid);
        try {
            while (rs.next()) {
                ReturnIopic_Pojo model = new ReturnIopic_Pojo();
                model.setC_date(rs.getDate("C_DATE"));
                model.setContent(rs.getString("CONTENT"));
                al.add(model);

            }
            s.setAttribute("r_list", al);
            s.setAttribute("m_tid",m_tid);
        } catch (Exception ex) {

        }
        request.setAttribute("m_topic", m_topic);
        request.setAttribute("m_content", m_content);
        RequestDispatcher dis = request.getRequestDispatcher("retlist.jsp");
        dis.forward(request,response);

        //response.sendRedirect("retlist.jsp");
    }


    public ResultSet GetReturn(String m_tid) {
        try {
            DBConnect db = new DBConnect();
            String sql = "select * from returntopic where M_TOPICID='" + m_tid +
                         "' ";
            return db.executeQuery(sql);
        } catch (Exception ex) {
            return null;
        }

    }

    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        doGet(request, response);
    }

    //Clean up resources
    public void destroy() {
    }
}