<dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <!-- 數據庫驅動 -->
    <dependency>
      <groupId>com.oracle</groupId>
      <artifactId>ojdbc6</artifactId>
      <version>11.2.0.3</version>
    </dependency>

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

package cn.xdl.entity;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="EMP") //通常和@Entity配合使用,只能標注在實體的class定義處,表示實體對應的數據庫表的信息
public class Emp implements Serializable{
  /**
   * 
   */
  private static final long serialVersionUID = 1L;
  @Id //定義了映射到數據庫表的主鍵的屬性,一個實體只能有一個屬性被映射為主鍵置于getXxxx()前
  @Column(name="EMPNO") //name表示表的名稱默認地,表名和實體名稱一致,只有在不一致的情況下才需要指定表名
  private Integer empno;
  @Column(name="ENAME")
  private String ename;
  @Column(name="JOB")
  private String job;
  @Column(name="MGR")
  private int mgr;
  public Integer getEmpno() {
    return empno;
  }
  public void setEmpno(Integer empno) {
    this.empno = empno;
  }
  public String getEname() {
    return ename;
  }
  public void setEname(String ename) {
    this.ename = ename;
  }
  public String getJob() {
    return job;
  }
  public void setJob(String job) {
    this.job = job;
  }
  public int getMgr() {
    return mgr;
  }
  public void setMgr(int mgr) {
    this.mgr = mgr;
  }
  @Override
  public String toString() {
    return "Emp [empno=" + empno + ", ename=" + ename + ", job=" + job + ", mgr=" + mgr + "]";
  }
}

package cn.xdl.jpa;

import org.springframework.data.jpa.repository.JpaRepository;

import cn.xdl.entity.Emp;
//JpaRepository:JPA資源庫
/**
 * 1.所有繼承該接口的都被spring所管理，改接口作為標識接口，功能就是用來控制domain模型的
 * 2.Spring Data可以讓我們只定義接口，只要遵循spring data的規范,無需寫實現類。 
 *
 */
public interface EmpDao extends JpaRepository<Emp, Integer>{

}

@SpringBootApplication
public class MyBootApplication {
  public static void main(String[] args) throws SQLException {
    ApplicationContext ioc = SpringApplication.run(MyBootApplication.class, args);
    // 自動配置創建DataSource，id名為dataSource
    DataSource ds = ioc.getBean("dataSource", DataSource.class);
    System.out.println(ds);
    System.out.println("=================");
    System.out.println("=================");
    System.out.println("=================");
    EmpDao empDao = ioc.getBean("empDao", EmpDao.class);
    /**
     * 遍歷
     */
    List<Emp> empdatas = empDao.findAll();
    for (Emp emp : empdatas) {
      System.out.println(emp);
    }
  }
}