要求:
1.完成登录 保存登录日志 使用请求转发,重定向做出响应
2.使用静态包含,搭建前端页面
创建好web项目后进行服务器部署,导入需要的架包。如图所示。
在数据库中新建user表,用来后台存储用户的账号和密码
新建login表,用来记录登录信息
新建登录页面login.jsp
<%--
Created by IntelliJ IDEA.
User: 云
Date: 2021/3/20
Time: 17:03
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
<script src="js/jquery.1.8.3.min.js" type="text/javascript"></script>
<script type="text/javascript">
<%-- 2.在浏览器中--%>
$(function(){
var arr = document.cookie.split(";");
for ( i = 0; i < arr.length; i++) {
var str = arr[i];
var strarr= str.split("=");
if(strarr[0]=="accck"){
$("#accountid").val(strarr[1]);
}
if(strarr[0]=="pswck"){
$("#passwordId").val(strarr[1]);
}
}
})
</script>
</head>
<body>
<%
String mess = (String) request.getAttribute("message");
out.print(mess);
%>
<%--在login.jsp页面中有两种方式可以获得cookie中的数据
1.在服务器端写java代码
2.在浏览器中 用js代码
--%>
<form action="login" method="post">
账号:<input type="text" name="account" value="" id="accountId">
<br>
密码:<input type="text" name="password" value="" id="passwordId">
<br>
您想要记住密码吗?
<input type="checkbox" value="ck" name="ck"/>
<br>
<input type="submit" value="提交">
</form>
</body>
</html>
新建登录成功后的跳转页面success.jsp
<%--
Created by IntelliJ IDEA.
User: 云
Date: 2021/3/20
Time: 17:12
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
<script type="text/javascript">
function back() {
var wh = confirm("您确定要退出吗?")
if (wh) {
window.location.replace("login");
}
}
</script>
</head>
<body>
欢迎
<%
/*String account = (String) request.getAttribute("account");
out.print(account);*/
String account = (String) session.getAttribute("account");
out.print(account);
%>
登录成功!
<input type="button" value="安全退出" onclick="back()">
<br>
</body>
</html>
新建dao
package com.ff.dao;
import java.sql.*;
public class Link {
static Connection connection;
public static Connection Jdbc() {
String url = "jdbc:mysql://127.0.0.1:3306/school_db?characterEncoding=utf8&serverTimezone=UTC";
try {
connection = DriverManager.getConnection(url, "root", "13579");
return connection;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
}
新建servlet
package com.ff.webpro;
import com.ff.dao.Link;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Date;
//数据库与java链接的完整过程
public class LoginServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.getSession().invalidate();
resp.sendRedirect("login.jsp");
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// req.setCharacterEncoding("utf-8");
resp.setHeader("content-Type", "text/html;charset=utf-8");
String account = req.getParameter("account");
try {
String password = req.getParameter("password");
String ck = req.getParameter("ck");
String sql = "select* from users where user_account=? and user_password=?";
PreparedStatement ps = Link.Jdbc().prepareStatement(sql);
ps.setString(1, account);
ps.setString(2, password);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
//登录成功(请求转发)
/*req.setAttribute("account", account);//向request对象中设置一组键值数据
RequestDispatcher requestDispatcher = req.getRequestDispatcher("success.jsp");//获得请求转发对象,告诉对象转发的地址
requestDispatcher.forward(req, resp);//执行转发动作*/
//在Servlet中获得session
if (ck != null) {
//创建cookie对象,封装数据,tomcat 9之后可以直接存储中文
Cookie accck = new Cookie("accck", account);
Cookie pswck = new Cookie("pswck", password);
//为cookie设置生存时间,以秒为单位,现在设置为为一周
accck.setMaxAge(3600 * 24 * 7);
pswck.setMaxAge(3600 * 24 * 7);
//添加响应对象
resp.addCookie(accck);
resp.addCookie(pswck);
}
//重定向
HttpSession session = req.getSession();//从请求对象中获取与之对应的session对象
session.setAttribute("account", account);
resp.sendRedirect("success.jsp");
} else {
//登录失败
req.setAttribute("message", "账号或密码错误");
RequestDispatcher requestDispatcher = req.getRequestDispatcher("login.jsp");
requestDispatcher.forward(req, resp);
}
} catch (SQLException throwables) {
throwables.printStackTrace();
} finally {
String insertSql = "insert into t_login(account,ip,login_time)" + "values(?,?,?)";
PreparedStatement ps = null;
try {
ps = Link.Jdbc().prepareStatement(insertSql);
String ip = req.getRemoteAddr();
java.util.Date date = new Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String login_time = dateFormat.format(date);
ps.setString(1, account);
ps.setString(2, ip);
ps.setString(3, login_time);
ps.executeUpdate();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
设置编码过滤器EncodingFilter(防止有中文时编码解码出现错误)
package filter;
import javax.servlet.*;
import java.io.IOException;
public class EcodingFilter implements Filter {
/*@Override
public void init(FilterConfig filterConfig) throws ServletException {
System.out.println("init");
}*/
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
System.out.println("filter");
servletRequest.setCharacterEncoding("utf-8");//统一执行编码处理
filterChain.doFilter(servletRequest, servletResponse);//让请求继续向下执行,到达下一个资源(下一个过滤器或目标资源)
}
/*@Override
public void destroy() {
System.out.println("destory");
}*/
}
设置是否登录过滤去IsLoginFilter(防止没有登录就用登录页面的网址进入登录成功页面)
package filter;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
public class IsLoginFilter implements Filter {
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
HttpServletRequest request = (HttpServletRequest) servletRequest;
HttpServletResponse response = (HttpServletResponse) servletResponse;
String name = (String) request.getSession().getAttribute("account");
if (name == null) {
System.out.println("is`t login?");
response.sendRedirect("login.jsp");
} else {
filterChain.doFilter(servletRequest, servletResponse);
}
}
}
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">
<welcome-file-list>
<welcome-file>login.jsp</welcome-file>
</welcome-file-list>
<!-- 配置servlet-->
<servlet>
<servlet-name>
login
</servlet-name>
<servlet-class>com.ff.webpro.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>login</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
<!--配置session失效时间,将默认时间改为10秒-->
<session-config>
<session-timeout>10</session-timeout>
</session-config>
<!--配置过滤器-->
<!--是否登录过滤器-->
<filter>
<filter-name>isLoginFilter</filter-name>
<filter-class>filter.IsLoginFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>isLoginFilter</filter-name>
<url-pattern>/success.jsp</url-pattern>
</filter-mapping>
<!--编码过滤器-->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>filter.EcodingFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<!--<url-pattern>/login.jsp</url-pattern>--><!--配置允许哪些可以进入过滤器-->
<url-pattern>/*</url-pattern><!--*表示可以访问本项目中的任何资源-->
</filter-mapping>
</web-app>
运行结果
登录界面
登录成功界面
点击安全退出的提示页面
点击安全退出再点击确定后会跳转到登录页面,点击安全突出后再点击取消刷新当前登录成功页面。
在登录页面,当账号或者密码有一个为错时的提示页面
数据库中保存的数据:
users表
t_login表
服务器端截图