servlet简单登录

任务

	暑期实习培训第三课——复习servlet实现简单登录

实现过程

1. 数据库搭建
2. jar包导入
3. 代码实现

代码实现

User：实体类

package com.lmc.bean;

public class User {
    public User() {
    }

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

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

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

    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 + '\'' +
                '}';
    }
}

UserDao类：数据库操作

package com.lmc.Dao;

import com.lmc.bean.User;
import com.lmc.util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;


public class UserDao {
    public int login(User user) {
        Connection connection = null;
        PreparedStatement statement = null;
        int row=0;
        try {
            connection = DBUtil.getConnection();
            String sql = "select * from tb_user where username=? and password=?";
            statement = connection.prepareStatement(sql);
            statement.setString(1,user.getUsername());
            statement.setString(2,user.getPassword());
            row = statement.executeUpdate();

        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            DBUtil.clossAll(null, statement, connection);
        }
        return row;
    }


}

DBUtil:封装数据库工具类

package com.lmc.util;

import java.sql.*;

public class DBUtil {
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost:3306/wzsxy";
    static final String USER = "root";
    static final String PASS = "123456";

    public static Connection getConnection() {
        Connection connection = null;
        try {
            //1.加载驱动
            Class.forName(JDBC_DRIVER);
            //2.创建连接
            connection = DriverManager.getConnection(DB_URL, USER, PASS);
            System.out.println("连接成功");

        } catch (Exception e) {
            // 处理 Class.forName 错误
            e.printStackTrace();
        }
        return connection;
    }

    public static void clossAll(ResultSet resultSet, Statement statement, Connection connection) {
        try {
            if (resultSet != null) {
                resultSet.close();
            }
            if (statement != null) {
                statement.close();
            }
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
        }
    }
}

LoginServlet

package com.lmc.servlet;

import com.lmc.Dao.UserDao;
import com.lmc.bean.User;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

public class LoginServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String username=req.getParameter("username");
        String password=req.getParameter("password");
        User user=new User();
        user.setUsername(username);
        user.setPassword(password);
        UserDao userDao=new UserDao();
        int row=userDao.login(user);
        if(row>0){
            resp.getWriter().write("sunccess");
        }else {
            resp.getWriter().write("failure");
        }
    }
}

index.jSP

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>$Title$</title>
  </head>
  <body>
  <form action="/login" method="post">
    username: <input name="username" type="text">
    password:<input name="password" type="password">
    <input type="submit" value="login">
  </form>
  </body>
</html>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
    <servlet>
        <servlet-name>HelloServlet</servlet-name>
        <servlet-class>com.lmc.servlet.HelloServlet</servlet-class>

    </servlet>
    <servlet-mapping>
        <servlet-name>HelloServlet</servlet-name>
        <url-pattern>/hello</url-pattern>
    </servlet-mapping>

    <servlet>
        <servlet-name>LoginServlet</servlet-name>
        <servlet-class>com.lmc.servlet.LoginServlet</servlet-class>

    </servlet>
    <servlet-mapping>
        <servlet-name>LoginServlet</servlet-name>
        <url-pattern>/login</url-pattern>
    </servlet-mapping>


</web-app>