1.介绍:
分页是我们开发项目时经常使用到的一个功能，它的好处是页面美观，提高查询效率，并不是直接将所有的数据都查出，而是只查询必须的数据。
我们开发项目时一般都会使用比较方便的工具，myBatis有一个分页工具叫pageHelper，这个插件其实就是对之前大家写的那个分页逻辑的封装，使用起来更加简单，实现方式都是一样。这个插件是国内一个大牛写的现在在github上维护
大牛网址:https://github.com/pagehelper
2.使用ssm实现分页查询(用到的工具及准备))
2.1开发工具:eclipse
2.2使用技术:Spring，SpringMVC，myBatis，mysql，maven
2.3开发环境:需要JDK，maven，mysql数据
3.实现思路:
3.1创建表(随便建一个简单的表)
3.2建一个maven项目(我使用的是maven项目写的)
切换视图(这样看起来舒服)
这里会出现一个问题(没有web.xml文件)
解决方式:
3.3配置pom.xml文件
|
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<spring.version>5.1.2.RELEASE</spring.version>
</properties>
<dependencies>
<!--单元测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<!--项目打包时该包不会被打入-->
<scope>test</scope>
</dependency>
<!-- JSTL标签类 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--mysql数据库驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<!--log4j日志包 -->
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-core</artifactId>
<version>2.6.1</version>
</dependency>
<!-- mybatis ORM框架 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<!--mybatis-spring适配器 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>
<!--Spring框架核心库 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- aspectJ AOP 织入器 -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.9</version>
</dependency>
<!--Spring java数据库访问包，在本例中主要用于提供数据源 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>4.1.6</version>
</dependency>
</dependencies>
需要注意几点:
3.3.1 test单元测试完了以后一定要把test包删除,要不然启动整个项目会报错
3.3.2 看看配置文件的版本号,有时候版本号不对导进去会报错
3.4 配置web.xml文件
|
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>springDispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 配置 DispatcherServlet 的一个初始化参数：配置 SpringMVC 配置文件的位置和名称 -->
<!-- 默认的配置文件格式：/WEB-INF/<servlet-name>-servlet.xml -->
<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>springDispatcherServlet</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<!-- 读取mybatis配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mybatis.xml</param-value>
</context-param>
<!-- 编码过滤器 ,使用ctrl+shift+t搜索类-->
<filter>
<filter-name>encoding</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>
</filter>
<filter-mapping>
<filter-name>encoding</filter-name>
<url-pattern>/</url-pattern>
</filter-mapping>
|
注意几点:
3.4.1 spring监听器
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
3.4.2 springmvc核心控制器(单词小心出错)
<servlet>
<servlet-name>springDispatcherServlet</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>
3.5 配置spring-mvc.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"
xmlns:aop="http://www.springframework.org/schema/aop"
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/aop http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
<!-- 包扫描 -->
<context:component-scan base-package="com.zhiyou100.controller" />
<!-- 定义跳转的文件的前后缀 ，视图模式配置 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/" />
<property name="suffix" value=".jsp" />
</bean>
3.6 配置spring-mybatis配置文件
<?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.xsd">
<!-- 开启包扫描 -->
<context:component-scan base-package="com.zhiyou100"/>
<!-- 读取外部数据库配置文件 -->
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:db.properties" />
</bean>
<!-- 配置数据源使用dbcp数据库连接池
c3p0使用CombopooledDataSource
destroy-method：销毁时自动调用close方法
-->
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
<!-- 初始化连接大小 -->
<property name="initialSize" value="${initialSize}"></property>
<!-- 连接池最大数量 -->
<property name="maxActive" value="${maxActive}"></property>
<!-- 连接池最大空闲 -->
<property name="maxIdle" value="${maxIdle}"></property>
<!-- 连接池最小空闲 -->
<property name="minIdle" value="${minIdle}"></property>
<!-- 获取连接最大等待时间 -->
<property name="maxWait" value="${maxWait}"></property>
</bean>
<!-- session工厂 -->
<bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mapping.xml文件 -->
<property name="mapperLocations"
value="classpath:com/zhiyou100/mapping/*.xml"></property>
<!-- 配置分页插件 -->
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageHelper">
<property name="properties">
<value>
dialect=mysql
reasonable=true
</value>
</property>
</bean>
</array>
</property>
</bean>
<!-- DAO接口所在包名，Spring会自动查找其下的类，不需要写接口的实现类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.zhiyou100.mapping"/>
</bean>
<!-- 事务管理 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
</beans>
3.7 写db.properties配置文件
driver=com.mysql.jdbc.Driver
url=jdbc:mysql:///ssm(数据库名称........三条线杠表示只能在本地使用,反之写地址)
username=root
password=root
initialSize=5
maxActive=20
maxIdle=20
minIdle=1
maxWait=60000
3.8日志文件log4j.properties
好处:
log4J是为java语言量身定做的一个日志模块，用统一的接口写日志，通过配置文件信息控制日志信息的输出格式、目的及输出级别（指定输出级别后，只有比输出级别更高的日志会被输出）。可以在不更改程序输出日志的情况下方便日志输出的控制，为日志的操作提供了很大的灵活性。
### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.err
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:\mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### set log levels - for more verbose logging change 'info' to 'debug' ###
log4j.rootLogger=DEBUG, stdout
3.9 展示页面show.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>
<tbody>
<tr>
<td>员工编号</td>
<td>员工姓名</td>
<td>员工密码</td>
</tr>
<c:forEach items="${user_list }" var="user">
<tr>
<td>${user.u_id }</td>
<td>${user.u_name }</td>
<td>${user.u_pass }</td>
</tr>
</c:forEach>
</tbody>
</table>
<!-- 分页部分 -->
<p>当前${pageInfo.pageNum}/${pageInfo.pages}页</p>
<a href="query.do?page=${pageInfo.firstPage}">第一页</a>
<a href="query.do?page=${pageInfo.nextPage}">下一页</a>
<a href="query.do?page=${pageInfo.perPage}">上一页</a>
<a href="query.do?page=${pageInfo.lastPage}">最后页</a>
</body>
</html>
3.10实体类,dao层,实体类的映射文件
3.10.1 实体类
package com.zhiyou100.pojo;
public class User {
private Integer u_id;
private String u_name;
private String u_pass;
public Integer getU_id() {
return u_id;
}
public void setU_id(Integer u_id) {
this.u_id = u_id;
}
public String getU_name() {
return u_name;
}
public void setU_name(String u_name) {
this.u_name = u_name;
}
public User(Integer u_id, String u_name, String u_pass) {
super();
this.u_id = u_id;
this.u_name = u_name;
this.u_pass = u_pass;
}
public String getU_pass() {
return u_pass;
}
public void setU_pass(String u_pass) {
this.u_pass = u_pass;
}
public User() {
super();
}
@Override
public String toString() {
return "User [u_id=" + u_id + ", u_name=" + u_name + ", u_pass=" + u_pass + "]";
}
}
3.10.2 dao层
package com.zhiyou100.mapping;
import java.util.List;
import com.zhiyou100.pojo.User;
public interface IUserDao {
List<User> queryAll();
}
3.10.3 实体类的映射文件
<?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">
<!-- 如果没有实现类，namespace写dao接口的全路径 -->
<mapper namespace="com.zhiyou100.mapping.IUserDao">
<!-- 配置映射关系 -->
<resultMap type="com.zhiyou100.pojo.User" id="userMap">
<id property="u_id" column="u_id"/>
<result property="u_name" column="u_name"/>
<result property="u_pass" column="u_pass"/>
</resultMap>
<!-- 查询 -->
<select id="queryAll" resultMap="userMap">
SELECT U_ID,U_NAME,U_PASS FROM tb_user
</select>
</mapper>
3.11 service层 + imp(实现类)
3.11.1 service层
package com.zhiyou100.service;
import java.util.List;
import com.zhiyou100.pojo.User;
public interface IUserService {
List<User> queryAll();
}
3.11.2 实现类
package com.zhiyou100.service.imp;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.zhiyou100.mapping.IUserDao;
import com.zhiyou100.pojo.User;
import com.zhiyou100.service.IUserService;
@Service
public class IUserServiceImpl implements IUserService{
@Resource
private IUserDao dao;
@Override
public List<User> queryAll() {
return dao.queryAll();
}
}
这样的话一个分页模块就完成了,
页面展示
扫一扫
221
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
