erc-example

This project is simple project and about patient

Using Tools & Technologies

Java 
Oracle db
Swing
Jdbc

Sql query

	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