• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

wkrzywiec/Library-Spring: The library web application where you can borrow books ...

原作者: [db:作者] 来自: 网络 收藏 邀请

开源软件名称(OpenSource Name):

wkrzywiec/Library-Spring

开源软件地址(OpenSource Url):

https://github.com/wkrzywiec/Library-Spring

开源编程语言(OpenSource Language):

Java 99.6%

开源软件介绍(OpenSource Introduction):

Library Portal (in Spring)

Spring MVC web application for borrowing and managing library books inventory.

Description

This is my first Spring MVC project, which is an implementation of the library website. The application allow to borrow books (as a standard user), manage books inventory (add new ones, check availablity, etc.) and user account.

In Library Portal there are three types of users:

  • Readers - they can register themselves and borrow limited number of books.
  • Librarian - limited number of users that can add new books, borrow and return them. They can also confirm payments for penalties in case when a reader keeps a book to long.
  • Admin - person, who can add, edit and deactivate users.

Tools & Frameworks

The application is written using Spring MVC framework and Gradle (for external dependency managment).

Database & configuration

  • MySQL
  • Flyway (for data migration)
  • Gradle
  • Tomcat
  • Git
  • Google Book API

Backend technologies

  • Java
  • Spring MVC, Spring AOP, Spring Security
  • Hibernate ORM, Hibernate Validator, Hibenrate Search (Lucene)
  • Retrofit, JSON
  • JUnit
  • Project Lombok
  • Log4j2

Frontend technologies

  • HTML, CSS, JavaScript
  • JSP, JSTL
  • Bootstrap 4

How to run it?

Prerequisites: Eclipse IDE (with Gradle and Tomcat plugin installed), Tomcat, MySQL Community Edition

  1. Clone this git repository

$ git clone https://github.com/wkrzywiec/Library-Spring

  1. Open MySQL Workbench and type following SQL script:
	CREATE USER 'library-spring'@'localhost' IDENTIFIED BY 'library-spring';
	GRANT ALL PRIVILEGES ON  *.* TO 'library-spring'@'localhost';
	SET GLOBAL EVENT_SCHEDULER = ON;
  1. Go to a folder src/main/resources/properties, create googleAPI.properties file and add your Google API key (here are instructions how to obtain it) as follows:

googleAPI.key=[YOUR KEY HERE]

  1. Run tomcatRun Gradle task (or assign it to the Run button in Eclipse)

  2. The application will avaialble under URL http://localhost:8080/library-spring

Blog Posts

During work on this project I've parallely created some blog posts that describe my path to the working application. In those entires I've tried to explain some of key concepts, tools and frameworks that I used. Here is the list of all entries that was written so far:

Library Portal — Spring Project Overview

General

Configurations

Clean code

Features

User Log Events
Full-text Search
User registration
Add book to library

Deployment

Database Diagram

Big picture on the database relationships. Database

Detailed look on user entity relationships.Some of them, like user_password_toke are specific for Spring Security Forgot password feature.

User database

And book entity relationships.

User database

Finally user-book relationships, those tables stores book status information (like if it is reserved, borrowed, has penalties) or logs.

User-Book database

Screenshots

Login page

Main page, after login. The quote is taken from Random Quote API.

Admin can find and modify user profiles. Also there are possibility for him to see the logs of the user to check what changes were made on the user account.

Librarian can add new books to the library. New book data are fetched from Google Book API when search query is performed.

Every, regular user can register themself in the application.

After registration they can look for a book they want, see their details, and reserve it.

The librarian can borrow and return books. Also he can check book history to get the insight who and when make any action on a book.




鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap