https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/kotlin-spring-security-jdbc-authentication-springboot-mysql-bootstrap

Kotlin – Spring Security JDBC Authentication – SpringBoot + MySQL + Bootstrap

In the tutorial, JavaSampleApproach will show you how to create a Kotlin Spring Security JDBC Authentication with SpringBoot + MySQL + Bootstrap.

I. Technologies

– Kotlin 1.2.20 – Apache Maven 3.5.2 – Spring Tool Suite – Version 3.9.0.RELEASE – Spring Boot – 1.5.10.RELEASE – Bootstrap - MySQL

II. Goal

We create a Kotlin MVC Web Application as below:

With 5 urls:

– ‘/’: access with everyone.

– ‘/user’: must authenticate and be accessed with user ROLE {USER, ADMIN}

– ‘/admin’: accessed by user with role Admin

– ‘/login’: login page

– ‘/403’: HTTP Error 403 Forbidden

We create 2 MySQL tables for 2 users (username/password):

• jack/jack has 2 roles {USER, ADMIN}
• peter/peter has 1 role USER

-> jack/jack can access both pages {user.html, admin.html}. While peter/peter just accesses 1 page user.html.

III. Implementation

– Create Kotlin Spring Boot project – Create Controller – Create View Pages – Configure Database – Configure WebSecurity

1. Create Kotlin Spring Boot project

Use SpringToolSuite to create a Kotlin SpringBoot project with below dependencies:

More at:

https://grokonez.com/spring-framework/spring-boot/kotlin-spring-boot/kotlin-spring-security-jdbc-authentication-springboot-mysql-bootstrap

Kotlin – Spring Security JDBC Authentication – SpringBoot + MySQL + Bootstrap

#kotlin #springsecurity #jdbc-authentication #springboot #mysql #bootstrap