The required items must be included in the filed file, if missed, will be deducted.
Please specify all items in the checklist file, not missing.
Limited time – I had finished in an 1 hour
6 hours
1 For a limited time, if you have not solved the problem, please still submit the correct answer in the email on time. After that, the final solution can be submitted later. 2 If submitted after the time limit will be deducted. 3 Please check the integrity, integrity, do right with your capacity.
-
The Creator Name: Mahavir Singh
-
Language development program Front End: Html, css, js, jquery, angular6 Back End: Java – Spring Boot – Restfull – MyBatis – Web-MySQL
-
Framework using E.G.) Spring, mybatis
-
Start time E.G.) 10 h on October 15, motorised
-
End time E.G.) 13 h 10 p on October 15
-
The total time 2 hours 50 minutes
-
employee information registration?
-
are there formal form for email?
-
the formal form for email is
-
There are regular forms for a phone number?
-
the main form of transport for the phone number is □ Yes □ No
□ Yes □ No
E.G.) [a-z] @ [a-z] □ Yes □ No
E.G.) [0-9] *-[0-9] *-[0-9] * < Capture screen for the corresponding function >
To be left in blank
Employee management program
Employee information needs to be stored in the DB includes employee code (3 digits), your name, phone number, location, mail address, please create the page can satisfy the following functions.
A) Function
- registration information
- In the list of employees
A. the content in: employee code, location, name, phone number, email B. by: order name (alphabetically) C. employee code always be printed with full three digits. (If the number 1 is 001)
-
find the staff A. can search according to the filter.
-
Editing employee information A. you can edit all employee information including employee code.
-
Delete the employee information
-
Employee information download A. list of staff can download as CSV file B. the plus point: XLS/XLSX file download
-
the plus Points - Feature updates of Repository on basis of requrests i gets A. can send mail to all employees once a day B. can send mail according to the desired time or the mail address wanting. C. Mail sent using the JavaMail API. D. use smtp.gmail.com SMTP server.
B) requirements – Additionally I had used Angular
- using Spring, MyBatis, jQuery, CSS ... to do the test
- Database Select one of the following categories: PostgreSQL, MySQL, Oracle. When submitting articles, please submit the attached SQL query related to the table structure and data basis. 3 Employee code is the only value.
- Each different filter must enter the correct form may register and edit.
- your phone number and email address to use the formal form for the right to enter.
- refer to the regular form of JAVA programs: java. util. regex package