For Demonstrate books online. Getting detailed informations about books. Adding and managing books and publishers. User Friendly. This is a Mini-project developed using Java, Jdbc.
Admin Have Following Access for this online store site:
- Add New Books and Publishers.
- Update New Books and Publishers.
- Add Books to spesific Publishers.
- View Books and Publishers Available.
- Remove Books and Publishers.
Publishers Have Following Access for this online book store site:
- Create New Account or Register.
- Add New Books.
- Update Books.
- View Books Available.
- Remove Books.
Users Have Following Access for this online library site:
- View Available Books.
- Back-End Development
- Java [JDK 8+]
- Spring (Boot/Data/Security)
- JPA
- JWT
- Docker
- MapStruct
Database used.
- MySql
- MySQL
- Intellij IDEA
- Java [JDK 8+]
- Tomcat v8.0+
- Gradle
STEP 1: Open MySQL Command Prompt or MySQL Workbench or just Data Source
STEP 2: Login to the administrator user as : mysql -u -p (Enter Password if asked)
STEP 3 :Copy paste the following MySql Commands:
Note: Default tables will be create via JPA.
-- user-role datas
insert into role values (1,'ROLE_ADMIN');
insert into role values (2,'ROLE_PUBLISHER');
insert into role values (3,'ROLE_USER');
insert into user values (1, 'Admin','$2a$10$Tvcbmk05q.e3Z9rmv0QDOOxbjWT3BPep4sYVm.cL2ju.5s9o95Opi','admin');
insert into user values (2, 'Teas-Press','$2a$10$Tvcbmk05q.e3Z9rmv0QDOOxbjWT3BPep4sYVm.cL2ju.5s9o95Opi','teas');
insert into user values (3, 'John','$2a$10$Tvcbmk05q.e3Z9rmv0QDOOxbjWT3BPep4sYVm.cL2ju.5s9o95Opi','jdoe');
insert into user_roles values (1, 1);
insert into user_roles values (2, 2);
insert into user_roles values (3, 3);-- dummy datas for publishers and books
insert into books (id, author, isbn, title, publisher_id) values (2,'J. K. Rowling','0-7475-3269-9','Harry Potter and the Philosophers Stone',1);
insert into books (id, author, isbn, title, publisher_id) values (4,'J. R. R. Tolkien','0-6182-6030-7','The Hobbit',3);
insert into books (id, author, isbn, title, publisher_id) values (11,'King, Stephen','1501192264','The Green Mile',10);
insert into books (id, author, isbn, title, publisher_id) values (13,'Agatha Christie','0062073559','Death on the Nile',12);
insert into books (id, author, isbn, title, publisher_id) values (15,'J. K. Rowling','0','The Man and the Myth',14);
insert into books (id, author, isbn, title, publisher_id) values (19,'Brend, Barbara','0-7123-0392-8','The Emperor Akbars Khamsa of Nizami',18);
insert into books (id, author, isbn, title, publisher_id) values (21,'Klavan, Andrew','1-6844-2270-1','The Emperors Sword: Another Kingdom',5);
insert into books (id, author, isbn, title, publisher_id) values (23,'Kipling, Rudyard','0141325291','The Jungle Book',22);
insert into books (id, author, isbn, title, publisher_id) values (25,'Draizer Teodor','5389084810','Sestra Kerri',24);
insert into books (id, author, isbn, title, publisher_id) values (27,'Dilqəm Əhməd','0','Mühacirlərin dönüşü',26);
insert into publisher (id, country, name) values (1,'England','Bloomsbury');
insert into publisher (id, country, name) values (3,'United Kingdom','George Allen & Unwinomsbury');
insert into publisher (id, country, name) values (5,'Nashville, US','Turner');
insert into publisher (id, country, name) values (10,'USA','Gallery Books');
insert into publisher (id, country, name) values (12,'USA','HarperCollins');
insert into publisher (id, country, name) values (14,'USA','Australia and New Zealand Book Company');
insert into publisher (id, country, name) values (18,'England','British Library Board');
insert into publisher (id, country, name) values (22,'UK','Puffin Books');
insert into publisher (id, country, name) values (24,'RF','Azbuka');
insert into publisher (id, country, name) values (26,'AZE','Teas-Press');For build project from an image:
docker pull elgunsh/bs-library:latest
docker run elgunsh/bs-library:latest
"Suggestions and project Improvements are Invited!"
Thanks a lot
Elgun Shukurov