spring整合mybatis时,MYSQL的版本是8.0,
测试连接数据库一直提示“Coule not create connection to database server”,
@Test
public void test1() throws SQLException {
ApplicationContext ac=new ClassPathXmlApplicationContext("spring-mybatis.xml");
DataSource ds=ac.getBean("dbcp",DataSource.class);
Connection con=ds.getConnection();
System.out.println(con);
con.close();
}
检查配置文件:
MySQL8.0版本需要更换驱动为“com.mysql.cj.jdbc.Driver
<!-- 配置DataSource 连接Mysql数据库 -->
<bean name="dbcp"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/***"></property>
<property name="username" value="root"></property>
<property name="password" value="123456789"></property>
</bean>
再次尝试连接!完成