package com.genersoft.iot.vmp.conf;
|
|
import org.apache.ibatis.logging.stdout.StdOutImpl;
|
import org.apache.ibatis.mapping.DatabaseIdProvider;
|
import org.apache.ibatis.mapping.VendorDatabaseIdProvider;
|
import org.apache.ibatis.session.SqlSessionFactory;
|
import org.mybatis.spring.SqlSessionFactoryBean;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.context.annotation.Bean;
|
import org.springframework.context.annotation.Configuration;
|
import org.springframework.core.annotation.Order;
|
|
import javax.sql.DataSource;
|
import java.util.Properties;
|
|
/**
|
* 配置mybatis
|
*/
|
@Configuration
|
@Order(value=1)
|
public class MybatisConfig {
|
|
@Autowired
|
private UserSetting userSetting;
|
|
@Bean
|
public DatabaseIdProvider databaseIdProvider() {
|
VendorDatabaseIdProvider databaseIdProvider = new VendorDatabaseIdProvider();
|
Properties properties = new Properties();
|
properties.setProperty("Oracle", "oracle");
|
properties.setProperty("MySQL", "mysql");
|
properties.setProperty("DB2", "db2");
|
properties.setProperty("Derby", "derby");
|
properties.setProperty("H2", "h2");
|
properties.setProperty("HSQL", "hsql");
|
properties.setProperty("Informix", "informix");
|
properties.setProperty("MS-SQL", "ms-sql");
|
properties.setProperty("PostgreSQL", "postgresql");
|
properties.setProperty("Sybase", "sybase");
|
properties.setProperty("Hana", "hana");
|
properties.setProperty("DM", "dm");
|
properties.setProperty("KingbaseES", "kingbase");
|
properties.setProperty("KingBase8", "kingbase");
|
databaseIdProvider.setProperties(properties);
|
return databaseIdProvider;
|
}
|
|
@Bean
|
public SqlSessionFactory sqlSessionFactory(DataSource dataSource, DatabaseIdProvider databaseIdProvider) throws Exception {
|
final SqlSessionFactoryBean sqlSessionFactory = new SqlSessionFactoryBean();
|
sqlSessionFactory.setDataSource(dataSource);
|
org.apache.ibatis.session.Configuration config = new org.apache.ibatis.session.Configuration();
|
if (userSetting.getSqlLog()){
|
config.setLogImpl(StdOutImpl.class);
|
}
|
config.setMapUnderscoreToCamelCase(true);
|
sqlSessionFactory.setConfiguration(config);
|
sqlSessionFactory.setDatabaseIdProvider(databaseIdProvider);
|
return sqlSessionFactory.getObject();
|
}
|
|
}
|
