newtopicservlet.java~34~

一个oracle和JSP做的论坛

package hcit.Servlet;

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

public class NewtopicServlet 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 session = request.getSession();
        String uid = session.getAttribute("userid").toString();
        String content = request.getParameter("content");
        String title = request.getParameter("title");

        String sql = "insert into maintopic values (seq_maintopic.nextval,'"+uid+"',sysdate,'"+content+"',0,0,'"+title+"')";
        try {
            int i =0;
            i = db.executeUpdate(sql);
            if (i > 0){
                out.println("<script>alert('发帖成功！');window.location='main.jsp'</script>");
            }else{
                out.println("<script>alert('发帖失败！');window.location='newtopic.jsp'</script>");
            }
        } catch (Exception ex) {
            out.println("<script>alert('发帖失败！');window.location='newtopic.jsp'</script>");
        }

    }

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

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