使用 JPA 和 Microsoft SQL Server 配置 Spring

    <!-- MSSQL 依赖 -->
    
        <groupid>com.microsoft.<a style="color:#f60; text-decoration:underline;" href="https://www.php.cn/zt/两3433.html" target="_blank">sqlserver</a></groupid><artifactid>mssql-jdbc</artifactid>7.二.二.jre8版原&gt;
    依赖&gt;

    <!-- Spring Data JPA 依赖 -->
    
        <groupid>org.springframework.boot</groupid><artifactid>spring-boot-starter-data-jpa</artifactid>依赖&gt;

    <!-- Spring Boot Starter Web 依赖项 -->
    
        <groupid>org.springframework.boot</groupid><artifactid>spring-boot-starter-web</artifactid>依赖&gt;
依赖项&gt;

硬件包 br.com.meuprojeto.config；

导进 org.springframework.context.annotation.Bean;
导进 org.springframework.context.annotation.Configuration;
导进 org.springframework.context.annotation.Profile;
导进 org.springframework.jdbc.datasource.DriverManagerDataSource;
导进 org.springframework.orm.jpa.JpaTransactionManager;
导进 org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
导进 org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
导进 org.springframework.transaction.annotation.EnableTransactionManagement;

导进 javax.persistence.EntityManagerFactory;
导进javax.sql.DataSource；
导进java.util.Properties；

@配备
@封用事务摒挡
民众类 JPAConfiguration {

    @豆
    民众LocalContainerEntityManagerFactoryBeanEntityManagerFactory（数据源dataSource，属性additionalProperties）{
        LocalContainerEntityManagerFactoryBeanfactoryBean = new LocalContainerEntityManagerFactoryBean();
        HibernateJpaVendorAdapter 提供商适配器 = new HibernateJpaVendorAdapter();
        factoryBean.setJpaVendorAdapter(vendorAdapter);
        factoryBean.setPackagesToScan(“br.com.meuprojeto.loja.models”);
        FactoryBean.setDataSource(dataSource);
        factoryBean.setJpaProperties(additionalProperties);
        返归工场Bean；
    }

    @豆
    @自我材料（“开辟”）
    民众属性additionalProperties() {
        属性属性 = new Properties();
        property.setProperty("hibernate.dialect", "org.hibernate.dialect.SQLServerDialect");
        property.setProperty("hibernate.show_sql", "true");
        property.setProperty("hibernate.hbm二ddl.auto", "创立");
        property.setProperty("javax.persistence.schema- Generation.scripts.create-target", "db-schema.jpa.ddl");
        返归属性；
    }

    @豆
    @小我私家材料（“开拓”）
    群众 DriverManagerDataSource dataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setUsername("sa");
        dataSource.setPassword(""); // 正在那面加添你的暗码
        dataSource.setUrl("jdbc:sqlserver://1两7.0.0.1;databaseName=MyProject;");
        dataSource.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        返归数据源；
    }

    @豆
    群众 JpaTransactionManager transactionManager(EntityManagerFactory emf) {
        返归新的 JpaTransactionManager(emf);
    }
}