3.Interaction with RDBMS
These are the General steps to follow while usingn JDBC.
1) Load the RDBMS specific JDBC driver because this driver actually communicates with the database.
2) Open the connection to database which is then used to send SQL statements and get results back.
3) Create JDBC Statement object. This object contains SQL query.
4) Execute statement which returns resultset(s). ResultSet contains the tuples of database table as a result of SQL query.
5) Process the result set.
6) Close the connection.
Example: Retrieve list of employees from Employee table using JDBC.
1) Load the RDBMS specific JDBC driver because this driver actually communicates with the database.
2) Open the connection to database which is then used to send SQL statements and get results back.
3) Create JDBC Statement object. This object contains SQL query.
4) Execute statement which returns resultset(s). ResultSet contains the tuples of database table as a result of SQL query.
5) Process the result set.
6) Close the connection.
Example: Retrieve list of employees from Employee table using JDBC.
String url = “jdbc:odbc:” + dbName; List employeeList = new ArrayList(); //load the jdbc-odbc driver class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”); //Open a connection to database Connection con = DriverManager.getConnection(url); //create Statement object Statement stmt = con.createStatement(); //execute statement ResultSet rs = stmt.executeQuery("SELECT * FROM Sells"); while ( rs.next() ){ EmployeeBean eb = new Employeebean(); eb.setName(rs.getString("name")); eb.setSalary(rs.getFloat("salary")); employeeList.add(eb); }Reference Books: