1，通过xml的方式：

      
       
       
        
          
        
         oracle
          
        
      
     

 

2，通过bean的方式：

@Bean    public SqlSessionFactory sqlSessionFactory() throws Exception {        SqlSessionFactoryBean sqf = new SqlSessionFactoryBean();        ResourcePatternResolver resolver = ResourcePatternUtils.getResourcePatternResolver(new DefaultResourceLoader());        sqf.setDataSource(dataSource());        sqf.setMapperLocations(resolver.getResources("classpath:mapper/*.xml"));        Properties properties = new Properties();        properties.put("dbType", "oracle");        sqf.setConfigurationProperties(properties);        return sqf.getObject();    }

 

使用：

1，java类中获取全局变量：

sqlSessionFactory.getConfiguration().getVariables().getProperty("dbType");

 

2，mapper中使用全局变量：

      SELECT          '${dbType}'    FROM  dual

或

        SELECT                FROM tb a where a.del_flag = 0                and a.state = '1'