JDBC Template

If your Query returns single value then use NamedParameterJdbcTemplate:
---------------------------------------------------------------------------

String fanNumber = new NamedParameterJdbcTemplate(
        getJdbcTemplate()).queryForObject(getSQL("OM.GET_ADH_NUM"), params, String.class);