package com.test.config;
import org.apache.commons.dbcp.BasicDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.log4j.Logger;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.core.env.Environment;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
@Configuration
@EnableTransactionManagement
public class DatabaseConfig {
private static final Logger logger = Logger.getLogger(DatabaseConfig.class);
@Autowired
Environment env;
@Bean
public DataSourceTransactionManager txManager() {
return new DataSourceTransactionManager(dataSource());
}
@Bean
public SqlSessionFactory sqlSessionFactory() throws Exception {
SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
sessionFactory.setDataSource(dataSource());
PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
sessionFactory.setMapperLocations(resolver.getResources("classpath:com/test/mapping/*Mapping.xml"));
return sessionFactory.getObject();
}
@Bean
public MapperScannerConfigurer scannerConfigurer(){
MapperScannerConfigurer configurer = new MapperScannerConfigurer();
configurer.setBasePackage("com.test.dao");
configurer.setSqlSessionFactoryBeanName("sqlSessionFactory");
return configurer;
}
@Bean(name = "dataSource")
public BasicDataSource dataSource() {
logger.info("DataSource");
BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&autoReconnect=true&failOverReadOnly=false");
dataSource.setUsername("root");
dataSource.setPassword("root");
dataSource.setInitialSize(0);
dataSource.setMaxActive(20);
dataSource.setMaxIdle(20);
dataSource.setMinIdle(1);
dataSource.setMaxWait(60000);
return dataSource;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
spring-redis.zip (41个子文件)
spring-redis
.project 2KB
.mymetadata 317B
src
test
resources
java
com
service
TestService.java 1KB
base
SpringTestCase.java 482B
main
webapp
WEB-INF
classes
lib
META-INF
MANIFEST.MF 39B
resources
log4j.properties 1KB
t_user.sql 637B
java
com
test
service
impl
UserServiceImpl.java 1KB
UserService.java 272B
model
User.java 1KB
controller
dao
UserDao.java 213B
config
DatabaseConfig.java 3KB
RootConfig.java 246B
CacheConfig.java 2KB
mapping
UserDaoMapping.xml 735B
target
m2e-jee
web-resources
META-INF
MANIFEST.MF 102B
maven
com.test
spring-redis
pom.properties 245B
pom.xml 3KB
classes
com
test
service
UserService.class 346B
impl
UserServiceImpl.class 2KB
model
User.class 2KB
controller
dao
UserDao.class 234B
config
CacheConfig.class 3KB
RootConfig.class 479B
DatabaseConfig.class 3KB
CacheConfig$1.class 1KB
mapping
UserDaoMapping.xml 735B
log4j.properties 1KB
t_user.sql 637B
test-classes
com
service
TestService.class 2KB
base
SpringTestCase.class 602B
.settings
org.eclipse.wst.jsdt.ui.superType.container 49B
org.eclipse.wst.common.project.facet.core.xml 252B
org.eclipse.m2e.core.prefs 90B
org.eclipse.jdt.core.prefs 430B
org.eclipse.wst.jsdt.ui.superType.name 6B
com.genuitec.eclipse.j2eedt.core.prefs 56B
org.eclipse.wst.common.component 589B
.jsdtscope 508B
pom.xml 3KB
.classpath 857B
共 41 条
- 1
资源评论
- 「已注销」2018-10-26很不错的资源!很有价值
- qilongpingchuan2017-10-31这个资源不错,谢谢分享
poorCoder_
- 粉丝: 128
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功