Springboot整合jpa实现mysql&oracle

• pom
• application
• entity
• JpaRepository
• 测试
• 多表关联查询
• • interface
  • JpaRepository
  • 测试

     mysql
     mysql-connector-java


     com.oracle
     ojdbc6
     11.2.0.3

 
     org.springframework.boot
     spring-boot-starter-data-jpa

#spring.jpa.hibernate.dialect = org.hibernate.dialect.MySQL5InnoDBDialect
#spring.datasource.driver-class-name = com.mysql.jdbc.Driver
spring.jpa.hibernate.dialect = org.hibernate.dialect.Oracle10gDialect
spring.datasource.driver-class-name = oracle.jdbc.driver.OracleDriver
spring.datasource.url = url地址
spring.datasource.username = 用户名
spring.datasource.password = 密码

@Entity
@Table(name = "SECURITY_ULTRA_USER")
public class UltraUser {
    @Id
    @GeneratedValue
    @Column(name = "USER_ID")
    private Long id;

    @Column(name = "USER_NAME")
    private  String name;

    @Column(name = "ACCOUNT")
    private String userAccount;

    @Column(name = "PASS")
    private String pass;
}

public interface UltraUserRepository extends JpaRepository {
}

List all = ultraUserRepository.findAll();

直接写成接口的形式，而不像上面写成entity

public interface UltraOrgan {
   String getDEPT_ID();
   String getDEPT_NAME();
   String getSUPER_ID();
   String getNOTE();
   Integer getSTATE();
   String getGROUP_DNID();
   String getORG_DNNAME();
   Integer getTYPE();
   String getAPP_NAME();
   String getORG_PHONE();
   String getORG_FAX();
   Integer getORG_ORDERBY();
   Integer getSYS_GROUP();
   Integer getORG_STATUS();
   String getDEPT_TYPE();
   String getEMAIL();
   String getCOUNTRY_ID();
   String getPROVINCE_ID();
   String getREGION_ID();
}

public interface UltraOrganizationRepository extends JpaRepository {

     @Query(value="select o.DEPT_ID,o.DEPT_NAME,o.SUPER_ID,o.NOTE,o.STATE,o.GROUP_DNID,o.ORG_DNNAME,o.TYPE,o.APP_NAME,o.ORG_PHONE,o.ORG_FAX,o.ORG_ORDERBY,o.SYS_GROUP,o.ORG_STATUS,d.DEPT_TYPE,d.EMAIL,d.COUNTRY_ID,d.PROVINCE_ID,d.REGION_ID from SECURITY_ORGANIZATION o left join SECURITY_DEPARTMENT d on o.DEPT_ID=d.ID",nativeQuery = true)
     List findOrganDept();
}

把查出来的数据直接封装进UltraOrgan里面

 List organDept = ultraOrganizationRepository.findOrganDept();