servlet和jsp实现简单登录（连接数据库）

最新推荐文章于 2023-12-02 20:26:10 发布

囿于宿命星河༄༅

最新推荐文章于 2023-12-02 20:26:10 发布

阅读量2.5k

点赞数 2

文章标签： servlet jsp javaweb

本文链接：https://blog.csdn.net/Q615749952/article/details/111573052

版权

<!DOCTYPE html>
<html>
    <head>
        <title>登录</title>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    </head>
    <body>
        <div>
            <form action="loginServlet.do" method="post">
                <table>
                    <tr>
                        <td><label for="user">用户名：</label></td>
                        <td><input type="text" id="user" name="user"></td>
                    </tr>
                    <tr>
                        <td><label for="password">密码：</label></td>
                        <td><input type="password" id="passwd" name="passwd"></td>
                    </tr>
                    <tr>
                        <input type="submit" name="submit" value="登录"></td>
                    </tr>
                </table>
            </form>
        </div>
    </body>
</html>

loginServlet.java

package login;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/loginServlet.do")
public class LoginServlet extends HttpServlet {
    Login L = null;
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        // TODO Auto-generated method stub
        //super.doPost(req, resp);
        try {
            L = new Login();
        } catch (Exception e1) {
            // TODO Auto-generated catch block
            e1.printStackTrace();
        }

        resp.setContentType("text/html;charset=utf-8");
        req.setCharacterEncoding("utf-8");
        String action = req.getParameter("action");
        PrintWriter out = resp.getWriter();


        String name = req.getParameter("user");
        String password = req.getParameter("passwd");


            try {
                boolean flag = L.LoginCorrect(name, password);
                if (flag) {
                    out.println("<h1>登陆成功</h1>");

                }else {
                	out.println("<!DOCTYPE html>");
    	            out.println("<html>");
    	            out.println("<head>");
    	            out.println("<meta charset=\"utf-8\">");
    	            out.println("<title>登录失败</title>");
    	            out.println("</head>");
    	            out.println("<body>");
    	            out.println("<h1>登录失败");
    	            out.println("<a href=\"login.jsp\">回首页登录");
    	            out.println("</body>");
    	            out.println("</html>");

                }
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        System.out.println("name:"+name);
        System.out.println("password:"+password);
    }
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        // TODO Auto-generated method stub
        super.doGet(req, resp);
    }


}

package login;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Login {

        private Connection conn = null;
        private Statement statement = null;

        public Login() throws Exception {
            conn = getConnection();
            statement = conn.createStatement();
        }

        // 查看登录用户名和密码是否正确
        public boolean LoginCorrect(String name, String password) throws Exception {

            String sql = "select * from login where loginName = '"+name + "' and pwd = '"+password+"";
            ResultSet rs = statement.executeQuery(sql);
            // 查看是否合法
            while (rs.next()) {
                if (name.equals(rs.getString("loginName"))
                        && password.equals(rs.getString("pwd")))
                {
                    System.out.println("登录成功");
                    return true;
                }
            }
            rs.close();
            return false;
        }



        private Connection getConnection() throws Exception {
            String driverClass = "com.mysql.jdbc.Driver";
            String url ="jdbc:mysql://localhost:3306/login" ;
            String user = "root";
            String password = "";

            // 注册加载驱动
            Class.forName(driverClass);

            // 获取连接

            Connection conn = DriverManager.getConnection(url, user, password);
            System.out.println(conn);
            return conn;
        }
    }

数据库文件：
在这里插入图片描述

囿于宿命星河༄༅

关注

2
点赞
踩
31

收藏

觉得还不错? 一键收藏
1
评论
servlet和jsp实现简单登录（连接数据库）

login.jsp<!DOCTYPE html><html> <head> <title>登录</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> </head> <body> <div> <for
复制链接

扫一扫