{"id":48,"date":"2026-10-09T14:38:51","date_gmt":"2026-10-09T06:38:51","guid":{"rendered":"https:\/\/blog.pcjust.com\/?p=48"},"modified":"2026-10-10T09:04:48","modified_gmt":"2026-10-10T01:04:48","slug":"springboot2-jpa-oracle-example","status":"publish","type":"post","link":"https:\/\/www.suncl.me\/blog\/springboot2-jpa-oracle-example\/","title":{"rendered":"springboot2+jpa+oracle\u5b9e\u4f8b"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

pom.xml<\/strong><\/p>\n\n\n\n

<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n    xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\n    <modelVersion>4.0.0<\/modelVersion>\n \n    <groupId>com.example<\/groupId>\n    <artifactId>springboot-jpa-oracle-demo<\/artifactId>\n    <version>0.0.1-SNAPSHOT<\/version>\n    <packaging>jar<\/packaging>\n \n    <name>springboot-jpa-oracle-demo<\/name>\n    <description>Demo project for Spring Boot<\/description>\n \n    <parent>\n        <groupId>org.springframework.boot<\/groupId>\n        <artifactId>spring-boot-starter-parent<\/artifactId>\n        <version>2.0.5.RELEASE<\/version>\n        <relativePath\/> <!-- lookup parent from repository -->\n    <\/parent>\n \n    <properties>\n        <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\n        <project.reporting.outputEncoding>UTF-8<\/project.reporting.outputEncoding>\n        <java.version>1.8<\/java.version>\n    <\/properties>\n \n    <dependencies>\n        <dependency>\n            <groupId>org.springframework.boot<\/groupId>\n            <artifactId>spring-boot-starter-data-jpa<\/artifactId>\n        <\/dependency>\n        <dependency>\n            <groupId>org.springframework.boot<\/groupId>\n            <artifactId>spring-boot-starter-web<\/artifactId>\n        <\/dependency>\n \n        <dependency>\n           <groupId>com.oracle<\/groupId>\n         \n           <artifactId>ojdbc6<\/artifactId>\n         \n           <version>11.2.0.4<\/version>\n         \n          <\/dependency>\n        <dependency>\n            <groupId>org.springframework.boot<\/groupId>\n            <artifactId>spring-boot-starter-test<\/artifactId>\n            <scope>test<\/scope>\n        <\/dependency>\n    <\/dependencies>\n \n    <build>\n        <plugins>\n            <plugin>\n                <groupId>org.springframework.boot<\/groupId>\n                <artifactId>spring-boot-maven-plugin<\/artifactId>\n            <\/plugin>\n        <\/plugins>\n    <\/build>\n \n \n<\/project><\/code><\/pre>\n\n\n\n
\u3000\u3000application.properties<\/strong><\/p>\n\n\n\n
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:ORCL\n \nspring.datasource.username=test\n \nspring.datasource.password=test\n \nspring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver\n \nspring.jpa.properties.hibernate.hbm2ddl.auto=update\n \nspring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect\n \nspring.jpa.show-sql= true\n \nspring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl\n \nserver.port = 9000<\/code><\/pre>\n\n\n\n
\u3000\u3000domain:<\/strong><\/p>\n\n\n\n
package com.example.demo.domain;\n \nimport javax.persistence.Column;\nimport javax.persistence.GeneratedValue;\nimport javax.persistence.Id;\nimport org.hibernate.annotations.GenericGenerator;\n \n@javax.persistence.Table(name = \"t_dynasty\")\n@javax.persistence.Entity\npublic class Dynasty {\n    \/**\n     *\n     * id\n     *\n     *\/\n \n    @Id\n \n    @GenericGenerator(name = \"system-uuid\", strategy = \"uuid\")\n \n    @GeneratedValue(generator = \"system-uuid\")\n \n    @Column(name = \"id\")\n \n    private String id;\n \n    @Column(name = \"name\")\n \n    private String name;\n \n    @Column(name = \"startYear\")\n \n    private String startYear;\n \n    @Column(name = \"endYear\")\n \n    private String endYear;\n \n    @Column(name = \"age\")\n \n    private Integer age;\n \n    public String getId() {\n \n        return id;\n \n    }\n \n    public void setId(String id) {\n \n        this.id = id;\n \n    }\n \n    public String getName() {\n \n        return name;\n \n    }\n \n    public void setName(String name) {\n \n        this.name = name;\n \n    }\n \n    public String getStartYear() {\n \n        return startYear;\n \n    }\n \n    public void setStartYear(String startYear) {\n \n        this.startYear = startYear;\n \n    }\n \n    public String getEndYear() {\n \n        return endYear;\n \n    }\n \n    public void setEndYear(String endYear) {\n \n        this.endYear = endYear;\n \n    }\n \n    public Integer getAge() {\n        return age;\n    }\n \n    public void setAge(Integer age) {\n        this.age = age;\n    }\n \n}<\/code><\/pre>\n\n\n\n
\u3000\u3000repository:<\/strong><\/p>\n\n\n\n
package com.example.demo.repository;\n \nimport org.springframework.data.jpa.repository.JpaRepository;\n \nimport com.example.demo.domain.Dynasty;\n \npublic interface DynastyRepository extends JpaRepository<Dynasty, Long> {\n}<\/code><\/pre>\n\n\n\n
\u3000\u3000controller:<\/strong><\/p>\n\n\n\n
package com.example.demo.web;\n \nimport java.util.List;\n \nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.web.bind.annotation.RequestMapping;\nimport org.springframework.web.bind.annotation.RestController;\n \nimport com.example.demo.domain.Dynasty;\nimport com.example.demo.repository.DynastyRepository;\n \n@RestController\n@RequestMapping(\"\/dynasty\")\npublic class DynastyController {\n \n    @Autowired\n    private DynastyRepository dynastyRepository;\n \n    @RequestMapping(\"\/findAll\")\n    public List<Dynasty> findAll() {\n        List<Dynasty> dynastys = dynastyRepository.findAll();\n        return dynastys;\n    }\n \n    @RequestMapping(\"\/hello\")\n    public String hello() {\n        return \"success\";\n    }\n}<\/code><\/pre>\n\n\n\n
\u3000\u3000\u542f\u52a8\u7a0b\u5e8f<\/strong><\/p>\n\n\n\n
package com.example.demo;\n \nimport org.springframework.boot.SpringApplication;\nimport org.springframework.boot.autoconfigure.SpringBootApplication;\n \n@SpringBootApplication\npublic class Demo1Application {\n    public static void main(String[] args) {\n        SpringApplication.run(Demo1Application.class, args);\n    }\n}<\/code><\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
pom.xml \u3000\u3000application.properties \u3000\u3000domain: \u3000\u3000repository … <\/p>\n
\u7ee7\u7eed\u9605\u8bfb\u201cspringboot2+jpa+oracle\u5b9e\u4f8b\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.suncl.me\/blog\/wp-json\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.suncl.me\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.suncl.me\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.suncl.me\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.suncl.me\/blog\/wp-json\/wp\/v2\/comments?post=48"}],"version-history":[{"count":2,"href":"https:\/\/www.suncl.me\/blog\/wp-json\/wp\/v2\/posts\/48\/revisions"}],"predecessor-version":[{"id":63,"href":"https:\/\/www.suncl.me\/blog\/wp-json\/wp\/v2\/posts\/48\/revisions\/63"}],"wp:attachment":[{"href":"https:\/\/www.suncl.me\/blog\/wp-json\/wp\/v2\/media?parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.suncl.me\/blog\/wp-json\/wp\/v2\/categories?post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.suncl.me\/blog\/wp-json\/wp\/v2\/tags?post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}