黑马程序员IDEA版JAVA基础班\JavaWeb部分视频\210Request和Response\第5节 request登录案例

用户登录案例需求：
1.编写login.html登录页面
username & password 两个输入框
2.使用Druid数据库连接池技术,操作mysql，day14数据库中user表
3.使用JdbcTemplate技术封装JDBC
4.登录成功跳转到SuccessServlet展示：登录成功！用户名,欢迎您
5.登录失败跳转到FailServlet展示：登录失败，用户名或密码错误

登录案例分析：

1. 创建项目，导入html页面，配置文件，jar包

 1 <!DOCTYPE html>
 2 <html lang="en">
 3 <head>
 4     <meta charset="UTF-8">
 5     <title>Title</title>
 6 </head>
 7 <body>
 8     <form action="" method="post">
 9         用户名:<input type="text" name="username"> <br>
10         密码:<input type="password" name="password"><br>
11 
12         <input type="submit" value="登录">
13 
14     </form>
15 </body>
16 </html>

把login.html复制到web文件夹中。

把druid的配置文件复制到src文件夹中。
driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/day14?characterEncoding=UTF-8&serverTimezone=GMT%2B8
username=root
password=root
initialSize=5
maxActive=10
maxWait=3000
minIdle=1
项目依赖的.jar包文件放在lib文件夹中，全部一起复制到新建的WEB-INF文件里。

【单元测试】JUnit-4.12使用报java.lang.NoClassDefFoundError: org/hamcrest/SelfDescribing错误
    所以现在有两个办法解决：

   1.junit版本降到4.10

   2.导入hamcrest-core-1.3.jar

2. 创建数据库环境

MySQL本地已经安装配置好8.0.17版本，图形化操作软件使用Navicat12。

            CREATE DATABASE day14;
            USE day14;
            CREATE TABLE USER(
            
                id INT PRIMARY KEY AUTO_INCREMENT,
                username VARCHAR(32) UNIQUE NOT NULL,
                PASSWORD VARCHAR(32) NOT NULL
            );

3. 创建包cn.itcast.domain,创建类User

4. 创建包cn.itcast.util,编写工具类JDBCUtils

 1 package cn.itcast.util;
 2 
 3 import com.alibaba.druid.pool.DruidDataSourceFactory;
 4 
 5 import javax.sql.DataSource;
 6 import java.io.IOException;
 7 import java.io.InputStream;
 8 import java.sql.Connection;
 9 import java.sql.SQLException;
10 import java.util.Properties;
11 
12 
13 /**
14  * JDBC工具类 使用Durid连接池
15  */
16 public class JDBCUtils {
17 
18     private static DataSource ds ;
19 
20     static {
21 
22         try {
23             //1.加载配置文件
24             Properties pro = new Properties();
25             //使用ClassLoader加载配置文件，获取字节输入流
26             InputStream is = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties");
27             pro.load(is);
28 
29             //2.初始化连接池对象
30             ds = DruidDataSourceFactory.createDataSource(pro);
31 
32         } catch (IOException e) {
33             e.printStackTrace();
34         } catch (Exception e) {
35             e.printStackTrace();
36         }
37     }
38 
39     /**
40      * 获取连接池对象
41      */
42     public static DataSource getDataSource(){
43         return ds;
44     }
45 
46 
47     /**
48      * 获取连接Connection对象
49      */
50     public static Connection getConnection() throws SQLException {
51         return  ds.getConnection();
52     }
53 }

5. 创建包cn.itcast.dao,创建类UserDao,提供login方法

 1 package cn.itcast.dao;
 2 
 3 import cn.itcast.domian.User;
 4 import cn.itcast.util.JDBCUtils;
 5 import org.springframework.dao.DataAccessException;
 6 import org.springframework.jdbc.core.BeanPropertyRowMapper;
 7 import org.springframework.jdbc.core.JdbcTemplate;
 8 
 9 /**
10  * 操作数据库中User表的类
11  */
12 public class UserDao {
13 
14     //声明JDBCTemplate对象共用
15     private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());
16 
17     /**
18      * 登录方法
19      * @param loginUser 只有用户名和密码
20      * @return user包含用户全部数据,没有查询到，返回null
21      */
22     public User login(User loginUser){
23         try {
24             //1.编写sql
25             String sql = "select * from user where username = ? and password = ?";
26             //2.调用query方法
27             User user = template.queryForObject(sql,
28                     new BeanPropertyRowMapper<User>(User.class),
29                     loginUser.getUsername(), loginUser.getPassword());
30 
31 
32             return user;
33         } catch (DataAccessException e) {
34             e.printStackTrace();//记录日志
35             return null;
36         }
37     }
38 }

编写测试类，检测数据库连接池的响应。

 1 package cn.itcast.test;
 2 
 3 import cn.itcast.dao.UserDao;
 4 import cn.itcast.domian.User;
 5 import org.junit.Test;
 6 
 7 public class UserDaoTest {
 8 
 9 
10 
11     @Test
12     public void testLogin(){
13         User loginuser = new User();
14         loginuser.setUsername("superbaby");
15         loginuser.setPassword("123");
16 
17 
18         UserDao dao = new UserDao();
19         User user = dao.login(loginuser);
20 
21         System.out.println(user);
22     }
23 }

6. 编写cn.itcast.web.servlet.LoginServlet类

.html文件中<form>标签的action=" "

FailServlet

 1 package cn.itcast.web.servlet;
 2 
 3 import javax.servlet.ServletException;
 4 import javax.servlet.annotation.WebServlet;
 5 import javax.servlet.http.HttpServlet;
 6 import javax.servlet.http.HttpServletRequest;
 7 import javax.servlet.http.HttpServletResponse;
 8 import java.io.IOException;
 9 
