一对多两个表的数据进行查找二表对应一表的多条数据后将两个表进行封装一个list

黄志刚

于 2015-07-08 17:09:50 发布

阅读量2.8k

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/u010591939/article/details/46805919

版权

java 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

public List getRuleAndKeyWord(Integer wechatId) {
    List ruleAndKeyList = new ArrayList();
    Integer ruleid = null;
    String ruleName = null;
    String keyword = null;

    List<WechatRule> wechatRuleList = wechatRuleMapper.findByWechatId(wechatId);
    for (WechatRule wechatRule : wechatRuleList){
        List list = new ArrayList();
        ruleid = wechatRule.getRuleId();
        ruleName = wechatRule.getRuleName();
        list.add(ruleid);
        list.add(ruleName);

    List<WechatRuleKey> wechatRuleKeyList = wechatRuleKeyMapper.queryByRuleId(ruleid);
    for (WechatRuleKey wechatRuleKey:wechatRuleKeyList){
        keyword = wechatRuleKey.getKeyword();
        list.add(keyword);
    }
        ruleAndKeyList.add(list);
    }
    return ruleAndKeyList;
}