adduser.jsp~24~

来自「system1为用户注册模块 system2为在线聊天系统 system3为」· JSP~24~ 代码 · 共 56 行

JSP~24~
56
字号
<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<jsp:useBean id="db" class="database.dbbean" scope="page">
</jsp:useBean>

<%

  String Username=request.getParameter("Username");
  String Password=request.getParameter("Password");
  String Email=request.getParameter("Email");
  String Question=request.getParameter("Question");
  if (Question=="0")
  {
   Question="你最爱的宠物";
  }
  else if(Question=="1")
  {
   Question="你最爱的老师的名字";
  }
  else
  {
   Question="你最喜欢的品牌";
  }
  String Reply=request.getParameter("Reply");

  ResultSet rs=null;

  String sqlstring = "select * from UserInfo where UserName='"+Username+"'";
  rs = db.executeQuery(sqlstring);
 if(!rs.next())
 {
  sqlstring="insert into UserInfo(UserName,PassWord,Email,Question,Reply) values ('"+Username+"','"+Password+"','"+Email+"','"+Question+"','"+Reply+"')";
  db.executeUpdate(sqlstring);

  session.setAttribute("s_username",Username);
  session.setAttribute("s_password",Password);
  session.setAttribute("s_Email",Email);
  session.setAttribute("s_Question",Question);
  session.setAttribute("s_Reply",Reply);

  response.sendRedirect("member.jsp");
  }
  else
  {
  %>
<html>
<body>
<p><a href="Register.jsp">返回</a></p>
</body>
 </html>
  <%
   out.println("该用户名已登记,请使用其他用户名注册!");
  }
  %>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?