0
1.4kviews
written 6.8 years ago by |
There are some steps you have to follow for java and oracle db connectivity.
1) Load Driver class
2) Create Connection Object
3) Set user name and password of oracle
4) Create Statement object
5) Execute query
6) Close connection object
Let's understand by an example
First, create table in oracle db by using below command
create table student(rollno number(10), name varchar2(40));
In the below program system is the default user name of oracle db and mca is a password of oracle db.
import java.sql.*;
class FetchAllRecords {
public static void main(String args[]) {
try {
//Step 1, load driver class
Class.forName("oracle.jdbc.driver.OracleDriver");
//Step2, create connection object
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "mca");
//Step3, create statement
Statement stm = con.creatStatement();
//Step 4 , execute query
ResultSet rs = stm.executeQuery("select * from student");
while(rs.next()) {
System.out.println(rs.getInt(1)+" " +rs.getString(2));
}
//Step 5, close connection object
con.close();
}
catch(Exception e) {
System.out.println(e);
}
}
}