Rewrite the example shown in Figure 8-5 using VB.NET. import java.sql.*; public class TestJDBC { public static

Rewrite the example shown in Figure 8-5 using VB.NET.

Transcribed Image Text:

import java.sql.*; public class TestJDBC { public static void main(String[] args) { try { Driverd = (Driver)Class.forName("oracle.jdbc.driver.OracleDriver").newlnstance( ); System.out.println(d); DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver( );L Connection conn = Register the driver to be used. Identify the type of driver to be used. DriverManager.getConnection ("jdbc:oracle:thin:@durga.uits.indiana.edu:1 521:OED1", args[O], args[1]); Open a connection to a database. Create a Statement variable that can Statement st = conn.createStatement( ;< ResultSet rec = st.executeQuery("SELECT * FROM Student"); while(rec.next( )) { System.out.println(rec.getString("name"):) conn.close( );< be used to issue queries against the database Issue a query and get a result. catch (Exception e) { System.out.printin("Error – " + e); Process the result, one row at a time. Close the connection.