Determining the correct JDBC SQL queries

The JdbcUserDetailsManager class has three SQL queries that have a well-defined parameter and a set of returned columns. We must determine the SQL that we'll assign to each of these queries, based on the intended functionality. Each SQL query used by JdbcUserDetailsManager takes the username presented at login as its one and only parameter:

Be aware that in some cases, the return columns are not used by the default JdbcUserDetailsManager implementation, but they must be returned anyway.