1、查询所有数据
源码
package com.item.servlet; import com.item.dao.UserInfoDAO; import com.item.daoimpl.UserInfoDAOImpl; import com.item.pojo.UserInfo; 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 java.util.List; @WebServlet("/SelectAllServlet") public class SelectAllServlet extends HttpServlet { @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { UserInfoDAO db = new UserInfoDAOImpl(); List<UserInfo> list = db.GetAll(); req.setAttribute("list",list); req.getRequestDispatcher("index.jsp").forward(req,resp); } @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doPost(req, resp); } }
2、编写index.jsp页面
<%@ page import="com.item.pojo.UserInfo" %> <%@ page import="java.util.List" %><%-- Created by IntelliJ IDEA. User: 红目香薰 Date: 2022/2/25 Time: 17:02 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>$Title$</title> <link rel="stylesheet" href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css"> </head> <body> <% List<UserInfo> list=(List<UserInfo>)request.getAttribute("list");%> <table class="table table-hover table-bordered"> <tr> <th>编号</th> <th>创建时间</th> <th>用户名</th> <th>简介</th> <th>操作</th> </tr> <% for (UserInfo info:list ) { %> <tr> <td><%=info.getId()%></td> <td><%=info.getCreateDate()%></td> <td><%=info.getUserName()%></td> <td><%=info.getIntroduce()%></td> <td> <a href="UpdateByIdServlet?id=<%=info.getId()%>" class="btn btn-primary">修改</a> <a href="DeleteByIdServlet?id=<%=info.getId()%>" class="btn btn-primary">删除</a> </td> </tr> <% } %> </table> </body> </html>
3、访问测试
启动后直接进入主页
访问成功。
注：如果出现【No suitable driver found for jdbc】类似的报错，找到自己的【mysql-connector-java-5.1.39.jar】包，放到对应的识别路径上就好。
