1.安裝MySQL數(shù)據(jù)庫，建立用戶表 uid uname upwd 并插入3條數(shù)據(jù)

2.制作jsp登錄頁面 login.jsp 提交到dologin.jsp，使用jdbc連數(shù)據(jù)庫，判斷輸入的用戶名密碼是否存在

3.如果存在，把用戶名保存在SESSION中，跳轉(zhuǎn)到welcome.jsp，welcome.jsp中讀取session中的用戶名，顯示歡迎你xxx

4.若不存在，跳到登錄頁面。

CREATE DATABASE j_db;
USE j_db;
CREATE TABLE jsp_data(uname VARCHAR(10),upwd VARCHAR(10));
INSERT INTO jsp_data(uname,upwd)VALUES('張三',111);
INSERT INTO jsp_data(uname,upwd)VALUES('李四',222);
INSERT INTO jsp_data(uname,upwd)VALUES('王五',333);

　　

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<html>
  <head>
    <title>$Title$</title>
    <link rel="stylesheet" href="./layui/css/layui.css">
    <link rel="stylesheet" href="./css/adminLogin.css">
  </head>
  <body>

  <div>
    <img src="img/4.jpg" class="imgStyle">
    <div >
      <form action="get.jsp" method="POST">
        <div >
        </div>
        <div >
          <div>
            <label>用戶名:</label>
          </div>
          <div>
            <i class="layui-icon layui-icon-username adminIcon"></i>
            <input id="loginUsername" class="layui-input adminInput" type="text" name="name"
                   placeholder="輸入用戶名">
          </div>
        </div>
        <div>
          <div>
            <label>密碼:</label>
          </div>
          <div>
            <i class="layui-icon layui-icon-password adminIcon"></i>
            <input id="loginPassword" class="layui-input adminInput" type="password" name="password"
                   placeholder="輸入密碼">
          </div>
        </div>
        <div>
          <div>
            <label>驗證碼:</label>
          </div>
          <div>
            <input id="loginCard" class="layui-input cardInput" type="text" name="card" placeholder="輸入驗證碼">
          </div>
          <div id="code_box" class="codeDiv">4j8k
          </div>
        </div>
        <div>
          <div>
            <label>沒有賬號？<a href="#" id="loginRegister">點擊注冊</a></label>
          </div>
          <div>
            <input id="loginBtn" type="submit" class="submit layui-btn layui-btn-primary"
                   value="登錄"></input>
          </div>
        </div>
      </form>
    </div>
  </div>

  <script>
    var code_box = document.getElementById("code_box");

    function refreshCode() {

    
      var code = '0123456789qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM',
              char = '',
              result = '';

      for (var i = 0; i < 4; i++) {

       
        var code_index = Math.round(Math.random() * 61);
       
        var char = code[code_index];
       
        if (result.toUpperCase().indexOf(char.toUpperCase()) > -1)
                
        {
          i--;
      
          continue; 
        }
        result += char;
      }
      code_box.innerHTML = result;
    }
 
    code_box.onclick = refreshCode;
  </script>
  </body>
</html>

　　

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%
    PreparedStatement pre = null;
    Statement sql;
    ResultSet rs;
    request.setCharacterEncoding("utf-8");
    String Name = request.getParameter("name");  //獲取輸入的用戶名
    String Ps = request.getParameter("password");  // 密碼
    Name.trim();
    Ps.trim();
    request.setCharacterEncoding("utf-8");

    Class.forName("com.mysql.cj.jdbc.Driver");
    // 建立連接
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/j_db?serverTimezone=GMT", "root", "135790");
    sql =conn.createStatement();
    String SQL = "select * from jsp_data where uname=? and upassword=?";
    pre=conn.prepareStatement(SQL);
    pre.setString(1,Name);
    pre.setString(2,Ps);
    rs=pre.executeQuery();
    if (rs.next()) {
        String name = rs.getString(1);
        session.setAttribute("name",name);
%><p>歡迎登陸：<%=name%></p><%
      }else{%> <p>輸入錯誤，請重新登錄</p><a href="index.jsp"><button>返回登錄界面</button></a>
<%
      }
      rs.close();
    sql.close();
    conn.close();
    %>
</body>
</html>