returntopicservlet.java~13~

一个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 ReturnTopicServlet 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);
        PrintWriter out = response.getWriter();

        request.setCharacterEncoding("gb2312");
        DBConnect db = new DBConnect();
        HttpSession s = request.getSession();
        String userid = (String) s.getAttribute("userid");
        String face = request.getParameter("ticon");
        String returnconent =new String(request.getParameter("content").getBytes("iso-8859-1"),"gb2312");
        String mtid =  s.getAttribute("m_tid").toString();
        String sqlr = "insert into RETURNTOPIC values (seq_RTOPICID.nextval,"+mtid+",sysdate,'" +
                      returnconent + "','" + userid + "',1,0)";
        String sqlu="update maintopic set r_num = r_num + 1 where M_TOPICID= "+mtid;

        try {
            int k = 0;
            db.executeUpdate(sqlu);
            k = db.executeUpdate(sqlr);
            if (k > 0) {
                RequestDispatcher dis = request.getRequestDispatcher(
                        "mainlistservlet");
                dis.forward(request, response);
            } else {
                RequestDispatcher dis = request.getRequestDispatcher(
                        "retlist.jsp");
                dis.forward(request, response);

            }
        } catch (Exception ex) {

        }
    }



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

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