EasyMall注册功能-02
任务:实现注册功能!
1.创建数据库、表
create database easymall;
use easymall;
create table user (
id int primary key auto_increment,
username varchar(20),
password varchar(20),
nickname varchar(20),
email varchar(40)
);
2.开发注册Servlet
a.知识点
获取请求参数
请求参数乱码处理
请求转发
request域传递数据
JDBC访问数据库
数据库连接池的使用
b.代码实现
regist.jsp源码:
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE HTML>
<html>
<head>
<title>欢迎注册EasyMall</title>
<meta http-equiv="Content-type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" href="/EM01/css/regist.css"/>
<script type="application/javascript">
//表单提交校验
function checkForm(){
var canSub = true;
canSub = checkNull("username","用户名不能为空") && canSub;
canSub = checkNull("nickname","昵称不能为空") && canSub;
canSub = checkNull("email","邮箱不能为空") && canSub;
canSub = checkNull("valistr","验证码不能为空") && canSub;
canSub = checkPsw() && canSub;
canSub = checkEmail() && canSub;
return canSub;
}
//邮箱校验
function checkEmail(){
setMsg("email","")
var email = document.getElementsByName("email")[0].value;
if(email.trim()==""){
setMsg("email","邮箱不能为空!")
return false;
}
if(!/^\w+@\w+(\.\w+)+$/.test(email)){
setMsg("email","邮箱格式不正确!")
return false;
}
return true;
}
//密码校验
function checkPsw(){
setMsg("password","")
setMsg("password2","")
var flag = true;
var psw1 = document.getElementsByName("password")[0].value
var psw2 = document.getElementsByName("password2")[0].value
if(psw1.trim()==""){
setMsg("password","密码不能为空")
flag = false;
}
if(psw2.trim()==""){
setMsg("password2","确认密码不能为空")
flag = false;
}
if(flag && psw1.trim()!=psw2.trim()){
setMsg("password2","两次密码不一致!");
flag = false;
}
return flag;
}
//非空校验
function checkNull(pname,pmsg){
setMsg(pname,"")
var v = document.getElementsByName(pname)[0].value;
if(v.trim() == ""){
setMsg(pname,pmsg);
return false;
}
return true;
}
//设置提示信息
function