insertretopicservlet.java~4~

一个oracle和JSP做的论坛

package hcit.Servlet;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;

public class insertReTopicServlet 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();

        DBConnect db = new DBConnect();

        HttpSession s = request.getSession();
        String userid = (String) s.getAttribute("userid");
        String title = request.getParameter("title");
        String content = request.getParameter("content");
        String sqlinsert = "insert into MAINTOPIC (M_TOPICID,USERID,C_DATE,CONTENT,P_NUM,R_NUM,TOPICTITLE) values (seq_MTid.nextval,'" +
                           userid + "', sysdate ,'" + content + "',0,0,'" +
                           title + "')";

        try {
            int j = 0;
            j = db.executeUpdate(sqlinsert);

            if (j > 0) {
                RequestDispatcher dis = request.getRequestDispatcher("mainlist");
                dis.forward(request, response);
            } else {
                RequestDispatcher dis = request.getRequestDispatcher(
                        "error.jsp");
                dis.forward(request, response);
            }
        } catch (Exception ex) {
            //System.out.print(ex.toString());
        }

    }

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

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