Completed

Build basica Java Spring Boot Web App

I need a Spring boot project, using latest stable version of all componentes.

Must implement mvc, hibernate, multitenancy, security (using a login form), and all connected to a MySQL database. Deliver and IntelliJ Idea project.

For Multitenancy, I need the single database, multiple schemas approach. So I need a master schema that has relation between an username and the schema associated with, and then each user will have his own unique schema, dynamically created after registration and selected after login.

There must be a master database (schema in MySql) that contains the user ID and the table schema the user is allowed to use. Then each user will have one schema associated with one or more tables.

There must be a register option. When the user registers, it will receive a confirmation email, and when the user clicks is taken to the web app to validate his account, and then create a unique schema for him and the corresponfing tables. This unique schema along with his username, will be stored in the master database.

The password stored in the database must be encrypted.

In the login form, there must be a validation to know if the user is allowed into the system or not, and then he can only use the schema associated with him. There must be also a "Remember Me" checkbox in the login form, so the user doesnt need to enter his details again to login, unless he clicks Logout.

For this project, we can use the following db structure

CREATE TABLE IF NOT EXISTS `user` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`firstName` varchar(255) DEFAULT NULL,

`lastName` varchar(255) DEFAULT NULL,

`password` varchar(255) DEFAULT NULL,

`username` varchar(255) DEFAULT NULL,

`accountType` varchar(255) DEFAULT NULL,

`billingAddress` varchar(255) DEFAULT NULL,

`mobilePhone` varchar(255) DEFAULT NULL,

`officePhone` varchar(255) DEFAULT NULL,

`email` varchar(255) DEFAULT NULL,

`description` varchar(255) DEFAULT NULL,

`notes` varchar(255) DEFAULT NULL,

`createadBy` bigint(20) DEFAULT NULL,

`modifiedBy` bigint(20) DEFAULT NULL,

`createdDate` datetime DEFAULT NULL,

`modifiedDate` datetime DEFAULT NULL,

`lastLoggedIn` datetime DEFAULT NULL,

'active'

PRIMARY KEY (`id`),

UNIQUE KEY `username` (`username`)

) ENGINE=InnoDB AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `role` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`role` int(11) DEFAULT NULL,

`userId` bigint(20) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `FK3580769128426C` (`userId`)

) ENGINE=InnoDB AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `productGroup` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`groupName` varchar(255) NOT NULL,

`description` varchar(255) DEFAULT NULL,

`createadBy` bigint(20) DEFAULT NULL,

`modifiedBy` bigint(20) DEFAULT NULL,

`createdDate` datetime DEFAULT NULL,

`modifiedDate` datetime DEFAULT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `groupName` (`groupName`)

) ENGINE=InnoDB AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `product` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`productName` varchar(255) NOT NULL,

`description` varchar(255) DEFAULT NULL,

`productGroup` bigint(20) DEFAULT NULL,

`price` bigint(20) DEFAULT NULL,

`createadBy` bigint(20) DEFAULT NULL,

`modifiedBy` bigint(20) DEFAULT NULL,

`createdDate` datetime DEFAULT NULL,

`modifiedDate` datetime DEFAULT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `productname` (`productName`),

KEY `FKPRODGROUP` (`productGroup`),

CONSTRAINT `FKPRODGROUP` FOREIGN KEY (`productGroup`) REFERENCES `productGroup` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1;

For HTML forms, use Thymeleaf.

For testing purposes, implement a few controllers and views.

1. Add user (each user can add another user that can interact with his account, something like members of the same company that all will have access to the same account). Only an user with admin role can add other user to his account.

2. List/Delete users

3. Add/List/Delete Product

4. List Product

5. List/Edit Roles

Skills: Java, Java Spring, JSP, MySQL

