模糊查询查不到内容
关键console并没有报错啊！
一下是我的代码
MessageDao：
package com.imooc.dao;
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 com.imooc.bean.Message;
/**
* 和message表相关的数据库操作
*/
public class MessageDao {
/**
* 根据查询条件查询消息列表
*/
public List<Message> queryMessageList(String command,String description){
List<Message> messageList = new ArrayList<Message>();
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/micro_message?useUnicode=true&characterEncoding=utf8","root","skd2013");
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="+command+" ");
paramList.add(command);
}
if(description != null && !"".equals(description.trim())){
sql.append(" and DESCRIPTION like'%'?'%'");
paramList.add(description);
}
PreparedStatement st = conn.prepareStatement(sql.toString());
for (int i=0; i<paramList.size(); i++) {
st.setString(i + 1, paramList.get(i));
}
ResultSet rs = st.executeQuery();
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"));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
return messageList;
}
}
list.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>内容列表页面</title>
<link href="<%= basePath %>resource/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>
