java.sql(JDBC)

DatabaseMetaData is a JDBC interface used to obtain information about the database, JDBC driver, tables, columns, and supported database features. It is obtained from a Connection object using the getMetaData() method. Using DatabaseMetaData, a Java program can dynamically inspect database information without directly querying system tables. This is useful for database administration, debugging, database migration […]

ResultSetMetaData and DatabaseMetaData are JDBC interfaces used to obtain information about database results and the database itself. ResultSetMetaData provides information about the columns returned by a query, such as column names, data types, and number of columns. DatabaseMetaData provides information about the database, JDBC driver, tables, supported features, and database capabilities. Both are useful when

Program 1: Display All Employee Records Using Statement This program retrieves all employee records from the database using the Statement interface. The executeQuery() method executes the SELECT query and returns the records through a ResultSet. Program 2: Insert Employee Using Statement This program inserts a new employee record using the Statement interface. The executeUpdate() method

Program 1: Batch Update of Salaries for Multiple Employees This program updates the salaries of several employees in a single batch. The same UPDATE SQL structure is reused with different employee IDs and salary values using PreparedStatement. Program 2: Batch Delete of Employees from a Department This program removes multiple employees belonging to a particular

Program 1: Retrieve All Employee Records Using ResultSet This program retrieves all employee records from the employee table. The next() method is used to navigate through each row of the ResultSet. Program 2: Retrieve a Specific Employee Using ResultSet This program retrieves a specific employee using the employee ID. The ResultSet is checked using the

Program 1: Calling a Stored Procedure with an IN Parameter This program calls a stored procedure that accepts an employee ID as an input parameter. The procedure retrieves the employee’s details and returns them as a ResultSet. MySQL Procedure DELIMITER // CREATE PROCEDURE GetEmployee(     IN p_emp_id INT ) BEGIN     SELECT employee_id, employee_name, department,

A stored procedure is a precompiled group of SQL statements stored in the database and executed when required. In JDBC, the CallableStatement interface is used to call and execute stored procedures from a Java application. The Connection.prepareCall() method creates a CallableStatement object, while setXXX() methods are used to provide input parameters. The execute() method executes

CallableStatement is a JDBC interface used to execute stored procedures and stored functions in a database. It extends the PreparedStatement interface and allows Java applications to call database routines that may contain input parameters, output parameters, or both. The prepareCall() method of the Connection interface is used to create a CallableStatement object. Input values are

Transaction isolation levels in JDBC control how one transaction can see changes made by other transactions running at the same time. They help prevent problems such as dirty reads, non-repeatable reads, and phantom reads. The isolation level is set using the setTransactionIsolation() method of the Connection interface. JDBC provides four standard isolation levels: TRANSACTION_READ_UNCOMMITTED, TRANSACTION_READ_COMMITTED,

The commit() and rollback() methods are used in JDBC to manage database transactions. A transaction is a group of database operations that should be treated as a single unit of work. The commit() method permanently saves all changes made during the current transaction, while rollback() cancels the changes made since the transaction began or since