toretopicservlet.java

一个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 ToReTopicServlet 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 = new String(request.getParameter("m_tid").getBytes(
                "ISO-8859-1"));
        String m_topic = new String(request.getParameter("m_topic").getBytes(
                "ISO-8859-1"));
        String m_content = new String(request.getParameter("m_content").
                                      getBytes("ISO-8859-1"));
        ResultSet rs = GetReturn(m_tid);
        int p_num = update_pnum(m_tid);

        try {
            while (rs.next()) {
                ReturnIopic_Pojo model = new ReturnIopic_Pojo();
                model.setR_topicid(rs.getString("R_TOPICID"));
                model.setC_date(rs.getDate("C_DATE"));
                model.setContent(rs.getString("CONTENT"));
                model.setUp(rs.getInt("UP"));
                model.setDown(rs.getInt("DOWN"));
                model.setFace_adress(rs.getString("FACE_ADREE"));
                al.add(model);
            }
            s.setAttribute("r_list", al);
            s.setAttribute("m_tid", m_tid);
        } catch (Exception ex) {

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


    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;
        }
    }


    public int update_pnum(String m_tid) {
        try {
            int num = 0;
            DBConnect db = new DBConnect();
            String sql =
                    "update maintopic set p_num = p_num + 1 where M_TOPICID =" +
                    m_tid;
            num = db.executeUpdate(sql);
            if (num > 0) {
                return num;
            } else {
                return 0;
            }
        } catch (Exception ex) {
            return 0;
        }
    }


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

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