spring mvc bookstore

نظام إدارة المكتبة

التقنيات المستخدمة:

 - Server: Apache Tomcat 9.0.55
- Database: MySQL
- Backend
	- JDBC
	- Spring MVC
	- Servlet
- Frontend
	- JSP
	- Bootstrap
	- CSS

منظور المشروع:

 - User management(only for Admins and Employees(not for customers)):
	- Register
	- Login/Logout
- Customers view or find books easly without going anywhere
- Customers can search books by title using search input or by clicking 
  tags specified on the home page
- After customers select their books, then employees sells selected books 
	to the customer by adding customer and purchase detail
- Admin can Add, Edit and Delete employees
- Admin can Add, Edit and Delete books
- Admin can Add, Edit and Delete purchases
- Admin can view, and Delete feedbacks
- Customers can give feedback
- Stores purchase history
- The header navbar only display for Admin

استفسارات إنشاء الجداول:

قبل تشغيل المشروع ، قم بإنشاء الجداول عن طريق تشغيل أوامر SQL هذه

 create table bookstore .user
(
	id int ( 50 ) primary key auto_increment, 
	first_name varchar ( 220 ),  
	last_name varchar ( 220 ), 
	phone varchar ( 120 ), 
	email varchar ( 120 ), 
	password varchar ( 220 ),
	date_created timestamp default now()
);

 create table bookstore .admin
(
	id int ( 50 ) primary key auto_increment, 
	user_id int ( 45 ),  
	is_admin boolean default(false),
	FOREIGN KEY (user_id) REFERENCES bookstore . user (id)
);

 create table bookstore .book
(
	id int ( 50 ) primary key auto_increment, 
	title varchar ( 220 ), 
	author varchar ( 120 ), 
	genre varchar ( 120 ), 
	description text , 
	date_created timestamp default now(), 
	copy int ( 10 ), 
	price decimal ( 2 )
);

 create table bookstore .employee
(
	id int ( 50 ) primary key auto_increment, 
	name varchar ( 120 ), 
	salary decimal ( 50 ), 
	department varchar ( 120 ), 
	reg_date timestamp default now()
);

 create table bookstore .feedback 
(
	id int ( 50 ) primary key auto_increment, 
	name varchar ( 120 ), 
	phone varchar ( 120 ), 
	email varchar ( 120 ), 
	feedback text , 
	date_created timestamp default now()
);

 create table bookstore .purchase_detail
(
	id int ( 50 ) primary key auto_increment,  
	name varchar ( 120 ), 
	phone varchar ( 120 ), 
	books text , 
	quantity int ( 50 ), 
	total_price decimal ( 50 ), 
	date_purchased timestamp default now()
);

مفيد؟ امنحها نجمة

شكرًا