JDBC

The JDBC CallableStatement is used to execute the store procedure and functions. Let us study JDBC CallableStatement by OUT parameter example. Example: getEmpNameByEmpId Procedure JDBC CallableStatement Stored procedure IN parameter example. CREATE OR REPLACE PROCEDURE getEmpNameByEmpId( e_id IN EMPLOYEE.EMPLOYEE_ID%TYPE, e_NAME OUT EMPLOYEE.NAME%TYPE) IS BEGIN   SELECT NAME INTO e_NAME FROM EMPLOYEE WHERE EMPLOYEE_ID = e_id; … Read more

The JDBC CallableStatement is used to execute the store procedure and functions. Let us study JDBC CallableStatement by IN parameter example. Example: insertEMPLOYEE Procedure JDBC CallableStatement Stored procedure IN parameter example. CREATE OR REPLACE PROCEDURE insertEMPLOYEE( e_id IN EMPLOYEE.EMPLOYEE_ID%TYPE, e_name IN EMPLOYEE.NAME%TYPE, e_salary IN EMPLOYEE.SALARY%TYPE) IS BEGIN   INSERT INTO EMPLOYEE ("EMPLOYEE_ID", "NAME", "SALARY") VALUES … Read more

The JDBC CallableStatement is used to execute the store procedure and functions. CallableStatement interface provides the methods to execute the store procedure and functions. We can get a statement object by invoking the prepareCall() method of Connection interface. Syntax: CallableStatement callableStatement = conn.prepareCall(“{call procedurename(?,?…?)}”);  Note: A store procedure is used to perform business logic and … Read more

The JDBC PreparedStatement is used to execute parameterized queries against the database. Let us study JDBC PreparedStatement by batch update example. Example: JDBCTest.java import java.sql.Connection; import java.sql.PreparedStatement; import com.w3spoint.util.JDBCUtil;   /** * This class is used to batch update in DB table * using PreparedStatement. * @author w3spoint */ public class JDBCTest { public static … Read more

The JDBC PreparedStatement is used to execute parameterized queries against the database. Let us study JDBC PreparedStatement by deletes a record example. Example: JDBCTest.java import java.sql.Connection; import java.sql.PreparedStatement; import com.w3spoint.util.JDBCUtil;   /** * This class is used to delete a record from DB table * using PreparedStatement. * @author w3spoint */ public class JDBCTest { … Read more

The JDBC PreparedStatement is used to execute parameterized queries against the database. Let us study JDBC PreparedStatement by select records example. Example: JDBCTest.java import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import com.w3spoint.util.JDBCUtil;   /** * This class is used to select a list of records from DB table * using PreparedStatement. * @author w3spoint */ public … Read more

The JDBC PreparedStatement is used to execute parameterized queries against the database. Let us study JDBC PreparedStatement by updates a record example. Example: JDBCTest.java import java.sql.Connection; import java.sql.PreparedStatement; import com.w3spoint.util.JDBCUtil;   /** * This class is used to update a record in DB table * using PreparedStatement. * @author w3spoint */ public class JDBCTest { … Read more

The JDBC PreparedStatement is used to execute parameterized queries against the database. Let us study JDBC PreparedStatement by inserts a record example. Example: JDBCTest.java import java.sql.Connection; import java.sql.PreparedStatement; import com.w3spoint.util.JDBCUtil;   /** * This class is used to insert a record in DB table * using PreparedStatement. * @author w3spoint */ public class JDBCTest { … Read more

The JDBC PreparedStatement is used to execute parameterized queries against the database. Let us study JDBC PreparedStatement by creates a table example. Example: JDBCTest.java import java.sql.Connection; import java.sql.PreparedStatement; import com.w3spoint.util.JDBCUtil;   /** * This class is used to create a table in DB * using PreparedStatement. * @author w3spoint */ public class JDBCTest { public … Read more

The JDBC PreparedStatement is used to execute parameterized queries against the database. PreparedStatement is an interface which provides the methods to execute parameterized queries. A parameter is represented by ? symbol in JDBC. PreparedStatement extends the Statement interface. We can get a PreparedStatement object by invoking the prepareStatement() method of Connection interface. Syntax: PreparedStatement pstmt … Read more