Maddy's Experiences: Spring Security: JDBC + Customized 403 & Login Form

Let’s start building the spring security application:

Basic Requirement :

Create two tables in MYSQL :

CREATE TABLE `users` (

`USER_ID` INT(10) UNSIGNED NOT NULL,

`USERNAME` VARCHAR(45) NOT NULL,

`PASSWORD` VARCHAR(45) NOT NULL,

`ENABLED` tinyint(1) NOT NULL,

PRIMARY KEY (`USER_ID`)

);

CREATE TABLE `user_roles` (

`USER_ROLE_ID` INT(10) UNSIGNED NOT NULL,

`USER_ID` INT(10) UNSIGNED NOT NULL,

`AUTHORITY` VARCHAR(45) NOT NULL,

PRIMARY KEY (`USER_ROLE_ID`),

KEY `FK_user_roles` (`USER_ID`),

CONSTRAINT `FK_user_roles` FOREIGN KEY (`USER_ID`) REFERENCES `users` (`USER_ID`) ON DELETE CASCADE

);

Insert values :

INSERT INTO testdb1.users (USER_ID, USERNAME,PASSWORD, ENABLED)

VALUES (100, 'kumar', 'kumar', TRUE);

INSERT INTO testdb1.user_roles (USER_ROLE_ID, USER_ID,AUTHORITY)

VALUES (1, 100, 'ROLE_USER');

INSERT INTO testdb1.users (USER_ID, USERNAME,PASSWORD, ENABLED)

VALUES (200, 'sushil', 'sushil', TRUE);

INSERT INTO testdb1.user_roles (USER_ROLE_ID, USER_ID,AUTHORITY)

VALUES (2, 200, 'ROLE_ADMIN');

Code Structure in Eclipse

LoginController.java:

package com.sushil.spring.security.controller;

import org.springframework.security.core.context.SecurityContextHolder;

import org.springframework.security.core.userdetails.User;

import org.springframework.stereotype.Controller;

import org.springframework.ui.ModelMap;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

@Controller

public class LoginController {

@RequestMapping(value="/welcome", method = RequestMethod.GET)

public String printWelcome(ModelMap model) {

User user = (User)SecurityContextHolder.getContext().getAuthentication().getPrincipal();

String name = user.getUsername();

System.out.println("in Welcome module");

model.addAttribute("username", name);

model.addAttribute("message", "Spring Security login + database example");

return "hello";

}

@RequestMapping(value="/login", method = RequestMethod.GET)

public String login(ModelMap model) {

System.out.println("in login module");

return "login";

}

@RequestMapping(value="/loginfailed", method = RequestMethod.GET)

public String loginerror(ModelMap model) {

System.out.println("in login failed module");

model.addAttribute("error", "true");

return "login";

}

@RequestMapping(value="/logout", method = RequestMethod.GET)

public String logout(ModelMap model) {

return "login";

}

@RequestMapping(value="/403", method = RequestMethod.GET)

public String accessDenied(){

return "403";

}

login.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

<html>

<head>

<title>Login Page</title>

<style>

.errorblock {

color: #ff00cc;

background-color: #ffEEEE;

border: 10px solid #ff0000;

padding: 10px;

margin: 20px;

}

</style>

</head>

<h3>Login Authentication with Database</h3>

<c:if test="${not empty error}">

Your login attempt was not successful, try again.<br />

Caused : ${sessionScope["SPRING_SECURITY_LAST_EXCEPTION"].message}

</div>

</c:if>

<form name='f' action="<c:url value='j_spring_security_check' />"

method='POST'>

<tr>

</td>

</tr>

<tr>

<td colspan="2">Password:</td>

</td>

</tr>

<tr>

<td colspan='2'><input name="submit" type="submit"

value="submit" />

</td>

</td>

</tr>

</table>

</form>

</body>

</html>

hello.jsp:

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

<html>

<body>

<h3>Message : ${message}</h3>

<h3>Username : ${username}</h3>

<a href="<c:url value="/j_spring_security_logout" />" > Logout</a>

</body>

</html>

403.jsp:

<html>

<body>

<h1><font color="red">WARNING : ${msg}</font></h1>

</body>

</html>

SpringMvcSecurityDatabase-servlet.xml

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="

http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd">

<context:component-scan base-package="com.sushil.spring.security.controller" />

<bean id="accessDeniedHandler"

class="com.sushil.spring.security.handler.MyAccessDeniedHandler">

</bean>

<bean id="dataSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource">

</bean>

<bean

class="org.springframework.web.servlet.view.InternalResourceViewResolver">

<value>/WEB-INF/pages/</value>

</property>

</property>

</bean>

<bean id="messageSource"

class="org.springframework.context.support.ResourceBundleMessageSource">

<list>

<value>mymessages</value>

</list>

</property>

</bean>

</beans>

spring-security.xml

<beans:beans xmlns="http://www.springframework.org/schema/security"

xmlns:beans="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/security

http://www.springframework.org/schema/security/spring-security-3.1.xsd">

<intercept-url pattern="/welcome*" access="ROLE_ADMIN" />

<form-login login-page="/login" default-target-url="/welcome" authentication-failure-url="/loginfailed" />

<access-denied-handler ref="accessDeniedHandler"/>

</http>

<authentication-manager>

<authentication-provider>

<jdbc-user-service data-source-ref="dataSource"

users-by-username-query="select username,password, enabled

from users where USERNAME=?"

authorities-by-username-query=" select u.username, ur.authority from users u, user_roles ur where u.user_id = ur.user_id and u.username =? " />

</authentication-provider>

</authentication-manager>

</beans:beans>

Web.xml

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:javaee="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" id="WebApp_ID" version="2.4">

<display-name>Spring MVC + Security Application</display-name>

<servlet-name>SpringMvcSecurityDatabase</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<load-on-startup>1</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>SpringMvcSecurityDatabase</servlet-name>

<url-pattern>/</url-pattern>

</servlet-mapping>

<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

</listener>

<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>

/WEB-INF/SpringMvcSecurityDatabase-servlet.xml,

/WEB-INF/spring-security.xml

</param-value>

</context-param>

<filter-name>springSecurityFilterChain</filter-name>

<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>

</filter>

<filter-mapping>

<filter-name>springSecurityFilterChain</filter-name>

<url-pattern>/*</url-pattern>

</filter-mapping>

</web-app>

Output Screens :

Just hit ‘http://localhost:8080/Example2/welcome’ on the browser :

Customized login form :

Enter Wrong Password / login name

Enter authorized user name and password 'sushil' , 'sushil'

Enter UnAuthorized user details 'kumar' , 'kumar'

Maddy's Experiences

Wednesday, June 26, 2013

Spring Security: JDBC + Customized 403 & Login Form

No comments:

Knowledge Seeker