08-13 写登录页面以及其中出现的错误_写登录的代码报错print errot messages-CSDN博客

本文链接：https://blog.csdn.net/Coco2cy/article/details/119683790

写登录页面

1. 搭建环境

在WEB-INF里创建lib包并且导包
- 新建一个lib
- 复制粘贴导入包
在项目里建一个资源包resources并且配置c3p0
- 添加配置文件并修改
- 把包变成资源包
- 把lib里的jar包导入
创建src里的包

2. 写页面

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>登录页面</title>
</head>
<body>
    <form action="/login" method="post">
        姓名：<input type="text" name="username">
        密码：<input type="password" name="password">
        <input type="submit" value="提交">
    </form>
</body>
</html>

3. 写服务层（servlet）

LoginServlet

package com.chen.servlets;

import com.chen.dao.UserLogin;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import com.chen.domain.User;



@WebServlet("/login")
public class LoginServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //写我们的逻辑
        //1.得到前端的用户名跟密码
        String username = request.getParameter("username");
        String password = request.getParameter("password");

        //2.去数据库查询是否有用户名跟密码信息返回一个user
        User user = UserLogin.login(username, password);

        //4.如果user对象是空的,那么展示失败

        //3.如果user对象有,那么展示成功
        if (user != null){
            System.out.println("成功");
            //通过SuccessServlet转发到页面
            request.getRequestDispatcher("/success").forward(request, response);
        }else {
            System.out.println("失败");
            //通过ErrorServlet转发到页面
            request.getRequestDispatcher("/error").forward(request, response);

        }
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }
}

4. 连接数据库

在这里插入图片描述

显示不出数据库怎么办

在这里插入图片描述

先点

右键点在这里插入图片描述

在这里插入图片描述

5. 数据库表的自动生成实体类对象

在这里插入图片描述

选择路径

在这里插入图片描述

6.使用dbutils进行操作

UserLogin

package com.chen.dao;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import com.chen.domain.User;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import java.sql.SQLException;

/*
 *@description:描述
 *@author:陈琰
 *@time：2021/8/13  11:03
 */

public class UserLogin {
    public static User login(String username, String password) {
        QueryRunner queryRunner = new QueryRunner(new ComboPooledDataSource());
        try {
            //使用dbutils进行操作
            User user = queryRunner. query("select * from user where username=? and password=?", new
                    BeanHandler<User>(User.class), username, password);
            return user;
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return null;
    }
}

7.写登录成功或登陆失败的转发服务层

SuccessServlet

package com.chen.servlets;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@WebServlet("/success")
public class SuccessServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        System.out.println("成功的servlet");
        response.setContentType("text/html;charset=utf-8");
        response.getWriter().println("登录成功！！！");
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }
}

ErrorServlet

package com.chen.servlets;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@WebServlet("/error")
public class ErrorServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        System.out.println("失败的servlet");
        response.setContentType("text/html;charset=utf-8");
        response.getWriter().println("登录失败！！！");
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    }
}