一个快速的JPA + Oracle序列示例,仅供参考。
1. Oracle数据库
发出以下SQL脚本以创建表和序列。
CREATE TABLE CUSTOMER(
ID NUMBER(10) NOT NULL,
NAME VARCHAR2(100) NOT NULL,
EMAIL VARCHAR2(100) NOT NULL,
CREATED_DATE DATE NOT NULL,
CONSTRAINT CUSTOMER_PK PRIMARY KEY (ID)
);
CREATE SEQUENCE customer_seq
MINVALUE 1
MAXVALUE 9999999999
START WITH 4
INCREMENT BY 1;
2. JPA
在Java中,添加JPA注释,如下所示:
Customer.java
package com.mkyong.model;
import javax.persistence.*;
import java.util.Date;
@Entity
public class Customer {
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "CUST_SEQ")