环境搭建

环境介绍

• 开发工具：idea
• JDK版本：1.8
• 数据库：oracle11g

创建项目

1. 如图：

   
   image.png

2. 创建好的项目目录如下图：

   
   image.png

3. 添加依赖包

test包

    <!--单元测试junit -->
    <!-- https://mvnrepository.com/artifact/junit/junit -->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>

spring-test包

     <!-- spring test spring测试 -->
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-test -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>4.3.12.RELEASE</version>
      <scope>test</scope>
    </dependency>

oracle 驱动 ojdbc6

 注意：maven不能直接安装oracle驱动
             首先查看自己oracle的版本号
             需要dos命令安装 mvn install:install-file -DgroupId=com.oracle
             -DartifactId=ojdbc6 -Dversion=11.2.0.1.0 -Dpackaging=jar
            -Dfile=E:\worksoft\oracle11g\product\11.2.0\dbhome_1\jdbc\lib\ojdbc6.jar
             <dependency>
                   <groupId>com.oracle</groupId>
                   <artifactId>ojdbc6</artifactId>
                   <version>11.2.0.1.0</version>
               </dependency>

数据库连接池driud

  <!--数据库连接池 driud -->
  <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
  <dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.5</version>
  </dependency>

spring-context

    <!--spring-context-->
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>4.3.12.RELEASE</version>
    </dependency>

spring-data-jpa

    <!--spring-data-jpa-->
    <!-- https://mvnrepository.com/artifact/org.springframework.data/spring-data-jpa -->
    <dependency>
      <groupId>org.springframework.data</groupId>
      <artifactId>spring-data-jpa</artifactId>
      <version>1.8.2.RELEASE</version>
    </dependency>

hibernate-entitymanager

    <!--hibernate-entitymanager-->
    <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-entitymanager -->
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-entitymanager</artifactId>
      <version>4.3.6.Final</version>
    </dependency>

4.编写配置文件

• 数据源配置文件 dbconfig.properties

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:jpa="http://www.springframework.org/schema/data/jpa"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd
       http://www.springframework.org/schema/data/jpa
       http://www.springframework.org/schema/data/jpa/spring-jpa.xsd">
    <!--spring自动扫描的包-->
    <context:component-scan base-package="com.keke"/>

    <!-- 引入数据源配置文件dbconfig.properties-->
    <context:property-placeholder location="classpath:dbconfig.properties"/>

    <!--配置阿里的druids数据源-->
    <bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource"
          init-method="init"
          destroy-method="close">
        <property name="url" value="${oracle.url}"/>
        <property name="driverClassName" value="${oracle.driverClass}"/>
        <property name="username" value="${oracle.username}"/>
        <property name="password" value="${oracle.password}"/>
    </bean>
    <!--配置 entity-manager-->
    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <!--数据源-->
        <property name="dataSource" ref="druidDataSource"/>
        <!--适配器-->
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"/>
        </property>
        <!--扫描实体类路径-->
        <property name="packagesToScan" value="com.keke.domain"/>
        <property name="jpaProperties">
            <props>
                <prop key="hibernate.ejb.naming_strategy">org.hibernate.cfg.ImprovedNamingStrategy</prop>
                <prop key="hibernate.dialect">org.hibernate.dialect.Oracle12cDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.format_sql">true</prop>
                <prop key="hibernate.hbm2ddl.auto">none</prop>
            </props>
        </property>
    </bean>

    <!--配置事务管理-->
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory"/>
    </bean>
    <!--使用事务注解-->
    <tx:annotation-driven transaction-manager="transactionManager"/>
    <!--配置springData扫描-->
    <jpa:repositories base-package="com.keke" 
                                entity-manager-factory-ref="entityManagerFactory"
                                 transaction-manager-ref="transactionManager"/>
</beans>