<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<html>
<head>
<title>用户注册</title>
</head>
<body>
<%
String username = request.getParameter("username");
String pass_word = request.getParameter("pass_word");
String email = request.getParameter("email");
String age = request.getParameter("age");
if(username==null||"".equals(username.trim())||pass_word==null||"".equals(pass_word.trim())){
//out.write("用户名或密码不能为空!");
System.out.println("用户名或密码不能为空!");
response.sendRedirect("lab2register.jsp");
return;
//request.getRequestDispatcher("login.jsp").forward(request, response);
}
if (email==null||"".equals(email.trim())||age==null||"".equals(age.trim())){
System.out.println("用户信息不能为空!");
response.sendRedirect("lab2register.jsp");
return;
}
if (pass_word.length() < 8){
System.out.println("密码不能低于8位字符!");
response.sendRedirect("lab2register.jsp");
return;
}
boolean m = false;//定义一个boolean值,用来表示是否包含数字
boolean m1 = false;//定义一个boolean值,用来表示是否包含字母
for(int i=0 ; i<pass_word.length() ; i++){ //循环遍历字符串
if(Character.isDigit(pass_word.charAt(i))){ //用char包装类中的判断数字的方法判断每一个字符
m = true;
}
if(Character.isLetter(pass_word.charAt(i))){ //用char包装类中的判断字母的方法判断每一个字符
m1 = true;
}
}
if (!m || !m1){
System.out.println("密码格式错误!");
response.sendRedirect("lab2register.jsp");
return;
}
pageContext.setAttribute("username",username);
pageContext.setAttribute("pass_word",pass_word);
pageContext.setAttribute("email",email);
pageContext.setAttribute("age",age);
%>
<sql:setDataSource var="dataSource"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
user="sa"
password="1234567"
url="jdbc:sqlserver://localhost:1433;databaseName=waijiao"
/>
<sql:update dataSource="${dataSource}" var="result">
INSERT INTO lab2(username,pass_word,email,age) VALUES ('${username}', '${pass_word}', '${email}', '${age}');
</sql:update>
<%
request.getRequestDispatcher("success.jsp").forward(request,response);
%>
</body>
</html>