📄 checkregister.jsp
字号:
<HTML>
<BODY>
<%@ page import="java.util.*, java.sql.*"
contentType="text/html;charset=GB2312" %>
<jsp:useBean id="pool" scope="application" class="chapter10.ConnPool"/>
<%String name=new String(request.getParameter("name").getBytes("ISO8859_1"),"GBK");
String password1=new String(request.getParameter("password1").getBytes("ISO8859_1"),"GBK");
String password2=new String(request.getParameter("password2").getBytes("ISO8859_1"),"GBK");
String email=request.getParameter("email");
boolean valid=true;
String err="";
%>
<%@ include file="conn.jsp"%>
<%
sql="select ID from Users where Name='"+name+"'";
ResultSet rs=statement.executeQuery(sql);
if (rs.next()){
err+="该用户名已经存在,请更换用户名!<br>";
valid=false;
}else if (name.equals("")||password1.equals("")||password2.equals("")||email.equals("")){
err+="用户名、电子邮箱、密码和密码确认都不能为空!<br>";
valid=false;
}else if (!password1.equals(password2)){
err+="两次输入的密码不同!<br>";
valid=false;
}else{
sql="insert into Users (Name,Password,Email,IsAdmin,Disable) values ('"
+name+"','"+password1+"','"+email+"',false,false)";
statement.executeUpdate(sql);
}%>
<%@ include file="disconn.jsp"%>
<%if (valid) {
response.sendRedirect("login.html");
}else{%>
<%=err%>
<a href="javascript:history.back();">返回</a>
<%}%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -