📄 adduser.jsp~26~

📁 system1为用户注册模块 system2为在线聊天系统 system3为在线投票系统 system4为在线考试系统 system5为新闻发布模块

💻 JSP~26~

字号:

<%@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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -