Spring Security using Database Authentication

package com.kb.controllers;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

@Controller
public class SpringSecurityHelloWorldControllerDatabase {
	  @RequestMapping("/public/pages")
    public String helloWorld(Model model) {
        model.addAttribute("message", "Hi   user, welcome to Public Hello World page");
 
        return "/helloWorld";
    }
     
    @RequestMapping("/secured/pages")
    public String helloWorldSecured(Model model) {
        model.addAttribute("message", "Hi user,  Great !! , welcome to Secured Hello World page");
        return "/secured/securedHelloWorld";
    }
	

}

package com.kb;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.DataSource;

public class DBUtilsToCreateRoleTables {
	
	private DataSource dataSource;

	public DataSource getDataSource() {
		return dataSource;
	}

	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
	}
	
	public void createRoleTables(){
		DataSource dataSource = getDataSource();
		Connection connection =null;
		Statement statement =null;
		try {
			System.out.println("inside createRoleTables method");
			 connection = dataSource.getConnection();
			 statement = connection.createStatement();
			 System.out.println("connection - "+connection);
			 System.out.println("statement - "+statement);
			statement.executeUpdate("DROP TABLE USERS IF EXISTS");
			statement.executeUpdate("CREATE TABLE USERS(USER_ID INTEGER,USERNAME VARCHAR(50),PASSWORD VARCHAR(50),ENABLED BOOLEAN);");
			statement.executeUpdate("INSERT INTO USERS VALUES(1,'kb','1234',TRUE);");
			statement.executeUpdate("DROP TABLE USERS_ROLES IF EXISTS");
			statement.executeUpdate("CREATE TABLE USERS_ROLES(USER_ROLE_ID INTEGER,USER_ID INTEGER,ROLE VARCHAR(50));");
			statement.executeUpdate("INSERT INTO USERS_ROLES VALUES(1,1,'ROLE_ADMIN');");
		} catch (Exception e) {
			e.printStackTrace();
		}
		finally {
			try {
				statement.close();
				connection.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
	}

}

<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.2.xsd
          http://www.springframework.org/schema/security
          http://www.springframework.org/schema/security/spring-security-3.2.xsd">
           
    <http auto-config='true'>
      <intercept-url pattern="/secured/*" access="ROLE_ADMIN" />
    </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 us.username,ur.role from users us,
        users_roles ur where us.user_id=ur.user_id and us.username=?"/>          
      </authentication-provider>
    </authentication-manager>   
           
</beans:beans>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-4.0.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

	<context:component-scan base-package="com.kb.*" />
	<mvc:annotation-driven />
	<context:property-placeholder location="classpath:database.properties" />
	<bean id="viewResolver"
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/pages/" />
		<property name="suffix" value=".jsp" />
	</bean>

	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${driverClassName}" />
		<property name="url" value="${url}" />
		<property name="username" value="${username}" />
		<property name="password" value="${password}" />
	</bean>

	<bean id="dbUtil" class="com.kb.DBUtilsToCreateRoleTables"
		init-method="createRoleTables">
		<property name="dataSource" ref="dataSource" />
	</bean>
</beans>

driverClassName=org.hsqldb.jdbcDriver
url=jdbc:hsqldb:mem://personDb
username=kb
password=1234

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h3>Hello World!</h3>
<h4>${message}</h4>
</body>
</html>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h3>Hello World!</h3>
<h4>${message}</h4>
</body>
</html>