@Override
public void addViewControllers(ViewControllerRegistry registry) {
    registry.addViewController("/index").setViewName("index");
    registry.addViewController("/login").setViewName("login");
    registry.addViewController("/403").setViewName("denied");

}



@Bean(name= "datasource")
public DriverManagerDataSource dataSource() {
    DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();
    driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    driverManagerDataSource.setUrl("jdbc:mysql://localhost:3306/admin_dev");
    driverManagerDataSource.setUsername("admin");
    driverManagerDataSource.setPassword("password");;
    return driverManagerDataSource;

}

static final String usersByUsernameSql = "select users.user_id, users.password, users.created_date, users.created_by, users.updated_date, users.updated_by, users.address1, users.address2,"
        + " users.city, users.country, users.date_of_birth, users.facebook_id, users.gender, users.last_login_date, users.mobile, users.name, users.password_reset_date, users.password_reset_key, users.post_code,"
        + " users.salt, users.state, users.status, users.company_id, users.fav_sports_id from users where users.user_id=?";

static final String authoritiesByUsernameSql = "select users.user_id, roles.name from users" +
                                                " join user_roles on users.user_id = user_roles.user_id" +
                                                " join roles on user_roles.role_id = roles.id" +
                                                " where users.user_id=?";

@Autowired
DataSource dataSource;

@Autowired
public void configAuthentication(AuthenticationManagerBuilder auth) throws Exception {
    try{

        auth.jdbcAuthentication().dataSource(dataSource).
        usersByUsernameQuery(usersByUsernameSql).
        authoritiesByUsernameQuery(authoritiesByUsernameSql);

    } catch (Exception e){
        System.out.println(e.getMessage());

    }
}

@Override
protected void configure(HttpSecurity http) throws Exception {

    try{
        http.authorizeRequests().antMatchers("/home").access("hasRole('Super Admin')").anyRequest().permitAll().and().formLogin().
        loginPage("/login").usernameParameter("username").passwordParameter("password").and().logout().logoutSuccessUrl("/login?logout").and().exceptionHandling().accessDeniedPage("/403");

    } catch (Exception e){
        System.out.println(e.getMessage());

    }

}

</div>
 <div th:if="${param.logout}">
     <h1 style="color:blue">Logged out.</h1>
 </div>
<form th:action="@{/login}" method="post">
    <div>
        <!-- Email Address -->
        <div class="form-group">
            <input type="text" name="username" class="form-control input-md" placeholder="Email Address"/>
        </div>

        <!-- Password -->
        <div class="form-group">
            <input type="password" name="password" class="form-control input-md" placeholder="Password"/>
        </div>

        <!-- Submit Button -->
        <div class="form-actions">
            <input type="submit" class="btn btn-block btn-primary btn-default"></input>
        </div>
    </div>
</form>