学习SSM框架时，使用pagehelper插件时遇到的问题

Myth丶恋晨 2022-01-28 20:35 352阅读 0赞

# 模拟获取页码各类信息问题 #

## 先上模拟获取页码信息代码图： ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1h4OTQzNw_size_16_color_FFFFFF_t_70]

## 运行之后： ##

`代码报错如下：`.

org.springframework.web.util.NestedServletException: Handler dispatch failed; nested exception is java.lang.AbstractMethodError: Method com/mchange/v2/c3p0/impl/NewProxyResultSet.isClosed()Z is abstract
    
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1006)
    	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
    	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
    	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:866)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:686)
    	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
    	at org.springframework.test.web.servlet.TestDispatcherServlet.service(TestDispatcherServlet.java:71)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:791)
    	at org.springframework.mock.web.MockFilterChain$ServletFilterProxy.doFilter(MockFilterChain.java:166)
    	at org.springframework.mock.web.MockFilterChain.doFilter(MockFilterChain.java:133)
    	at org.springframework.test.web.servlet.MockMvc.perform(MockMvc.java:182)

`问题出在c3p0版本问题，只要将pom.xml中的依赖设置改一下即可，将c3p0换成如下版本：`

<dependency>
    		    <groupId>com.mchange</groupId>
    		    <artifactId>c3p0</artifactId>
    		    <version>0.9.5.2</version>
    		</dependency>

## 改掉之后再运行 ##

###### `运行成功`![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1h4OTQzNw_size_16_color_FFFFFF_t_70 1] ######

`上述报错原因可能阐述的不够清楚，但问题已得到解决！`

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1h4OTQzNw_size_16_color_FFFFFF_t_70]: /images/20220129/1c7f51fae01d4750a746728fd70532d0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1h4OTQzNw_size_16_color_FFFFFF_t_70 1]: /images/20220129/0b2ad069b66a4ec18494af5c159f484a.png