registerinformation_deal.jsp

该网上论坛除了包含数据库之外,还有能够成功地进行信息上传及返回

<%@ page language="java" contentType="text/html; charset=GB18030"
    pageEncoding="GB18030"%>
<%@ page import="java.sql.*" errorPage=""%>
<jsp:useBean id="connBean" scope="page" class="JavaBean.connDB"/>

<%
	request.setCharacterEncoding("GB2312");
    String UserName = request.getParameter("username");
    String Password = request.getParameter("password");
    String ConfirmPassword  = request.getParameter("confirmPassword");
    String BirthDay = request.getParameter("Birthday");
    String Sex = request.getParameter("sex");//如何处理单选按钮，
    String QQ = request.getParameter("QQ");
    String Telphoto = request.getParameter("telnumber");
    String Address  = request.getParameter("address");
    String Code = request.getParameter("code");
    String Email = request.getParameter("E_mail");
    
    ResultSet rs = connBean.executeQuery("SELECT * FROM LoginInformation WHERE UserName='"+UserName+"'");
    if(rs.next())
    	out.println("<script language='javascript'>alert('该用户已经注册过，请重新注册！');window.location.href='RegisterUser.jsp'</script>");
    String sql = "INSERT INTO RegisterInformation VALUES('"+UserName+"','"+Password+"','"+ConfirmPassword+"','"+BirthDay+"r','"+Sex+"','"+QQ+"','"+Telphoto+"','"+Address+"','"+Code+"','"+Email+"',default)";
    int result = connBean.executeUpdate(sql);
    if(result!=0) 
    	out.println("<script language='javascript'>alert('该用户注册成功！');window.location.href='HomePage.jsp'</script>");
    else
    	out.println("<script language='javascript'>alert('该用户注册失败！');window.location.href='RegisterUser.jsp'</script>");
%>