4/13/23, 9:57 AM Java Database Connectivity with Oracle - javatpoint
[Link]
3 min read
Java Database Connectivity with Oracle -
javatpoint
To connect java application with the oracle database, we need to follow 5 following steps.
In this example, we are using Oracle 10g as the database. So we need to know following
information for the oracle database:
1. Driver class: The driver class for the oracle database is
[Link].
2. Connection URL: The connection URL for the oracle10G database is
jdbc:oracle:thin:@localhost:1521:xe where jdbc is the API, oracle is the
database, thin is the driver, localhost is the server name on which oracle is running,
we may also use IP address, 1521 is the port number and XE is the Oracle service
name. You may get all these information from the [Link] file.
3. Username: The default username for the oracle database is system.
4. Password: It is the password given by the user at the time of installing the oracle
database.
Create a Table
Before establishing connection, let's first create a table in oracle database. Following is
the SQL query to create a table.
1. create table emp(id number(10),name varchar2(40),age number(3));
Example to Connect Java Application with Oracle database
[Link] 1/4
4/13/23, 9:57 AM Java Database Connectivity with Oracle - javatpoint
In this example, we are connecting to an Oracle database and getting data from emp
table. Here, system and oracle are the username and password of the Oracle database.
1. import [Link].*;
2. class OracleCon{
3. public static void main(String args[]){
4. try{
5.
6. [Link]("[Link]");
7.
8.
9. Connection con=[Link](
10. "jdbc:oracle:thin:@localhost:1521:xe","system","oracle");
11.
12.
13. Statement stmt=[Link]();
14.
15.
16. ResultSet rs=[Link]("select * from emp");
17. while([Link]())
18. [Link]([Link](1)+" "+[Link](2)+" "+[Link](3));
19.
20.
21. [Link]();
22.
23. }catch(Exception e){ [Link](e);}
24.
25. }
26. }
The above example will fetch all the records of emp table.
To connect java application with the Oracle database [Link] file is required to be
loaded.
[Link] 2/4
4/13/23, 9:57 AM Java Database Connectivity with Oracle - javatpoint
Two ways to load the jar file:
1. paste the [Link] file in jre/lib/ext folder
2. set classpath
1) paste the [Link] file in JRE/lib/ext folder:
Firstly, search the [Link] file then go to JRE/lib/ext folder and paste the jar file here.
2) set classpath:
There are two ways to set the classpath:
temporary
permanent
How to set the temporary classpath:
Firstly, search the [Link] file then open command prompt and write:
1. C:>set classpath=c:\folder\[Link];.;
How to set the permanent classpath:
Go to environment variable then click on new tab. In variable name write classpath and
in variable value paste the path to [Link] by appending [Link];.; as
C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\[Link];.;
Video Player is loading.
Current Time 0:00
Duration 0:00
[Link] 3/4
4/13/23, 9:57 AM Java Database Connectivity with Oracle - javatpoint
Remaining Time 0:00
To see the slides of seting parmanent path click here
Generated with Reader Mode
[Link] 4/4