Please help me, I need answers tonight! ! ! _html/css_WEB-ITnose

Employee query system

1. Language and environment
A. Implementation language: Java
B. Implementation technology: HTML, JavaScript, JSP, Servlet
C. Environment requirements: Eclipse , database (Oracle, MySql optional), Tomcat
D. No style requirements when designing web pages
2. Requirements
XXX company has a personnel management system, one of the functional modules is based on employee positions, Employee name is used to query employee details.
2.1 Function and page design requirements:
1) The query page can display the employee’s position name, and the display content of the position name comes from the database table Employee. Job titles cannot be repeated.
2) The query page can complete the client verification work and provide verification prompts for unselected job categories.
3) The result display page can query the results based on the entered employee name and selected employee position, and correctly use the table to display the results. If the query content is empty, the prompt message should be displayed correctly.
2.2 Database design requirements:
1) All fields of the database table Employee must be set according to the contents of (Table 1). The content is filled in the data table according to the content of (Table 2).
Employee Table 1:
Table name EMPLOYEE
Primary key Id
Serial number field name Field description Type Digits Attribute remarks
1 Id Employee number int 4 Required, not empty
2 POST_TYPE Position category int 4 required, not empty 1: administrative assistant, 2. business manager
3. general manager
3 EMP_NAME employee name varchar 100
4 EMP_SEX employee gender int 4 1: male, 2: female
5 EMP_AGE Employee age int 4
6 EMP_DEPART Department varchar 50
7 EMP_YEAR Employee length of service int 4

3. Recommended implementation steps
1. Establish a database
A. Create a database table. For the structure of the table, please refer to the structure of the above table:
B. After the database is completed, enter the test data recorded below, as shown in the table below:
Test data Table 2:
Id POST_TYPE EMP_NAME EMP_SEX EMP_AGE EMP_DEPART EMP_YEAR
00001 1 Li Xiaoming1 25 Administration Department 2
00002 1 Yang Weilin 1 29 Administration Department 5
00003 2 You Zhimiao 2 33 Business Department 9
00004 3 Niu Xiaofei 1 40 Group 10
2. Design WEB page
Create project:
A. Create a JAVA WEB project in Eclipse.
Make the home page:
A. Design the main page for employee query, named search.jsp. The page style can be seen in Figure 1.
B. When clicking the "Query Employee Details" button, it is necessary to verify whether the customer has selected a job name. If the customer does not select a job name, the message "Please select a job name" will be prompted.
C. When the employee name on the home page is empty, all records will be displayed.
D. When the "employee name" item and the "position name" item are both used as conditions, find the query records that meet the conditions as required.

Figure 1 Query main interface

Design and production results page:
After the customer fills in the employee name or selects the employee position, click the "Query" button to start querying according to the requirements, display The query result page is shown in Figure 2:

Figure 2 Employee details display page
4. Notes:
Please pay attention to the code writing standards, comment methods, entity naming standards, etc.
5. Submission method
Export the project as a zip file (named "student ID.zip", for example, 20090100.zip) and upload it. For the upload method, refer to the "Upload File Format Instructions".

Reply to the discussion (solution)

It should be okay, it won’t be too difficult

It would be okay if I help you write a static html page . . There was real pressure backstage. .

Come on, host? (^ω^)?