【Servlet登录案例】

最新推荐文章于 2021-11-09 22:55:12 发布

木子丶Li

最新推荐文章于 2021-11-09 22:55:12 发布

阅读量633

点赞数 1

文章标签： html mysql servlet

本文链接：https://blog.csdn.net/l531003231/article/details/82807589

版权

登录案例 --------- 分析
a) 建工程, 建数据库, 建表,
b) 准备好连接数据库的代码.

德鲁伊 (druid) , mysql驱动jar包, spring的jdbcTemplate

建包

   com.itheima.web
   放servlet类
   com.itheima.dao
   UserDao , 操作数据库
   com.itheima.utils
   JdbcUtils , 工具类
   com.itheima.domain
   User, 实例类

c) 首先要写一个登录的表单, 设置 action, 指向具体的 servlet

路径不要写错, 按照绝对路径的方式去写

</form>

d) 编写工程中 Servlet程序.

获得用户名和密码
封装到 javabean 中, 注意封装时使用 BeanUtils

使用 BeanUtils 要记得导入jar包. jar包要放到

WEB-INF/lib 目录中.

commons-beanutils-1.8.0.jar
commons-logging-1.2.jar

BeanUtils.populate(bean, map )

全部jar包如图：

e) 在servlet中,调用 UserDao中的login的方法,

String sql ="select * from users where usename=? and password=?";

tempalte.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), .... );

f)回到登录的 servlet中, 判断user是否空

User user = ....

if(user==null){

// 登录失败 , 跳转到FailServlet

}else{

// 登录成功,跳转到SuccessServlet
}

登录案例开始：

1.创建数据库环境
       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
       );

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

package cn.itcast.domain;

public class User {


    private int id;
    private String username;
    private String password;
    private String gender;

    public User() {
    }

    public User(int id, String username, String password, String gender) {
        this.id = id;
        this.username = username;
        this.password = password;
        this.gender = gender;
    }

    public void setHehe(String gender){
        this.gender=gender;
    }
    public String getHehe(){
        return gender;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    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;
    }


    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
    
}

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

package cn.itcast.util;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

public class JdbcUtils {

    private static DataSource ds;

    static {
        try {
            //1.加载配置文件
            Properties pro=new Properties();
            InputStream is = JdbcUtils.class.getClassLoader().getResourceAsStream("druid.properties");
            pro.load(is);

            //2.初始化连接池对象
            ds=DruidDataSourceFactory.createDataSource(pro);
        } catch (IOException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }

    }

    /**
     * 获取连接池对象
     */
    public static DataSource getDataSource(){
        return ds;
    }

    /**
     * 获取连接Connection对象
     * @return
     * @throws SQLException
     */
    public static Connection getConnection() throws SQLException {
        return  ds.getConnection();
    }
}

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

package cn.itcast.dao;

import cn.itcast.domain.User;
import cn.itcast.util.JdbcUtils;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

/**
 * 操作数据库中User表的类
 */
public class UserDao {

    //声明JDBCTemplate对象公用
    private JdbcTemplate template=new JdbcTemplate(JdbcUtils.getDataSource());

    /**
     * 登录方法
     * @param loginUser 只有用户名和密码
     * @return user包含用户全部数据，没有查询到，返回null
     */
    public User login(User loginUser){
        try {
            //1.编写sql
            String sql="select * from user where username=? and password=?";

            //2.调用query方法
            User user=template.queryForObject(sql,
                    new BeanPropertyRowMapper<User>(User.class),
                    loginUser.getUsername(),loginUser.getPassword());
            return user;
        } catch (DataAccessException e) {
            e.printStackTrace();//纪录日志
            return null;
        }
    }
}

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

package cn.itcast.web.servlet;

import cn.itcast.dao.UserDao;
import cn.itcast.domain.User;
import org.apache.commons.beanutils.BeanUtils;

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 java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.util.Map;

@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1.设置编码
        request.setCharacterEncoding("utf-8");

/*
        //2.获取请求参数
        String username=request.getParameter("username");
        String password=request.getParameter("password");
        //3.封装user对象
        User loginUser =new User();
        loginUser.setPassword(username);
        loginUser.setPassword(password);
*/

        //2.获取请求参数
        Map<String, String[]> map = request.getParameterMap();
        //3.封装user对象
        User loginUser =new User();
        //3.2 使用BeanUtils封装
        try {
            BeanUtils.populate(loginUser,map);
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (InvocationTargetException e) {
            e.printStackTrace();
        }

        //4.调用UserDao的login方法
        UserDao dao=new UserDao();
        User user = dao.login(loginUser);

        //5.判断user
        if (user==null){
            //登录失败
            request.getRequestDispatcher("/failServlet").forward(request,response);
        }else {
            //登录成功
            //存储数据
            request.setAttribute("user",user);
            //转发
            request.getRequestDispatcher("/successServlet").forward(request,response);
        }

    }
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request,response);
    }
}

6.编写FailServlet和SuccessServlet类

package cn.itcast.web.servlet;

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 java.io.IOException;

@WebServlet("/failServlet")
public class FailServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //写给页面一句话
        //设置编码
        response.setContentType("text/html;charset=utf-8");
        //输出
        response.getWriter().write("登录失败，用户名或密码错误");
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request,response);
    }
}











package cn.itcast.web.servlet;

import cn.itcast.domain.User;

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 java.io.IOException;

@WebServlet("/successServlet")
public class SuccessServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //获取request域中共享的user对象
        User user = (User) request.getAttribute("user");


        //输出
        if (user!=null){
            //设置编码
            response.setContentType("text/html;charset=utf-8");
            response.getWriter().write("登录成功！"+user.getUsername()+"欢迎您");
        }

    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request,response);
    }
}

7. login.html中form表单的action路径的写法
* 虚拟目录+Servlet的资源路径

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <form action="/day14/loginServlet" method="post">
        用户名:<input type="text" name="username"> <br>
        密码:<input type="password" name="password"><br>

        <input type="submit" value="登录">

    </form>
</body>
</html>

8. 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对象中

cn.itcast.test测试类测试自己写的代码

package cn.itcast.test;

import cn.itcast.dao.UserDao;
import cn.itcast.domain.User;
import org.junit.Test;

public class UserDaoTest {

    @Test
    public void login(){
        User loginuser=new User();
        loginuser.setUsername("root");
        loginuser.setPassword("root");

        UserDao dao=new UserDao();
        User user=dao.login(loginuser);
        System.out.println(user);
    }

}

运行结果：

输入数据库中正确的用户名和密码