springMVC分页显示

1，创建工程，配置pom.xml文件。

pom.xml代码：

<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.zxq</groupId>  <artifactId>ssssss</artifactId>  <packaging>war</packaging>  <version>0.0.1-SNAPSHOT</version>  <name>ssssss Maven Webapp</name>  <url>http://maven.apache.org</url>  <dependencies>    <dependency>      <groupId>junit</groupId>      <artifactId>junit</artifactId>      <version>3.8.1</version>      <scope>test</scope>    </dependency>    <dependency>      <groupId>junit</groupId>      <artifactId>junit</artifactId>      <version>3.8.1 </version>      <scope>test</scope>    </dependency>    <dependency>              <groupId>org.springframework</groupId>              <artifactId>spring-context</artifactId>              <version>3.2.4.RELEASE</version>              <type>jar</type>          </dependency>          <dependency>              <groupId>org.springframework</groupId>              <artifactId>spring-core</artifactId>              <version>3.2.4.RELEASE</version>              <type>jar</type>          </dependency>          <dependency>              <groupId>org.springframework</groupId>              <artifactId>spring-beans</artifactId>              <version>3.2.4.RELEASE</version>              <type>jar</type>          </dependency>          <dependency>              <groupId>org.springframework</groupId>              <artifactId>spring-webmvc</artifactId>              <version>3.2.4.RELEASE</version>              <type>jar</type>          </dependency>          <dependency>              <groupId>org.springframework</groupId>              <artifactId>spring-orm</artifactId>              <version>3.2.4.RELEASE</version>              <type>jar</type>          </dependency>          <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver --><dependency>    <groupId>org.aspectj</groupId>    <artifactId>aspectjweaver</artifactId>    <version>1.7.1</version></dependency>        <!-- hibernate需要的jar包 -->          <dependency>              <groupId>org.hibernate</groupId>              <artifactId>hibernate-validator</artifactId>              <version>5.1.3.Final</version>          </dependency>          <dependency>              <groupId>org.hibernate</groupId>              <artifactId>hibernate-core</artifactId>              <version>4.2.16.Final</version>              <type>jar</type>          </dependency>          <!-- hibernate ehcache需要的jar包 -->          <dependency>              <groupId>org.hibernate</groupId>              <artifactId>hibernate-ehcache</artifactId>              <version>4.3.8.Final</version>          </dependency>          <!-- 连接MySQL数据库需要的jar包 -->          <dependency>              <groupId>mysql</groupId>              <artifactId>mysql-connector-java</artifactId>              <version>5.1.34</version>          </dependency>          <!-- dbcp连接池需要的jar包 -->          <dependency>              <groupId>commons-dbcp</groupId>              <artifactId>commons-dbcp</artifactId>              <version>1.4</version>          </dependency>          <!-- jstl需要的jar包 -->          <dependency>              <groupId>jstl</groupId>              <artifactId>jstl</artifactId>              <version>1.2</version>          </dependency>          <!-- log4j需要的jar包 -->          <dependency>              <groupId>log4j</groupId>              <artifactId>log4j</artifactId>              <version>1.2.17</version>          </dependency>          <!-- 文件上传需要的jar包 -->          <dependency>              <groupId>commons-fileupload</groupId>              <artifactId>commons-fileupload</artifactId>              <version>1.2.1</version>          </dependency>          <dependency>              <groupId>commons-io</groupId>              <artifactId>commons-io</artifactId>              <version>1.4</version>          </dependency>          <!-- 单元测试需要的jar包 -->          <dependency>              <groupId>junit</groupId>              <artifactId>junit</artifactId>              <version>3.8.1</version>              <scope>test</scope>          </dependency>          <dependency>              <groupId>javax.servlet.jsp</groupId>              <artifactId>jsp-api</artifactId>              <version>2.2</version>              <type>jar</type>          </dependency>          <dependency>          <groupId>javax.servlet</groupId>            <artifactId>javax.servlet-api</artifactId>            <version>3.0.1</version>            <scope>provided</scope>        </dependency>        <dependency>              <groupId>javax.validation</groupId>              <artifactId>validation-api</artifactId>              <version>1.1.0.Final</version>          </dependency>          <dependency>              <groupId>org.apache.ant</groupId>              <artifactId>ant</artifactId>              <version>1.7.0</version>          </dependency>  </dependencies>  <build>    <finalName>ssssss</finalName>  </build></project>