10 @WebServlet("/failServlet")
11 public class FailServlet extends HttpServlet {
12     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
13         //给页面写一句话
14 
15         //设置编码
16         response.setContentType("text/html;charset=utf-8");
17         //输出
18         response.getWriter().write("登录失败，用户名或密码错误");
19 
20     }
21 
22     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
23         this.doPost(request,response);
24     }
25 }

SuccessServlet

 1 package cn.itcast.web.servlet;
 2 
 3 import cn.itcast.domian.User;
 4 
 5 import javax.servlet.ServletException;
 6 import javax.servlet.annotation.WebServlet;
 7 import javax.servlet.http.HttpServlet;
 8 import javax.servlet.http.HttpServletRequest;
 9 import javax.servlet.http.HttpServletResponse;
10 import java.io.IOException;
11 
12 @WebServlet("/successServlet")
13 public class SuccessServlet extends HttpServlet {
14     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
15         //获取request域中共享的user对象
16         User user = (User) request.getAttribute("user");
17 
18         if(user != null){
19             //给页面写一句话
20 
21             //设置编码
22             response.setContentType("text/html;charset=utf-8");
23             //输出
24             response.getWriter().write("登录成功！"+user.getUsername()+",欢迎您");
25         }
26 
27 
28     }
29 
30     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
31         this.doPost(request,response);
32     }
33 }

LoginServlet

 1 package cn.itcast.web.servlet;
 2 
 3 import cn.itcast.dao.UserDao;
 4 import cn.itcast.domian.User;
 5 
 6 import javax.servlet.ServletException;
 7 import javax.servlet.annotation.WebServlet;
 8 import javax.servlet.http.HttpServlet;
 9 import javax.servlet.http.HttpServletRequest;
10 import javax.servlet.http.HttpServletResponse;
11 import java.io.IOException;
12 
13 @WebServlet("/loginServlet")
14 public class LoginServlet extends HttpServlet {
15 
16     @Override
17     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
18 
19         this.doGet(request,response);
20     }
21     @Override
22     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
23         //1.设置编码
24         request.setCharacterEncoding("utf-8");
25         //2.获取请求参数
26         String username = request.getParameter("username");
27         String password = request.getParameter("password");
28         //3.封装user对象
29         User loginUser = new User();
30         loginUser.setUsername(username);
31         loginUser.setPassword(password);
32         //4.调用UserDao的login方法
33         UserDao  dao = new UserDao();
34         User user =dao.login(loginUser);
35 
36         //5.判断user
37         if (user == null){
38             //登陆失败
39             request.getRequestDispatcher("/failServlet").forward(request,response);
40         }else{
41             //登陆成功
42             //存储数据
43             request.setAttribute("user",user);
44             //转发
45             request.getRequestDispatcher("/successServlet").forward(request,response);
46         }
47     }
48 }

23_登录案例_BeanUtils基本使用

commons-beanutils-1.8.0

 // LoginServlet
 1 package cn.itcast.web.servlet;
 2 
 3 import cn.itcast.dao.UserDao;
 4 import cn.itcast.domain.User;
 5 import org.apache.commons.beanutils.BeanUtils;
 6 
 7 import javax.servlet.ServletException;
 8 import javax.servlet.annotation.WebServlet;
 9 import javax.servlet.http.HttpServlet;
10 import javax.servlet.http.HttpServletRequest;
11 import javax.servlet.http.HttpServletResponse;
12 import java.io.IOException;
13 import java.lang.reflect.InvocationTargetException;
14 import java.util.Map;
15 
16 
17 @WebServlet("/loginServlet")
18 public class LoginServlet extends HttpServlet {
19 
20 
21     @Override
22     protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
23         //1.设置编码
24         req.setCharacterEncoding("utf-8");
25        /* //2.获取请求参数
26         String username = req.getParameter("username");
27         String password = req.getParameter("password");
28         //3.封装user对象
29         User loginUser = new User();
30         loginUser.setUsername(username);
31         loginUser.setPassword(password);*/
32         //2.获取所有请求参数
33         Map<String, String[]> map = req.getParameterMap();
34         //3.创建User对象
35         User loginUser = new User();
36         //3.2使用BeanUtils封装
37         try {
38             BeanUtils.populate(loginUser,map);
39         } catch (IllegalAccessException e) {
40             e.printStackTrace();
41         } catch (InvocationTargetException e) {
42             e.printStackTrace();
43         }
44 
45 
46         //4.调用UserDao的login方法
47         UserDao dao = new UserDao();
48         User user = dao.login(loginUser);
49 
50         //5.判断user
51         if(user == null){
52             //登录失败
53             req.getRequestDispatcher("/failServlet").forward(req,resp);
54         }else{
55             //登录成功
56             //存储数据
57             req.setAttribute("user",user);
58             //转发
59             req.getRequestDispatcher("/successServlet").forward(req,resp);
60         }
61 
62     }
63 
64     @Override
65     protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
66         this.doGet(req,resp);
67     }
68 }

9. BeanUtils工具类，简化数据封装
* 用于封装JavaBean的
1. JavaBean：标准的Java类
1. 要求：
1. 类必须被public修饰
2. 必须提供空参的构造器
3. 成员变量必须使用private修饰
4. 提供公共setter和getter方法
2. 功能：封装数据

2. 概念：
成员变量：
属性：setter和getter方法截取后的产物
例如：getUsername() --> Username--> username

3. 方法：
1. setProperty()
2. getProperty()
3. populate(Object obj , Map map):将map集合的键值对信息，封装到对应的JavaBean对象中

okey

部分内容来自于学习编程期间收集于网络的免费分享资源和工作后购买的付费内容。如需获取教程配套的资源文件和一对一专属答疑支持，请加vx:kangmf24联系作者。