利用spring将mybatils集成，从而减少代码

梦里梦外; 2024-03-24 21:31 65阅读 0赞

**目录**

一.spring和mybatis集成

A.为什么要进行整合？

B.项目整合

1.导入.pom.xml 依赖

2.配置XML文件

C.测试

1.根据数据库表格生成对应的实体 ，mapper接口 ,mapper文件

2.测试类标记为spring测试类：每一个测试方法都会加载spring上下文

二. spring aop集成poageHelper

1.在mapper.xml构建一个分页查询的方法

2.在mapper实现接口,并且在bookbiz同样实现接口,并且调用此方法

3.建立一个包用于切面的aspect实现，建一个用于工具类的保存

4.测试方法

--------------------

## 一.spring和mybatis集成 ##

### A.为什么要进行整合？ ###

1.mybatis中的测试 :**测试biz业务接口中mapper是从sqlsesson获取  
通过**

sqlSession = SessionUtil.openSession();
            //从session对象中获取mapper对象
            BookMapper mapper = sqlSession.getMapper(BookMapper.class);

2.mybatis事物管理:**sqlsesson本身以及增加，删除，修改 交给 spring 进行项目整合**

3.**并且在通过这种方法进行代码编写时会出现，很多问题比如说代码重复性多，在对于某一个模块进行修改时，在有相识代码的情况下要进行大规模的修改，耗时耗力！**

###    B.项目整合 ###

#### 1.导入.pom.xml 依赖 ####

> **spring mybatis logger mysql  
> mybatis-spring :(**
> 
> 1.通过注解扫描所有javabean ，将所有组件加载到spring上下文
> 
> 2.配置数据源
> 
> 3.配置session连接工厂
> 
> 4.扫描mapper接口
> 
> 5.配置事物管理器
> 
> 6配置 自动aop代理
> 
> 7.配置 spring-test.xml
> 
> **)**
> 
> 加粗的字体插件

将pom.xml 替换原有的内容**从 propoetis 到 dependencies**

<properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
        <maven.compiler.plugin.version>3.7.0</maven.compiler.plugin.version>
    
        
        
        <spring.version>5.0.2.RELEASE</spring.version>
        
        <mybatis.version>3.4.5</mybatis.version>
        
        <mysql.version>5.1.44</mysql.version>
        
        <pagehelper.version>5.1.2</pagehelper.version>
        
        <mybatis.spring.version>1.3.1</mybatis.spring.version>
        
        <commons.dbcp2.version>2.1.1</commons.dbcp2.version>
        <commons.pool2.version>2.4.3</commons.pool2.version>
        
        <log4j2.version>2.9.1</log4j2.version>
        
        <junit.version>4.12</junit.version>
        <servlet.version>4.0.0</servlet.version>
        <lombok.version>1.18.2</lombok.version>
    </properties>
    
    
    <dependencies>
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</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-aspects</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-test</artifactId>
            <version>${spring.version}</version>
        </dependency>
    
        
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>${mybatis.version}</version>
        </dependency>
        
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql.version}</version>
        </dependency>
        
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>${pagehelper.version}</version>
        </dependency>
        
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>${mybatis.spring.version}</version>
        </dependency>
    
        
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>${commons.dbcp2.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-pool2</artifactId>
            <version>${commons.pool2.version}</version>
        </dependency>
    
        
        
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-core</artifactId>
            <version>${log4j2.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-api</artifactId>
            <version>${log4j2.version}</version>
        </dependency>
        
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-web</artifactId>
            <version>${log4j2.version}</version>
        </dependency>
    
        
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>${junit.version}</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>${servlet.version}</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>${lombok.version}</version>
            <scope>provided</scope>
        </dependency>
    
    </dependencies>

在<finalName>leran\_ssm</finalName>下面添加

<resources>
        
        <resource>
            <directory>src/main/java</directory>
            <includes>
                <include>**/*.xml</include>
            </includes>
        </resource>
        
        <resource>
            <directory>src/main/resources</directory>
            <includes>
                <include>jdbc.properties</include>
                <include>*.xml</include>
            </includes>
        </resource>
    </resources>

其次在<plugins>标签下添加插件

plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>${maven.compiler.plugin.version}</version>
        <configuration>
            <source>${maven.compiler.source}</source>
            <target>${maven.compiler.target}</target>
            <encoding>${project.build.sourceEncoding}</encoding>
        </configuration>
    </plugin>
    <plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.3.2</version>
        <dependencies>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>
        </dependencies>
        <configuration>
            <overwrite>true</overwrite>
        </configuration>
    </plugin>

####    2.配置XML文件 ####

> spring-context.xml spring-mybatis.xml generatorConfig.xml log4j2.xml jdbc.properties

在 spring-context.xml导**入 spring-mybatis.xml 的路径用于扫描所有JavaBean**

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
        
        <import resource="classpath:spring-mybatis.xml"></import>
    </beans>

在其中要注意包名，不然在运行时找不到

<?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:tx="http://www.springframework.org/schema/tx"
           xmlns:aop="http://www.springframework.org/schema/aop"
           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">
        
        
        <context:annotation-config/>
        
        <context:component-scan base-package="com.lz"/>
    
        <context:property-placeholder location="classpath:jdbc.properties"/>
    
        <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
              destroy-method="close">
            <property name="driverClassName" value="${jdbc.driver}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
            
            <property name="initialSize" value="10"/>
            
            <property name="maxTotal" value="100"/>
            
            <property name="maxIdle" value="50"/>
            
            <property name="minIdle" value="10"/>
            
            
            <property name="maxWaitMillis" value="-1"/>
        </bean>
    
        
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            
            <property name="mapperLocations" value="classpath*:com/lz/**/mapper/*.xml"/>
            
            <property name="typeAliasesPackage" value="com/lz/**/model"/>
            
            <property name="plugins">
                <array>
                    <bean class="com.github.pagehelper.PageInterceptor">
                        <property name="properties">
                            <value>
                                helperDialect=mysql
                            </value>
                        </property>
                    </bean>
                </array>
            </property>
        </bean>
    
        
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            
            <property name="basePackage" value="com/lz/**/mapper"/>
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        </bean>
    
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource" />
        </bean>
        <tx:annotation-driven transaction-manager="transactionManager" />
        <aop:aspectj-autoproxy/>
    </beans>

用于生成mapper接口，以及相对应的实体

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    <generatorConfiguration>
        
        <properties resource="jdbc.properties"/>
    
        
        <classPathEntry location="D:\\tool\\apache-maven-3.5.0-bin\\maven_jar\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
    
        
        <context id="infoGuardian">
            
            <commentGenerator>
                <property name="suppressAllComments" value="true"/>
                <property name="suppressDate" value="true"/> 
            </commentGenerator>
    
            
            <jdbcConnection driverClass="${jdbc.driver}"
                            connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
    
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            
            
            <javaModelGenerator targetPackage="com.lz.model"
                                targetProject="src/main/java">
                
                <property name="enableSubPackages" value="false"/>
                
                <property name="constructorBased" value="true"/>
                
                <property name="trimStrings" value="false"/>
                
                <property name="immutable" value="false"/>
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="com.lz.mapper"
                             targetProject="src/main/java">
                
                <property name="enableSubPackages" value="false"/>
            </sqlMapGenerator>
    
            
            
            
            
            <javaClientGenerator targetPackage="com.lz.mapper"
                                 targetProject="src/main/java" type="XMLMAPPER">
                
                <property name="enableSubPackages" value="false"/>
            </javaClientGenerator>
    
            
            
            
            
            
            
            
            
            
            
            
            
            
    
            <table schema="" tableName="t_mvc_book" domainObjectName="Book"
                   enableCountByExample="false" enableDeleteByExample="false"
                   enableSelectByExample="false" enableUpdateByExample="false">
                
                
                
                
            </table>
    
        </context>
    </generatorConfiguration>

日志文件

<?xml version="1.0" encoding="UTF-8"?>
    
    
    <Configuration status="WARN" monitorInterval="30">
    	<Properties>
    		
    		<Property name="LOG_HOME">/root/workspace/lucenedemo/logs</Property>
    		<property name="ERROR_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/error</property>
    		<property name="WARN_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/warn</property>
    		<property name="PATTERN">%d{yyyy-MM-dd HH:mm:ss.SSS} [%t-%L] %-5level %logger{36} - %msg%n</property>
    	</Properties>
    
    	<Appenders>
    		
    		<Console name="Console" target="SYSTEM_OUT">
    			
    			<ThresholdFilter level="trace" onMatch="ACCEPT"
    				onMismatch="DENY" />
    			
    			
    			<PatternLayout pattern="${PATTERN}" />
    		</Console>
    
    		
    		
    		<File name="log" fileName="logs/test.log" append="false">
    			<PatternLayout
    				pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    		</File>
    		
    		<RollingFile name="RollingFileInfo" fileName="${LOG_HOME}/info.log"
    			filePattern="${LOG_HOME}/$${date:yyyy-MM}/info-%d{yyyy-MM-dd}-%i.log">
    			
    			<ThresholdFilter level="info" onMatch="ACCEPT"
    				onMismatch="DENY" />
    			<PatternLayout
    				pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    			<Policies>
    				
    				
    				
    				<TimeBasedTriggeringPolicy interval="1"
    					modulate="true" />
    				
    				
    			</Policies>
    		</RollingFile>
    
    		<RollingFile name="RollingFileWarn" fileName="${WARN_LOG_FILE_NAME}/warn.log"
    			filePattern="${WARN_LOG_FILE_NAME}/$${date:yyyy-MM}/warn-%d{yyyy-MM-dd}-%i.log">
    			<ThresholdFilter level="warn" onMatch="ACCEPT"
    				onMismatch="DENY" />
    			<PatternLayout
    				pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    			<Policies>
    				<TimeBasedTriggeringPolicy />
    				<SizeBasedTriggeringPolicy size="2 kB" />
    			</Policies>
    			
    			<DefaultRolloverStrategy max="20" />
    		</RollingFile>
    
    		<RollingFile name="RollingFileError" fileName="${ERROR_LOG_FILE_NAME}/error.log"
    			filePattern="${ERROR_LOG_FILE_NAME}/$${date:yyyy-MM}/error-%d{yyyy-MM-dd-HH-mm}-%i.log">
    			<ThresholdFilter level="error" onMatch="ACCEPT"
    				onMismatch="DENY" />
    			<PatternLayout
    				pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    			<Policies>
    				
    				<TimeBasedTriggeringPolicy interval="1"
    					modulate="true" />
    				
    			</Policies>
    		</RollingFile>
    
    	</Appenders>
    
    	
    	<Loggers>
    		
    		<logger name="org.springframework" level="INFO"></logger>
    		<logger name="org.mybatis" level="INFO"></logger>
    
    		
    		<logger name="org.springframework" level="ERROR" />
    		<logger name="org.hibernate" level="ERROR" />
    		<logger name="org.apache.struts2" level="ERROR" />
    		<logger name="com.opensymphony.xwork2" level="ERROR" />
    		<logger name="org.jboss" level="ERROR" />
    
    
    		
    		<root level="all">
    			<appender-ref ref="Console" />
    			<appender-ref ref="RollingFileInfo" />
    			<appender-ref ref="RollingFileWarn" />
    			<appender-ref ref="RollingFileError" />
    		</root>
    
    	</Loggers>
    
    </Configuration>

数据库连接，以及数据库访问路径，密码，账号

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://47.100.191.44:3308/mybatis_ssm?useUnicode=true&characterEncoding=UTF-8
    jdbc.username=test01
    jdbc.password=test01

### C.测试 ###

#### 1.根据数据库表格生成对应的实体 ，mapper接口 ,mapper文件 ####

![8d0914e0900c49daa53531582fe231a0.png][]

> 说明一点小编，生成的mapper，以及mapper.xml将会以图片的形式展示节省时间![882642a8bcba4824b95dd1c51a02bb00.png][]
> 
> ![52eb11e4d14e4fa0a5be9e5286f4c856.png][]
> 
> ![85be618a3cbd4ae6ad5c242faa5c6901.png][]
> 
> ![2c13df5435f54ec0b14746d124d1f794.png][]

#### 2.测试类标记为spring测试类：每一个测试方法都会加载spring上下文 ####

> 其次在项目的目录构建一个包用于方法测试：其目的是为了验证环境是否搭建成功？BooBiz用来实现刚刚生成的bookmapper的接口，其次BookBizImpl 用来继承前者的方法，最后通过其实现junt来进行方法的测试，凭借此来验证spring和mybatis是否集成成功！

![35069e0faf48419694a21403478dabda.png][]

在通过一个类继承接口，调用方法

![f7e5d691b65142038f32773137cd11fb.png][]

在通过 选中bookbziimpl 通过快捷键 Alt+n 通过创建一个测试类实现方法

package com.lz.biz.impl;
    
    import com.lz.biz.BookBiz;
    import com.lz.model.Book;
    import com.lz.utils.PageBean;
    import org.junit.After;
    import org.junit.Before;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.test.context.ContextConfiguration;
    import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    
    /**
     * @author lz
     * @create 2023-08-25 15:58
     */
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration(locations={"classpath:spring-context.xml"})
    
    public class BookBizImplTest {
         @Autowired
         private BookBiz  bookBiz;
    
        @Before
        public void setUp() throws Exception {
        }
    
        @After
        public void tearDown() throws Exception {
        }
    
        @Test
        public void deleteByPrimaryKey() {
        }
    
        @Test
        public void insert() {
        }
    
        @Test
        public void insertSelective() {
        }
    
        @Test
        public void selectByPrimaryKey() {
            System.out.println(this.bookBiz.selectByPrimaryKey(25
    ));
        }
    
        @Test
        public void updateByPrimaryKeySelective() {
        }
    
        @Test
        public void updateByPrimaryKey() {
        }
       
    }

![e3258417840e486cac2c17ad5517287c.png][]

##    二. spring aop集成poageHelper ##

#### 1.在mapper.xml构建一个分页查询的方法 ####

<select id="listPage" resultType="com.lz.model.Book"  parameterType="com.lz.model.Book" >
        select
        <include refid="Base_Column_List" />
        from t_mvc_book
       <where>
      <if test="bname != null ">
        and  bname like  concat('%',#{bname},'%')
      </if>
       </where>
      </select>

#### 2.在mapper实现接口,并且在bookbiz同样实现接口,并且调用此方法 ####

List <Book> listPage(Book  book);

@Override
        public List<Book> listPage(Book book, PageBean pageBean) {
            return   bookMapper.listPage(book) ;
        }

#### 3.建立一个包用于切面的aspect实现，建一个用于工具类的保存 ####

package com.lz.aspect;
    
    import com.github.pagehelper.PageHelper;
    import com.github.pagehelper.PageInfo;
    import com.lz.utils.PageBean;
    import org.aspectj.lang.ProceedingJoinPoint;
    import org.aspectj.lang.annotation.Around;
    import org.aspectj.lang.annotation.Aspect;
    import org.springframework.stereotype.Component;
    
    import java.util.List;
    
    /**
     * @author lz
     * @create 2023-08-25 16:56
     */
    @Aspect //切面
    @Component
    public class PageAspect {
        // * :任意返回值     *..任意包
        // *Service：以service结尾的类  *Pager:以pager结尾的类
    
        @Around("execution(* *..*Biz.*Page(..))")
        public Object invoke(ProceedingJoinPoint args) throws Throwable {
            //获取目标方法的所有方法
            Object[] params = args.getArgs();
            PageBean pageBean = null;
            for (Object param : params) {
                if(param instanceof PageBean){
                    pageBean = (PageBean)param;
                    break; } }
            if(pageBean != null && pageBean.isPagination())
                PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
            //执行目标方法
            Object list = args.proceed(params);
            if(null != pageBean && pageBean.isPagination()){
                PageInfo pageInfo = new PageInfo((List) list);
                pageBean.setTotal(pageInfo.getTotal()+""); }
            return list;
        }
    
    
    
    }

> 在其中
> 
>     // * :任意返回值     *..任意包
>     // *Service：以service结尾的类  *Pager:以pager结尾的类

package com.lz.utils;
    
    import javax.servlet.http.HttpServletRequest;
    import java.io.Serializable;
    import java.util.Map;
    
    public class PageBean implements Serializable {
    
    	private static final long serialVersionUID = 2422581023658455731L;
    
    	//页码
    	private int page=1;
    	//每页显示记录数
    	private int rows=10;
    	//总记录数
    	private int total=0;
    	//是否分页
    	private boolean isPagination=true;
    	//上一次的请求路径
    	private String url;
    	//获取所有的请求参数
    	private Map<String,String[]> map;
    	
    	public PageBean() {
    		super();
    	}
    	
    	//设置请求参数
    	public void setRequest(HttpServletRequest req) {
    		String page=req.getParameter("page");
    		String rows=req.getParameter("rows");
    		String pagination=req.getParameter("pagination");
    		this.setPage(page);
    		this.setRows(rows);
    		this.setPagination(pagination);
    		this.url=req.getContextPath()+req.getServletPath();
    		this.map=req.getParameterMap();
    	}
    	public String getUrl() {
    		return url;
    	}
    
    	public void setUrl(String url) {
    		this.url = url;
    	}
    
    	public Map<String, String[]> getMap() {
    		return map;
    	}
    
    	public void setMap(Map<String, String[]> map) {
    		this.map = map;
    	}
    
    	public int getPage() {
    		return page;
    	}
    
    	public void setPage(int page) {
    		this.page = page;
    	}
    	
    	public void setPage(String page) {
    		if(null!=page&&!"".equals(page.trim()))
    			this.page = Integer.parseInt(page);
    	}
    
    	public int getRows() {
    		return rows;
    	}
    
    	public void setRows(int rows) {
    		this.rows = rows;
    	}
    	
    	public void setRows(String rows) {
    		if(null!=rows&&!"".equals(rows.trim()))
    			this.rows = Integer.parseInt(rows);
    	}
    
    	public int getTotal() {
    		return total;
    	}
    
    	public void setTotal(int total) {
    		this.total = total;
    	}
    	
    	public void setTotal(String total) {
    		this.total = Integer.parseInt(total);
    	}
    
    	public boolean isPagination() {
    		return isPagination;
    	}
    	
    	public void setPagination(boolean isPagination) {
    		this.isPagination = isPagination;
    	}
    	
    	public void setPagination(String isPagination) {
    		if(null!=isPagination&&!"".equals(isPagination.trim()))
    			this.isPagination = Boolean.parseBoolean(isPagination);
    	}
    	
    	/**
    	 * 获取分页起始标记位置
    	 * @return
    	 */
    	public int getStartIndex() {
    		//(当前页码-1)*显示记录数
    		return (this.getPage()-1)*this.rows;
    	}
    	
    	/**
    	 * 末页
    	 * @return
    	 */
    	public int getMaxPage() {
    		int totalpage=this.total/this.rows;
    		if(this.total%this.rows!=0)
    			totalpage++;
    		return totalpage;
    	}
    	
    	/**
    	 * 下一页
    	 * @return
    	 */
    	public int getNextPage() {
    		int nextPage=this.page+1;
    		if(this.page>=this.getMaxPage())
    			nextPage=this.getMaxPage();
    		return nextPage;
    	}
    	
    	/**
    	 * 上一页
    	 * @return
    	 */
    	public int getPreivousPage() {
    		int previousPage=this.page-1;
    		if(previousPage<1)
    			previousPage=1;
    		return previousPage;
    	}
    
    	@Override
    	public String toString() {
    		return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", isPagination=" + isPagination
    				+ "]";
    	}
    }

#### 4.测试方法 ####

@Test
        public void listPage() {
            Book book=new Book();
            PageBean pageBean=new PageBean();
            pageBean.setPage(2);
            pageBean.setRows(10);
            book.setBname("圣墟");
            this.bookBiz.listPage(book,pageBean).forEach(System.out::println);
    
        }

![9db0ff68b23247aabf82a624066a6bb9.png][]

[8d0914e0900c49daa53531582fe231a0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/4690fb8aef9c491196b1b2250469ec5c.png
[882642a8bcba4824b95dd1c51a02bb00.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/058427273be34212bddcd8da6a4fa32c.png
[52eb11e4d14e4fa0a5be9e5286f4c856.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/318b70cd866a432891059b3f399bb99b.png
[85be618a3cbd4ae6ad5c242faa5c6901.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/89d28557ad4b45e7954fbea88770cf43.png
[2c13df5435f54ec0b14746d124d1f794.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/be3c4f05b9194188978757fe22851aa4.png
[35069e0faf48419694a21403478dabda.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/5955ea9d415c40d6b41f874dbe2ba18e.png
[f7e5d691b65142038f32773137cd11fb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/275efd9a978240db8c1782e2676f5866.png
[e3258417840e486cac2c17ad5517287c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/dd017ee53d074223931823923ffcf8a7.png
[9db0ff68b23247aabf82a624066a6bb9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/1b414fe5f72c4e399e52899d195e6fc4.png