Software required for this tutorials are NetBeans IDE & Oracle Database XE which should already installed at your computer and Oracle JDBC Thin Driver.
Oracle JDBC Thin driver is platform independent because it is based on Java language. It is standalone driver which does not require other Oracle libraries for connection with Oracle database, it allows a direct connection with Database. Oracle JDBC Thin driver file " ojdbc7.jar can save before the connection established process or during the process. We will download file during connection process.
Lets start, Open the NetBeans IDE, open the Services tab as showing in below picture. Right click on Database node and click on New Connection
A window has opened, where Drive options are given to select for connection with your desired database server. We shall select Oracle Thin for Oracle Database XE as showing in below picture. Click next for further step
Driver Name Oracle Thin (with Service ID (SID))
If your database is installed on an other computer, provide that computer IP address or resolvable hostname.
Port 1521 (default)
Service ID (SID) XE (default SID for Oracle Database XE).
Service ID can be different for different database instance, in this case ask the database administrator to provide desired database SID.
For our tutorial, enter system as username (default database administrator account) and password that you used during database installation like abc@123.
Username Enter the username.
Password Enter the password for the selected username.