Skip to content

Guest Book App using Spring Boot, JSP and MySQL which consists of Role based security, login page, crud operation

Notifications You must be signed in to change notification settings

Sudarshan-Gowda/Guestbook

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Guest Book Application Using Spring Boot and JSP

Build and Test

This application is build and done testing with Pipeline;
CircleCI

Feature and Scope:

Guestbook application consists of two types of users.

  1. Guests
  2. Administrator

Guests

  • User needs to login in order to write a new entry in the guestbook
  • Guestbook entry can be either a single image or a text

Administrator

  • View all the entries posted by all the users
  • Approve the entries
  • Edit the entries
  • Remove the entries

Prerequisites

The following items should be installed in your system:

  • Tool - Spring Tool Suite/Eclipse
  • MySQL Workbench
  • Git
  • Java 11
  • Maven

Technologies Used

  • Java 11
  • Spring boot
  • JSP, HTML, CSS
  • Bootstrap, JQuery, JS
  • MySQL

Steps to Clone The Repository Application Locally:

  1. Download this Project from Git.
git clone https://github.com/Sudarshan-Gowda/Guestbook.git
  1. To Import the Project Using Eclipse or STS
File -> Import -> Maven -> Existing Maven project -> spring-boot-admin

Looking for something in particular?

Guest Book Class or Java property files
Configuration File application.properties
Scripts - Create File database.sql
Scripts - Insert File scripts.sql
SpringSecurityConfig File SpringSecurityConfig.java

Steps to test the application:

To Run the Spring MVC Application:

step 1: Download this repository & do maven import.

step 2: Create schema with name guestbook and execute data base scripts to create table structures from database.sql and import the default data from file scripts.sql

step 3: Go to the main class file and run as Java application.
or execute the commands mvn spring-boot:run to run locally

step 4: Once the application starts, By default application will be deployed in 8080 port, and you can access it by using http://localhost:8080/

Build Application

To build the application using maven, use the command mvn clean install, this will create production ready jar file under target folder to deploy to any server.

To Login to Application

 Navigate to the URL http://localhost:8080/ and use the below credentails to login and manage the application <br>
  -- To login as ADMIN Role -- UN/PW -- `admin/P@ssword123`. <br>
  -- To login as USER Role  -- UN/PW -- `user/P@ssword123` or `user2/P@ssword123` <br>

To see the complete project flow

Project Flow for Guest Book

  1. Login Page for Guest User/Admin

  1. Registration Page for Guest User

  1. Login as Guest User and create new book entry

  1. Login as Admin User and can view all the records

  1. Update/View the record for Admin User

  1. Admin User can do Approve/Update/View/Delete for newly added record by Guest User

Contributing

The issue tracker is the preferred channel for bug reports, features requests and submitting pull requests.

About

Guest Book App using Spring Boot, JSP and MySQL which consists of Role based security, login page, crud operation

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published