ajax+jsp+MySql+页面跳转 注册用户 判断用户名格式(正则表达式),信息保存数据库
index.jsp文档
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html" charset="UTF-8">
<script type="text/javascript">
function checkUsername(username){
if(form1.username.value==""){
alert("请输入用户名");
form1.username.focus();
return;
}
var user2 = document.getElementById("user_id").value;
var reg1 =/^[a-z].*$/
var reg2 =/^.{8,}$/
if(reg1.test(user2)==false | reg2.test(user2)==true){
alert("您用户名格式有误!");
return;
}
createRequest("checkusername.jsp?user="+form1.username.value);
}
function zhuce(form1){
var pwd1 = document.getElementById("pwd_id").value;
var reg1 =/^[A-Z].*$/
var reg2 =/^.{16,}$/
if(reg1.test(pwd1)==false | reg2.test(pwd1)==true){
alert("您密码格式有误!");
return;
}
createRequest("zhuce.jsp?user="+form1.username.value+"&pwd="+form1.pwd.value);
}
function createRequest(url){
http_request=new XMLHttpRequest();
http_request.onreadystatechange=function(){
if(http_request.readyState==4){
if(http_request.status==200){
alert(http_request.responseText);
if(http_request.responseText==1)
window.location.href = "index.jsp";<%
}else{
alert("您请求的页面有错误!");
}
}
}
http_request.open("POST",url,true);
http_request.send(null);
}
</script>
</head>
<body>
<form name="form1" action="" onSubmit="return zhuce(form1)">
用户名:
<input type="text" name="username"id="user_id" size=10 onblur="checkUsername(this.form.username)" />
密 码:<%
<input type="password" name="pwd" id="pwd_id" size=10 />
<input type="button" name="Button"size=10 value="注册" onclick="zhuce(form1)" />
</form>
</body>
</html>
register 后台处理
<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<%
String user=new String(request.getParameter("user").getBytes("ISO-8859-1"),"UTF-8");
String pwd=new String(request.getParameter("pwd").getBytes("ISO-8859-1"),"UTF-8");
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("加载数据库驱动时抛出异常,内容如下:");
e.printStackTrace();
}
Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/taobaoDB?useSSL=true&serverTimezone=GMT", "root", "123456");
Statement stmt = conn.createStatement();
int rtn = stmt.executeUpdate("insert into user_info(name,password) values('"+user+"','"+pwd+"')");
out.println("注册成功" );
out.println("1" );
stmt.close();
conn.close();
%>