JDBC

JDBC Projects

JDBC Project 1

adplus-dvertising
Step of the connectivity with Oracle
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