org.mybatis.spring.SqlSessionFactoryBean#setConfiguration

Source File: DataSourceConfig.java From springbootexamples with Apache License 2.0

6 votes

/**
 * 多数据源的 SqlSessionFactory
 * @param dynamicDataSource
 * @return
 * @throws Exception
 */
@Bean(name = "sqlSessionFactory")
public SqlSessionFactory sqlSessionFactory(@Qualifier("dynamicDataSource") DataSource dynamicDataSource)
        throws Exception {
    SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
    bean.setDataSource(dynamicDataSource);
    //设置数据数据源的Mapper.xml路径
    bean.setMapperLocations(
            new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/*.xml"));
    //设置Mybaties查询数据自动以驼峰式命名进行设值
    org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session
            .Configuration();
    configuration.setMapUnderscoreToCamelCase(true);
    bean.setConfiguration(configuration);

    return bean.getObject();
}

Source File: DataSource1Config.java From Resource with GNU General Public License v3.0

6 votes

@Bean(name = "db1SqlSessionFactory")
public SqlSessionFactory setSqlSessionFactory(@Qualifier("db1DataSource") DataSource dataSource,
                                              @Qualifier("db1Configuration") org.apache.ibatis.session.Configuration configuration)
    throws Exception
{
    String url = "classpath:com/zsm/mapper/db1/*.xml";
    SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
    bean.setDataSource(dataSource);
    bean.setConfiguration(configuration);
    bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(url));
    org.apache.ibatis.session.Configuration config = new org.apache.ibatis.session.Configuration();
    config.setMapUnderscoreToCamelCase(true); // 开启驼峰命名支持
    bean.setConfiguration(config);
    //格式化sql语句打印
    PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
    Properties properties = new Properties();
    properties.setProperty("format", "true");
    performanceInterceptor.setProperties(properties);
    bean.setPlugins(new Interceptor[] {performanceInterceptor});
    return bean.getObject();
}

Source File: DataSource2Config.java From Resource with GNU General Public License v3.0

6 votes

@Bean(name = "db2SqlSessionFactory")
public SqlSessionFactory setSqlSessionFactory(@Qualifier("db2DataSource") DataSource dataSource,
                                              @Qualifier("db2Configuration") org.apache.ibatis.session.Configuration configuration)
    throws Exception
{
    String url = "classpath:com/zsm/mapper/db2/*.xml";
    SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
    bean.setDataSource(dataSource);
    bean.setConfiguration(configuration);
    bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(url));
    org.apache.ibatis.session.Configuration config = new org.apache.ibatis.session.Configuration();
    config.setMapUnderscoreToCamelCase(true); // 开启驼峰命名支持
    bean.setConfiguration(config);
    //格式化sql语句打印
    PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
    Properties properties = new Properties();
    properties.setProperty("format", "true");
    performanceInterceptor.setProperties(properties);
    bean.setPlugins(new Interceptor[] {performanceInterceptor});
    return bean.getObject();
}

Source File: MybatisConfig1.java From spring-boot-inside with MIT License

5 votes

@Bean(name = "sqlSessionFactory1")
public SqlSessionFactory sqlSessionFactory1(DataSource dataSource1) throws Exception {
	SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
	org.apache.ibatis.session.Configuration ibatisConfiguration = new org.apache.ibatis.session.Configuration();
	sqlSessionFactoryBean.setConfiguration(ibatisConfiguration);

	sqlSessionFactoryBean.setDataSource(dataSource1);
	sqlSessionFactoryBean.setTypeAliasesPackage("sample.mybatis.domain");
	return sqlSessionFactoryBean.getObject();
}

Source File: BaseDataSourceConfig.java From spring-boot-tutorials with Apache License 2.0

5 votes

public SqlSessionFactory getSqlSessionFactory(DataSource dataSourceTwo, String location)
        throws Exception {
    final SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
    sqlSessionFactoryBean.setDataSource(dataSourceTwo);
    sqlSessionFactoryBean.setConfiguration(configuration());
    sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver()
            .getResources(location));
    return sqlSessionFactoryBean.getObject();
}

Source File: MybatisAutoConfiguration.java From spring-boot-mybatis-rw with Apache License 2.0

5 votes

@Bean
public SqlSessionFactory sqlSessionFactory(DataSourceProxy dataSource)
		throws Exception {

	SqlSessionFactoryBean factory = new SqlSessionFactoryBean();
	Interceptor rwplugin = new RWPlugin();
	if (StringUtils.hasText(this.properties.getConfigLocation())) {
		factory.setConfigLocation(this.resourceLoader.getResource(this.properties.getConfigLocation()));
	}
	factory.setConfiguration(properties.getConfiguration());

	if (ObjectUtils.isEmpty(this.interceptors)) {
		Interceptor[] plugins = { rwplugin };
		factory.setPlugins(plugins);
	} else {
		List<Interceptor> interceptorList = new ArrayList<Interceptor>(Arrays.asList(interceptors));
		interceptorList.add(rwplugin);
		factory.setPlugins(interceptorList.toArray(new Interceptor[interceptorList.size()]));
	}
	if (this.databaseIdProvider != null) {
		factory.setDatabaseIdProvider(this.databaseIdProvider);
	}
	if (StringUtils.hasLength(this.properties.getTypeAliasesPackage())) {
		factory.setTypeAliasesPackage(this.properties.getTypeAliasesPackage());
	}
	if (StringUtils.hasLength(this.properties.getTypeHandlersPackage())) {
		factory.setTypeHandlersPackage(this.properties.getTypeHandlersPackage());
	}
	if (!ObjectUtils.isEmpty(this.properties.resolveMapperLocations())) {
		factory.setMapperLocations(this.properties.resolveMapperLocations());
	}
	factory.setDataSource(dataSource);
	return factory.getObject();
}

Source File: MybatisConfig.java From genericdao with Artistic License 2.0

5 votes

@Bean
public SqlSessionFactoryBean sessionFactoryBean(DataSource dataSource , Environment environment) throws IOException{
	SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean() ;
	sqlSessionFactoryBean.setDataSource(dataSource);
	//别名包
	sqlSessionFactoryBean.setTypeAliasesPackage(environment.getRequiredProperty(PROPERTY_MYBATIS_ALIAS_PACKAGE));
	
	PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver() ;
	//获取mybatis映射文件路径，classpath:mybatis/mybatis-config.xml
	if(environment.containsProperty(PROPERTY_MYBATIS_CONFIG)){
		sqlSessionFactoryBean.setConfigLocation(resolver.getResource(environment.getRequiredProperty(PROPERTY_MYBATIS_CONFIG)));
	}
	//获取mybatis映射文件路径，例：classpath*:com/framework/sample/mapper/*Mapper.xml
	sqlSessionFactoryBean.setMapperLocations(resolver.getResources(environment.getRequiredProperty(PROPERTY_MYBATIS_MAPPER_LOCATION)));

	//开启后将在启动时检查设定的parameterMap,resultMap是否存在，是否合法
	sqlSessionFactoryBean.setFailFast(true) ;

	//存储mybatis的插件
	List<Interceptor> interceptorList = new ArrayList<Interceptor>() ;
	//初始化mybatis的插件
	initPlugins(interceptorList , environment) ;
	//设置mybatis插件
	sqlSessionFactoryBean.setPlugins(interceptorList.toArray(new Interceptor[]{}));

	//创建自定义的的Configuration
	Configuration configuration = new Configuration() ;
	//设置ObjectWrapperFactory，在其中映射mybatis查询结果和jpa实体
	configuration.setObjectWrapperFactory(new JPAObjectWrapperFactory());
	sqlSessionFactoryBean.setConfiguration(configuration);

	return sqlSessionFactoryBean ;
}

Source File: SpringAnnotationTest.java From Mapper with MIT License

5 votes

@Bean
public SqlSessionFactory sqlSessionFactory() throws Exception {
    SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
    sessionFactory.setDataSource(dataSource());
    tk.mybatis.mapper.session.Configuration configuration = new tk.mybatis.mapper.session.Configuration();
    configuration.setMapperHelper(new MapperHelper());
    sessionFactory.setConfiguration(configuration);
    return sessionFactory.getObject();
}

Source File: DatabaseConfig.java From java-master with Apache License 2.0

4 votes

@Bean
@SuppressWarnings("ALL")
public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
    PathMatchingResourcePatternResolver resourcePatternResolver = new PathMatchingResourcePatternResolver();
    SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
    sqlSessionFactoryBean.setDataSource(dataSource);

    //分页插件
    PageHelper pageHelper = new PageHelper();
    Properties properties = new Properties();
    properties.setProperty("reasonable", "true");
    properties.setProperty("supportMethodsArguments", "true");
    properties.setProperty("returnPageInfo", "check");
    properties.setProperty("params", "count=countSql");
    properties.setProperty("dialect", "MySQL");
    pageHelper.setProperties(properties);
    sqlSessionFactoryBean.setPlugins(new Interceptor[]{pageHelper});

    final String mapperLocation = "classpath*:mapper/**/*.xml";
    sqlSessionFactoryBean.setMapperLocations(resourcePatternResolver.getResources(mapperLocation));
    // 只指定包名,则mybatis会自动为 JavaBean 注册一个小写字母开头的非完全限定的类名形式的别名
    sqlSessionFactoryBean.setTypeAliasesPackage("org.javamaster.b2c.core.entity");
    org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
    configuration.setLogImpl(Slf4jImpl.class);

    TypeHandlerRegistry typeHandlerRegistry = configuration.getTypeHandlerRegistry();
    sqlSessionFactoryBean.setConfiguration(configuration);
    // 找到EnumBase接口所在的包下所有实现该接口的枚举类
    Set<Class<?>> set = ClassUtils.getAllClassesFromPackage(EnumBase.class.getPackage().getName())
            .stream()
            .filter(clz -> clz.isEnum() && EnumBase.class.isAssignableFrom(clz))
            .collect(Collectors.toSet());
    // 动态注册所有实现了EnumBase接口枚举类的类型转换器到Mybatis
    set.forEach(enumClass -> {
        EnumBaseTypeHandler handler = new EnumBaseTypeHandler(enumClass);
        typeHandlerRegistry.register(enumClass, JdbcType.TINYINT, handler);
        typeHandlerRegistry.register(enumClass, null, handler);
    });

    return sqlSessionFactoryBean.getObject();
}

Java Code Examples for org.mybatis.spring.SqlSessionFactoryBean#setConfiguration()