2，创建MVC常用包

3，配置web.xml文件和ssssss-servlet.xml文件。

web.xml代码：

<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"           xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee                             http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"           version="3.1">     <display-name>Archetype Created Web Application</display-name>    <context-param>        <param-name>contextConfigLocation</param-name>        <param-value>classPath:applicationContext.xml</param-value>    </context-param><!--监听  -->    <listener>        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>    </listener><!--utf8  --><filter>          <filter-name>characterEncodingFilter</filter-name>          <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>          <init-param>              <param-name>encoding</param-name>              <param-value>UTF-8</param-value>          </init-param>          <init-param>              <param-name>forceEncoding</param-name>              <param-value>true</param-value>          </init-param>      </filter>      <filter-mapping>          <filter-name>characterEncodingFilter</filter-name>          <url-pattern>/*</url-pattern>      </filter-mapping><!--service  -->    <servlet>        <servlet-name>ssssss</servlet-name>        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>    </servlet>    <servlet-mapping>        <servlet-name>ssssss</servlet-name>        <url-pattern>*.html</url-pattern>    </servlet-mapping></web-app>

ssssss-servlet.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: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-3.1.xsd      http://www.springframework.org/schema/context      http://www.springframework.org/schema/context/spring-context-3.1.xsd">    <context:component-scan base-package="com.zxq.web"></context:component-scan><!--视图解析  -->    <bean id="jspViewResolver"        class="org.springframework.web.servlet.view.InternalResourceViewResolver">        <property name="prefix" value="/WEB-INF/jsp/"></property>        <property name="suffix" value=".jsp"></property>    </bean></beans>

4，配置核心文件applicationContext.xml

applicationContext.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:xsi="http://www.w3.org/2001/XMLSchema-instance" 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:util="http://www.springframework.org/schema/util" xmlns:jdbc="http://www.springframework.org/schema/jdbc"      xmlns:cache="http://www.springframework.org/schema/cache"      xsi:schemaLocation="      http://www.springframework.org/schema/context      http://www.springframework.org/schema/context/spring-context.xsd      http://www.springframework.org/schema/beans      http://www.springframework.org/schema/beans/spring-beans.xsd      http://www.springframework.org/schema/tx      http://www.springframework.org/schema/tx/spring-tx.xsd      http://www.springframework.org/schema/jdbc      http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd      http://www.springframework.org/schema/cache      http://www.springframework.org/schema/cache/spring-cache-3.1.xsd      http://www.springframework.org/schema/aop      http://www.springframework.org/schema/aop/spring-aop.xsd      http://www.springframework.org/schema/util      http://www.springframework.org/schema/util/spring-util.xsd"><!--扫描包  -->    <context:component-scan base-package="com.zxq.dao"></context:component-scan>    <context:component-scan base-package="com.zxq.server"></context:component-scan><!--jdbc  -->    <bean id ="dataSource" class="org.apache.commons.dbcp.BasicDataSource"            destroy-method="close"            p:driverClassName="com.mysql.jdbc.Driver"            p:url="jdbc:mysql://localhost:3306/test"            p:username="root"            p:password="root"></bean>    <bean id ="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"            p:dataSource-ref="dataSource" />    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"            p:dataSource-ref="dataSource" /></beans>

5,MVC框架基本配置好，开始在相应包中创建类。

Student.java代码：

package com.zxq.domin;public class Student {    private String s;    private String sname;    private String sage;    private String ssex;    public String getS() {        return s;    }    public void setS(String s) {        this.s = s;    }    public String getSname() {        return sname;    }    public void setSname(String sname) {        this.sname = sname;    }    public String getSage() {        return sage;    }    public void setSage(String sage) {        this.sage = sage;    }    public String getSsex() {        return ssex;    }    public void setSsex(String ssex) {        this.ssex = ssex;    }}

StudentDao.java代码：

package com.zxq.dao;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.RowCallbackHandler;import org.springframework.stereotype.Repository;import com.zxq.domin.Student;@Repositorypublic class StudentDao {@Autowired    private JdbcTemplate jdbcTemplate;public List<Student> findTestById(int page1){    final List<Student> list = new ArrayList<Student>();    int pageSize = 3;    int pageCount = 0;    int count;    //String sql1 = "SELECT COUNT(*) as c FROM student";    count= jdbcTemplate.queryForInt("select count(*) from student");        if(count%pageSize == 0){            pageCount = count/pageSize;         }else{            pageCount = count/pageSize+1;         }        if(page1 >= pageCount){            page1 = pageCount;        }    String sql = "select * from student limit "+(page1-1)*pageSize+","+pageSize;    jdbcTemplate.query(sql,new Object[]{},new RowCallbackHandler() {        public void processRow(ResultSet rs) throws SQLException {            Student student = new Student();            student.setS(rs.getString("S"));            student.setSage(rs.getString("Sage"));            student.setSname(rs.getString("Sname"));            student.setSsex(rs.getString("Ssex"));            list.add(student);        }    });    return list;}}

Sserver.java代码，（这个类名字应该是StudentServlet.java 当时我创建时没有注意随便写了一下，不影响！！！）

package com.zxq.server;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.zxq.dao.StudentDao;import com.zxq.domin.Student;@Servicepublic class SsServer {@Autowiredprivate StudentDao studentDao;public List<Student> findTestById(int page1){    return studentDao.findTestById(page1);}}

SsCotoller.java代码（这个名字也应该是StudentCotoller.java）

package com.zxq.web;import java.util.List;import javax.servlet.http.HttpServletRequest;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.servlet.ModelAndView;import com.zxq.domin.Student;import com.zxq.server.SsServer;@Controller@RequestMapping(value="/www")public class SsCotoller {    @Autowired    private SsServer ssServer;@RequestMapping(value="/hello")    public ModelAndView hello(){    ModelAndView mav = new ModelAndView("hello");    mav.setViewName("hello");    mav.addObject("list" ,"aaa");    return mav;    }    @RequestMapping(value="/homePage")    public ModelAndView findTest(HttpServletRequest request){        String pagestr = request.getParameter("page1");        int page1=1;        if(pagestr != null){            page1 = Integer.parseInt(pagestr);        }        if(page1<1){            page1=1;        }        ModelAndView mav = new ModelAndView("homePage");        mav.setViewName("homePage");        List<Student> list = ssServer.findTestById(page1);        mav.addObject("list",list);        mav.addObject("page1", page1);        return mav;    }//  @RequestMapping(value="/home")//  public ModelAndView home(){//      ModelAndView mv = new ModelAndView("homePage");//      mv.setViewName("homePage");//      mv.addObject("page",page1);//      return mv;//  }}

6,剩下就是jsp显示页面了，在WEB-INF下创建jsp包，在jsp中创建homePage.jsp

homPage.jsp代码：

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body>    <table>    <c:forEach var="s" items="${list}">        <tr>            <td>${s.s}</td>            <td>${s.sname}</td>            <td>${s.sage}</td>            <td>${s.ssex}</td>        </tr>    </c:forEach>    </table>    <a href="homePage.html?page1=${page1-1}">上一页</a>    <a href="homePage.html?page1=${page1+1}">下一页</a></body></html>

测试显示结果