registerservlet.java~29~

一个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 RegisterServlet 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();

        String bbsusers = request.getParameter("bbsuser");
        String username = request.getParameter("name");
        String pwd = request.getParameter("password");
        String emails = request.getParameter("email");
        //seq_reguser.nextval 序列userid
        String sql =
                "insert into USERDETAIL (USERID,USERNAME,PASSWD,EMAILAD,USERTYPE) values(seq_reguser.nextval,'" +
                username + "','" + pwd + "','" + emails +
                "','1')";
        try {
            int i = 0;
            i = db.executeUpdate(sql);
            if (i > 0) {
                out.println(
                        "<script>alert('注册成功，进入登录页面……');window.location='login.jsp';</script>");
            } else {
                out.println(
                        "<script>alert('注册失败,请重新注册……');window.location='register.jsp';</script>");
            }
        } 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() {
    }
}