五、springboot（二）配置数据源oracle

1、添加依赖

 

<!-- jpa -->

  　<dependency>

   <groupId>org.springframework.boot</groupId>

   <artifactId>spring-boot-starter-data-jpa</artifactId>

  </dependency>

  <!-- oracle数据库驱动 start -->

  <dependency>

   <groupId>com.oracle</groupId>

   <artifactId>ojdbc6</artifactId>

   <version>11.2.0.3</version>

  </dependency>　　

 

2、在application.properties中添加数据源

　　

#db 单数据源

   spring.datasource.url=jdbc:oracle:thin:@localhost:1521:ORCL

　　spring.datasource.username=root

　　spring.datasource.password=root

　　spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver

　　spring.jpa.properties.hibernate.hbm2ddl.auto=update

　　spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

　　spring.jpa.show-sql= true

　　#1、无修改命名

   spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

　　#2、遇到大写字母 加”_”的命名

　　#spring.jpa.hibernate.naming.physical-strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy

 

 

 

3、创建实体类主键采用UUID策略

 

 

 

javax.persistence.Table(name = "t_dynasty")@javax.persistence.Entity

public class Dynasty {

 

/**

* id

*/

@Id

@GenericGenerator(name ="system-uuid", strategy = "uuid")

@GeneratedValue(generator = "system-uuid")

@Column(name = "id")

private String id;

 

@Column(name = "name")

private String name;

 

@Column(name = "startYear")

private String startYear;

 

@Column(name = "endYear")

private String endYear;

 

@Column(name = "age")

private Integer age;

 

public String getId() {

return id;

}

 

public void setId(String id) {

this.id = id;

}

 

public String getName() {

return name;

}

 

public void setName(String name) {

this.name = name;

}

 

public String getStartYear() {

return startYear;

}

 

public void setStartYear(String startYear) {

this.startYear = startYear;

}

 

public String getEndYear() {

return endYear;

}

 

public void setEndYear(String endYear) {

this.endYear = endYear;

}

 

public Integer getAge() {

return age;

}

 

public void setAge(Integer age) {

this.age = age;

}

 　　

}

 

 

4、创建对应的接口repository继承JpaRepository<K,V>

　　

  

public interface DynastyRepository extends JpaRepository<Dynasty, Long>{

 

}

 

5、创建相应的接口调用

　　

  

@RestController

@RequestMapping("/dynasty")

public class DynastyController {

 

 @Autowired

 private DynastyRepository dynastyRepository;

 

 @RequestMapping("/hello")

 public String hello() {

  return "success";

 }

 

 @RequestMapping("/findAll")

 public List<Dynasty> findAll() {

  List<Dynasty> dynastys =dynastyRepository.findAll();

  return dynastys;

 }

 

 @RequestMapping("/save")

 public String save(Dynasty dynasty) {

  dynastyRepository.save(dynasty);

  return "success";

 }

}