基于springboot2集成jpa,创建dao的案例

<dependency>
 <groupId>org.springframework.boot</groupId>
 <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

 <dependency>
  <groupId>org.hibernate</groupId>
  <artifactId>hibernate-core</artifactId>
 </dependency>
 <dependency>
  <groupId>com.oracle</groupId>
  <artifactId>ojdbc6</artifactId>
  <version>11.2.0.4.0</version>
 </dependency>

spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@DESKTOP-46DMVCH:1521:orcl
spring.datasource.password=****
spring.datasource.username=****
spring.mvc.date-format=yyyy-MM-dd HH:mm:ss
spring.jpa.database=oracle
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
spring.datasource.log-abandoned=true
spring.datasource.remove-abandoned=true
spring.datasource.remove-abandoned-timeout=200

@NoRepositoryBean
public interface BaseRepository<T> extends JpaRepository<T,Long> {
}

public interface TbUserDao extends BaseRepository<TbUser> {
}

@Service
public class UserService {
 @Resource
 private TbUserDao userDao;
}

@NoRepositoryBean
public interface JpaRepository<T, ID> extends PagingAndSortingRepository<T, ID>, QueryByExampleExecutor<T> {
/*
  * (non-Javadoc)
  * @see org.springframework.data.repository.CrudRepository#findAll()
  */
 List<T> findAll();
 /*
  * (non-Javadoc)
  * @see org.springframework.data.repository.PagingAndSortingRepository#findAll(org.springframework.data.domain.Sort)
  */
 List<T> findAll(Sort sort);
 /*
  * (non-Javadoc)
  * @see org.springframework.data.repository.CrudRepository#findAll(java.lang.Iterable)
  */
 List<T> findAllById(Iterable<ID> ids);
 /*
  * (non-Javadoc)
  * @see org.springframework.data.repository.CrudRepository#save(java.lang.Iterable)
  */
 <S extends T> List<S> saveAll(Iterable<S> entities);
 /**
  * Flushes all pending changes to the database.
  */
 void flush();
 /**
  * Saves an entity and flushes changes instantly.
  *
  * @param entity
  * @return the saved entity
  */
 <S extends T> S saveAndFlush(S entity);
 /**
  * Deletes the given entities in a batch which means it will create a single {@link Query}. Assume that we will clear
  * the {@link javax.persistence.EntityManager} after the call.
  *
  * @param entities
  */
 void deleteInBatch(Iterable<T> entities);
 /**
  * Deletes all entities in a batch call.
  */
 void deleteAllInBatch();
 /**
  * Returns a reference to the entity with the given identifier.
  *
  * @param id must not be {@literal null}.
  * @return a reference to the entity with the given identifier.
  * @see EntityManager#getReference(Class, Object)
  * @throws javax.persistence.EntityNotFoundException if no entity exists for given {@code id}.
  */
 T getOne(ID id);
 /*
  * (non-Javadoc)
  * @see org.springframework.data.repository.query.QueryByExampleExecutor#findAll(org.springframework.data.domain.Example)
  */
 @Override
 <S extends T> List<S> findAll(Example<S> example);
 /*
  * (non-Javadoc)
  * @see org.springframework.data.repository.query.QueryByExampleExecutor#findAll(org.springframework.data.domain.Example, org.springframework.data.domain.Sort)
  */
 @Override
 <S extends T> List<S> findAll(Example<S> example, Sort sort);
}

@NoRepositoryBean
public interface PagingAndSortingRepository<T, ID> extends CrudRepository<T, ID> {
 Iterable<T> findAll(Sort var1);
 Page<T> findAll(Pageable var1);
}

@Target(ElementType.TYPE)
@Retention(RetentionPolicy.RUNTIME)
@Documented
@Inherited
@Import(JpaRepositoriesRegistrar.class)
public @interface EnableJpaRepositories {
 /**
  * Alias for the {@link #basePackages()} attribute. Allows for more concise annotation declarations e.g.:
  * {@code @EnableJpaRepositories("org.my.pkg")} instead of {@code @EnableJpaRepositories(basePackages="org.my.pkg")}.
  */
 String[] value() default {};
 /**
  * Base packages to scan for annotated components. {@link #value()} is an alias for (and mutually exclusive with) this
  * attribute. Use {@link #basePackageClasses()} for a type-safe alternative to String-based package names.
  */
 String[] basePackages() default {};
 /**
  * Type-safe alternative to {@link #basePackages()} for specifying the packages to scan for annotated components. The
  * package of each class specified will be scanned. Consider creating a special no-op marker class or interface in
  * each package that serves no purpose other than being referenced by this attribute.
  */
 Class<?>[] basePackageClasses() default {};
 /**
  * Specifies which types are eligible for component scanning. Further narrows the set of candidate components from
  * everything in {@link #basePackages()} to everything in the base packages that matches the given filter or filters.
  */
 Filter[] includeFilters() default {};
 /**
  * Specifies which types are not eligible for component scanning.
  */
 Filter[] excludeFilters() default {};
 /**
  * Returns the postfix to be used when looking up custom repository implementations. Defaults to {@literal Impl}. So
  * for a repository named {@code PersonRepository} the corresponding implementation class will be looked up scanning
  * for {@code PersonRepositoryImpl}.
  * 
  * @return
  */
 String repositoryImplementationPostfix() default "Impl";
 /**
  * Configures the location of where to find the Spring Data named queries properties file. Will default to
  * {@code META-INF/jpa-named-queries.properties}.
  * 
  * @return
  */
 String namedQueriesLocation() default "";
 /**
  * Returns the key of the {@link QueryLookupStrategy} to be used for lookup queries for query methods. Defaults to
  * {@link Key#CREATE_IF_NOT_FOUND}.
  * 
  * @return
  */
 Key queryLookupStrategy() default Key.CREATE_IF_NOT_FOUND;
 /**
  * Returns the {@link FactoryBean} class to be used for each repository instance. Defaults to
  * {@link JpaRepositoryFactoryBean}.
  * 
  * @return
  */
 Class<?> repositoryFactoryBeanClass() default JpaRepositoryFactoryBean.class;
 /**
  * Configure the repository base class to be used to create repository proxies for this particular configuration.
  * 
  * @return
  * @since 1.9
  */
 Class<?> repositoryBaseClass() default DefaultRepositoryBaseClass.class;
 // JPA specific configuration
 /**
  * Configures the name of the {@link EntityManagerFactory} bean definition to be used to create repositories
  * discovered through this annotation. Defaults to {@code entityManagerFactory}.
  * 
  * @return
  */
 String entityManagerFactoryRef() default "entityManagerFactory";
 /**
  * Configures the name of the {@link PlatformTransactionManager} bean definition to be used to create repositories
  * discovered through this annotation. Defaults to {@code transactionManager}.
  * 
  * @return
  */
 String transactionManagerRef() default "transactionManager";
 /**
  * Configures whether nested repository-interfaces (e.g. defined as inner classes) should be discovered by the
  * repositories infrastructure.
  */
 boolean considerNestedRepositories() default false;
 /**
  * Configures whether to enable default transactions for Spring Data JPA repositories. Defaults to {@literal true}. If
  * disabled, repositories must be used behind a facade that's configuring transactions (e.g. using Spring's annotation
  * driven transaction facilities) or repository methods have to be used to demarcate transactions.
  * 
  * @return whether to enable default transactions, defaults to {@literal true}.
  */
 boolean enableDefaultTransactions() default true;
}