編譯器不報(bào)錯(cuò)，就是無法顯示數(shù)據(jù)庫里的數(shù)據(jù)
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;
/*
?* 列表頁面初始化控制
?*/
@SuppressWarnings("serial")
public class ListServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
// TODO Auto-generated method stub
this.doGet(req, resp);
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/micro_message","root","8470287");
String sql="select ID,COMMAND,DESCRIPTION,CONTENT from message ";
PreparedStatement statement=conn.prepareStatement(sql);
ResultSet rs=statement.executeQuery(sql);
List<Message>messageList=new ArrayList<Message>();
//System.out.println(messageList.size());
while(rs.next()){
Message message=new Message();
messageList.add(message);
message.setId(rs.getString("ID"));
message.setCommand(rs.getString("COMMAND"));
message.setDescription(rs.getString("DESCRIPTION"));
message.setContent(rs.getString("CONTENT"));
//System.out.println(message);
}
req.setAttribute("messageList", "messageList");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
? @Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
?
// TODO Auto-generated method stub
?req.getRequestDispatcher("/WEB-INF/jsp/List.jsp").forward(req, resp);
}
}
這是jsp
<!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">演示字段1：</td>
<td>
<input type="text" class="allInput" value=""/>
</td>
<td width="90" align="right">演示字段2：</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" /></th>
? ?<th>序號(hào)</th>
? ?<th>指令名稱</th>
? ?<th>描述</th>
? ?<th>操作</th>
</tr>
<c:forEach items="${messageList}" var="message" varStatus="status">
<tr ?<c:if test="${status.index % 2 != 0}">style='background-color:#ECF6EE;'</c:if>>
<td><input type="checkbox" ?name="id" value="${message.id}"/></td>
<td>${status.index + 1}</td>
<td>${message.command}</td>
<td>${message.description}</td>
<td>
<a href="#">修改</a>
<a href="${basePath}DeleteOneServlet.action?id=${message.id}">刪除</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>
?一晚上都沒調(diào)好，這是為什么
2016-08-21
while(rs.next()){
Message message=new Message();
message.setId(rs.getString("ID"));
message.setCommand(rs.getString("COMMAND"));
message.setDescription(rs.getString("DESCRIPTION"));
message.setContent(rs.getString("CONTENT"));
//System.out.println(message);
messageList.add(message);
}
改成這樣。? 你要先給message設(shè)置完熟悉再加到list中才有屬性值啊