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
2017-03-15
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("查看");
}
}
举报
