SSM(Spring,springmvc,mybatis)+maven+AJAX实现分页功能
来源:互联网 发布:腾讯上班知乎 编辑:程序博客网 时间:2024/06/05 00:58
SSM(Spring,springmvc,mybatis)+maven+AJAX实现分页功能
简介经过这段时间的工作,有一种强烈的写博客的想法,或是为了分享,或是为了记录自己的点滴,也是为了加深印象,也是为了锻炼自己表达能力和描述问题的能力。在工作的过程中很多内容都是别人搭建好的,所以很多问题自己是遇不到的,只有自己亲自动手才会知道很多东西该怎么用,遇到问题该怎么解决。同时程序员共享的精神和长期保持学习也是非常重要的。
项目目录结构如下
简单介绍一下,各个文件和类的作用,首先,先了解配置文件,按照编写的顺序讲解。首先是pom.各个包的作用几乎都有解释是用来干嘛的了,不知道的可以自行网上查找。
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.libo</groupId> <artifactId>blog</artifactId> <packaging>war</packaging> <version>0.0.1-SNAPSHOT</version> <name>blog Maven Webapp</name> <url>http://maven.apache.org</url> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <spring.version>4.3.7.RELEASE</spring.version> <jackson.version>1.9.13</jackson.version> <druid.version>1.0.29</druid.version> </properties> <dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-mock</artifactId> <version>2.0.8</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context-support</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>${spring.version}</version> </dependency> <!-- 事物管理 --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>${spring.version}</version> </dependency> <!-- JDBC操作 --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring.version}</version> </dependency> <!-- 定时器使用 --> <dependency> <groupId>org.quartz-scheduler</groupId> <artifactId>quartz</artifactId> <version>2.2.1</version> </dependency> <!-- 数据库连接池 --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>${druid.version}</version> </dependency> <!-- mysql驱动包 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.38</version> </dependency> <!-- mybatis包 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.2.4</version> </dependency> <!-- mybatis-spring整合包 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.3.0</version> </dependency> <!-- webSocket操作 --> <dependency> <groupId>javax</groupId> <artifactId>javaee-api</artifactId> <version>7.0</version> </dependency> <!-- 文件上传下载 --> <dependency> <groupId>commons-fileupload</groupId> <artifactId>commons-fileupload</artifactId> <version>1.3.1</version> </dependency> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-io</artifactId> <version>1.3.2</version> </dependency> <!-- 拦截验证属性约束 --> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-validator</artifactId> <version>5.1.3.Final</version> </dependency> <!-- JSTL标签引入 --> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!-- json对象和数组的相互转换使用 --> <dependency> <groupId>net.sf.json-lib</groupId> <artifactId>json-lib</artifactId> <version>2.4</version> <classifier>jdk15</classifier> </dependency> <!-- spring4.0以上版本出现的内容 --> <dependency> <groupId>commons-httpclient</groupId> <artifactId>commons-httpclient</artifactId> <version>3.1</version> </dependency> <!-- java对象和json对象相互转化 --> <dependency> <groupId>org.codehaus.jackson</groupId> <artifactId>jackson-core-asl</artifactId> <version>${jackson.version}</version> </dependency> <dependency> <groupId>org.codehaus.jackson</groupId> <artifactId>jackson-mapper-asl</artifactId> <version>${jackson.version}</version> </dependency> <!-- JSON解析 工具包,提供基于流模式API,包冲突--> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-core</artifactId> <version>2.7.0</version> </dependency> <!-- json工具包,可以实现xml,json,java对象之间的互转--> <dependency> <groupId>com.fasterxml.jackson.dataformat</groupId> <artifactId>jackson-dataformat-xml</artifactId> <version>2.7.0</version> </dependency> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> <version>2.7.0</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-core --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> <version>4.3.7.RELEASE</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>javax.servlet-api</artifactId> <version>3.0.1</version> <scope>provided</scope> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> </dependencies> <build> <finalName>blog</finalName> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>3.1</version> <configuration> <source>1.7</source> <target>1.7</target> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-war-plugin</artifactId> <version>2.6</version> <configuration> <warSourceDirectory>src/main/webapp</warSourceDirectory> <failOnMissingWebXml>true</failOnMissingWebXml> </configuration> </plugin> </plugins> </build></project>
接下来是db.properties文件,相信有点基础的人都知道里面各个参数的作用,我就不多说了,各位可以把里面的用户名和密码改为自己需要的。
jdbc.driverClass=com.mysql.jdbc.Driver#jdbc.url=jdbc\:mysql\://192.168.0.104\:3306/blog?useUnicode=true&characterEncoding=utf-8jdbc.url=jdbc\:mysql\://127.0.0.1\:3306/blog?useUnicode=true&characterEncoding=utf-8jdbc.username=rootjdbc.password=123
日志文件
log4j.xml,对于初学者来说,这个文件觉得很不爽,为什么要加呢?这个文件的加入,往往是后期我们找bug的关键,所以也要好好的去了解一下。我比较习惯于用log4j.properties这种文件形式,也是为了偷懒,将就一下。
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE log4j:configuration PUBLIC "-//log4j/log4j Configuration//EN" "log4j.dtd"><log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"> <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender"> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="[MSTREAM]-%d %-5p %c.%M:%L - %m%n"/> </layout> </appender> <appender name="RollingFile" class="org.apache.log4j.RollingFileAppender"> <param name="MaxFileSize" value="500MB"/> <param name="File" value="logs/mstream.log"/> <param name="Append" value="true" /> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="%d %-5p %c.%M:%L - %m%n"/> </layout> </appender> <logger name="org.springframework" additivity="false"> <level value="INFO" /> <appender-ref ref="STDOUT" /> </logger> <logger name="net.sf.json.JSONObject" additivity="false"> <level value="ERROR" /> <appender-ref ref="STDOUT" /> </logger> <!-- end of pay attention--> <!-- for all other loggers log only info and above log messages --> <root> <priority value="DEBUG"/> <appender-ref ref="STDOUT" /> <!-- <appender-ref ref="RollingFile" /> --> </root> </log4j:configuration>
接下来是spring.xml文件
相应的配置相信大家都比较熟悉,我也不解释原因了。直接上文件内容,里面有的配置本来是不需要的,但是为了接下来我写其他内容,所以懒得配置了,例如上传下载的配置等等。Mybatis的sqlSessionFactory的内容配置需要注意一下,里面使用了 配置之后,在*Mapper.xml文件中,里面的类型可省略不需要写全类名,只需要一个类名就好了。不然会报错的。
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" 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-4.0.xsd"> <!-- 配置自动扫描 --> <context:component-scan base-package="com.blog.service"></context:component-scan> <!--配置数据库访问 --> <context:property-placeholder location="classpath:db.properties"/> <!-- druid数据源 --> <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <property name="url" value="${jdbc.url}" /> <property name="driverClassName" value="${jdbc.driverClass}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <property name="filters" value="stat" /> <property name="maxActive" value="3" /> <property name="initialSize" value="1" /> <property name="maxWait" value="60000" /> <property name="minIdle" value="2" /> <property name="timeBetweenEvictionRunsMillis" value="3000" /> <property name="minEvictableIdleTimeMillis" value="300000" /> <property name="validationQuery" value="SELECT 'x'" /> <property name="testWhileIdle" value="true" /> <property name="testOnBorrow" value="false" /> <property name="testOnReturn" value="false" /> </bean> <!-- 配置事物属性 --> <bean id="transactionInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor"> <property name="transactionManager" ref="transactionManager"/><property name="transactionAttributes"> <props> <prop key="*">PROPAGATION_REQUIRED,-Exception</prop> <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop> <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop> <prop key="list*">PROPAGATION_REQUIRED,readOnly</prop> <prop key="query*">PROPAGATION_REQUIRED,readOnly</prop> <prop key="retrieve*">PROPAGATION_REQUIRED,readOnly</prop> </props> </property> </bean> <!-- TransactionTemplate <bean id="commonTransactionTemplate" class="org.springframework.transaction.support.TransactionTemplate"> <property name="transactionManager" ref ="transactionManager" /> </bean> --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <!--Mybatis的sqlSessionFactory --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="mapperLocations" value="classpath:com/blog/mapper/xml/*.xml" /> <property name="typeAliasesPackage" value="com.blog.vo"/> </bean> <!--自动扫描指定包内接口为org.mybatis.spring.mapper.MapperFactoryBean Dao接口所在包名 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.blog.mapper" /> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> </bean> <!-- 事务管理 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource"ref="dataSource" /> </bean>--> <!-- 上传文件配置操作 --> <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <property name="maxUploadSize" value="20000000"/> </bean> </beans>
spring-mvc.xml文件配置
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd"> <!-- 自动扫描该包,使Springmvc认为包下使用了@Controller注解的类是控制器 --> <context:component-scan base-package="com.blog.controller" /> <!-- 定义文件跳转的前后缀,完成请求和POJO的映射 --> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" /> <property name="prefix" value="/WEB-INF/view/" /> <property name="suffix" value=".jsp" /> </bean> <!-- 静态资源映射 --> <mvc:resources mapping="/resource/js/**" location="/resources/js/" /> <mvc:resources mapping="/resource/css/**" location="/resources/css/" /> <mvc:resources mapping="/resource/images/**" location="/resources/images/" /> <mvc:resources mapping="/resource/fonts/**" location="/resources/fonts/" /> <mvc:resources mapping="/resource/plugins/**" location="/resources/plugins/" /> <!-- <bean id="jsonConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"></bean> <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"> <property name="messageConverters"> <list> <ref bean="jsonConverter" /> </list> </property> </bean> --> <!-- 自动注册DefaultAnnotationHandlerMapping与AnnotationMethodHandlerAdapter 两个bean,是spring MVC为@Controllers分发请求所必须的 --> <mvc:annotation-driven /></beans>
web.xml文件
这个文件内容一定不要忘记,我当初初学的时候这个文件里老是出问题。不知道的自行百度
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0"> <display-name>blog</display-name> <!-- Spring --> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <listener> <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class> </listener> <!-- 设置编码格式为utf8 --> <filter> <filter-name>Set Character Encoding</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf8</param-value> </init-param> </filter> <filter-mapping> <filter-name>Set Character Encoding</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- Spring MVC配置 --> <servlet> <servlet-name>blog</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring-mvc.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>blog</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list></web-app>
下面开始操作。为了方便,在User类中我仅仅用了id,userName,password三个字段,代码如下
package com.blog.vo;import java.io.Serializable;public class User implements Serializable { private Integer id; private String userName; private String password; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; }}
在设计Page的时候,为了简便,我也只使用了三个字段。首先我考虑到数据库中的查询是:select * from table_name limit start_number,size;所以我只需要开始查询的起始条数start_number和每次查询显示的条数size,准确的来说我用到了两个。里面的skip字段表示需要跳过的条数
package com.blog.vo;import java.io.Serializable;public class Page implements Serializable { /** * @author libo * */ private static final long serialVersionUID = 1L; private int pageSize; //每页显示的条数 private Integer skip;//跳过的条数,也就是起始数 private String orderByClause;//排序字段 public int getPageSize() { return pageSize; } public void setPageSize(int pageSize) { this.pageSize = pageSize; } public Integer getSkip() { return skip; } public void setSkip(Integer skip) { this.skip = skip; } public String getOrderByClause() { return orderByClause; } public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; }}
UserController类包含我所要控制的操作
package com.blog.controller;import java.util.List;import java.util.Map;import org.apache.commons.collections.map.HashedMap;import org.apache.log4j.Logger;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.ResponseBody;import com.blog.service.UserService;import com.blog.vo.Page;import com.blog.vo.ResultInfoVO;import com.blog.vo.User;@SuppressWarnings("unchecked")@Controller@RequestMapping(value="user")public class UserController { private static final Logger log = Logger.getLogger(UserController.class); @Autowired private UserService userService;// @RequestMapping(value="/list",method=RequestMethod.GET)// @ResponseBody// public ResultInfoVO getAllList(){// log.info("Enter method getAllList ");// int result = 1;// String message = "";// ResultInfoVO vo = new ResultInfoVO();// List<User> users = userService.getAllUsers();// if(users!=null){// vo.setObject(users);// message = "成功!";// result = 0;// }// vo.setResult(result);// vo.setRtnMessage(message);// return vo;// }// @RequestMapping(value="/initIsZero",method=RequestMethod.POST) @ResponseBody public ResultInfoVO initIsZero(Integer indexPage,Integer pageSize){ log.info("Enter method initIsZero "); ResultInfoVO vo = new ResultInfoVO(); int count = userService.getUserCount(); Page page = new Page(); int result = -1; String rtnMessage = ""; page.setSkip(indexPage*pageSize); //设置跳过的条数 page.setPageSize(pageSize); //设置要显示多少条数据,可在前端页面中更改 List<User> users = userService.getPageZero(page); Map<String,Object> map = new HashedMap(); if(users!=null){ map.put("users", users); map.put("count",count); result=0; rtnMessage = "OK"; } vo.setObject(map); vo.setRtnMessage(rtnMessage); vo.setResult(result); return vo; } @RequestMapping(value="/indexPageNotZero",method=RequestMethod.POST) @ResponseBody public ResultInfoVO indexPageNotZero(Integer indexPage,Integer pageSize){ log.info("Enter method initIsZero "); ResultInfoVO vo = new ResultInfoVO(); Page page = new Page(); int result = -1; String rtnMessage = ""; page.setSkip(indexPage*pageSize); //设置跳过的条数 page.setPageSize(pageSize); //设置要显示多少条数据,可在前端页面中更改 List<User> users = userService.getPageZero(page); Map<String,Object> map = new HashedMap(); if(users!=null){ result = 0; rtnMessage = "OK"; map.put("users", users); } vo.setObject(map); System.out.println(map.get("users").toString()); vo.setResult(result); vo.setRtnMessage(rtnMessage); return vo; }}
接下来实现方法以及使用的接口
package com.blog.service.impl;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.blog.mapper.UserMapper;import com.blog.service.UserService;import com.blog.vo.Page;import com.blog.vo.User;@Servicepublic class UserServiceImpl implements UserService { @Autowired private UserMapper userMapper; @Override public List<User> getAllUsers() { return userMapper.getAllUsers(); } @Override public List<User> getPageZero(Page page) { return userMapper.getPageZero(page); } @Override public int getUserCount() { return userMapper.getAllUserCount(); }}
接口定义
package com.blog.service;import java.util.List;import com.blog.vo.Page;import com.blog.vo.User;public interface UserService { List<User> getAllUsers(); List<User> getPageZero(Page page); int getUserCount();}
UserMapper接口文件
package com.blog.mapper;import java.util.List;import com.blog.vo.Page;import com.blog.vo.User;public interface UserMapper { //获取所有用户 List<User> getAllUsers(); //分页查询数据 //获取该对象的所有数 int getAllUserCount(); //获取数据的条数 List<User> getPageZero(Page page);}
接口定义的方法和UserMapper.xml文件内容对应
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" ><mapper namespace="com.blog.mapper.UserMapper" > <!-- <resultMap type="BaseResultMap" id="com.blog.vo.User"> <id column="id" property="id" jdbcType="INTEGER" /> <result column="username" property="userName" jdbcType="VARCHAR" /> <result column="passowrd" property="password" jdbcType="VARCHAR" /> </resultMap> --> <!-- 获取所有用户 --> <select id="getAllUsers" resultType="User"> select username,password from user </select> <select id="getAllUserCount" resultType="java.lang.Integer"> select count(*) from user </select> <select id="getPageZero" resultType="User" parameterType="com.blog.vo.Page"> select * from user limit #{skip},#{pageSize} </select></mapper>
接下来到前端页面
目录结构如下:
其中的pagination.css和jquery.pagination.js是一个分页插件,很小。最后我会把项目放进来。
在index.jsp页面中内容如下:
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%><%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%><%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt_rt"%><% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";%><html><head><%-- <%@ include file="..common/common.jsp"%> --%> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>myblog</title> <head> <link rel="stylesheet" href="<%=basePath%>resource/css/pagination.css" /> <script type="text/javascript" src="<%=basePath%>resource/js/jquery-2.1.4.min.js"></script> <script type="text/javascript" src="<%=basePath%>resource/js/jquery.pagination.js"></script> <style type="text/css"> body{ height:100%; width:100%; } #page{ padding-left:45%; } #Pagination{ font-size: 12px; letter-spacing: 4px; padding-left:550px; margin-top:20px; } </style> </head><body> <div id="page"> <h4>我的分页操作</h2> <table> <thead> <tr> <th>姓名</th> <th>密码</th> </tr> </thead> <tbody id="showUser"> </tbody> </table> </div> <div id="Pagination"> </div></body> <script type="text/javascript"> var pageIndex = 0; //页面索引初始值 var pageSize = 6; //每页显示条数初始化,修改显示条数,修改这里即可 $(document).ready(function(){ searchRecords(0); }); function searchRecords(indexPage){ var url = ""; if(indexPage==0){ url='<%=basePath%>user/initIsZero'; }else{ url='<%=basePath%>user/indexPageNotZero'; } $.ajax({ url:url, type:"POST", data:"indexPage="+indexPage+"&pageSize="+pageSize, dataType:'json', async: false, success:function(data){ if(data.result==0){ if(indexPage==0){ initPage(data.object.count); } initContext(data.object.users); } }, error:function(data){ alert(data.rtnMessage); } }); } function initContext(array){ var html = ''; if(array!=null){ for(i in array){ html += '<tr>'; html += '<td>'+array[i].userName+'</td>'; html += '<td>'+array[i].password+'</td>'; html += '</tr>'; } $("#showUser").html(html); }else{ $("#showUser").html(''); } } //分页操作,传入记录的总条数 function initPage(total){ $("#Pagination").pagination(total,{ callback: PageCallback, //PageCallback() 为翻页调用次函数。 prev_text: "上一页", next_text: "下一页", items_per_page:pageSize, num_edge_entries: 2, //两侧首尾分页条目数 num_display_entries: 6, //连续分页主体部分分页条目数 current_page: pageIndex, //当前页索引 }); } //翻页调用 function PageCallback(index, jq) { searchRecords(index); } </script></html>
最后整体内容就是这样子。加入后运行效果如下:
写博客之前有很多话要说,最想把自己在整个过程中遇到的问题通通说出来,但是真正写代码的时候发现无话可说,很难受,想吐又吐不出来,最后也只有希望小伙伴们给我多多提意见,我会把我在这个过程中遇到的问题释疑,确实不知道需要讲什么,再接再厉。
最后附代码地址:http://download.csdn.net/detail/qq_25050981/9919437
- SSM(Spring,springmvc,mybatis)+maven+AJAX实现分页功能
- Maven+Mybatis+Spring+SpringMVC实现分页
- spring+SpringMVC+Maven+Mybatis+Mysql分页实现
- MyBatis+SpringMVC+Spring 实现分页功能
- Maven+Mybatis+Spring+SpringMVC实现分页查询(附源码)
- Maven+Mybatis+Spring+SpringMVC实现分页查询(附源码)
- Maven+Mybatis+Spring+SpringMVC实现分页查询(附源码)
- Maven+Mybatis+Spring+SpringMVC实现分页查询(附源码)
- SpringMVC Spring Mybatis Maven 实现登录功能
- Maven整合SSM(Maven+springmvc+spring+mybatis)
- 使用maven,实现ssm(spring+springmvc+mybatis)三大框架的整合DEMO
- SSM框架整合(IntelliJ IDEA + maven + Spring + SpringMVC + MyBatis)
- maven工程建立和SSM(springMVC+spring+mybatis)整合
- Eclipse下使用Maven整合SSM(spring springmvc mybatis)
- SSM框架整合(IntelliJ IDEA + maven + Spring + SpringMVC + MyBatis)
- Maven+ssm(spring、springmvc、mybatis)开发Web应用
- MyEclipse+Maven创建SSM(springMVC+spring+mybatis)项目
- 基于Maven的SSM框架整合(Spring+SpringMVC+MyBatis)
- 【HDU1856】More is better(并查集)
- 3505: [Cqoi2014]数三角形
- WebGIS学习(四)WebGIS中通过行列号来换算出多种瓦片的URL 之离线地图
- 2465: [中山市选2009]小球
- 歌曲管理系统
- SSM(Spring,springmvc,mybatis)+maven+AJAX实现分页功能
- 2306: [Ctsc2011]幸福路径
- 设计模式之建造者模式
- 2659: [Beijing wc2012]算不出的算式
- [机器学习入门] 李宏毅机器学习笔记-35(Ensemble part 1;集成方法 part 1)
- POJ 3342 Party at Hali-Bula(树形DP)
- 2150: 部落战争
- 图形学数学基础之Hammersley采样
- tabs切换的实现方式