@Bean(name = "test2SqlSessionFactory") public SqlSessionFactory testSqlSessionFactory(@Qualifier("test2DataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean bean = new SqlSessionFactoryBean(); bean.setDataSource(dataSource); bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/mapper/test2/*.xml")); return bean.getObject(); }
@Bean @ConditionalOnMissingBean public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception { SqlSessionFactoryBean factory = new SqlSessionFactoryBean(); factory.setDataSource(dataSource); factory.setVfs(SpringBootVFS.class); if (StringUtils.hasText(this.properties.getConfigLocation())) { factory.setConfigLocation(this.resourceLoader.getResource(this.properties.getConfigLocation())); factory.setConfigurationProperties(this.properties.getConfigurationProperties()); factory.setPlugins(this.interceptors); factory.setDatabaseIdProvider(this.databaseIdProvider); factory.setTypeAliasesPackage(this.properties.getTypeAliasesPackage()); factory.setTypeAliasesSuperType(this.properties.getTypeAliasesSuperType()); factory.setTypeHandlersPackage(this.properties.getTypeHandlersPackage()); factory.setMapperLocations(this.properties.resolveMapperLocations()); return factory.getObject();
@Bean(name = "test2SqlSessionFactory") public SqlSessionFactory testSqlSessionFactory(@Qualifier("test2DataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean bean = new SqlSessionFactoryBean(); bean.setDataSource(dataSource); return bean.getObject(); }
@Bean(name = "sqlSessionFactory") public SqlSessionFactoryBean sqlSessionFactory(ApplicationContext applicationContext) throws Exception { SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean(); sessionFactory.setDataSource(dataSource); // sessionFactory.setPlugins(new Interceptor[]{new PageInterceptor()}); sessionFactory.setMapperLocations(applicationContext.getResources("classpath*:mapper/*.xml")); return sessionFactory; }
@Bean(name = "sqlSessionFactory") @Primary public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception { SqlSessionFactoryBean factory = new SqlSessionFactoryBean(); MybatisProperties mybatisProperties = this.mybatisProperties(); if (null != entityFactory) { factory.setObjectFactory(new MybatisEntityFactory(entityFactory)); factory.setVfs(SpringBootVFS.class); if (mybatisProperties().isDynamicDatasource()) { factory.setSqlSessionFactoryBuilder(new DynamicDataSourceSqlSessionFactoryBuilder()); factory.setTransactionFactory(new SpringManagedTransactionFactory() { @Override public Transaction newTransaction(DataSource dataSource, TransactionIsolationLevel level, boolean autoCommit) { factory.setDataSource(dataSource); if (StringUtils.hasText(mybatisProperties.getConfigLocation())) { factory.setConfigLocation(this.resourceLoader.getResource(mybatisProperties .getConfigLocation())); factory.setConfiguration(mybatisProperties.getConfiguration()); factory.setPlugins(this.interceptors); factory.setDatabaseIdProvider(this.databaseIdProvider); factory.setTypeAliasesPackage(mybatisProperties.getTypeAliasesPackage()); String typeHandlers = "org.hswebframework.web.dao.mybatis.handler"; if (mybatisProperties.getTypeHandlersPackage() != null) { typeHandlers = typeHandlers + ";" + mybatisProperties.getTypeHandlersPackage();
SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean(); factoryBean.setConfigLocation(this.configLocation); factoryBean.setMapperLocations(this.mapperLocations); factoryBean.setDataSource(dataSource); factoryBean.setEnvironment(this.environment); factoryBean.setConfigurationProperties(this.configurationProperties); factoryBean.setPlugins(this.plugins); factoryBean.setTypeHandlers(this.typeHandlers); factoryBean.setTypeHandlersPackage(this.typeHandlersPackage); factoryBean.setTypeAliases(this.typeAliases); factoryBean.setTypeAliasesPackage(this.typeAliasesPackage); SqlSessionFactory sessionFacotry = factoryBean.getObject(); SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean(); factoryBean.setConfigLocation(shardConfiguration.getConfigLocation()); factoryBean.setMapperLocations(shardConfiguration.getMapperLocations()); factoryBean.setDataSource(shardConfiguration.getShardDataSource()); factoryBean.setEnvironment(this.environment); factoryBean.setConfigurationProperties(this.configurationProperties); factoryBean.setPlugins(this.plugins); factoryBean.setTypeHandlers(this.typeHandlers); factoryBean.setTypeHandlersPackage(shardConfiguration.getTypeHandlersPackage()); factoryBean.setTypeAliases(this.typeAliases); factoryBean.setTypeAliasesPackage(shardConfiguration.getTypeAliasesPackage());
@Bean public SqlSessionFactory sqlSessionFactory() throws Exception { log.debug("> sqlSessionFactory"); final SqlSessionFactoryBean sqlSessionFactory = new SqlSessionFactoryBean(); sqlSessionFactory.setDataSource(dataSource()); sqlSessionFactory.setConfigLocation(new ClassPathResource("mybatis-config.xml")); sqlSessionFactory.setFailFast(true); sqlSessionFactory.setMapperLocations(getResource(SQLMAP_PACKAGE, "**/*.xml")); sqlSessionFactory.setTypeHandlersPackage(TYPE_HANDLERS_PACKAGE); sqlSessionFactory.setTypeAliasesPackage(TYPE_ALIASES_PACKAGE); return sqlSessionFactory.getObject(); }
@Bean(name = "sqlSessionFactory") public SqlSessionFactoryBean sqlSessionFactory( ApplicationContext applicationContext) throws Exception { SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean(); sessionFactory.setDataSource(dataSource); org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration(); configuration.setMapUnderscoreToCamelCase(true); configuration.setJdbcTypeForNull(JdbcType.NULL); configuration.setLogImpl(org.apache.ibatis.logging.log4j.Log4jImpl.class);//use log4j log sessionFactory.setConfiguration(configuration); sessionFactory.setMapperLocations(applicationContext.getResources("classpath:com/yy/example/mapper/*.xml")); // // Properties prop = new Properties(); // prop.setProperty("supportMethodsArguments","true"); // prop.setProperty("rowBoundsWithCount", "true"); // prop.setProperty("params","pageNum=pageNum;pageSize=pageSize;"); // PageInterceptor pi = new PageInterceptor(); // pi.setProperties(prop); // sessionFactory.setPlugins(new Interceptor[]{pi}); return sessionFactory; }
@Bean public SqlSessionFactory sqlSessionFactory(@Qualifier(DATA_SOURCE_BEAN_NAME) DataSource dataSource) throws Exception { SqlSessionFactoryBean factory = new SqlSessionFactoryBean(); factory.setDataSource(dataSource); if (ArrayUtils.isNotEmpty(interceptors)) { factory.setPlugins(interceptors); } Configuration configuration = new Configuration(); customizers.forEach(c -> c.customize(configuration)); factory.setConfiguration(configuration); return factory.getObject(); }
@Bean(name = DEMO_SESSION_FACTORY) public SqlSessionFactoryBean demoSqlSessionFactory() { SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean(); sessionFactory.setDataSource(demoDs); sessionFactory.setConfigLocation(new ClassPathResource("demo/config.xml")); return sessionFactory; }
@Bean public SqlSessionFactoryBean sqlSessionFactory(){ SqlSessionFactoryBean sqlSessionFactory=new SqlSessionFactoryBean(); sqlSessionFactory.setDataSource(dataSource); sqlSessionFactory.setTypeAliasesPackage("com.im.lottery.entity"); sqlSessionFactory.setConfigLocation(new ClassPathResource("mybatis-config.xml")); Interceptor[] interceptors=new Interceptor[1]; interceptors[0]=pageHelper(); sqlSessionFactory.setPlugins(interceptors); return sqlSessionFactory; } }
public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource) throws IOException { SqlSessionFactoryBean factoryBean = new SqlSessionFactoryUpdateConfigurationBean(); factoryBean.setDataSource(dataSource); factoryBean.setConfigLocation(configLocation); factoryBean.setMapperLocations(mapperLocations); factoryBean.setTypeAliasesPackage(typeAliasesPackage); myBatisConfigurer.addPlugins(interceptors); factoryBean.setTypeHandlers(typeHandlers.toArray(new TypeHandler[]{})); factoryBean.setPlugins(interceptors.toArray(new Interceptor[]{})); factoryBean.setConfigurationProperties(myBatisProperties.getConfigurationProperties()); return factoryBean;
@Bean public SqlSessionFactoryBean sqlSessionFactory() throws Exception { SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean(); factoryBean.setDataSource(dataSource()); Resource[] mapperLocations = new Resource[2]; mapperLocations[0] = new ClassPathResource("/mybatis/itemdao.xml"); mapperLocations[1] = new ClassPathResource("/mybatis/purchaseorderdao.xml"); factoryBean.setMapperLocations(mapperLocations); factoryBean.setTypeAliases(new Class<?>[] { PurchaseOrder.class }); return factoryBean; }
protected void configureSqlSessionFactory(SqlSessionFactoryBean sessionFactoryBean, DataSource dataSource) throws IOException { PathMatchingResourcePatternResolver pathResolver = new PathMatchingResourcePatternResolver(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setTypeAliasesPackage(ENTITY_PACKAGE_PREFIX); sessionFactoryBean.setConfigLocation(pathResolver.getResource(CONFIG_LOCATION_PATH)); sessionFactoryBean.setMapperLocations(pathResolver.getResources(MAPPER_LOCATIONS_PATH)); } }
@Bean public SqlSessionFactoryBean sqlSessionFactory() throws Exception { SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean(); sqlSessionFactoryBean.setDataSource(dataSource()); sqlSessionFactoryBean.setTypeAliasesPackage("com.kiroule.example.mybatis.domain"); return sqlSessionFactoryBean; } }
@Bean(name = "paymentSqlSessionFactory") public SqlSessionFactory paymentSqlSessionFactory(@Qualifier("paymentDataSource") DataSource paymentDataSource) throws Exception { SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean(); configureSqlSessionFactory(sessionFactoryBean, paymentDataSource); return sessionFactoryBean.getObject(); } }
@Bean public SqlSessionFactoryBean sqlSessionFactory() throws Exception { SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean(); // .... sessionFactory.setConfigLocation(new ClassPathResource("mybatis-config.xml")); // .... return sessionFactory; }
@Override public void setMapperLocations(Resource[] mapperLocations) { super.setMapperLocations(mapperLocations); this.mapperLocations = mapperLocations; }
@Bean(name = "test1SqlSessionFactory") @Primary public SqlSessionFactory testSqlSessionFactory(@Qualifier("test1DataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean bean = new SqlSessionFactoryBean(); bean.setDataSource(dataSource); return bean.getObject(); }
@Bean(name = "sqlSessionFactory") public SqlSessionFactory sqlSessionFactory(@Qualifier("dataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean factory = new SqlSessionFactoryBean(); factory.setVfs(SpringBootVFS.class); if (properties.isDynamicDatasource()) { factory.setSqlSessionFactoryBuilder(new DynamicDataSourceSqlSessionFactoryBuilder()); factory.setTransactionFactory(new SpringManagedTransactionFactory() { @Override public Transaction newTransaction(DataSource dataSource, TransactionIsolationLevel level, boolean autoCommit) { factory.setDataSource(dataSource); if (StringUtils.hasText(this.properties.getConfigLocation())) { factory.setConfigLocation(this.resourceLoader.getResource(this.properties .getConfigLocation())); factory.setPlugins(this.interceptors); factory.setDatabaseIdProvider(this.databaseIdProvider); factory.setTypeAliasesPackage(this.properties.getTypeAliasesPackage()); String typeHandlers = "org.hsweb.web.mybatis.handler"; if (this.properties.getTypeHandlersPackage() != null) { typeHandlers = typeHandlers + ";" + this.properties.getTypeHandlersPackage(); factory.setTypeHandlersPackage(typeHandlers); factory.setMapperLocations(this.properties.resolveMapperLocations()); return factory.getObject();