I have an List of Messages objects. My message object consist of sender and CaseNumber. A SQL query is pulls all the messages into a list. In this list I have multiple of the same CaseNumber.
What I would like to accomplish is loop though the current Messages List and split them out into their own individual list based on the CaseNumber.
我已经try 过了,但我不确定如何在for循环中实现这一点.
public class Messages {
private String sender = "";
private int caseNumber = 0
public int getCaseNumber() {
return caseNumber;
}
public void setCaseNumber(int caseNumber) {
this.caseNumber = caseNumber;
}
public String getSender() {
return sender;
}
public void setSender(String sender) {
this.sender = sender;
}
}
SQL makes a call and maps the vars into a huge object.
public List<Messages> getAllMessages()
{
List<Messages> entries = null;
String sql = "select sender, caseNumber from Messages";
entries = jdbcTemplate.query(sql, new MessagesMapper());
return entries;
}
//for loop in my function.
for(Messages m : allMessages)
{
//This is the part i am stumped on how to I check if case number = case number if so create a new Messages List. Then if any of the additional cases in the list, add them to this new List. If it's a new caseNumber, create a new list.
}
我曾想过更改SQL调用,只是为了按CaseNumber拉取每个消息,但我觉得我可能只是在敲打SQL,这感觉效率不高.
令人希望的是,这对我想要实现的目标是有意义的.根据CaseNumber拆分对象列表,并创建它自己对象列表.