how to connect oracle with java

whenever you want connect to any database server you have to follow the 4 steps as:

1.Register the driver(Class.forName(driverName) here oracle driver name is :
oracle.jdbc.driver.OracleDriver)

2.Get the connection(DriverManager.getConnection(url, username, password) here oracle url is:"jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid)

3.Create a statement(Statement smt=con.createStatement())

4.Execute the query(optional)

5.Close the connections(con.close())

using those steps you can connect to any database in java

to connect oracle u have to perform 2 steps
1. Establish connection
a. loading drivers: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
b. making connection
Connection con=DriverManager.connection("jdbc:odbc:<dsnname","><username>","<password>");
2. executing statements.
Statement st=con.createStatement();
st.executeUpdate("create table xyz(no number);

Note: Based on Type on Driver

to connect oracle u have to perform 2 steps
1. Establish connection
a. loading drivers: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
b. making connection
Connection con=DriverManager.connection("jdbc:odbc:<dsnname","><username>","<password>");
2. executing statements.
Statement st=con.createStatement();
st.executeUpdate("create table xyz(no number);

Note: Based on Type one Driver