为什么我查询出来的值，会被下一条语句中的值覆盖啊，每次查询出来的所有数据，都是最后一条数据
List<Message> messageList = new ArrayList<Message>();
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection;
connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/micro_message","root","root");
StringBuilder sql = new StringBuilder("select id,command,desription,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(desription != null && !"".equals(desription.trim())){
sql.append("and desription like '%' ? '%' ");
paramList.add(desription);
}
PreparedStatement statement = connection.prepareStatement(sql.toString());
for(int i=0;i<paramList.size();i++){
statement.setString(i + 1,paramList.get(i));
}
ResultSet rs = statement.executeQuery();
Message message = new Message();
while(rs.next()){
message.setId(rs.getString("id"));
message.setCommand(rs.getString("command"));
message.setDesription(rs.getString("desription"));
message.setContent(rs.getString("content"));
messageList.add(message);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch (SQLException e) {
e.printStackTrace();
}
return messageList;
