问答详情
源自:5-3 一对多关系的配置 Ⅲ

log4j显示总共有8条数据,回复每次却只显示第一条?

2017-03-15 17:24:44,240 [http-bio-8080-exec-8]DEBUG[Command.queryCommandList]- ==>  Preparing: select a.id,a.name,a.description,b.content from command a left join command_content b on a.id=b.command_id WHERE a.name=? 

2017-03-15 17:24:44,240 [http-bio-8080-exec-8]DEBUG[Command.queryCommandList]- ==> Parameters: 查看(String)

2017-03-15 17:24:44,245 [http-bio-8080-exec-8]DEBUG[Command.queryCommandList]- <==      Total: 8


http://img.mukewang.com/58c909d10001b57a12940620.jpg

http://img.mukewang.com/58c909d30001b2d209910598.jpg

http://img.mukewang.com/58c909d400012ca812940620.jpg

http://img.mukewang.com/58c909d50001d1c012940598.jpg


提问者:快乐不假 2017-03-15 17:31

个回答

  • 等一束花開3990875
    2017-03-15 19:27:38
    已采纳

    看下你的显示代码

  • qq_糖苦_03800705
    2017-09-04 20:08:05

    同问。。请问你是怎么解决的

  • 快乐不假
    2017-03-15 19:33:53


    public class QueryService {

    /**

    * 查询信息

    * @param command

    * @param description

    * @return

    */

    public List selectInfo(String command,String description){

    InfoSelect is=new InfoSelect();

    return is.selectInfo(command, description);

    }

    /**

    * 通过指令查询自动回复内容

    * @param command

    * @return

    */

    public String queryByCommond(String name)

    {

    CommandSelect cs=new CommandSelect();

    List<command>commandList;

    if(Iconst.HELP_COMMAND.equals(name))

    {

    commandList=cs.selectByCommand(null, null);

    StringBuilder sb=new StringBuilder();

    for(int i=0;i<commandList.size();i++)

    {

    if(i!=0)//第一条不拼接回车

    {

    sb.append("<br/>");

    }

    sb.append("回复【"+commandList.get(i).getName()+"】可以查看"+commandList.get(i).getDescription());

    }

    return sb.toString();

    }

    commandList=cs.selectByCommand(name,null);

    if(commandList.size()>0){

    List<command_content> command_contentList= commandList.get(0).getContentList();

    return command_contentList.get(new Random().nextInt(command_contentList.size())).getContent();

    }

    return Iconst.NO_MATCHING_CONTENT;

    }

    public static void main(String []args)

    {

    new QueryService().queryByCommond("查看");

    }

    }

    http://img.mukewang.com/58c926970001037408730546.jpg