public//列表
Map list(BaseParam baseParam,MarketIssueParam marketIssueParam) {
Map<String, Object> list=new HashMap<>();
PageHelper.startPage( baseParam.getPage(),baseParam.getLimit() );
MarketKeywordExample marketKeywordExample=new MarketKeywordExample();
MarketKeywordExample.Criteria criteria=marketKeywordExample.createCriteria();
criteria.andDeletedEqualTo( true );
if ( marketIssueParam.getId()!= null ) {
criteria.andIdEqualTo( marketIssueParam.getId() );
}
if ( !StringUtils.isEmpty( marketIssueParam.getClass() ) ) {
criteria.andKeywordEqualTo( marketIssueParam.getClass() );
}
if ( !StringUtils.isEmpty( marketIssueParam.toString() ) ) {
criteria.andAddTimeBetween( "" + marketIssueParam.toString() + "" );
}
List<MarketIssue> marketKeywords =marketIssueMapper.selectByExample( marketIssueParam );
PageInfo pageInfo=new PageInfo();
list.put( "total",pageInfo.getTotal() );
list.put( "pages",pageInfo.getPages() );
list.put( "limit",pageInfo.getPageSize() );
list.put( "page",pageInfo.getPageNum() );
list.put( "list",pageInfo.getList() );
return list;
}
这串代码应该是用来分页的吧,模糊查询和精确查询的代码,你的意思是sql语句还是Java代码,sql我知道,但是Java的还真不清楚
分页 把marketKeywordExample的信息存进去 模糊精确查询你得在sql里面弄 精确就是= 模糊就是%%
public//列表
Map list(BaseParam baseParam,MarketIssueParam marketIssueParam) {
Map<String, Object> list=new HashMap<>();
//分页,会对后面第一个执行的sql添加分页的条件
PageHelper.startPage( baseParam.getPage(),baseParam.getLimit() );
//这里是MarketKeywordExample的一些操作
MarketKeywordExample marketKeywordExample=new MarketKeywordExample();
MarketKeywordExample.Criteria criteria=marketKeywordExample.createCriteria();
criteria.andDeletedEqualTo( true );
if ( marketIssueParam.getId()!= null ) {
criteria.andIdEqualTo( marketIssueParam.getId() );
}
if ( !StringUtils.isEmpty( marketIssueParam.getClass() ) ) {
criteria.andKeywordEqualTo( marketIssueParam.getClass() );
}
if ( !StringUtils.isEmpty( marketIssueParam.toString() ) ) {
criteria.andAddTimeBetween( "" + marketIssueParam.toString() + "" );
}
//这里是具体的sql查询 会被分页
List<MarketIssue> marketKeywords =marketIssueMapper.selectByExample( marketIssueParam );
/**
*这个地方写的好像有点问题,应该是PageInfo pageInfo=new PageInfo(marketKeywords);
*这里的是PageHelper分页的 所以他会吧分页所需要的参数封装到PageInfo里面
*所以需要把它实例化出来 然后下面的getTotal、getPages等操作获取值
*/
PageInfo pageInfo=new PageInfo();
list.put( "total",pageInfo.getTotal() );
list.put( "pages",pageInfo.getPages() );
list.put( "limit",pageInfo.getPageSize() );
list.put( "page",pageInfo.getPageNum() );
list.put( "list",pageInfo.getList() );
return list;
}