See more: java spring boot rest mysql javascript typescript, java spring boot rest, java spring boot, Build a simple Angular 2 web app to flip image file and use edge.js, build a web app with java, java web application - reports/charts/geo maps (jasper/birt/spring boot - birt, java spring boot application that exposes restful api, java spring scheduler web interface, java ultimate team web app autobuyer, java build web app iphone, screen scraping web app java, java web app sip client, java timer web app, voice record java web app, java web app google earth, web app capture signature php java, java web app ftp, build bracelet web app, java web app javaserver faces hibernate, java spring web crawler

About the Employer:
( 2 reviews ) Letterkenny, Portugal

Project ID: #16102607

Awarded to:

damducthoai

Over 2 year with java technology, Have deep knowledge with Mysql, programming, JPA, Spring, EJB, I use Intellij as my main IDE, I also code angular with VS Code. I work with maven, npm.

€23 EUR in 1 day
(1 Review)
1.2

24 freelancers are bidding on average €151 for this job

wizard2015

Hi, I am experienced programmer and I can help you with crating such SpringBoot application. Please contact me if you are interested in cooperation. Relevant Skills and Experience Java, Spring Boot, Spring Data, Sprin More

€500 EUR in 10 days
(58 Reviews)
6.1
cleanCode

Hello, I have read all your requirements and I would like to work on your project. The quotation that I added is an hourly rate, not a fix price quotation Thanks, Alex Relevant Skills and Experience Spring/Java MyS More

€30 EUR in 60 days
(26 Reviews)
5.2
topit917

Dear sir. Nice to meet you. I checked your job post and I think I can do meet your requirements fully. Let's discuss more. Thank you. Relevant Skills and Experience Java, Java Spring, JSP, MySQL Proposed Milestones € More

€555 EUR in 1 day
(4 Reviews)
4.2
hongyuwang76

Experimented java developper, i worked in large companies for several years on web technologies. - Java 8, REST web services, various web applications - RabbitMq and Redis. - Persistence management with Hibernate / More

€333 EUR in 10 days
(2 Reviews)
2.4
kishanpala

reason for pricing is one and only that we put maximum efforts in one assignment we are working only in one assignment and project at one [login to view URL] working mission is only client satisfaction. Relevant Skills and Exper More

€14 EUR in 1 day
(5 Reviews)
2.7
vw7985909vw

Currently working on spring boot with one of the popular us based [login to view URL] development experience 6 years

€14 EUR in 1 day
(0 Reviews)
0.0
€111 EUR in 2 days
(0 Reviews)
0.0
nilesh30490

I have around 3 years of experience in spring boot application development. Currently using the spring boot framework to implement web based application.

€23 EUR in 1 day
(0 Reviews)
0.0
bhavneetbodh2013

I can deliver this project in your specified time as my expertise in Java and related technologies is backed by a full decade of application development.

€23 EUR in 1 day
(0 Reviews)
0.0
€44 EUR in 10 days
(0 Reviews)
0.0
bigdatabear

I have 11 years of experience in developing various application in java,j2ee,spring mvc,spring-boot,hibernate. Relevant Skills and Experience Spring,Spring mvc,Sprint boot,Hibernate Proposed Milestones €30 EUR - Adv More

€100 EUR in 10 days
(0 Reviews)
0.0
PrachiNMali

I have almost 4 years of professional experience in Java development with the below technologies. Java, Hibernate, Spring, Oracle, Web services, J2EE. Relevant Skills and Experience Java, Hibernate, Spring, Oracle, We More

€200 EUR in 10 days
(0 Reviews)
0.0
€23 EUR in 2 days
(0 Reviews)
0.0
€23 EUR in 1 day
(0 Reviews)
0.0
€28 EUR in 35 days
(0 Reviews)
0.0
neerajpaliwal49

Hi, I have advanced proficiency in J2ee/Java(recent version - upto Java 8), Angular.js , Node.js, React.js, JavaScript, JQuery, excellent front-end & back-end and Hibernate and Spring,springboot. Relevant Skills and More

€34 EUR in 3 days
(0 Reviews)
0.0
madhawa30

I'm a professional software engineer. please check my following profile. I'm new to this site. [login to view URL]

€277 EUR in 6 days
(0 Reviews)
0.0
romangutkovich

I'm skilled Java Engineer with 3+ yr. experience. So from my point of view it's not very difficult task but it requires time, and the main business rule is time = money. Relevant Skills and Experience Java, JSP, MySQ More

€145 EUR in 3 days
(0 Reviews)
0.0
mukulpuspam0

A proposal has not yet been provided

€55 EUR in 5 days
(0 Reviews)
0.0
theventure334

we have best qualified team and our company we will work your project send me message then we will discuss...? Relevant Skills and Experience java,php,mysql,C#,.net,visual basic Proposed Milestones €34 EUR - java Bo More

€34 EUR in 5 days
(0 Reviews)
0.0