This project is simple project and about patient
Java
Oracle db
Swing
Jdbc
CREATE TABLE AAPATIENT
(
patientid NUMBER(19,0) NOT NULL ENABLE,
name VARCHAR2(255 CHAR),
lastname VARCHAR2(255 CHAR),
age VARCHAR2(255 CHAR),
gender VARCHAR2(255 CHAR),
city VARCHAR2(255 CHAR),
status NUMBER(10,0),
PRIMARY KEY (patientid)
);
CREATE TABLE "AVC237"."AAPATIENT"
( "PATIENTID" NUMBER(19,0) NOT NULL ENABLE,
"NAME" VARCHAR2(255 CHAR),
"LASTNAME" VARCHAR2(255 CHAR),
"AGE" VARCHAR2(255 CHAR),
"GENDER" VARCHAR2(255 CHAR),
"CITY" VARCHAR2(255 CHAR),
"STATUS" NUMBER(10,0),
PRIMARY KEY ("PATIENTID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE
) SEGMENT CREATION IMMEDIATE
CREATE SEQUENCE AA_PATIENT_SEQ START WITH 1 INCREMENT BY 1
INSERT INTO AAPATIENT VALUES (1,'Can','Yücel','51','Male','Zonguldak')
INSERT INTO AAPATIENT VALUES (2,'Harun ','tunay','5','Male','Ankara')
INSERT INTO AAPATIENT VALUES (3,'Firidevs','tunay','6','Female','Kayseri')
SELECT * FROM AAPATIENT ORDER BY PATIENTID
SELECT AA_PATIENT_SEQ.NEXTVAL FROM DUAL