Table of Contents
Reply to the discussion (solution)
Home Web Front-end HTML Tutorial Please help me, I need answers tonight! ! ! _html/css_WEB-ITnose

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

Jun 24, 2016 pm 12:22 PM

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? (^ω^)?

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Difficulty in updating caching of official account web pages: How to avoid the old cache affecting the user experience after version update? Difficulty in updating caching of official account web pages: How to avoid the old cache affecting the user experience after version update? Mar 04, 2025 pm 12:32 PM

The official account web page update cache, this thing is simple and simple, and it is complicated enough to drink a pot of it. You worked hard to update the official account article, but the user still opened the old version. Who can bear the taste? In this article, let’s take a look at the twists and turns behind this and how to solve this problem gracefully. After reading it, you can easily deal with various caching problems, allowing your users to always experience the freshest content. Let’s talk about the basics first. To put it bluntly, in order to improve access speed, the browser or server stores some static resources (such as pictures, CSS, JS) or page content. Next time you access it, you can directly retrieve it from the cache without having to download it again, and it is naturally fast. But this thing is also a double-edged sword. The new version is online,

How do I use HTML5 form validation attributes to validate user input? How do I use HTML5 form validation attributes to validate user input? Mar 17, 2025 pm 12:27 PM

The article discusses using HTML5 form validation attributes like required, pattern, min, max, and length limits to validate user input directly in the browser.

What are the best practices for cross-browser compatibility in HTML5? What are the best practices for cross-browser compatibility in HTML5? Mar 17, 2025 pm 12:20 PM

Article discusses best practices for ensuring HTML5 cross-browser compatibility, focusing on feature detection, progressive enhancement, and testing methods.

How to efficiently add stroke effects to PNG images on web pages? How to efficiently add stroke effects to PNG images on web pages? Mar 04, 2025 pm 02:39 PM

This article demonstrates efficient PNG border addition to webpages using CSS. It argues that CSS offers superior performance compared to JavaScript or libraries, detailing how to adjust border width, style, and color for subtle or prominent effect

What is the purpose of the <datalist> element? What is the purpose of the <datalist> element? Mar 21, 2025 pm 12:33 PM

The article discusses the HTML &lt;datalist&gt; element, which enhances forms by providing autocomplete suggestions, improving user experience and reducing errors.Character count: 159

What is the purpose of the <progress> element? What is the purpose of the <progress> element? Mar 21, 2025 pm 12:34 PM

The article discusses the HTML &lt;progress&gt; element, its purpose, styling, and differences from the &lt;meter&gt; element. The main focus is on using &lt;progress&gt; for task completion and &lt;meter&gt; for stati

How do I use the HTML5 <time> element to represent dates and times semantically? How do I use the HTML5 <time> element to represent dates and times semantically? Mar 12, 2025 pm 04:05 PM

This article explains the HTML5 &lt;time&gt; element for semantic date/time representation. It emphasizes the importance of the datetime attribute for machine readability (ISO 8601 format) alongside human-readable text, boosting accessibilit

What is the purpose of the <meter> element? What is the purpose of the <meter> element? Mar 21, 2025 pm 12:35 PM

The article discusses the HTML &lt;meter&gt; element, used for displaying scalar or fractional values within a range, and its common applications in web development. It differentiates &lt;meter&gt; from &lt;progress&gt; and ex

See all articles