我想知道怎么用ajax分页,每页10条,ajax写好之后,后台写什么方法去执行调用,我是新手,不懂这些,求大神帮帮忙
我用的是spring,springmvc+hibernate,三个框架,实在是不会了。
<script type="text/javascript">
$(function()
{
//此demo通过Ajax加载分页元素
var initPagination = function()
{
var num_entries = $("#hiddenresult").size();
// 创建分页
$("#Pagination").pagination(num_entries,
{
num_edge_entries: 1, //边缘页数
num_display_entries: 4, //主体页数
callback: pageselectCallback,
items_per_page: 10, //每页显示1项
prev_text: "前一页",
next_text: "后一页"
});
function pageselectCallback(page_index, jq)
{
var new_content = $("#hiddenresult :eq("+page_index +")").clone();
$("#Searchresult").empty().append(new_content); //装载对应分页的内容
alert($("#hiddenresult :eq("+page_index +")")+"2");
return false;
}
};
//ajax加载
$("#hiddenresult").load("/news/user/all.htmls",null,initPagination);
});
</script>
网上抄的ajax
后台查询所有数据
@SuppressWarnings({ "unchecked" })
@RequestMapping("/all")
public @ResponseBody List<AcctNewscontext> ceshi(){
String hql="from AcctNewscontext";
Query query = this.getCurrentSession().createQuery(hql);
System.out.println("这是所有"+query.list());
List<AcctNewscontext> q= query.list();
return q;
后台查询hibeinate分页查
@SuppressWarnings({ "unchecked" })
@RequestMapping(value="/listPage")
public @ResponseBody List<AcctNewscontext> next(Integer page_index){
LOGGER.info("下一页");
String hql="from AcctNewscontext";
Query query = this.getCurrentSession().createQuery(hql);
query.setFirstResult(page_index);//从第一条记录开始
query.setMaxResults(10);//取出10条记录
List<AcctNewscontext> q= query.list();
System.out.println("这是下一页"+q);
return q;
后台limit 查询
@SuppressWarnings("rawtypes")
@RequestMapping(value="/fenye")
public String fenye(ModelMap map){
LOGGER.info("各种分页各种列表");
String hql="select * from newscontent limit 0,10";
Query query = this.getCurrentSession().createSQLQuery(hql);
List list=query.list();
map.addAttribute("list", list);
System.out.println("这是分页"+list);
return "/user/listnews";