insertretopicservlet.java~2~

一个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 username=(String)s.getAttribute("username");
            //String topic = request.getParameter("zhiye");
            String title = request.getParameter("title");
            String content = request.getParameter("content");
            //String biaoqing = request.getParameter("ticon");
            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) {
                    //out.println("<script>alert('添加成功');window.location.href='main.jsp';</script>" );
                    RequestDispatcher dis = request.getRequestDispatcher("mainlist");
                    dis.forward(request, response);
                } else {
                    //out.println("<script>alert('添加失败');window.location.href='newtopic.jsp';</script>" );
                    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() {
    }
}