页面渲染:<div class="M-box"></div>
</div></div>
<script type="text/javascript">
$(function () {
PageCallback(1,false);
$('.M-box').pagination({
totalData:parseInt($("#totalItem").text()),
showData:1,
jump:true,
coping:true,
homePage:'首页',
endPage:'末页',
prevContent:'上页',
nextContent:'下页',
callback:function(api){
$('.now').text(api.getCurrent());
PageCallback(api.getCurrent(),true)
}
});
})
function PageCallback(page_index,isAsync){
$.ajax({
type : "GET",
url : "getAllHouse.do",
async:isAsync,
data : {
pageNumber : page_index,
pageSize:1
},
dataType : "json",
success : function(data) {
var html = template('allHouse', data);
console.log(data);
document.getElementById('allHousePage').innerHTML = html;
}
});
}
<td><%=page.content[i].houseBusiness%></td>
<td><%=page.content[i].houseUrban%></td>
<td><%=page.content[i].houseUrban%></td>
<td><%=page.content[i].houseUrban%></td>
<td><%=page.content[i].houseUrban%></td>
@RestController
@RequestMapping(value="getAllHouse")
public Map<String,Object> getAllHouse(Integer pageNumber,Integer pageSize,
HttpServletRequest request){
Map<String,Object> map = new HashMap<String,Object>();
System.out.println("输出PageNUmber1111"+pageNumber);
if(pageNumber == null){
pageNumber = 1;
}
Employee user = (Employee) request.getSession().getAttribute("user");
map.put("roles", rolesService.findByUserId(user.getId()));
map.put("page", this.houseService.getAllHouse(pageNumber, pageSize));
return map;
}
service
public Page<House> getAllHouse(int pageNumber,int pageSize){
System.out.println("输出PageNUmber"+pageNumber);
PageRequest page = new PageRequest(pageNumber - 1, pageSize, null);
return houseRepository.findAll( page);
}
//这里是我后面自己写的一个list查询。按自己需要封装Sql语句查询
public List<Customer> findSearch(final Customer cus){
Assert.notNull(cus);
List<Customer> result = customerRepository.findAll(new Specification<Customer>() {
public Predicate toPredicate(Root<Customer> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
System.out.println("sssssssssssssssssssssssssssssssssssssssssssssssss");
List<Predicate> list = new ArrayList<Predicate>();
// Path<String> namePath = root.get("tel");
//Path<String> nameid = root.get("customerid");
/**
* 连接查询条件, 不定参数,可以连接0..N个查询条件
*/
// query.where(cb.like(namePath, "%"+cus.getTel()+"%"),cb.equal(nameid, cus.getCustomerid())); //这里可以设置任意条查询条件
if(cus.getCustomerid() != null){
list.add(cb.equal(root.get("customerid"), cus.getCustomerid()));
}
if(cus.getTel()!=null){
list.add(cb.like(root.get("tel").as(String.class), "%"+cus.getTel()+"%"));
}
Predicate[] p = new Predicate[list.size()];
query.where(list.toArray(p));
return null;
/*List<Predicate> list = new ArrayList<Predicate>();
if(cus.getCucNumber() != null & cus.getCucNumber() !=" " ){
list.add(cb.equal(root.get("cusNumber").as(Customer.class), cus.getCucNumber()));
System.out.println(cus.getCucNumber().toString()+"ddddddddddddddddddddddcesji ");
}
if(cus.getXingming() !=null ){
list.add(cb.equal(root.get("xingming").as(Customer.class), cus.getXingming()));
}
if (StringUtils.isNotBlank(cus.getTel())) {
list.add(cb.like(root.get("tel").as(String.class), "%" + cus.getTel() + "%"));
System.out.println(cus.getCucNumber().toString()+"ddddddddddddddddddddddcesji ");
}
Predicate[] p = new Predicate[list.size()];
return cb.and(list.toArray(p));*/
}
});
return result;
}
接口
Page<House> findAll(Pageable page);
Page<House> findAll(Specification<House> spec, Pageable page);