= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setTypeHandlersPackage...().getResources("classpath:/mapper/master/*.xml")); return sessionFactoryBean.getObject();...= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setTypeHandlersPackage...= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setTypeHandlersPackage...sessionFactoryBean.setTypeHandlersPackage("com.banmoon.test.persistent.master.entity"); sessionFactoryBean.setMapperLocations
Qualifier("firstDataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean sessionFactoryBean...= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setMapperLocations...PathMatchingResourcePatternResolver() .getResources("classpath*:mapper/first/*.xml")); return sessionFactoryBean.getObject...Qualifier("secondDataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean sessionFactoryBean...= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setMapperLocations
= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSourceA); sessionFactoryBean.setConfigLocation...(configLocation); sessionFactoryBean.setTypeAliasesPackage("com.dhy.mapper"); Resource...(resources); return sessionFactoryBean.getObject(); } @Bean public MapperScannerConfigurer...= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSourceB); sessionFactoryBean.setConfigLocation...(configLocation); sessionFactoryBean.setTypeAliasesPackage("com.dhy.mapper.b"); Resource
Qualifier("masterDataSource") DataSource dataSource) throws Exception { final SqlSessionFactoryBean sessionFactoryBean...= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setMapperLocations...Qualifier("slaveDataSource") DataSource dataSource) throws Exception { final SqlSessionFactoryBean sessionFactoryBean...= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setMapperLocations...PathMatchingResourcePatternResolver().getResources(SlaveDataSourceConfig.MAPPER_LOCATION)); return sessionFactoryBean.getObject
Qualifier("gsiotDataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean sessionFactoryBean...= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setMapperLocations...@Qualifier("orgDataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean sessionFactoryBean...= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setMapperLocations...PathMatchingResourcePatternResolver() .getResources("classpath:mapping/org/*.xml")); return sessionFactoryBean.getObject
@Autowired private DataSource dataSource; @Bean public LocalSessionFactoryBean sessionFactoryBean...() { LocalSessionFactoryBean sessionFactoryBean = new LocalSessionFactoryBean(); sessionFactoryBean.setDataSource...(dataSource); sessionFactoryBean.setPackagesToScan("com.zhu.demo");//dao和entity的公共包 Properties...properties.setProperty("hibernate.current_session_context_class", current_session_context_class); sessionFactoryBean.setHibernateProperties...(properties); return sessionFactoryBean; } } 配置完之后,还需要将使用session的方法添加事务,否则会报错!
mybatisSqlSessionFactoryBean(DataSource dataSource) throws Exception { MybatisSqlSessionFactoryBean sessionFactoryBean...= new MybatisSqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource);...sessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath...:/mapper/*.xml")); sessionFactoryBean.setConfiguration(mybatisConfiguration()); sessionFactoryBean.setPlugins...(new Interceptor[]{paginationInterceptor()}); return sessionFactoryBean; } @Bean
SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource) throws Exception { SqlSessionFactoryBean sessionFactoryBean...= new SqlSessionFactoryBean();//工厂bean的对象是产品 sessionFactoryBean.setDataSource(dataSource);...resolver = new PathMatchingResourcePatternResolver(); //扫描 数据库和java entity 对应的配置文件,所在包是哪里 sessionFactoryBean.setMapperLocations...//将分页拦截器注册到插件中 //PageInterceptor pageInterceptor = new PageInterceptor(); //sessionFactoryBean.setPlugins...(new Interceptor[]{pageInterceptor}); return sessionFactoryBean; } } 配置application.yml
@Qualifier("db1DataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean sessionFactoryBean...= new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setMapperLocations...org.apache.ibatis.session.Configuration(); configuration.setMapUnderscoreToCamelCase(true); sessionFactoryBean.setConfiguration...(configuration); return sessionFactoryBean.getObject(); } @Primary @Bean(name =
配置SessionFactoryBean--> <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean
四、获取不到sessionFactoryBean: ssm项目中,如果你确定你的sqlSessionFactory已注入而报找不到sqlSessionFactory这个bean,那么可能是mapper.xml
Qualifier("MasterDataSource") DataSource dataSource) throws Exception { MybatisSqlSessionFactoryBean sessionFactoryBean...= new MybatisSqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setMapperLocations...; log.info("------------------------------------------MasterDataSource 配置成功"); return sessionFactoryBean.getObject...Qualifier("SlaveDataSource") DataSource dataSource) throws Exception { MybatisSqlSessionFactoryBean sessionFactoryBean...= new MybatisSqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setMapperLocations
-- 注入datasource,给sessionfactoryBean内setdatasource提供数据源 --> <property name="dataSource" ref="dataSource
如果 Bean 不是自己编写的类(如 JdbcTemplate、SessionFactoryBean 等),注释配置将无法实施,此时 XML 配置是唯一可用的方式。
ResourceKeyspacePopulator(scriptOf("DROP TABLE my_table;")); } // ... } 如果要使用 XML 配置初始化数据库并且可以提供对SessionFactorybean
所以默认可以不写 --> sessionFactoryBean
value="${jdbc.password}" /> <bean class="org.mybatis.spring.SqlSessionFactoryBean" id="<em>sessionFactoryBean</em>
org.hibernate.dialect.HSQLDialect"); props.setProperty("hibernate.show_sql", "true"); var sessionFactoryBean...= new LocalSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); // 扫描指定的...package获取所有entity class: sessionFactoryBean.setPackagesToScan("com.itranswarp.learnjava.entity..."); sessionFactoryBean.setHibernateProperties(props); return sessionFactoryBean;
领取专属 10元无门槛券
手把手带您无忧上云