day01 --环境搭建 注册 表单校验
c3p0-config.xml
<?xml version="1.0" encoding="UTF-8"?> <c3p0-config> <default-config> <property name="user">root</property> <property name="password">moujinling321</property> <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="jdbcUrl">jdbc:mysql:///shop</property> </default-config> </c3p0-config>
register.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head></head> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>会员注册</title> <link rel="stylesheet" href="css/bootstrap.min.css" type="text/css" /> <script src="js/jquery-1.11.3.min.js" type="text/javascript"></script> <!-- 引入表单校验的jquery插件 --> <script src="js/jquery.validate.min.js" type="text/javascript"></script> <script src="js/bootstrap.min.js" type="text/javascript"></script> <!-- 引入自定义css文件 style.css --> <link rel="stylesheet" href="css/style.css" type="text/css" /> <style> body { margin-top: 20px; margin: 0 auto; } .carousel-inner .item img { width: 100%; height: 300px; } font { color: #3164af; font-size: 18px; font-weight: normal; padding: 0 10px; } .error { color:red; } </style> <script type="text/javascript"> //自定义校验规则 $.validator.addMethod( //规则的名称 "checkUsername", //校验的函数 function(value,element,params){ //定义一个标志 var flag = true; //value是校验组件的value值,即输入的内容 //element是校验组件的节点对象 //params是校验规则的参数 //目的:对输入的username进行ajax校验 $.ajax({ "async":false, "url":"${pageContext.request.contextPath}/checkUsername", "data":{"username":value}, //发送到服务器的数据 "type":"POST", "dataType":"json", "success":function(data){ //请求成功后的回调函数 alert(data); //方法返回true,代表该校验器通过 flag = data.isExist; alert(flag); } }); //返回false代表该校验器不通过 //查到存在这个id,才执行message提示报错,即返回false应该通过 return !flag; } ); $(function(){ $("#myform").validate({ rules:{ "username":{ "required":true, "checkUsername":"xxxx" //校验规则,随便写字符串 }, "password":{ "required":true, "rangelength":[6,12] }, "repassword":{ "required":true, "rangelength":[6,12], "equalTo":"#password" //id选择器 }, "email":{ "required":true, "email":true }, "sex":{ "required":true } }, messages:{ "username":{ "required":"用户名不能为空", "checkUsername":"用户名已存在" }, "password":{ required:"密码不能为空", rangelength:"密码长度6-12位" }, "repassword":{ "required":"密码不能为空", "rangelength":"密码长度6-12位", "equalTo":"两次密码不一致 " }, "email":{ "required":"邮箱不能为空", "email":"邮箱格式不正确" }, "sex":{ "required":"您没有第三种选择" } } }); }); </script> </head> <body> <!-- 引入header.jsp --> <jsp:include page="/header.jsp"></jsp:include> <div class="container" style="width: 100%; background: url('image/regist_bg.jpg');"> <div class="row"> <div class="col-md-2"></div> <div class="col-md-8" style="background: #fff; padding: 40px 80px; margin: 30px; border: 7px solid #ccc;"> <font>会员注册</font>USER REGISTER <form id="myform" class="form-horizontal" action="${pageContext.request.contextPath}/register" method="post" style="margin-top: 5px;"> <div class="form-group"> <label for="username" class="col-sm-2 control-label">用户名</label> <div class="col-sm-6"> <input type="text" class="form-control" id="username" name="username" placeholder="请输入用户名"> </div> </div> <div class="form-group"> <label for="inputPassword3" class="col-sm-2 control-label">密码</label> <div class="col-sm-6"> <input type="password" class="form-control" id="password" name="password" placeholder="请输入密码"> </div> </div> <div class="form-group"> <label for="confirmpwd" class="col-sm-2 control-label">确认密码</label> <div class="col-sm-6"> <input type="password" class="form-control" id="confirmpwd" name="repassword" placeholder="请输入确认密码"> </div> </div> <div class="form-group"> <label for="inputEmail3" class="col-sm-2 control-label">Email</label> <div class="col-sm-6"> <input type="email" class="form-control" id="inputEmail3" name="email" placeholder="Email"> </div> </div> <div class="form-group"> <label for="usercaption" class="col-sm-2 control-label">姓名</label> <div class="col-sm-6"> <input type="text" class="form-control" id="usercaption" name="name" placeholder="请输入姓名"> </div> </div> <div class="form-group opt"> <label for="inlineRadio1" class="col-sm-2 control-label">性别</label> <div class="col-sm-6"> <label class="radio-inline"> <input type="radio" name="sex" id="sex1" value="male">男 </label> <label class="radio-inline"> <input type="radio" name="sex" id="sex2" value="female">女 </label> <label class="error" for="sex" style="display:none"> 您没有第三种选择 </label> </div> </div> <div class="form-group"> <label for="date" class="col-sm-2 control-label">出生日期</label> <div class="col-sm-6"> <input type="date" class="form-control" name="birthday"> </div> </div> <div class="form-group"> <label for="date" class="col-sm-2 control-label">验证码</label> <div class="col-sm-3"> <input type="text" class="form-control" name="checkCode"> </div> <div class="col-sm-2"> <img src="./image/captcha.jhtml" /> </div> </div> <div class="form-group"> <div class="col-sm-offset-2 col-sm-10"> <input type="submit" width="100" value="注册" name="submit" style="background: url('./images/register.gif') no-repeat scroll 0 0 rgba(0, 0, 0, 0); height: 35px; width: 100px; color: white;"> </div> </div> </form> </div> <div class="col-md-2"></div> </div> </div> <!-- 引入footer.jsp --> <jsp:include page="/footer.jsp"></jsp:include> </body> </html>
registerFail.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<h2>对不起,注册失败,请联系管理员 010-68888888</h2>
</body>
</html>
registerSuccess.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> <h2>恭喜您注册成功,请赶快前往注册邮箱激活您的帐户</h2> <div> <span><a href="http://mail.163.com/">网易163邮箱</a></span> <span><a href="http://mail.126.com/">网易126邮箱</a></span> <span><a href="https://mail.qq.com/cgi-bin/loginpage">腾讯QQ邮箱</a></span> </div> </body> </html>
CommonsUtils
package com.itheima.utils; import java.util.UUID; public class CommonsUtils { //生成uuid的方法 public static String getUUID(){ return UUID.randomUUID().toString(); } }
DatasourceUtils
package com.itheima.utils; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.sql.DataSource; import com.mchange.v2.c3p0.ComboPooledDataSource; public class DataSourceUtils { private static DataSource dataSource = new ComboPooledDataSource(); private static ThreadLocal<Connection> tl = new ThreadLocal<Connection>(); // 直接获取一个连接池 public static DataSource getDataSource() { return dataSource; } //获取连接对象 public static Connection getConnection() throws SQLException { Connection con = tl.get(); if (con == null) { con = dataSource.getConnection(); tl.set(con); } return con; } //开启事务 public static void startTransaction() throws SQLException { Connection con = getConnection(); if (con != null) { con.setAutoCommit(false); } } //事务回滚 public static void rollback() throws SQLException { Connection con = getConnection(); if (con != null) { con.rollback(); } } //提交并且 关闭资源及从ThreadLocall中释放 public static void commitAndRelease() throws SQLException { Connection con = getConnection(); if (con != null) { con.commit();// 事务提交 con.close();// 关闭资源 tl.remove();// 从线程绑定中移除 } } // 关闭资源方法 public static void closeConnection() throws SQLException { Connection con = getConnection(); if (con != null) { con.close(); } } public static void closeStatement(Statement st) throws SQLException { if (st != null) { st.close(); } } public static void closeResultSet(ResultSet rs) throws SQLException { if (rs != null) { rs.close(); } } }
MailUtils
package com.itheima.utils; import java.util.Properties; import javax.mail.Authenticator; import javax.mail.Message; import javax.mail.MessagingException; import javax.mail.PasswordAuthentication; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.AddressException; import javax.mail.internet.InternetAddress; import javax.mail.internet.MimeMessage; import javax.mail.internet.MimeMessage.RecipientType; public class MailUtils { public static void sendMail(String email, String emailMsg) throws AddressException, MessagingException { // 1.创建一个程序与邮件服务器会话对象 Session Properties props = new Properties(); props.setProperty("mail.transport.protocol", "SMTP"); //发邮件的服务器地址 props.setProperty("mail.host", "smtp.126.com"); props.setProperty("mail.smtp.auth", "true");// 指定验证为true // 创建验证器 Authenticator auth = new Authenticator() { public PasswordAuthentication getPasswordAuthentication() { //要发邮件的账户和授权密码 return new PasswordAuthentication("moujinling321", "hao123"); } }; Session session = Session.getInstance(props, auth); // 2.创建一个Message,它相当于是邮件内容 Message message = new MimeMessage(session); message.setFrom(new InternetAddress("moujinling321@126.com")); // 设置发送者 message.setRecipient(RecipientType.TO, new InternetAddress(email)); // 设置发送方式与接收者 message.setSubject("用户激活"); // message.setText("这是一封激活邮件,请<a href='#'>点击</a>"); message.setContent(emailMsg, "text/html;charset=utf-8"); // 3.创建 Transport用于将邮件发送 Transport.send(message); } }
User
package com.itheima.domain; import java.util.Date; public class User { private String uid; private String username; private String password; private String name; private String email; private String telephone; private Date birthday; private String sex; private Integer state;//是否激活 private String code;//激活码 public String getUid() { return uid; } public void setUid(String uid) { this.uid = uid; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getTelephone() { return telephone; } public void setTelephone(String telephone) { this.telephone = telephone; } public Date getBirthday() { return birthday; } public void setBirthday(Date birthday) { this.birthday = birthday; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public Integer getState() { return state; } public void setState(Integer state) { this.state = state; } public String getCode() { return code; } public void setCode(String code) { this.code = code; } @Override public String toString() { return "User [uid=" + uid + ", username=" + username + ", password=" + password + ", name=" + name + ", email=" + email + ", telephone=" + telephone + ", birthday=" + birthday + ", sex=" + sex + ", state=" + state + ", code=" + code + "]"; } }
RegisterServlet :注册
package com.itheima.web.servlet; import java.io.IOException; import java.lang.reflect.InvocationTargetException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Map; import javax.mail.MessagingException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.commons.beanutils.BeanUtils; import org.apache.commons.beanutils.ConvertUtils; import org.apache.commons.beanutils.Converter; import com.itheima.domain.User; import com.itheima.service.UserService; import com.itheima.utils.CommonsUtils; import com.itheima.utils.MailUtils; /** * @author mjl E-mail: example@aliyun.com * @version 创建时间:2018年6月13日 下午4:50:41 * tags */ @WebServlet("/RegisterServlet") public class RegisterServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html; charset=UTF-8"); //获得表单数据 Map<String, String[]> properties = request.getParameterMap(); User user = new User(); try { //自己制定一个类型转换器(将String转成Date),register(接口,转换成的类型) ConvertUtils.register(new Converter() { // public Object convert(Class clazz, Object value) { //将String转成date SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); Date parse = null; try { //parse,将String转为Date类型 parse = format.parse(value.toString()); } catch (ParseException e) { e.printStackTrace(); } return parse; } }, Date.class); //映射封装 BeanUtils.populate(user, properties); } catch (IllegalAccessException | InvocationTargetException e1) { e1.printStackTrace(); } //private String uid; user.setUid(CommonsUtils.getUUID()); //private String telephone; user.setTelephone(null); //private Integer state;是否激活 user.setState(0); //private String code;激活码 String activeCode = CommonsUtils.getUUID(); user.setCode(activeCode); //将user传递给service层 UserService service = new UserService(); boolean isRegisterSuccess = service.regist(user); //是否注册成功 if(isRegisterSuccess){ //发送激活邮件 String emailMsg = "恭喜您注册成功,请点击下面的链接激活账户" + "<a href='http://localhost:8080/HeimaShop/active?activeCode="+activeCode+"'>"+ "http://localhost:8080/HeimaShop/active?activeCode="+activeCode+"</a>"; try { MailUtils.sendMail(user.getEmail(), emailMsg); } catch (MessagingException e) { e.printStackTrace(); } //跳转到注册成功的页面,重定向,地址变化 response.sendRedirect(request.getContextPath()+"/registerSuccess.jsp"); }else{ //跳转到失败的提示页面 response.sendRedirect(request.getContextPath()+"/registerFail.jsp"); } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }
ActiveServlet :激活
package com.itheima.web.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.itheima.service.UserService; /** * @author mjl E-mail: example@aliyun.com * @version 创建时间:2018年6月17日 下午3:34:44 * tags */ @WebServlet("/active") public class ActiveServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //获得激活码 String activeCode = request.getParameter("activeCode"); System.out.println(activeCode); UserService service = new UserService(); service.active(activeCode); //跳转到登录页面 response.sendRedirect(request.getContextPath()+"/login.jsp"); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }
CheckUsernameServlet:检查用户名是否存在
package com.itheima.web.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.itheima.service.UserService; /** * @author mjl E-mail: example@aliyun.com * @version 创建时间:2018年6月19日 下午2:11:35 * tags */ @WebServlet("/CheckUsernameServlet") public class CheckUsernameServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html; charset=UTF-8"); System.out.println("------------"); //获得用户名 String username = request.getParameter("username"); UserService service = new UserService(); boolean isExist = service.checkUsername(username); String json = "{\"isExist\":"+isExist+"}"; response.getWriter().write(json); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }
UserService
package com.itheima.service; import java.sql.SQLException; import com.itheima.dao.UserDao; import com.itheima.domain.User; public class UserService { //注册 public boolean regist(User user){ UserDao dao = new UserDao(); Integer row = 0; try { row = dao.regist(user); } catch (SQLException e) { e.printStackTrace(); } return row>0?true:false; } //激活 public void active(String activeCode) { UserDao dao = new UserDao(); try { dao.active(activeCode); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } //检查用户名是否存在 public boolean checkUsername(String username) { UserDao dao = new UserDao(); Long isExist = 0L; try { isExist = dao.checkUsername(username); } catch (SQLException e) { e.printStackTrace(); } return isExist>0?true:false; } }
UserDao
package com.itheima.dao; import java.sql.SQLException; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.ScalarHandler; import com.itheima.domain.User; import com.itheima.utils.DataSourceUtils; public class UserDao { //注册 public Integer regist(User user) throws SQLException{ QueryRunner runner = new QueryRunner(DataSourceUtils.getDataSource()); String sql="insert into user values(?,?,?,?,?,?,?,?,?,?)"; int update = runner.update(sql, user.getUid(),user.getUsername(),user.getPassword(),user.getName(), user.getEmail(),user.getTelephone(),user.getBirthday(),user.getSex(),user.getState(),user.getCode()); return update; } //激活 public void active(String activeCode) throws SQLException { QueryRunner runner = new QueryRunner(DataSourceUtils.getDataSource()); String sql = "update user set state = ? where code = ?"; runner.update(sql, 1,activeCode); } //检查用户名是否存在 public Long checkUsername(String username) throws SQLException { QueryRunner runner = new QueryRunner(DataSourceUtils.getDataSource()); String sql = "select count(*) from user where username = ?"; Long query = (Long) runner.query(sql, new ScalarHandler(),username); return query; } }