JSP_5.16_课堂笔记

最新推荐文章于 2024-07-30 20:50:32 发布

[CN]qi_fen_zhong

最新推荐文章于 2024-07-30 20:50:32 发布

阅读量89

点赞数

文章标签： java 笔记

本文链接：https://blog.csdn.net/weixin_60422460/article/details/130735164

版权

login.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Login</title>
<script src="js/jquery-3.3.1.min.js"></script>
<script>
    $(document).ready(function(){
        $("#submit").click(function(){
            var username = $("#username").val(); // 获取用户名
            var password = $("#password").val(); // 获取密码
            if(username == "" || password == ""){
                alert("请输入用户名和密码！"); // 输入为空，提示用户
                return;
            }
            $.ajax({
                url: "jdbclogin.jsp", // 后端处理jsp文件
                type: "POST",
                data: {"username":username,"password":password}, // 发送用户名和密码到后端
                success: function(data){
                    if(data == "success"){
                        window.location.href = "main.jsp"; // 登录成功，跳转到主页
                    }else{
                        alert("用户名或密码错误！"); // 登录失败，提示用户
                    }
                }
            });
        });
    });
</script>
</head>
<body>
    <form>
        <table>
            <tr>
                <td>用户名：</td>
                <td><input type="text" id="username"></td> 
            </tr>
            <tr>
                <td>密码：</td>
                <td><input type="password" id="password"></td> 
            </tr>
            <tr>
                <td colspan="2"><input type="button" value="登录" id="submit"></td> 
            </tr>
        </table>
    </form>
</body>
</html>

jdbclogin.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%
    String username = request.getParameter("username"); // 获取用户名
    String password = request.getParameter("password"); // 获取密码
	Class.forName("com.mysql.cj.jdbc.Driver");
	Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/study?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=utf8", "root", "000000"); // 建立数据库连接
	Statement stat = conn.createStatement();
	String sql = "SELECT * FROM user WHERE username='"+username+"' AND password='"+password+"'"; // 查询语句
	ResultSet rs = stat.executeQuery(sql); // 执行查询
        if(rs.next()){
            out.print("success"); // 查询结果存在，登录成功
        }else{
            out.print("fail"); // 查询结果不存在，登录失败
        }
   	rs.close();
   	stat.close();
   	conn.close();

%>

数据库账户root 密码000000
只会返回fail