关键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 queryMessageList(String command,String description){
List messageList = new ArrayList();
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 paramList = new ArrayList();
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
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:
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
内容列表页面type="text/css" />