?1. pom
<!-- 達(dá)夢數(shù)據(jù)庫驅(qū)動 -->
<dependency>
? ? <groupId>com.dm</groupId>
? ? <artifactId>DmJdbcDriver18</artifactId>
? ? <version>1.8</version>
</dependency>
maven?中央倉庫里面沒有儒搭，需要手動安裝到 maven 本地倉庫
2. druid 配置?application.properties
#數(shù)據(jù)源1
datasource.no1.driver-class-name: dm.jdbc.driver.DmDriver
datasource.no1.url=jdbc:dm://192.168.0.11:5238/SYSDBA?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=utf-8
datasource.no1.username=SYSDBA
datasource.no1.password=root123456789
3. 配置類
package org.fh.config;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.DefaultResourceLoader;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import com.alibaba.druid.pool.DruidDataSource;
/**
* 說明：第一數(shù)據(jù)源配置
* 作者：FH Admin
* from：fhadmin.cn
*/
@Configuration
@MapperScan(basePackages = MasterDataSourceConfig.PACKAGE, sqlSessionFactoryRef = "masterSqlSessionFactory") //掃描 Mapper 接口并容器管理
public class MasterDataSourceConfig {
……
//其中的 dataSource.addFilters("wall"); 去掉吵血，否則訪問不了數(shù)據(jù)庫
? ? @Bean(name = "masterDataSource")
? ? @Primary
? ? public DataSource masterDataSource() throws SQLException {
? ? ? ? DruidDataSource dataSource = new DruidDataSource();
? ? ? ? dataSource.setDriverClassName(driverClass);
? ? ? ? dataSource.setUrl(url);
? ? ? ? dataSource.setUsername(user);
? ? ? ? dataSource.setPassword(password);
? ? ? ? dataSource.addFilters("stat");
? ? ? ? //dataSource.addFilters("wall");
? ? ? ? return dataSource;
? ? }
……
}
