-------1------config.properties-----------------
driverClassName=com.mysql.jdbc.Driver
validationQuery=SELECT 1
jdbc_url=jdbc:mysql://localhost:3306/test?characterEncoding=utf8
jdbc_username=root
jdbc_password=root
-------2------config.properties-----------------
<!-- 引入属性文件 -->
<context:property-placeholder location="classpath:config.properties" />
-------3-----config.properties-----------------
<!-- 配置数据源 -->
<bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="url" value="${jdbc_url}" />
<property name="username" value="${jdbc_username}" />
<property name="password" value="${jdbc_password}" />
---------------------------------------------------------------------------------------------------------------------------------------------------
<!-- 需要将applicationContext-bean.xml导入,否则不能够解析到Controller -->
<import resource="applicationContext.xml" />
---------------------------------------------------------------------------------------------------------------------------------------------------
<!-- service包(自动注入) --><context:component-scan base-package="com.soft.service" />
---------------------------------------------------------------------------------------------------------------------------------------------------
<!-- 依赖注入 -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="baseDao" class="com.engc.newwmb.dao.impl.BaseDaoImpl">
<property name="jt" ref="jdbcTemplate"></property>
<property name="dataSource" ref="dataSource"></property>
</bean>
<bean id="baseService" class="com.engc.newwmb.service.impl.BaseServiceImpl">
<property name="baseDao" ref="baseDao" />
</bean>
---------------------------------------------------------------------------------------------------------------------------------------------------
<!--calss注入,及class属性赋值 -->
<bean id="captchaProducer" class="com.google.code.kaptcha.impl.DefaultKaptcha">
<property name="config">
<bean class="com.google.code.kaptcha.util.Config">
<constructor-arg>
<props>
<prop key="kaptcha.border">no</prop>
<prop key="kaptcha.border.color">105,179,90</prop>
<prop key="kaptcha.textproducer.font.color">red</prop>
<prop key="kaptcha.image.width">250</prop>
<prop key="kaptcha.textproducer.font.size">90</prop>
<prop key="kaptcha.image.height">90</prop>
<prop key="kaptcha.session.key">code</prop>
<prop key="kaptcha.textproducer.char.length">4</prop>
<prop key="kaptcha.textproducer.font.names">宋体,楷体,微软雅黑</prop>
</props>
</constructor-arg>
</bean>
</property>
</bean>
-------------------------------------
<bean id="myDataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource" >
<property name="driverClassName">
<!-- sqlserver -->
<!-- <value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value> -->
<!-- mysql -->
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<!-- sqlserver -->
<!-- <value>jdbc:sqlserver://192.168.100.121:1433;DatabaseName=db_softproject</value> -->
<!-- mysql -->
<value>jdbc:mysql://192.168.100.121:3306/jhtdd?useUnicode=true&characterEncoding=UTF-8</value>
<!-- <value>jdbc:mysql://localhost:3306/jhtdd?useUnicode=true&characterEncoding=UTF-8</value> -->
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>root</value>
</property>
<property name="initialSize">
<value>2</value>
</property>
<property name="maxActive">
<value>20</value>
</property>
</bean>
---------------------------------------------------------------------------------------------------------------------------------------------------