扫二维码与项目经理沟通
我们在微信上24小时期待你的声音
解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流
这篇文章主要介绍了Spring-boot集成pg、mongo多数据源过程详解,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
专注于为中小企业提供成都网站制作、成都网站设计服务,电脑端+手机端+微信端的三站合一,更高效的管理,为中小企业南溪免费做网站提供优质的服务。我们立足成都，凝聚了一批互联网行业人才，有力地推动了上1000家企业的稳健成长，帮助中小企业通过网站建设实现规模扩充和转变。
修改POM文件，增加相应Jar包
org.springframework.boot spring-boot-starter-data-MongoDB org.postgresql postgresql runtime org.springframework.boot spring-boot-starter-jdbc
修改启动类，去除原有的数据源自动加载机制
@SpringBootApplication(
exclude = {DataSourceAutoConfiguration.class,
PageHelperAutoConfiguration.class ,
MongoAutoConfiguration.class, MongoDataAutoConfiguration.class//禁用数据源自动配置
})
@EnableEurekaClient
public class MainApplication {、、、编写application.yml文件，增加配置信息
spring: # 默认的postgreSQL库 datasource: pg: url: jdbc:postgresql://127.0.0.1:5432/pgdb username: us_wu password: netcool@919 driver-class-name: org.postgresql.Driver mg: host: 127.0.0.1 username: aaa password: aaa database: mgdb port: 27017
分别手动增加PG、mongo的数据源以及使用样例
pg
1、手动加载数据源
@Configuration
public class DataSourceConfig {
final String cmspg="spring.datasource.pg";
@Bean(name = "pgDS")
@ConfigurationProperties(prefix =pg)
public DataSource dataSource() {
return DataSourceBuilder.create().build();
}2、创建pg配置文件，指定SqlSessionFactory以及要扫描的Dao
@Configuration
@MapperScan(basePackages = {"com.**.mapper.pg"}, sqlSessionFactoryRef = "sqlSessionFactory")
public class PostgresDBConfig {
@Autowired
@Qualifier("pgDS")
private DataSource pgDS;
@Bean
public SqlSessionFactory sqlSessionFactory() throws Exception {
SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
factoryBean.setDataSource(pgDS);
return factoryBean.getObject();
}
@Bean
public SqlSessionTemplate sqlSessionTemplate() throws Exception {
SqlSessionTemplate template = new SqlSessionTemplate(sqlSessionFactory()); // 使用上面配置的Factory
return template;
}
}
3、编写Dao--注解形式
@Repository
@Mapper
public interface StCableFiberMapper {
@Select("SELECT * FROM st_cable_fiber WHERE id = #{id}")
St_cable_fiber findById(@Param("id") String id);mongo
1、加载mongo配置信息
public abstract class AbstractMongoConfigure {
private String host, database, username, password;
private int port;
// Setter methods go here..
/*
* Method that creates MongoDbFactory Common to both of the MongoDb
* connections
*/
public MongoDbFactory mongoDbFactory() throws Exception {
ServerAddress serverAddress = new ServerAddress(host, port);
List mongoCredentialList = new ArrayList<>();
mongoCredentialList.add(MongoCredential.createScramSha1Credential(username, database, password.toCharArray()));
return new SimpleMongoDbFactory(new MongoClient(serverAddress,mongoCredentialList), database);
}
/*
* Factory method to create the MongoTemplate
*/
abstract public MongoTemplate getMongoTemplate() throws Exception;
}
@Configuration
@EnableMongoRepositories(basePackages = {"com.**.mapper.mg"},mongoTemplateRef = "mongoTemplate")
@ComponentScan
@ConfigurationProperties(prefix = "spring.datasource.mg")
public class MongoMasterConfig extends AbstractMongoConfigure{
@Override
@Bean("mongoTemplate")
public MongoTemplate getMongoTemplate() throws Exception {
return new MongoTemplate(mongoDbFactory());
}
} 编写Dao MongoTemplate模式
@Repository
public class CmCableDetailRepo{
@Autowired
private MongoTemplate mongoTemplate;
public Page findByLevelAndName(String areacode, int level,String name,int pageNum, int pageSize){
PageRequest page = new PageRequest(pageNum, pageSize);
Query query = new Query();
Criteria criteria = new Criteria();
criteria.and("areacode").regex("^"+areacode);
if(level > -1){
criteria.and("cableSegment_level").is(level);
}
if(null != name && name.trim().length() > 0){
criteria.and("zh_label").regex(".*?"+name+".*");
}
query.addCriteria(criteria);
Long count = mongoTemplate.count(query, Cm_Cable.class);
List list = mongoTemplate.find(query.with(page), Cm_Cable.class);
return new PageImpl(list, page, count);
}
MongoRepository模式