Skip to main content

JDBC FAQ Part10

20: What is ment by ResultSet and What are the types of ResultSets are available in JDBC application?

            In jdbc applications ResultSets could be classified in the following two ways.
  • On the basis of ResultSet privilizations (Concurancy):- 

There are 2 types of ResultSets.
    • Read only ResultSet
    • Updatable ResultSet
Read only ResultSet:-   It is a ResultSet, which will allow the users to read the        data only. To refer this ResultSet, we will use the following constant from ResultSet interface.
                        public static final int CONCUR_READ_ONLY;
 Updatable ResultSet:-  If is a ResultSet object, which will allow users to perform some updations on its content. To refer this ResultSet we will use the following constant from ResultSet interface.
                        public static final int CONCUR_UPDATABLE;
2)On the  basis of  the ResultSet cursor movement:-
There are 2 types of ResultSets.
    • Forward  only ResultSet
    • Scrollable ResultSet
Forward only ResultSet:-  It is a ResultSet object, which will allow the users to iterate the data in any forward direction. To refer this ResultSet object we will use the following  constant from ResultSet interface.
                        public static final int TYPE_FORWARD_ONLY;
Scrollable ResultSet:-  These are the ResultSet objects, which will allow the users to iterate the data in both forward and backward directions.
            There are 2 types of Scrollable ResultSets.

  • Scroll sensitive ResultSets
  • Scroll in sensitive ResultSets.
21:  What is the difference between ScrollSensitive ResultSet  and ScrollInsensitive  ResultSets?
Ans:  Scroll sensitive ResultSet is a ResultSet object, which will allow the later updations from database automatically after creating it. To refer this ResultSet we will use the following constant.
            public static final int TYPE_SCROLL_SENSITIVE;
            Scroll insensitive ResultSet is a ResultSet object, which will not allow later updations from database after creating it. To refer this ResultSet we will use the following constant from ResultSet interface.
  • public static final int TYPE_SCROLL_INSENSITIVE;
22:What is the default ResultSet type in JDBC application and How it is possible to create a specific type of ResultSet object?
  • The default ResultSet type in the jdbc applications is Read only and forward only.
  • In jdbc applications we are able to specify the following types of the ResultSet combination to any particular ResultSet.

    • read-only, forward only
    • read-only, scroll sensitive
    • read-only, scroll insensitive
    • updatable, forward only
    • updatable, scroll sensitive
    • updatable, scroll insensitive
  • if we want to specity a particular type to the ResultSet object then we should use either of the above constants combination as a parameter to createStatement() method, for this we will use the following method.

public Statement createStatement(int forward / ScrollSensitive / ScrollInsensitive, int  readonly / updatable)
Eg: Statement st = con. createSensitive(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = con.executeQuery(….);

Comments

Post a Comment

Popular posts from this blog

Applications of Insulating Materials

All electrical systems require some kind of insulation to prevent short circuits and leaking currents. 3 forms of insulators: solid, liquid and gaseous Performance of these insulators depend on the temperature Classification according to their temperature rating. Impregnation: Letting the solid material absorb some liquid With the advent of new materials, the classification has been modified by International Electrotechnical Commission: The transformer insulation: (a) conductor or turn-to-turn insulation, (b) coil-to-coil insulation, (c) low voltage coil-to-earth insulation, (d) high voltage coil-to-low voltage coil insulation, and (e) high voltage coil-to-ground insulation. Transformer oil -- provides the required dielectric strength and insulation -- cools the transformer by circulating itself through the core and the coil structure. -- should be in the liquid state over the complete operating range of temperatures between -40°C and+50°C. -- gets o...
15 comments
Read more

MULTILEVEL INVERTER

                                       MULTILEVEL INVERTER Historical Review From the late nineteenth century through the middle of the twentieth century, DC-to-AC   power conversion   was accomplished using   rotary converters   or   motor-generator   sets (M-G sets). In the early twentieth century,   vacuum tubes   and   gas filled tubes began to be used as switches in inverter circuits. The most widely used type of tube was the   thyratron . The origins of electromechanical inverters explain the source of the term   inverter . Early AC-to-DC converters used an induction or synchronous AC motor direct-connected to a generator (dynamo) so that the generator's commutator reversed its connections at exactly the right moments to produce DC. A later development is the synchronous converter, in which the motor and generator windin...
Post a Comment
Read more

JSTL-JSP Standard Tag Library part 2

Evolution of JSTL-JSP Standard Tag Library As JSP grew in popularity, it became clear that different sites' custom tags fell into familiar, frequently used patterns. For example, many pages needed to loop over data to print tables and lists. Vendors of JSP containers and members of the open-source community tried to address these needs by providing collections of tags --tag libraries--that solved common problems. While many JSP page authors used these libraries, nothing tied them together. To address this fragmentation, the Java Community Process --the same group that now maintains and standardizes JSP itself --decided to offer a standard tag library. JSTL 1.0, to include tags for the following common tasks:          •Looping over data to produce tables, lists, etc.          •Conditional operations          •Importing and processing data from other web pages         ...
Post a Comment
Read more