form-in-spring

CRUD operation to database in simple form

This is my old project. The project contains one main commit that adds the whole project. The whole story is on my BitBucket. I decided so because it contained commits that kept the state of the application down (which I think is not good) and a description of the problems and the reason for using the solution. Used technologies:

• Spring Boot
• Spring Data JPA
• Hibernate
• Maven
• Lombok
• MySQL
• Thymeleaf
• SQL
• JavaScript, jQuery
• HTML, CSS

Data generated at https://www.generatedata.com/#t1

To do:

Pagination of pages

• The entry to the page starts from the page pagination by default
• The Cancel operation on the form when adding and updating data should transfer to the previous pagination page
• When sorting, the returned result should be displayed in pagination of pages in the main URL path
• When sorting data, switching to the next page of pagination should keep the table in the form sorted after the selected sort criterion
• Sorting on any page of pagination can not redirect to the first pagination page, the current subpage must be updated with the appropriate sort result
• After switching to the next subpage of searched results, these should be the next searched phrases
• After deleting all records from a given sub-page, the table's header itself is displayed - to redirect in this case to the page with records

Search

• The ability to search data for part of the expression, e.g. 'What', 'what', 'Comp', 'any', 'pan', 'PANY', 'cOmPa', etc. should return, among others, CompanyOne and JavaCompany and other matching expressions, exactly the same case for searching on the fields vatId and regNo
• Data search should be returned in pagination of pages
• The search result should be returned in the main URL path (without redirecting to another subpage)
• The ability to search by clicking the mouse in the buton and not exclusively by enter
• If the given data was not found information about it instead of the table header only

Addition, Data update

• Ability to add and update data
• Adding multiple addresses and contacts to one client

Data removal

• All related data should be removed from all tables in the database and not only from one
• In the message confirming the deletion of data should be given the name of the client from the field Client.name
• Deleting a position from the current pagination subpage can not redirect to the first pagination page - it must be the current subpage from which the record is removed

Error handling

• Error message page instead of the standard server error message

---