queryuser.jsp

来自「论坛元程序」· JSP 代码 · 共 46 行

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*"  %>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>

<%!String User_Name,User_Password,User_Password1,sql,User_Question,User_Email,User_Answer,User_Icon;%>
<%
User_Name=request.getParameter("name");
User_Name=yy.ex_chinese(User_Name);
User_Password=request.getParameter("password");
User_Password=yy.ex_chinese(User_Password);
User_Password1=request.getParameter("password2");
User_Password1=yy.ex_chinese(User_Password1);
User_Question=request.getParameter("question");
User_Question=yy.ex_chinese(User_Question);
User_Answer=request.getParameter("answer");
User_Answer=yy.ex_chinese(User_Answer);
User_Email=request.getParameter("email");
User_Icon=request.getParameter("icon");


Connection con=yy.getConn();
Statement  stmt=con.createStatement();
ResultSet  rs=null;
sql="select * from User where user_name='"+User_Name+"'";
rs=stmt.executeQuery(sql);
if (rs.next())
{
   response.sendRedirect("err.jsp?id=3");
}
sql="select * from User where email='"+User_Email+"'";
rs=stmt.executeQuery(sql);
if (rs.next())
{
   response.sendRedirect("err.jsp?id=2");
}
else
{
sql="insert into User(user_name,user_password,question,answer,email,user_pic,user_rank,numofpublish,numofvisit,register_time,isonline)";
sql=sql+" values('"+User_Name+"','"+User_Password+"','"+User_Question+"','"+User_Answer+"','"+User_Email+"','"+User_Icon+"','1','0','1','"+yy.getTime()+"','1')";
//out.println(sql);
stmt.executeUpdate(sql);
session.putValue("UserName",User_Name);
session.putValue("UserLevel","新手上路");
session.putValue("UserClass","1");
out.println("<font size=2 color=blue>谢谢您的注册，正在处理您的用户信息，稍后会自动登陆...</font><meta http-equiv='refresh' content='2;url=index.jsp'>");
}
%>