Previous | Home | Next |
The steps of developing the Java programs that access the Oracle database.
Step 1: load the database driver and register it with the driver
manager.Class.forName(“oracle.jdbc.driver.oracleDriver”);
Step 2: In the second step we are create the connection to the database
server.Connection con = DriverManager.getConnection(“jdbc:oracle;thin:@ localhost:1521:xe”,”system”,”sam”);
Step 3: In this step you can create the statement object by giving your Oracle.
PreparedStatement stm = con.prepareStatement(“select * from sam”);
Step 4: Now you can execute the SQL query and retrieve the data in the form of ResultSet. In case of delete or update you can execute the SQL and get the information about the SQL execution like no of records deleted or modified etc.
ResultSet rset = stm.executeQuery();
Step 5: Finally you should disconnect your database
connection.Con.close();
Previous | Home | Next |