Jsp显示数据库所有数据

这里使用QueryRunner查询

  @Override
    public List<User> allUser() throws SQLException {
        String sql ="select * from `user`";
        List<User> query = Qr.qr().query(sql, new BeanListHandler<User>(User.class));
        System.out.println(query);
        return query;
    }

jsp页面

<%-- 导入jstl--%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
    UserDaoImpl userDao = new UserDaoImpl();
    try {
        request.setAttribute("list", userDao.allUser());
    } catch (SQLException e) {
        e.printStackTrace();
    }
%>

<c:forEach begin="0" end="${list.size()-1}" var="i">
    <table>
        <tr>
            <th>ID</th>
            <th>用户名</th>
            <th>昵称</th>
            <th>密码</th>
            <th>性别</th>
            <th>生日</th>
            <th>邮箱</th>

        </tr>
        <tr>
            <td> ${list[i].uid}</td>
            <td> ${list[i].username}</td>
            <td> ${list[i].name}</td>
            <td> ${list[i].password}</td>
            <td> ${list[i].sex}</td>
            <td> ${list[i].birthday}</td>
            <td> ${list[i].email}</td>
        </tr>
    </table>
</c:forEach>
<c:forEach var="u" items="${list}">
    <table>
        <tr>
            <th>ID</th>
            <th>用户名</th>
            <th>昵称</th>
            <th>密码</th>
            <th>性别</th>
            <th>生日</th>
            <th>邮箱</th>

        </tr>
        <tr>
            <td> ${u.uid}</td>
            <td> ${u.username}</td>
            <td> ${u.name}</td>
            <td> ${u.password}</td>
            <td> ${u.sex}</td>
            <td> ${u.birthday}</td>
            <td> ${u.email}</td>
        </tr>
    </table>
</c:forEach>