java sql创建表,要具体的,不具体的不要回答,谢谢!!!

发布网友发布时间：2022-04-25 04:52

共3个回答

热心网友时间：2023-10-06 00:19

一个具体的创建oracle表的示例
create table EMPLOYEES
(
ID NUMBER(10),
NAME VARCHAR2(50),
BORNDATE DATE,
GENDER CHAR(1),
E_MAIL VARCHAR2(50),
PHONE VARCHAR2(20),
HIRE_DATE DATE,
MANAGER_ID NUMBER(10),
DEPARTMENT_ID NUMBER(2),
POSITION NUMBER(2)
)
tablespace PRD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 640K
minextents 1
maxextents unlimited
);
上面是用pl/sql develop 自动生成的每个不同的数据库有细微的差别

热心网友时间：2023-10-06 00:20

DROP DATABASE if exists lts;

create database if not exists lts;

USE lts;

/*管理员表*/
DROP TABLE IF EXISTS admin; /*如admin表存在则删除*/
CREATE TABLE admin (
user varchar(10) NOT NULL,
passw varchar(10) NOT NULL,
PRIMARY KEY (user)
)

热心网友时间：2023-10-06 00:20

CREATE TABLE petOwner(
id NUMBER(8,0) PRIMARY KEY NOT NULL;
name VARCHAR2(50) NOT NULL;
password VARCHAR2(50) NOT NULL;
money number(10,2) NOT NULL
);
CREATE SEQUENCE petOwner_id
START WITH 1
INCREMENT BY 1
NOMAXVALUE
CACHE 10;

CREATE TABLE petStore(
id NUMBER(8,0) PRIMARY KEY NOT NULL;
name VARCHAR2(50) NOT NULL;
password VARCHAR2(50) NOT NULL;
balance NUMBER(10,2) NOT NULL
);
CREATE SEQUENCE petStore_id
START WITH 1
INCREMENT BY 1
NOMAXVALUE
CACHE 5;

CREATE TABLE pet(
id NUMBER(8,0) PRIMARY KEY NOT NULL;
name VARCHAR2(50) NOT NULL;
typename VARCHAR2(20) NOT NULL;
health NUMBER(1,0) NOT NULL;
love NUMBER(2,0) NOT NULL;
birthday DATE NOT NULL;
owner_id NUMBER(8,0) NOT NULL;
store_id NUMBER(8,0) NOT NULL
);
CREATE SEQUENCE pet_id
START WITH 1
INCREMENT BY 1
NOMAXVALUE
CACHE 5;

ALTER TABLE pet ADD CONSTRAINT owner_id_pk FOREIGN KEY(owner_id) REFERENCES petOwner(id);
ALTER TABLE pet ADD CONSTRAINT store_id_pk FOREIGN KEY (store_id) REFERENCES petStore(id);

CREATE TABLE account(
id NUMBER(8,0) PRIMARY KEY NOT NULL;
deal_type NUMBER(1,0) NOT NULL;
pet_id NUMBER(8,0) NOT NULL;
seller_id NUMBER(8,0) NOT NULL;
buyer_id NUMBER(8,0) NOT NULL;
deal_time DATE NOT NULL
);

ALTER TABLE account ADD CONSTRAINT seller_id_pk FOREIGN KEY (seller_id) REFERENCES petOwner(id);
ALTER TABLE account ADD CONSTRAINT buyer_id_pk FOREIGN KEY (buyer_id) REFERENCES petStore(id);
ALTER TABLE account ADD CONSTRAINT pet_id_pk FOREIGN KEY (pet_id) REFERENCES pet(id);