Let's learn java programming language with easy steps

Friday, 2 February 2018

Java ResultSet Interface in JDBC with Example

What is ResultSet in JDBC?

Java ResultSet Interface in jdbc with example

Java ResultSet is an interface in jdbc which extends Wrapper and AutoCloseable interfaces.

ResultSet is used to retrieve SQL select query result.

A ResultSet object maintains a cursor pointing to its current row of data in the table. Initially, the cursor positioned before the first row. 

ResultSet is not updatable and by default, the object of Resultset can be moved only forward direction.

But we can move the object of ResultSet interface in both direction i.e forward and backward direction by using TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE in createStatement method and make the object updatable by using below statement.

Statement stm = con.createStatement(

ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);  


Method of ResultSet Interface in Java

There are some methds of java jdbc ResultSet interface which is mostly used in jdbc programs.

1) public boolean next()

It is used to move the cursor to the one row next from the current position.

2) public boolean previous()

It is used to move the cursor to the one row previous from the current position.

3) public boolean first()

It is used to move the cursor to the first row in result set object.

4) public boolean last()

It is used to move the cursor to the last row in result set object.

5) public boolean absolute(int row)

It is used to move the cursor to the specified row number in the result set object.

6) public boolean relative(int row)

It is used to move the cursor to the relative row number in the result set object and it may be positive and negative.

7) public int getInt(int columnIndex)

It is used to return the data of specified column index of the current row as an int.

8) public int getInt(String columnName)

It is used to return the data of specified column name of the current row as an int.

9) public String getString(int columnIndex)

It is used to return the data of specified column index of the current row as String.

10) public String getString(String columnName)

It is used to return the data of specified column name of the current row as String.

Let's simple example of java jdbc ResultSet interface.

Suppose there is a student table in the oracle database with the rollno and name column.

You can read this post : Oracle Database Connection in Java and Jdbc Statement interface.


Java ResultSet Example

In this ResultSet example, We will fetch all the records from the student table by using select query.

import java.sql.*;
class ResultSetExample
{
public static void main(String args[])
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","system","bca");

Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery("select * from student");

while(rs.next());
{
System.out.println(rs.getInt(1)+" "+rs.getString(2));
}
}

catch(Exception e)
{
System.out.println(e);
}
}
}

Read More:

How to Connect Java Program with MySql Database.
Steps to Connect to Database in Java.
Java Interface Concept with Examples.
Some Basic Java Programs for Beginners.
Star Pattern Programs in Java.
Alphabet Pattern Programs in Java.

The above java jdbc ResultSet example will fetch all the records from the student table.

Share:

6 comments:

  1. Thank you for this jdbc and other java tutorials.

    ReplyDelete
  2. Very Nice.. Really good for the Java developer. These question student in Java Training for getting placement.

    ReplyDelete
  3. Hi, Very Nice Article.
    Thanks For The Sharing.

    ReplyDelete
  4. CIITN is the Best Php training institute in Noida and delhi Ncr. You will get Live Project Training on PHP by our PHP expert who have 5+ year industrial experience.Focus on practical and live project training. In our PHP training, we you will learn core PHP, advance PHP, HTML, CSS, JavaScript, jQuery, Bootstrap, Cake PHP and Wordpress.CIITN provides 100% job assistance in PHP training. CIITN is well known PHP coaching center because our 100% PHP students are placed now.


    Ciitnoida provides Core and java training institute in noida. We have a team of experienced Java professionals who help our students learn Java with the help of Live Base Projects. The object-oriented, class-based build of Java has made it one of most popular programming languages and the demand of professionals with certification in Advance Java training is at an all-time high not just in India but foreign countries too.

    By helping our students understand the fundamentals and Advance concepts of Java, we prepare them for a successful programming career. With over 13 years of sound experience, we have successfully trained hundreds of students in Noida and have been able to turn ourselves into an institute for best Java training in Noida.


    java training institute in noida
    php training in noida
    linux training in noida
    linux institute in noida
    java course in noida

    ReplyDelete
  5. CIITN is the Best Php training institute in Noida and delhi Ncr. You will get Live Project Training on PHP by our PHP expert who have 5+ year industrial experience.Focus on practical and live project training. In our PHP training, we you will learn core PHP, advance PHP, HTML, CSS, JavaScript, jQuery, Bootstrap, Cake PHP and Wordpress.CIITN provides 100% job assistance in PHP training. CIITN is well known PHP coaching center because our 100% PHP students are placed now.


    Ciitnoida provides Core and java training institute in noida. We have a team of experienced Java professionals who help our students learn Java with the help of Live Base Projects. The object-oriented, class-based build of Java has made it one of most popular programming languages and the demand of professionals with certification in Advance Java training is at an all-time high not just in India but foreign countries too.

    By helping our students understand the fundamentals and Advance concepts of Java, we prepare them for a successful programming career. With over 13 years of sound experience, we have successfully trained hundreds of students in Noida and have been able to turn ourselves into an institute for best Java training in Noida.


    java training institute in noida
    php training in noida
    linux training in noida
    linux institute in noida
    java course in noida

    ReplyDelete
  6. CIIT Noida provides Best MCA Courses in Noida based on the current

    IT industry standards that help students to get high paying jobs in Top MNCs. CIIT provides Best MCA Training in Noida, Greater Noida, and Ghaziabad.

    CIIT is one of the trusted MCA training institutes in Noida providing practical knowledge and 100% job assistance with basic as well as advanced

    level MCA subjects. CIITN is the best MCA college in Noida, greater noida, ghaziabad, delhi, gurgaon regoin.

    At CIIT MCA classes in Noida is conducted by subject experts corporate professionals with 9+ years of experience in managing real-time and live

    projects. Sofracle Nano Specialized MCA classes Noida is the perfect blend of academic learning and practical sessions to provide maximum exposure to

    students that transform an average student into a corporate professional whom companies prefer to hire.

    Best MCA College in Noida

    ReplyDelete

Facebook Page Likes

Follow javatutorial95 on Google+

Follow javatutorial95 on twitter

Popular Posts

Get Updates By Email

Link

Translate