登录跳转

登陆跳转

内容借鉴网上代码实现登录至跳转

  • 登录页面

  •  

     

  • 登录，进入系统

     

     

  • 核心代码

<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!-- 
功能介绍：用户登录数据验证

 -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<%@ include file="/files/db/conn.jsp"%>
<%
    //获取登录页面的账号、密码
    String username = request.getParameter("username");
    String password = request.getParameter("password");
    String role = request.getParameter("role");
    ResultSet rs = null;
    try{
        String sql = "select * from t_user where  username='"+username.trim()+"'";
        rs = stmt.executeQuery(sql);
    if (rs.next()) {
            if (rs.getString("password").equals(password)&&rs.getString("role").equals(role)) {//账号验证成功
                session.setAttribute("username", username);
                session.setAttribute("realname",rs.getString("realname"));
                session.setAttribute("role",rs.getString("role"));
                session.setAttribute("id", rs.getString("id"));
                session.setAttribute("departmentid",rs.getString("departmentid"));
                response.sendRedirect("../../index.jsp");    
            }else{//账号验证失败跳转登录界面
                response.sendRedirect("../../login.jsp?info=0");
            }
        }else{//账号验证失败跳转登录界面
            response.sendRedirect("../../login.jsp?info=1");
        }
    } catch (Exception e) {
        out.println(e.getMessage());
    } finally {
        if (rs != null) {
            try {
                rs.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        if (stmt != null) {
            try {
                stmt.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        if (conn != null) {
            try {
        conn.close();
            } catch (Exception e) {
        e.printStackTrace();
            }
        }
    }
    
    
    
%>
View Code

 首先是调用各方法获取登陆页面账户口令，后续只需从数据库中找出存储用户数据的表，并验证用户口令是否有对应的

 若对应则用setAttribute这个方法将该表中各项属性数据存储到session对象中，以便后续我们进行其它操作时，可以直接从session这里调用出来进行操作
posted @ 2022-12-11 23:06  头发换代码  阅读(47)  评论(0)  编辑  收藏  举报