项目场景：

用spring连接数据库

---

问题描述：

配置文件中&报错

<bean id="datasource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="com.mysql.cj.jdbc.Driver"></property> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true"></property> <property name="user" value="root"></property> <property name="password" value="root"></property> </bean> //测试spring容器产生数据源对象 @Test public void test4() throws SQLException, PropertyVetoException { ApplicationContext app=new ClassPathXmlApplicationContext("applicationContext.xml"); DataSource dataSource = app.getBean(DataSource.class); Connection connection=dataSource.getConnection(); System.out.println(connection); connection.close(); }

---

原因分析：

&符号在xml不能被解析，

---

解决方案：

把每一个&改成&运行成功

<bean id="datasource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="com.mysql.cj.jdbc.Driver"></property> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test?characterEncoding=utf8&amp;useSSL=false&amp;serverTimezone=UTC&amp;rewriteBatchedStatements=true"></property> <property name="user" value="root"></property> <property name="password" value="root"></property> </bean>