package?com.neusoft.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.neusoft.bean.Message;
/**
?*?列表頁面初始化控制
?*?@author?Administrator
?*
?*/
public?class?ListServlet?extends?HttpServlet{
@Override
protected?void?doGet(HttpServletRequest?req,?HttpServletResponse?resp)
throws?ServletException,?IOException?{
this.doPost(req,?resp);
}
@Override
protected?void?doPost(HttpServletRequest?req,?HttpServletResponse?resp)
throws?ServletException,?IOException?{
try?{
req.setCharacterEncoding("UTF-8");
String?command=req.getParameter("command");
String?description=req.getParameter("description");
System.out.println(command);
System.out.println(description);
req.setAttribute("command",?command);
req.setAttribute("description",?description);
Class.forName("com.mysql.jdbc.Driver");
Connection?conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/micro_message1","root","root");
StringBuilder?sql=new?StringBuilder("select?ID,COMMAND,DESCRIPTION,CONTENT?from?message?where?1=1?");
List<String>?paramList=new?ArrayList<String>();
if(command?!=null?&&?!"".equals(command.trim())?){
sql.append("and?COMMAND=??");
paramList.add(command);
}
if(description?!=null?&&?!"".equals(description.trim())?){
sql.append("and?DESCRIPTION?like?'%'?'%'");
paramList.add(description);
}
PreparedStatement?statement=conn.prepareStatement(sql.toString());
for?(int?i?=?0;?i?<?paramList.size();?i++)?{
statement.setString(i+1,?paramList.get(i));
}
System.out.println(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)?{
e.printStackTrace();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
req.getRequestDispatcher("/WEB-INF/jsp/back/list.jsp").forward(req,?resp);
}
}<!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"?%>
<%@?page?language="java"?import="java.util.*"?pageEncoding="UTF-8"%>
<%
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>內容列表頁面</title>
<link?href="<%=basePath?%>resources/css/all.css"?rel="stylesheet"?type="text/css"?/>
</head>
<body?style="background:?#e1e9eb;">
<form?action="<%=basePath?%>List.action"?id="mainForm"?method="post">
<div?class="right">
<div?class="current">當前位置：<a?href="javascript:void(0)"?style="color:#6E6E6E;">內容管理</a>?>?內容列表</div>
<div?class="rightCont">
<p?class="g_title?fix">內容列表?<a?class="btn03"?href="#">新?增</a> <a?class="btn03"?href="#">刪?除</a></p>
<table?class="tab1">
<tbody>
<tr>
<td?width="90"?align="right">指令名稱：</td>
<td>
<input?name="command"?type="text"?class="allInput"?value="${command?}"/>
</td>
<td?width="90"?align="right">描述：</td>
<td>
<input?name="description"?type="text"?class="allInput"?value="${description?}"/>
</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>序號</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>
<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>
當前第<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>
