ResultSet in JDBC- Types and Use

java.sql.ResultSet is an interface that can hold the records from the database. Types of ResultSet in JDBC ResultSet in JDBC can be of 3 types and can be defined while creation of t

Read More →

Scrollable ResultSet in JDBC example

A normal ResultSet object can only move in forward direction. But using the ResultSet.TYPE_SCROLL_SENSITIVE we can create Scrollable Resultset in JDBC. What is Scrollable Resultset in JDBC Scrollab

Read More →

Update Record using ResultSet in JDBC

We know that ResultSet objects are used to get the data that is retrieved using a Select statement. ResultSet can also be used to insert or update records in the database. Steps to remember when yo

Read More →

Insert Record using ResultSet in JDBC

We know that ResultSet objects are used to get the data that is retrieved using a Select statement. ResultSet can also be used to insert or update records in the database. Steps to remember when yo

Read More →

ResultSetMetaData in JDBC example

The object of java.sql.ResultSetMetaData can be used to get the details of the columns available in the ResultSet object. Some of the important methods of ResultSetMetaData are [crayon-672a

Read More →

Connect to Oracle Database using JDBC

In this post we will see the sample code to connect to Oracle Database using JDBC drivers in java. For connecting to Oracle database we will need the following 1. Connection URL The format is [cray

Read More →