Is it possible to pass input parameters to a prepared statement CallableStatement and how is it done?

Yes, prepared statements with CallableStatement can accept input parameters. CallableStatement is used to call stored procedures in the database, and parameters are passed using setXXX() methods, where XXX is the data type.

Example of passing input parameters:

CallableStatement cs = connection.prepareCall("{call my_procedure(?, ?)}");
cs.setInt(1, 10); // first parameter
cs.setString(2, "example"); // second parameter
cs.execute();

Here, the question mark (?) is a placeholder for a parameter, and methods like setInt, setString, etc., set the values for these parameters by their position.