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
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
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
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
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
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
Difference between Statement PreparedStatement and CallableStatement
Statement PreparedStatement and CallableStatement are interfaces of JDBC that are used to interact with the Database, either to execute the insert’s, updates, deletes or to call a stored proc
CallableStatement example with IN OUT parameters
CallableStatement in JDBC is used to execute Stored Procedures. A Stored Procedure can have 3 types of parameters 1. IN – is input parameter to the procedure 2. OUT – is output paramete
Batch Processing using Prepared Statement in Java
Batch processing is a feature in JDBC used to club multiple SQLs and send it to database in one call. You can get more details on Batch Processing here Advantages of Batch processing 1. Performance
Delete record using Prepared Statement in Java
PreparedStatement is an interface and has pre-compiled SQL statements. PreparedStatements are used to efficiently execute the same SQL statement multiple times. They are also used to set the parame