67,513
社区成员
发帖
与我相关
我的任务
分享
<context:annotation-config />
<aop:aspectj-autoproxy proxy-target-class="true"/>
<context:component-scan base-package="com.oa">
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" />
</context:component-scan>
<!-- 给web使用的spring文件 -->
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath:dbconfig.properties</value>
</list>
</property>
</bean>
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
init-method="init" destroy-method="close">
<property name="url"
value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
<property name="driverClassName" value="${driverClassName}"/>
<property name="filters" value="${filters}"/>
<property name="maxActive" value="${maxActive}"/>
<property name="initialSize" value="${initialSize}"/>
<property name="maxWait" value="${maxWait}"/>
<property name="minIdle" value="${minIdle}"/>
<property name="timeBetweenEvictionRunsMillis" value="${timeBetweenEvictionRunsMillis}"/>
<property name="minEvictableIdleTimeMillis" value="${minEvictableIdleTimeMillis}"/>
<property name="validationQuery" value="${validationQuery}"/>
<property name="testWhileIdle" value="${testWhileIdle}"/>
<property name="testOnBorrow" value="${testOnBorrow}"/>
<property name="testOnReturn" value="${testOnReturn}"/>
<property name="maxOpenPreparedStatements" value="${maxOpenPreparedStatements}"/>
<property name="removeAbandoned" value="${removeAbandoned}"/>
<!-- 打开removeAbandoned功能 -->
<property name="removeAbandonedTimeout" value="${removeAbandonedTimeout}"/>
<!-- 1800秒,也就是30分钟 -->
<property name="logAbandoned" value="${logAbandoned}"/>
<!-- 关闭abanded连接时输出错误日志 -->
<property name="defaultAutoCommit" value="${autoCommit}"></property>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="configLocation">
<value>classpath:mybatisConfig.xml</value>
</property>
<property name="mapperLocations" value="classpath*:mappers/*.xml"/>
<property name="dataSource">
<ref bean="dataSource" />
</property>
</bean>
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="sqlSessionFactory" />
<constructor-arg index="1" value="BATCH"></constructor-arg>
</bean>
<bean id="userDao" class="com.oa.dao.impl.SysUserBaseDaoImpl">
</bean>
<bean id="userServiceImpl" class="com.oa.service.impl.SysUserBaseService">
</bean>
<!-- 事务管理器 -->
<bean id="txManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 开启事务支持 -->
<tx:annotation-driven transaction-manager="txManager"/>
@Override
public List<SysUserBase> select(HashMap<String, Object> map) {
List<SysUserBase> lst=sqlSession.selectList("com.oa.mapper.ext.SysUserBaseMapper.selectByMap",map);
log.info("查询结果"+ JSONObject.toJSONString(lst));
return lst;
}
2014-10-28 22:40:23 DEBUG: Committing JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4e453182]
2014-10-28 22:40:23 DEBUG: Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@591e356b]
2014-10-28 22:40:23 DEBUG: Returning JDBC Connection to DataSource
2014-10-28 22:40:23 INFO : 查询结果
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>