网上说要更新mysql-connector.jar可是在我更新之后问题还是没有解决，后来浏览国外的网站发现解决方法了
就是在spring的beans.xml中添加<property name="validationQuery" value="${db.validationQuery}" />配置即可解决问题。
具体配置如下：
beans.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="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/aop http://www.springframework.org/schema/aop/spring-aop.xsd"> <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${db.driverClassName}" /> <property name="url" value="${db.url}" /> <property name="username" value="${db.username}" /> <property name="password" value="${db.password}" /> <property name="validationQuery" value="${db.validationQuery}" /> </bean> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location" value="classpath:jdbc.properties" /> </bean> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref="dataSource"></property> </bean> <bean id="studentDao" class="cn.edu.whpu.dao.impl.StudentDaoImpl"> <property name="jdbcTemplate" ref="jdbcTemplate"></property> </bean> <bean id="studentService" class="cn.edu.whpu.service.impl.StudentServiceImpl"> <property name="studentDao" ref="studentDao"></property> </bean> </beans> jdbc.properties db.driverClassName=com.mysql.jdbc.Driver db.url=jdbc:mysql://localhost:3306/db_spring db.username=root db.password=123456 db.validationQuery=select 1