ResultSet In Java

ResultSet In Java

In this section we will learn about the ResultSet in Java. We will read here about how to retrieve and modify the values from result sets. In this section we will also discuss about the various methods that are mostly used in to get the value.

ResultSet contains the data of a table after executing the SQL queries. Object of ResultSet also maintains the current position of the cursor to the current row. ResultSet provides next() method to move cursor in forward direction. next() method returns false when the cursor reached at the last row and the previous() method moves the cursor to the previous row. ResultSet object is automatically closed if the Statement/PreparedStatement object is committed to close, re-executed.

Commonly Used Methods Of ResultSet Object

The above method summary explains few of the methods. Many of the methods of ResultSet object are overloaded such as, methods that are used to retrieve the value as primitive data type value are overloaded as datatype getXXXX(datatype columnLabel) { The parameter columnLabel specifies the name of the field of the database table} for example, int getInt( columnLabel)

Example

Here I am giving a simple example which will demonstrate you about how to use the ResultSet in Java. In this example you will see how I have created the ResultSet and keept the database data after querying the SQL. For this we have to create a database table using a DBMS (I will use MySQL) and then we will insert some data into it and then we will create a Java Class where we will display the data stores in the result set.

ResultSetExample.java

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class ResultSetExample {
	
	String driverName = "com.mysql.jdbc.Driver";
	String url = "jdbc:mysql://localhost:3306/record";
	String user = "root";
	String password = "root";
	
	Connection conn= null;
	PreparedStatement ps = null;
	ResultSet rs = null;
	
	String sql = "SELECT * FROM attendance";
	
	public void getData()
	{		
		try{
			Class.forName(driverName);			
		}
		catch(ClassNotFoundException cnfe)
		{
			System.out.println(cnfe);
		}
		
		try
		{
			conn = DriverManager.getConnection(url, user, password);
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			System.out.println("Date \t\t Id \t Name \t Status");
			while(rs.next())
			{
				String date = rs.getString(1);
				String id = rs.getString(2);
				String name = rs.getString(3);
				String status = rs.getString(4);
				System.out.println(date+"\t "+id+"\t"+name+"\t"+status);
				
			}
		}
		catch(SQLException sqle)
		{
			System.out.println(sqle);
		}		
	}
	public static void main(String args[])
	{
		ResultSetExample rse = new ResultSetExample();
		rse.getData();
	}
}

Output

When you will compile and execute the ResutlSetExample.java then the output will be as follows :

Download Source Code