接口:
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