servlet
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
OrderDal dal=new OrderDal();
List<Order> list= dal.getAll();
request.setAttribute("listInfo", list);
request.getRequestDispatcher("/order/order.jsp").forward(request, response);
}
jsp
<table >
<tr>
<td>订单号</td> <td>用户名</td><td>地址</td><td>电话</td><td>购买状态</td><td>备注</td><td>编辑</td><td>删除</td>
</tr>
<c:forEach items="${listInfo}" var="item">
<tr>
<td>${item.number }</td><td>${item.name }</td> <td>${item.address }</td><td>${item.phone }</td><td>${item.state}</td>
<td>${item.remark}</td>
<td><a href="${pageContext.servletContext.contextPath }/order/edit?number=${item.number }">编辑</a></td>
<td><a href="${pageContext.servletContext.contextPath }/order/del?number=${item.number }">删除</a></td>
<tr/>
</c:forEach>
</table>
orderDal
public List< Order> getAll(){
conn=util.getConnection();
String sql="select * from order";
try {
PreparedStatement pst= conn.prepareStatement(sql);
ResultSet rs= pst.executeQuery();
List< Order> list= new ArrayList< Order>();
Order order=null;
while(rs.next()){
order=new Order();
order.setNumber(rs.getString("number"));
order.setName(rs.getString("name"));
order.setAddress(rs.getString("address"));
order.setPhone(rs.getString("phone"));
order.setState(rs.getString("state"));
order.setRemark(rs.getString("remark"));
list.add(order);
}
rs.close();
pst.close();
conn=null;
return list;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
后台打印下那个链表确定有数据吗
jstl在jsp中引用了吧
先看一下是不是数据库真的连接成功了,然后断点调试一下,看看能不能在get方法那儿获取到数据
感谢各位大神已经解决