DBMS와 JDBC Driver 준비

오라클 DBMS
: Oracle Database 18c Express Edition for Windows x64
download.oracle.com/otn/nt/oracle18c/180000/OracleXE184_Win64.zip

https://login.oracle.com:443/oam/server/obrareq.cgi?encquery%3DC32hIgzvYYYjFnHK%2F16WRy0kdsoGRCSzhCBUlxytyISmc20RWckhvWBhUy%2FOglfBccnxkkAxEzNA8jcrEdkO5nHMKoR2vm%2BuoYMT2Pijyh9zzr89tCK1x5owDHEX8kp06ccJm%2FggGKJ%2FTZxDLl%2B%2BmogngSeOSSjJ%2BlcbI8PLBM08qJfjBqJ0uyi2Of4fAFaNTFbnALadAEsnL3XlOcSllL12pUoLQwwrdsYTK9yPtIM7JC1NM2DPHEEUYfL990YV9ovHP4sCU79dNYVF4y%2Bu%2FLn9xnwOHe8uID6FYo9IbQYw1kkzsE4jtC00MdbDPfNj24tRZrfpqkBugws2KY95SK0lIKPTSSQqkWZRGaVOKEEx6qRa8ookCOSDh9Yvck9agsogyMyXW8hB90hHpbVWywCZdKVcnrh3YYPJNBT0SzU%3D%20agentid%3Dedelivery-extprod%20ver%3D1%20crmethod%3D2&ECID-Context=1.005kFDBPVFLFo2KimTctkJ0007uf00ArU_%3BkXjE

www.youtube.com/watch?v=aDTiSKcMtoc&list=PLq8wAnVUcTFVq7RD1kuUwkdWabxvDGzfu&index=2

 

SQL plus 사용

설치된 프로그램을 실행
사용자명 입력: sys as sysdba
비밀번호 입력: 자신이 설정한 비밀번호

 

JDBC Driver 설치
: ojdbc8.jar
download.oracle.com/otn/utilities_drivers/jdbc/183/ojdbc8.jar

https://login.oracle.com:443/oam/server/obrareq.cgi?encquery%3DOSqjs8ce0nR6bhurd5OwhHQV7I%2BqOk9%2Fgf2S4V8uhLihCRFJY9Og0oSZAmZH25VYiL3XmH4jcECK5nzxGvFcf%2F37kYs9ahu%2FIJmbi3wnLkQrDqfNXCvJ6MfQEjmg4Y6w9taPjZUvjQRTg6m7aL08CL3fiBXFSoBHhBaz3yDsikhImXUJOJG4%2BrlYWS0PBTID8MUnUaxVh4TEycQkerKw1jUOAd7ljCki%2BYoiagAwxW7UTFB%2ByvdLbfg%2BH9w14p08ba7GjfJ%2BXrDeV7q9sSuZIvnX%2BzRPvdkwHzeLkkJULW8V%2BPayTszGTC2Mpjp3sXfNedhPba59Kn9cjd4fYLBlE1M9Qvg6UxHZfa2MuQaXk5I4QyQ5ArMu9G%2F%2FupfI9DdtVzGe6GqWSCswoP4AiCULrgqCDXAn0VGacLNnLm2Zf0Q%3D%20agentid%3Dedelivery-extprod%20ver%3D1%20crmethod%3D2&ECID-Context=1.005kFD5Tkq7Fo2KimTctkJ0007uf005QK8%3BkXjE

JDBC Driver 설정방법

Properties -> Java Build Path -> Libraeries -> Add External JARs... -> find: ojdbc8.jar -> Oepn

 

테스트화면

자바프로젝트생성(JDBCPrj) -> Class생성(package: ex, name: Program.java) -> 코드작성: Connection con;