public static synchronized SqlSessionFactory CreateSessionFactory(String dbName) throws Exception {
// 数据库连接
PooledDataSource dataSource = new PooledDataSource();
dataSource.setDriver("com.microsoft.sqlserver.jdbc.SQLServerDriver");
dataSource.setUsername("sa");
dataSource.setPassword("aaaa");
dataSource.setUrl("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=kh-platform");
TransactionFactory transactionFactory = new JdbcTransactionFactory();
Environment evn = new Environment(dbName,transactionFactory,dataSource);
Configuration config = new Configuration(evn);
config.addMapper(QueryMapper.class);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(config);
sessionFactory.getConfiguration().addInterceptor(new PageInterceptor());
return sessionFactory;
}