Board Game Database

A comprehensive full-stack board game database web application built with Spring Boot and Spring Security. This project demonstrates enterprise Java development practices with role-based access control, CRUD operations, and modern web technologies. ## Application Overview The Board Game Database is a secure web application that allows users to manage board game collections and reviews. It implements a complete authentication and authorization system with different user roles having varying levels of permissions. The application showcases modern Java web development using Spring Boot framework with integrated security, data persistence, and responsive UI design. ## Core Features - **Complete Board Game Management**: Users can view, add, and manage board game listings with detailed information - **Review System**: Comprehensive review functionality allowing users to add, edit, and delete game reviews - **Role-Based Security**: Multi-tier security system with different permissions for non-members, users, and managers - **Responsive Design**: Modern UI built with Thymeleaf templates and Bootstrap styling - **RESTful API**: Complete REST endpoints for board game data access and manipulation ## Security Architecture - **Spring Security Integration**: Full authentication and authorization using Spring Security framework - **Role-Based Access Control**: Three distinct user roles with specific permissions: - **Non-members**: View board game lists and reviews only - **Users**: Add board games and write reviews - **Managers**: Full CRUD operations including edit and delete capabilities - **JDBC Authentication**: Database-backed user authentication with encrypted passwords - **Session Management**: Secure session handling with proper logout functionality ## Technical Implementation - **Spring Boot Framework**: Modern Java development with auto-configuration and embedded server - **Spring MVC**: Clean separation of concerns with controllers, services, and data layers - **JDBC Integration**: Database connectivity using Spring JDBC with parameterized queries - **H2 Database**: In-memory database for development with custom schema initialization - **Thymeleaf Templating**: Server-side template engine with fragment-based HTML components - **Bootstrap Styling**: Responsive and modern UI design with Twitter Bootstrap ## Database Design - **Board Games Table**: Complete game information including difficulty levels, player counts, and game types - **Reviews Table**: User-generated reviews linked to specific board games - **Security Tables**: Spring Security's default schema for users, authorities, and roles - **Schema Initialization**: Custom SQL scripts for database setup and initial data ## Testing & Quality - **JUnit Testing**: Comprehensive unit tests for database operations and controllers - **MockMvc Testing**: Integration testing for web controllers and endpoints - **Test-Driven Development**: Well-structured test cases ensuring application reliability - **Spring Boot Testing**: Full-stack testing with embedded test environment This project demonstrates professional Java web development practices, showcasing how to build secure, scalable, and maintainable web applications using the Spring ecosystem.

Stack

Deployments

Screenshots

💡 Scroll horizontally to view all screenshots. Click on any image to view in full size.

More Products

Some additional products

Authentication System

Spring Security implementation with role-based access control and JDBC authentication

Board Game Management

Complete CRUD operations for board games with detailed information and categorization

Review System

User review functionality with role-based permissions for editing and deletion