reg_deal.jsp

来自「jsp留言簿,包括留言和回复功能等等」· JSP 代码 · 共 30 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connBean" scope="page" class="beans.connDB"/>
<%
request.setCharacterEncoding("GB2312");
String username=request.getParameter("username");
String PWD=request.getParameter("PWD1");
String birthday=request.getParameter("birthday");
String sex=request.getParameter("sex");
String OICQ=request.getParameter("OICQ");
String tel=request.getParameter("tel");
String homepage=request.getParameter("homepage");
String address=request.getParameter("address");
String postcode=request.getParameter("postcode");
String Email=request.getParameter("Email");
ResultSet rs=connBean.executeQuery("select * from tb_user where username='"+username+"'");
if (rs.next()){
	out.println("<script language='javascript'>alert('该用户名已经存在，请重新注册！');window.location.href='reg.jsp';</script>");
}else{
	String sql="Insert into tb_User values('"+username+"','"+PWD+"','"+birthday+"','"+sex+"','"+OICQ+"','"+tel+"','"+homepage+"','"+address+"','"+postcode+"','"+Email+"',default )";
	int ret=0;
	ret=connBean.executeUpdate(sql);
	if (ret!=0){
		out.println("<script language='javascript'>alert('用户注册成功！');window.location.href='index.jsp';</script>");
		}else{
		out.println("<script language='javascript'>alert('用户注册失败！');window.location.href='reg.jsp';</script>");
	}
}
%>