Wha are the differences between Statement, PreparedStatement and CallableStatement ?

Question

explain proper use of them and which one have resultset values

Answer 1

the difference is a prepared statement has only input variables but a callableStatement also has output variables in, out and a mixture of both inout
explaining them deeper would take pretty long so have fun with this link

https://www.tutorialspoint.com/jdbc/jdbc-statements.htm