五、springboot(二)配置数据源oracle
2024-09-12 05:32:38
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::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 #、无修改命名 spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl #、遇到大写字母 加”_”的命名 #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"; } }
最新文章
- godaddy域名使用DNSPod做DNS解析图文教程
- [PHP] - Laravel - 用户登陆中间件
- GraphicsMagick+Im4Java在windows和linux下的配置
- 爱上MVC系列~前端验证与后端数据有效性验证
- centos7.0 没有netstat 命令问题
- jquery_dialog实现效果
- struts2 获取前台表单的值?? 原理??
- [转]Oracle 多行的数据合并
- Python 同时for遍历多个列表
- HW5.31
- 九度OJ 1468 Sharing -- 哈希
- UIAlertController使用的一个坑
- 七、适配器(Adapter)模式--结构模式(Structural Pattern)
- C#DataTable学习心得
- mongoDB高级查询$type4array使用解析
- Python 的第一个小程序
- DevExpress v18.2版本亮点——Reporting篇(三)
- 用户态使用 glibc/backtrace 追踪函数调用堆栈定位段错误【转】
- (8)Python判断结构
- MVC5使用EF6 Code First--创建EF数据模型(一)