使用c:forEach數(shù)據(jù)庫(kù)的內(nèi)容沒有加載
ListServlet.java的內(nèi)容
package?com.imooc.servlet;import?java.io.IOException;import?java.sql.Connection;import?java.sql.DriverManager;import?java.sql.PreparedStatement;import?java.sql.ResultSet;import?java.sql.SQLException;import?java.util.ArrayList;import?java.util.List;import?javax.servlet.ServletException;import?javax.servlet.http.HttpServlet;import?javax.servlet.http.HttpServletRequest;import?javax.servlet.http.HttpServletResponse;import?com.imooc.bean.Message;/**?*?列表頁面初始化控制?*/public?class?ListServlet?extends?HttpServlet{ @Override protected?void?doGet(HttpServletRequest?req,?HttpServletResponse?resp)?throws?ServletException,?IOException?{ try?{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection?conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=micro_message",?"sb",?"123"); String?sql="select?id,command,description,content?from?message"; PreparedStatement?statement=conn.prepareStatement(sql); ResultSet?rs=statement.executeQuery(); List<Message>?messageList=new?ArrayList<Message>(); while(rs.next())?{ Message?message=new?Message(); messageList.add(message); message.setId(rs.getInt("id")); message.setCommand(rs.getString("command")); message.setContent(rs.getString("content")); message.setDescription(rs.getString("description")); } req.setAttribute("messageList",?messageList); }?catch?(ClassNotFoundException?e)?{ //?TODO?Auto-generated?catch?block e.printStackTrace(); }?catch?(SQLException?e)?{ //?TODO?Auto-generated?catch?block e.printStackTrace(); } req.getRequestDispatcher("/WEB-INF/jsps/back/list.jsp").forward(req,?resp); } @Override protected?void?doPost(HttpServletRequest?req,?HttpServletResponse?resp)?throws?ServletException,?IOException?{ this.doGet(req,?resp); }}list.jsp的內(nèi)容
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%String path=request.getContextPath();String basePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="X-UA-Compatible"content="IE=9; IE=8; IE=7; IE=EDGE" />
<title>內(nèi)容列表頁面</title>
<link href="<%=basePath %>resources/css/all.css" rel="stylesheet" type="text/css" />
</head>
<body style="background: #e1e9eb;">
<form action="" id="mainForm" method="post">
<div class="right">
<div class="current">當(dāng)前位置：<a href="javascript:void(0)" style="color:#6E6E6E;">內(nèi)容管理</a> > 內(nèi)容列表</div>
<div class="rightCont">
<p class="g_title fix">內(nèi)容列表 <a class="btn03" href="#">新 增</a> <a class="btn03" href="#">刪 除</a></p>
<table class="tab1">
<tbody>
<tr>
<td width="90" align="right">序號(hào)：</td>
<td>
<input type="text" class="allInput" value=""/>
</td>
<td width="90" align="right">指令名稱：</td>
<td>
<input type="text" class="allInput" value=""/>
</td>
? ? ? ? ? ? ? ? ? ? ? ? ? ? <td width="85" align="right"><input type="submit" class="tabSub" value="查 詢" /></td>
? ? ? ? </tr>
</tbody>
</table>
<div class="zixun fix">
<table class="tab2" width="100%">
<tbody>
<tr>
? ? <th><input type="checkbox" id="all" onclick="#"/></th>
? ? <th>序號(hào)</th>
? ? <th>指令名稱</th>
? ? <th>描述</th>
? ? <th>操作</th>
</tr>
<c:forEach items="${messageList}" var="messages" varStatus="status">
<tr <c:if test="${status.index%2!=0}">style='background-color:#ECF6EE;'</c:if> >
<td><input type="checkbox" /></td>
<td>${status.index +1}</td>
<td>${messages.command}</td>
<td>${messages.description}</td>
<td>
<a href="#">修改</a>
<a href="#">刪除</a>
</td>
</tr>
</c:forEach>
</tbody>
</table>
<div class='page fix'>
共 <b>4</b> 條
<a href='###' class='first'>首頁</a>
<a href='###' class='pre'>上一頁</a>
當(dāng)前第<span>1/1</span>頁
<a href='###' class='next'>下一頁</a>
<a href='###' class='last'>末頁</a>
跳至 <input type='text' value='1' class='allInput w28' /> 頁
<a href='###' class='go'>GO</a>
</div>
</div>
</div>
</div>
? ? </form>
</body>
</html>
這就是按著老師的內(nèi)容來敲的，網(wǎng)上找問題也找了一天了，還是沒有解決，那四行一直沒有加載出來
2019-08-01
要想有數(shù)據(jù)顯示，記得首先數(shù)據(jù)庫(kù)里面要有數(shù)據(jù)，不然一直都不會(huì)得到結(jié)果的，血淚的教訓(xùn)?