Spring复习日志--spring中的jdbc

xml的配置

<!--c3p0的配置-->
 <bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="com.mysql.cj.jdbc.Driver"/>
        <property name="jdbcUrl"
                  value="jdbc:mysql://127.0.0.1:3306/lk?serverTimezone=UTC&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
        <property name="user" value="root"/>
        <property name="password" value="12345678"/>
        <property name="initialPoolSize" value="20"/>
        <property name="maxPoolSize" value="50"/>
        <property name="minPoolSize" value="20"></property>
        <property name="maxStatements" value="100"></property>
    </bean>
    <bean name="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>
   
    <!-- 使用Spring自带的DriverManagerDataSource -->
	<bean name="dataSource_1"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName"
			value="com.mysql.jdbc.Driver"></property