Creating the PreparedStatement ------------------------------------- =>By calling prepareStatement() method on the Connection object, java.sql.PreparedStatement object is created. PreparedStatement preparedStatement=connection.prepareStatement("SQL statement"); For eg. PreparedStatement preparedStatement1=connection.prepareStatement("INSERT INTO ACCOUNT VALUES(?,?,?)"); PreparedStatement preparedStatement2=connection.prepareStatement("UPDATE ACCOUNT SET BALANCE=BALANCE+? WHERE ACCNO=?"); PreparedStatement preparedStatement3=connection.prepareStatement("DELETE FROM ACCOUNT WHERE ACCNO=?"); PreparedStatement preparedStatement4=connection.prepareStatement("SELECT BALANCE FROM ACCOUNT WHERE ACCNO=?"); Binding of Parameters ------------------------- =>Supplying values to the place holders(question marks) is nothing but binding of parameters. =>By calling setter methods on PreparedStatement object, parameter binding is performed. For eg. preparedStatement1.setInt(1,100001); preparedStatement1.setString(2,"Rama"); preparedStatement1.setDouble(3,50000); Submitting the SQL Statement ----------------------------------- By calling executeUpdate() OR executeQuery() method on the PreparedStatement object, SQL Statement is submitted to the DBMS. For eg. preparedStatement1.executeUpdate();