Q) Creating PreparedStatement object

A)

->By calling “prepareStatement()” method on connection object, preparedStatement object in created.

Examples:

1)       PreparedStatement ps1 = con.PreparedStatement (“INSERT INTO ACCOUNT VALUES (?,?,?)”);

Here  “ ? ” means “ place holder ”.

2)       PreparedStatement ps2 = con.PreparedStatement (“UPDATE ACCOUNT SET BALANCE = BALANCE+? WHERE ACCNO=?”);

3)      PreparedStatement ps3 = con.PreparedStatement (“DELETE FROM ACCOUNT WHERE ACCNO=?”);

4)      PreparedStatement ps4 = con.PreparedStatement (“SELECT BALANCE FROM ACCOUNT WHERE ACCNO=?”);

                                        

Note:

Object oriented representation of (encapsulation of) a pre-compiled/already prepared SQL statement. Is nothing but PreparedStatement object.