Java Swing (2) 한국 축구 구단 관리 프로그램 (자바 스윙 프로젝트)

2022 한국 축구 구단 관리 프로그램

 

데이터베이스 테이블

---

DBMS는 오라클 이용,
DBeaver Community를 이용하여 관리했습니다.

---

SQL Sample

//식단
INSERT INTO CBAN.FOODTABLE (FOOD, DRINK)VALUES('통곡물 시리얼, 계란흰자', '콜라');
INSERT INTO CBAN.FOODTABLE (FOOD, DRINK)VALUES('통곡물 파스타,야채,구운감자,치킨샐러드', '사이다');
INSERT INTO CBAN.FOODTABLE (FOOD, DRINK)VALUES('참치롤', '제로콜라');
INSERT INTO CBAN.FOODTABLE (FOOD, DRINK)VALUES('현미밥,닭가슴살', '단백질쉐이크');
//주전 선수
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(1, '김승규', 33, 187, 84, 'GK');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(3, '김진수', 31, 177, 77, 'DF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(19, '김영권', 33, 186, 83, 'DF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(23, '김태환', 34, 177, 72, 'DF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(4, '김민재', 27, 190, 88, 'DF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(22, '권창훈', 29, 174, 66, 'MF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(5, '정우영', 34, 186, 78, 'MF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(10, '이재성', 31, 180, 70, 'MF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(11, '황희찬', 27, 177, 77, 'MF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(7, '손흥민', 31, 180, 78, 'MF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(16, '황의조', 31, 183, 73, 'FW');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(12, '송범근', 26, 194, 88, 'GK');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(21, '조현우', 32, 189, 75, 'GK');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(2, '윤종규', 25, 173, 64, 'DF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(15, '박지수', 29, 187, 77, 'DF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(20, '권경원', 31, 177, 83, 'DF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(18, '이재익', 24, 185, 78, 'DF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(8, '남태희', 32, 174, 66, 'MF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(13, '송민규', 24, 179, 72, 'MF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(6, '고승범', 29, 173, 70, 'MF');
INSERT INTO CBAN.PLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(17, '조영욱', 24, 181, 73, 'FW');
//후보 선수
INSERT INTO CBAN.SUBPLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(12, '송범근', 26, 194, 88, 'GK');
INSERT INTO CBAN.SUBPLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(21, '조현우', 32, 189, 75, 'GK');
INSERT INTO CBAN.SUBPLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(2, '윤종규', 25, 173, 64, 'DF');
INSERT INTO CBAN.SUBPLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(15, '박지수', 29, 187, 77, 'DF');
INSERT INTO CBAN.SUBPLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(20, '권경원', 31, 177, 83, 'DF');
INSERT INTO CBAN.SUBPLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(18, '이재익', 24, 185, 78, 'DF');
INSERT INTO CBAN.SUBPLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(8, '남태희', 32, 174, 66, 'MF');
INSERT INTO CBAN.SUBPLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(13, '송민규', 24, 179, 72, 'MF');
INSERT INTO CBAN.SUBPLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(6, '고승범', 29, 173, 70, 'MF');
INSERT INTO CBAN.SUBPLAYER (PN, NAME, AGE, HEIGHT, WEIGHT, "POSITION") VALUES(17, '조영욱', 24, 181, 73, 'FW');

create문 생략

 

데이터베이스 연동 작업은 'DB' 카테고리에서 추가로 작업하겠습니다.