Skip to main content

Q) Explain the architecture of ResultSet?



A)
->A Resultset is divided into 3 parts.

1) Zero record area
2) Records area
3) No record area

->when the resultSet is open a logical pointer known as “cursor” points to zero record area.
->when cursor is pointing to zero record or no record area we should not process the record.     We get SQL Exception.
->java.sql.ResultSet object has around 15 methods to deal with cursor.
->next() method is most frequently used method.
->when next() method is called on ResultSet object, 2 things happen in the background.
  1) Cursor is moved in forward direction by one record area.
  2) It returns true if record exists there otherwise false.
->To process the record, i.e. to retrieve the record each column value of the record (row) of the ResultSet object, getxxx() methods are available. These methods take column member in the ResultSet records as argument and return the column value. Relational table column type influences the kind of getxxx method we need to call on ResultSet object.

Some example for getxxx() methods :
getFloat()
getString()
getInt()
getBytes()

Comments

Post a Comment

Popular posts from this blog

Q) Explain repeated deletion of records.

A) //RepeatedDeletion.java import java.util.Scanner; import java.sql.*; class RepeatedDeletion {        public static void main(String[] args) {               Connection con= DriverManager. getConnection ( "jdbc:odbc:prince" , "scott" , "tiger" );               PreparedStatement ps=con.PreparedStatement( "DELETE FROM ACCOUNT WHERE ACCNO=?" );               Scanner s= new Scanner(System. in );               while ( true )               {                      System. out .println( "Enter accno : " );      ...
Post a Comment
Read more

Introduction

1) What is not JDBC? 2) What is the purpose of JDBC? 3) What is ODBC? 4) What is JDBC? 5) What is JDBC architecture? 6) What is JDBC client? What are its responsibilities? 7) What is JDBC API?  8) What is driver manager? 9) What is JDBC driver? What is its role in java database connection? 10) What is database server?
Post a Comment
Read more

Q) Explain about nested classes?

A) ->defining a class with in another class is known as nesting of the class. Ex: class A {        class B        {                      } //nested class, and inner class.because it is not static class. } //enclosing class or outer class. ->static class is declared in inside an another class then it does not become an inner class. Note: non-static nested class is known as “inner class”. In the above example class B is nested but not an inner class. Ex: class D {        static c        {                      } //nested class, but not an inner class , because of static class. } //outer class. ->we have three different kinds of inner classes. 1) Member inner class 2) Meth...
Post a Comment
Read more