SSM整合--ajax实现分页功能()

接口:

public int count();//查询分页总记录数
public List<smbms_user> pageOne(Map<String,Object> map);//获取单页数据
小配置:

   <!--Ajax??-->
<select id="count" resultType="int">
    SELECT COUNT(*)  FROM  smbms_user
</select>
<select id="pageOne" resultType="smbms_user">
    SELECT * FROM smbms_user limit #{PageIndex},#{PageSize}
</select>
实体类:


service层:

     接口:

     

public int count();//查询分页总记录数
public page pageOne(int PageIndex, int PageSize);
接口实现:
/* Ajax分页*/
public int count() {
    return userDao.count();
}
public page pageOne(int pageIdex, int pagesize) {
    Map<String,Object> map=new HashMap<String,Object>();
    map.put("PageIndex",pageIdex*pagesize);
    map.put("PageSize",pagesize);
    page pg=new page();
    pg.setPageIdex(pageIdex);
    pg.setPagesize(pagesize);
    int count=userDao.count();
    pg.setTotalRecords(count);
    int totalPage=pg.getTotalRecords()%pg.getPagesize()==0?pg.getTotalRecords()/pg.getPagesize():pg.getTotalRecords()/pg.getPagesize()+1;
    pg.setIntalpage(totalPage);
    List<smbms_user> user=userDao.pageOne(map);
    pg.setList(user);
    return pg;
Controller:
 
@Controller()
@RequestMapping("/user")
public class userController {
/*植入service*/
    @Resource(name = "userService")
    UserService service;
 /*Ajax分页
让用户看到该视图*/
@RequestMapping("/showUserList")
public String showUserList()
{
    return "userlist1";
}
@ResponseBody
@RequestMapping(value = "/getUserInfo",method = RequestMethod.POST)
public Object getUserInfo(@RequestParam(defaultValue = "1")int pageIdex,@RequestParam(defaultValue = "2") int pagesize){
    return service.pageOne(pageIdex,pagesize);
}

}
xml:
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:p="http://www.springframework.org/schema/p"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd

        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd

       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd

        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd

         http://www.springframework.org/schema/mvc
         http://www.springframework.org/schema/mvc/spring-mvc.xsd">

    <!--包扫描器-->
    <context:component-scan base-package="bdqn"></context:component-scan>
    <!--mvc注解驱动  作用:创建7个HttpMessaeingConvert-->
    <mvc:annotation-driven></mvc:annotation-driven>
    <!--视图解析器-->

    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>
    <!--1.识别jdbc.properties-->
    <context
  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值