<tr>

? ? <th><input type="checkbox" id="all" onclick="#"/></th>

? ? <th>序號</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" /></td>

<td>${status.index+1}</td>

<td>${message.command}</td>

<td>${message.description}</td>

<td>

<a href="#">修改</a>&nbsp;&nbsp;&nbsp;

<a href="#">刪除</a>

</td>

</tr>

</c:forEach>

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 doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

req.getRequestDispatcher("/WEB-INF/jsp/back/list.jsp").forward(req, resp);

? ?try {

Class.forName("com.mysql.jdbc.Driver");

Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/micro_message","root","123456789");

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.getString("ID"));

message.setCommand(rs.getString("COMMAND"));

message.setDescription(rs.getString("DESCRIPTION"));

message.setContent(rs.getString("CONTENT"));

}

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 doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

// TODO Auto-generated method stub

this.doGet(req, resp);

}

}