JavaWebDay8

最新推荐文章于 2024-10-01 09:29:45 发布

m0_62761692

最新推荐文章于 2024-10-01 09:29:45 发布

阅读量78

点赞数

文章标签： java

本文链接：https://blog.csdn.net/m0_62761692/article/details/125952217

版权

该博客介绍了如何使用JDBC实现用户登录功能，通过获取表单输入的用户名和密码，从数据库中查找匹配的用户。登录成功后跳转到数据展示页面，显示员工信息列表，并提供删除功能。用户点击删除按钮，根据员工ID调用DAO实现删除操作，并返回主页面。

摘要由CSDN通过智能技术生成

1>结合jdbc的知识实现登录

<%@ page import="JDBC.dao.UsersDao" %>
<%@ page import="JDBC.dao.impl.UsersDaoImpl" %>
<%@ page import="java.util.List" %>
<%@ page import="JDBC.bean.Users" %><%--
  Created by IntelliJ IDEA.
  User: 32519
  Date: 2022/7/23
  Time: 14:00
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<form action="login.jsp">
    <p>用户名: <input type="text" name="username"/></p>
    <p>密码: <input type="password" name="pwd"/></p>
    <p> <input type="submit" value="提交"/> </p>
</form>
</body>
</html>

<%@ page import="JDBC.dao.UsersDao" %>
<%@ page import="JDBC.dao.impl.UsersDaoImpl" %>
<%@ page import="JDBC.bean.Users" %>
<%--
  Created by IntelliJ IDEA.
  User: 32519
  Date: 2022/7/23
  Time: 14:14
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%
    String name = request.getParameter("username");
    String pwd = request.getParameter("pwd");
    UsersDao usersDao = new UsersDaoImpl();
    Users users = usersDao.findByNameAndPwd(name,pwd);
    if (users != null) {
        response.sendRedirect("main.jsp");
    } else {
        response.sendRedirect("first.jsp");
    }
%>
</body>
</html>

2>登录成功后转入数据展示页面

<%@ page import="JDBC.dao.EmpDao" %>
<%@ page import="JDBC.dao.impl.EmpDaoImpl" %>
<%@ page import="java.util.List" %>
<%@ page import="JDBC.bean.Emp" %><%--
  Created by IntelliJ IDEA.
  User: 32519
  Date: 2022/7/22
  Time: 16:58
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%
    EmpDao dao = new EmpDaoImpl();
    List<Emp> list = dao.findAll();
%>
<input type="button" value="添加" onclick="window.location.href='add.jsp'"/>
<table border="1" width="880">
    <tr>
        <td>empid</td>
        <td>姓名</td>
        <td>性别</td>
        <td>地址</td>
        <td>生日</td>
        <td>电话</td>
        <td>deptid</td>
        <td>工资</td>
        <td>奖金</td>
    </tr>
    <%
        for (Emp e:list) {
    %>
    <tr>
        <td><%=e.getEmpid() %></td>
        <td><%=e.getEmpname() %></td>
        <td><%=e.getEmpsex() %></td>
        <td><%=e.getEmpaddr() %></td>
        <td><%=e.getEmpbirth() %></td>
        <td><%=e.getEmpphone() %></td>
        <td><%=e.getDeptid() %></td>
        <td><%=e.getSal() %></td>
        <td><%=e.getComm() %></td>
        <td>
            <a href="delete.jsp?id=<%=e.getEmpid() %>" >删除</a>
        </td>
    </tr>
    <%
        }
    %>
</table>
</body>
</html>

3>在展示列表中实现删除功能

<%@ page import="JDBC.dao.EmpDao" %>
<%@ page import="JDBC.dao.impl.EmpDaoImpl" %><%--
  Created by IntelliJ IDEA.
  User: 32519
  Date: 2022/7/23
  Time: 14:44
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%
    String id = request.getParameter("id");
    EmpDao empDao = new EmpDaoImpl();
    empDao.delete(Integer.parseInt(id));
    response.sendRedirect("main.jsp");
%>
</body>
</html>