Question: Hello, I am creating a website using java language and spring MVC framework + Thymeleaf for view. In my DB I have a table which

Hello,

I am creating a website using java language and spring MVC framework + Thymeleaf for view.

In my DB I have a table which has a self referencing (hierarchal), I have a table for employees which contains an employee Id and for each employee there is a manager Id.. so an employee can be a manager for other employees.

what I want is nested checkboxes (only show managers who are only managers and there is no manager above them) and when check a manager box, other employees checkboxes under this manager will be shown

I create the table in a DB and I have an entity (exactly like the table in DB), but I don't know how to create query (spring JPA only allowed) to retrieve the managers and employees under them

Could any expert help me by give me a code to solve this problem with clear code and explaination

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Hello, I am creating a website using java language and spring MVC framework + Thymeleaf for view. In my DB I have a table which has a self referencing (hierarchal), I have a table for employees which...

i need to make the server side multi threaded , and spawn a thread for every request. I have the rest of the code done . Just make the server,c multi threaded //server.c // Server side C/C++ program...

Hello, need assistance creating an outline to follow in order to complete the project #1 of the attached document. Thanks, Executive Summary Projects Descriptions, Instructions, and Grading Rubrics...

Hello, Need help creating this LMS to determine odd or even numbers please. Thank you! This project consists of writing a block of code for the LMC to solve a computational problem. More...

Hello I am creating an abbreviated data dictionary template for hospital admission. I need to have 10 field names and I am totally lost. I don't understand how to create it

Hello, I need creating a portfolio for a 62 year old within a few years of retirement. I need to create the portfolio based on the best mean-variance efficient frontier. I must account for inflation....

Create a Stata program file that does all the following (attach the program file in to including a listing of commands below): Input the following data on wages, education, and experience: Wage Educ...

Hello! I am creating a trivia game in JavaFX and I want to summarize the results of the quiz by listing each question number and whether it was correct or not, along with the final score in a results...

Hello, I am creating an android application in android studio and I am using SQLite as the local database. I am using MySQL database as the application server. I want to be able to pull the data from...

What are the reasons an auditor might plan to perform some procedures at an interim date and others during or after the client has closed its books after the fiscal year end?

Arrange these species into isoelectronic groups. It does not matter which group goes in which box, so long as the correct species are grouped. Ne Ar Isoelectronic group Lit N- Isoelectronic group B...

Question 3 3 pts Suppose the interest rate is r . The present value of $ 1 0 0 that will be paid two years from today is 1 0 0 ( 1 r ) 2 . True Fatse

Write a java code to create a Movie class to hold information about Movies; Attributes are Movies name Length of the movie Rating You can define other attributes if you need in your design Your code...