需求背景

  • 运维交付平台里包含着产品包的升级计划，升级计划 是产品迭代的核心草案，但是在之前的过程中，升级计划与 缺陷管理平台中的bug记录 无相关性，导致该升级解决了哪些BUG，实现了哪些增补是无从感知，或者需要人工再次统计，十分的不便使用。

    实现目标

  • 创建升级计划的同时关联到 缺陷记录。并提供对应的crud关联展示。

    配置

    ```java

=== itsm db

spring.datasource.itsm.jdbc-url=jdbc:mysql://172.16.100.xxx:3306/dt_itsm_dev?serverTimezone=Asia/Shanghai&useSSL=false&allowPublicKeyRetrieval=true spring.datasource.itsm.username=root spring.datasource.itsm.password=abc123 spring.datasource.itsm.driver-class-name=com.mysql.cj.jdbc.Driver

=== zentao db

spring.datasource.zentao.jdbc-url=jdbc:mysql://rm-xxx.mysql.rds.aliyuncs.com:3306/zentao spring.datasource.zentao.username=xxx spring.datasource.zentao.password=Y)g)xx spring.datasource.zentao.driver-class-name=com.mysql.cj.jdbc.Driver

  2. - 对两个数据源进行分别配置，这里选择使用配置类的方式
  3. ```java
  4. package com.dtstack.itsm.base.config;
  7. import org.apache.ibatis.session.SqlSessionFactory;
  8. import org.mybatis.spring.SqlSessionFactoryBean;
  9. import org.mybatis.spring.SqlSessionTemplate;
  10. import org.mybatis.spring.annotation.MapperScan;
  11. import org.mybatis.spring.boot.autoconfigure.SpringBootVFS;
  12. import org.springframework.beans.factory.annotation.Autowired;
  13. import org.springframework.beans.factory.annotation.Qualifier;
  14. import org.springframework.boot.context.properties.ConfigurationProperties;
  15. import org.springframework.boot.jdbc.DataSourceBuilder;
  16. import org.springframework.context.annotation.Bean;
  17. import org.springframework.context.annotation.Configuration;
  18. import org.springframework.context.annotation.Primary;
  19. import org.springframework.core.env.Environment;
  20. import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
  21. import org.springframework.jdbc.datasource.DataSourceTransactionManager;
  23. import javax.sql.DataSource;
  25. /*
  26.  * @Author shihu
  27.  * @Description  运维交付平台db配置类
  28.  * @Date 4:42 下午 2021/8/18
  29.  * @Param
  30.  * @return 
  31.  **/
  32. @Configuration
  33. @MapperScan(basePackages = "com.dtstack.itsm.mapper", sqlSessionFactoryRef = "db1SqlSessionFactory")   //basePackages db1的数据库的dao层的地址
  34. public class MybatisItsmConfig {
  36.     @Autowired
  37.     private Environment env;
  39.     @Primary // 表示这个数据源是默认数据源, 这个注解必须要加，因为不加的话spring将分不清楚那个为主数据源（默认数据源）
  40.     @Bean("db1DataSource")
  41.     @ConfigurationProperties(prefix = "spring.datasource.itsm") //读取application.yml中的配置参数映射成为一个对象
  42.     public DataSource getDb1DataSource(){
  43.         return DataSourceBuilder.create().build();
  44.     }
  46.     @Primary
  47.     @Bean("db1SqlSessionFactory")
  48.     public SqlSessionFactory db1SqlSessionFactory(@Qualifier("db1DataSource") DataSource dataSource) throws Exception {
  49.         SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
  50.         bean.setDataSource(dataSource);
  51.         // mapper的xml形式文件位置必须要配置，不然将报错：no statement （这种错误也可能是mapper的xml中，namespace与项目的路径不一致导致）  映射地址一定要正确，不然会报invalid bound statement (not found)错误
  53.         bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/*Mapper.xml"));
  54.         bean.setVfs(SpringBootVFS.class);
  55.         bean.setTypeAliasesPackage(env.getProperty("mybatis.type-aliases-package"));
  57.         return bean.getObject();
  58.     }
  60.     @Primary
  61.     @Bean("db1SqlSessionTemplate")
  62.     public SqlSessionTemplate db1SqlSessionTemplate(@Qualifier("db1SqlSessionFactory") SqlSessionFactory sqlSessionFactory){
  63.         return new SqlSessionTemplate(sqlSessionFactory);
  64.     }
  69. }
  71. ------ 禅道数据库 
  72. package com.dtstack.itsm.base.config;
  75. import org.apache.ibatis.session.SqlSessionFactory;
  76. import org.mybatis.spring.SqlSessionFactoryBean;
  77. import org.mybatis.spring.SqlSessionTemplate;
  78. import org.mybatis.spring.annotation.MapperScan;
  79. import org.mybatis.spring.boot.autoconfigure.SpringBootVFS;
  80. import org.springframework.beans.factory.annotation.Autowired;
  81. import org.springframework.beans.factory.annotation.Qualifier;
  82. import org.springframework.boot.context.properties.ConfigurationProperties;
  83. import org.springframework.boot.jdbc.DataSourceBuilder;
  84. import org.springframework.context.annotation.Bean;
  85. import org.springframework.context.annotation.Configuration;
  86. import org.springframework.context.annotation.Primary;
  87. import org.springframework.core.env.Environment;
  88. import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
  90. import javax.sql.DataSource;
  93. @Configuration
  94. @MapperScan(basePackages = "com.dtstack.zentao.mapper", sqlSessionFactoryRef = "db2SqlSessionFactory")   //basePackages db1的数据库的dao层的地址
  95. public class MybatisZentaoConfig {
  97.     @Autowired
  98.     private Environment env;
  100.     @Bean("db2DataSource")
  101.     @ConfigurationProperties(prefix = "spring.datasource.zentao")
  102.     public DataSource getDb1DataSource(){
  103.         return DataSourceBuilder.create().build();
  104.     }
  106.     @Bean("db2SqlSessionFactory")
  107.     public SqlSessionFactory db1SqlSessionFactory(@Qualifier("db2DataSource") DataSource dataSource) throws Exception {
  108.         SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
  109.         bean.setDataSource(dataSource);
  110.         bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/*Mapper.xml"));
  111.         bean.setVfs(SpringBootVFS.class);
  112.         bean.setTypeAliasesPackage(env.getProperty("mybatis.type-aliases-package"));
  113.         return bean.getObject();
  114.     }
  116.     @Bean("db2SqlSessionTemplate")
  117.     public SqlSessionTemplate db1SqlSessionTemplate(@Qualifier("db2SqlSessionFactory") SqlSessionFactory sqlSessionFactory){
  118.         return new SqlSessionTemplate(sqlSessionFactory);
  119.     }
  122. }
  • 之所以选择直连db的方式是因为禅道的api太tm难用了，又臭又长又烂。
  • 目录结构

image.png

  • 之后对于db的使用同常规方式一样，domain mapper service 安排即可，不再进行赘述