Current location - Education and Training Encyclopedia - Graduation thesis - Database system development paper
Database system development paper
1

Introduction 2

1. 1 question 2

Two. System overview 4

2. 1 Functions mainly completed by this system 4

2.2 System Preview Figure 4

Analysis of three major system requirements 5

System design and architecture 6

4. 1 System design idea 6

4.2 System Structure Design 6

4.3 System Function Module Subdivision 7

4.4 Design, Generation and Configuration of Database 7

4.5 Compilation of Public Module 12

4.6 Personal User Interface Design 27

4.7 Enterprise User Interface Design 43

Five abstracts 45

Six thanks 45

7 references 46

abstract:

With the development of Internet information, the application of Internet in people's life is more and more extensive. The recruitment website provides a convenient and quick way for candidates to apply. For the recruitment unit, the recruitment website also provides them with the conditions to query and retrieve the candidate information base, which makes the primary selection of personnel in the recruitment work easy. The development of this system has brought great convenience and economy to job seekers and recruitment companies, so that they can easily complete job hunting and recruitment without leaving home.

The core content of this system development is to realize the interactive choice between enterprises and talents in the recruitment process. This kind of interaction can be understood as four aspects: the information of the enterprise itself, the information of the enterprise recruitment, the information of the talents themselves and the information of the talents' job hunting. At the same time, in order to better realize these interactions, it is necessary to provide some subsidiary columns, such as website news, policies and regulations. , in order to facilitate the transmission of information.

Keywords: talent, job hunting

abstract:

With the development of online information, the Internet is more and more used in people's lives. The recruitment website provides a convenient and quick way for candidates. As far as recruiting units are concerned, the recruitment website also provides them with information and searches the candidate information database, making it easy to recruit junior employees. This system brings a lot of convenience and economy for recruiting candidates, so that they can easily complete job hunting and recruitment without leaving home.

The core of developing this system is to realize the interaction between enterprise recruitment and talent selection, which can be understood as four aspects: enterprise information, enterprise recruitment information, talent information and enterprise recruitment information. At the same time, in order to better realize these interactions, it is necessary to provide some subsidiary columns, such as news websites, policies and regulations, to facilitate the transmission of information.

Keywords: human resources, job seekers

Talent recruitment is an important part of enterprise knowledge management, which involves the overall quality level of enterprise employees. In the past, the selection of talents was often very complicated, and the review of countless resumes would consume a lot of manpower. The differences between online recruitment and traditional recruitment methods are as follows: first, it saves costs, and applicants do not have to rush to the recruitment site to print and put in multiple resumes. Enterprises can directly call the comparison from the computer when reviewing resumes, which greatly reduces labor costs; Second, it is convenient to establish an electronic talent pool for resumes in case of emergency. Online job recruitment has become an important means of job recruitment, and the scale and success rate of job recruitment have approached the traditional job fair, and some even surpassed the traditional job fair. Through it, applicants and recruitment companies/units can break through the time and space restrictions on the Internet and realize job hunting and talent recruitment of companies/units. The rise of online recruitment has had a strong impact on the traditional talent recruitment and circulation system. Compared with traditional recruitment, online recruitment has the characteristics of wide recruitment scope, large amount of information, large choice, high quality of candidates, good recruitment effect and low cost, which has won the recognition advantage of more and more enterprises. At the same time, it has the characteristics of low operating cost, virtual inventory, convenient user retrieval and less geographical restrictions.

The core content of this system development is to realize the interactive choice between enterprises and talents in the recruitment process. This kind of interaction can be understood as four aspects: the information of the enterprise itself, the information of the enterprise recruitment, the information of the talents themselves and the information of the talents' job hunting. At the same time, in order to better realize these interactions, it is necessary to provide some subsidiary columns, such as website news, policies and regulations. , in order to facilitate the transmission of information.

introduce

Put forward the question of 1. 1

In the current market environment. With the progress of society and the development of technology, knowledge is playing a great role.

The role of market competition is largely reflected in the competition for talents. Therefore. Finding suitable talents has become a key task for enterprises to improve their competitiveness. Meanwhile. Today's market environment is also a rapidly changing environment. The market demand is changing, and the demand for talents is also changing accordingly. How to quickly adapt to this change, improve the efficiency of talent recruitment process and quickly locate has become an important factor for talent recruitment companies/units to consider.

Whether it is for the recruitment service of enterprise human resources department, or the cross-regional supply and demand information communication of professional intermediaries, or the export of foreign labor services. As a service type, its service objects all contain demand-driven features. The efficiency and effect of recruiting personnel it achieves is the value and reason of its existence. For another service object of the mediation service. That is, suppliers, people all over the world looking for suitable jobs. We are also concerned about whether we can get the information and conditions of job requirements quickly. All these have created a demand for information systems. Only through the information system can we realize the understanding and demand research based on the talent recruitment market.

In order to meet the market demand for talent recruitment solutions, an online talent recruitment solution was launched. As a professional business process improvement tool, it effectively solves the problem of improving the efficiency and effectiveness of talent recruitment. This graduation project is an attempt to adapt to modern job hunting/recruitment methods. This system adopts ASP, a server-side development environment, and Windows XP operating system as the working platform. At the same time, this graduation project is realized with the help of Microsoft Access2000, a powerful database management system.

1.2 the research route of this paper

Online recruitment system is an online recruitment system built by using the Internet, which involves the subject of online recruitment. The construction of a website should start with the function. Function is the purpose of the website, and it is a waste of time to sacrifice the demand for function for "personality". Usually, the functional requirement is nothing more than: (1) can clearly express the theme of a website. (2) It can accommodate various forms of content. To develop an excellent website, we usually follow the following workflow: first, make clear the purpose of developing the website; Next, design the appearance of the website; Secondly, make the actual page; Then test the website to ensure that it meets the original goal; Finally, publish the website. After the website is published, it needs to be maintained in order to update the content of the website in time. Therefore, to be an excellent online recruitment system, the following requirements must be met. First of all, it is essential to understand the definition, characteristics and advantages of online recruitment in the talent market. Secondly, it is necessary to plan the system website, investigate and analyze the goal and market demand of website construction, analyze the feasibility of website design and management, and deeply analyze the solutions of website design and management. Thirdly, the construction of the online recruitment system website platform, the selection of servers, the knowledge of ASP software and database are the basis of online recruitment.

The implementation of the above-mentioned website operating environment and its software and hardware platform is general and basic, and it is also the basic idea of building an online recruitment system. Through the demonstration theme of online job hunting/recruitment, the interactivity, aesthetics and practicality of the website are fully presented.

Main contents and significance of 1.3

In view of people's demand for online recruitment system, ASP technology is used to make it convenient for people to register online users, put in and find resumes, inquire about employment status, inquire about employers and leave messages.

This paper is divided into six parts, namely: introduction, system overview, demand analysis, system design and architecture, database design and generation and configuration, functional module writing, personal user interface design, enterprise user interface design and summary. In the introduction, it mainly introduces the problem, the necessity of system development and the research route of the system.

The system overview part mainly introduces the system function, application background and system preview.

The system requirements analysis part mainly introduces the system functional requirements description, management flow and data flow chart.

System design and architecture is the part of concrete work realization, and its content is the concrete guidance of system realization, which is divided into three parts: system design idea, system structure design and system function module subdivision.

The installation, testing and debugging of the system mainly introduces the installation and debugging of IIS5.0, how to browse the online system under IIS5.0, and the debugging and testing of the system.

The summary part mainly summarizes the experience of the system in the use process, completes those functions, is different from others or uses those advanced technologies, and what are the shortcomings and deficiencies of the system.

Overview of the second system

2. 1 Main functions of this system

As follows:

Enterprise recruitment

Talent job hunting

User registration (enterprise users and individual users)

User login (enterprise users and individual users)

Talent news

Talent evaluation

personnel training

laws and regulations

charging standards

Leave me a message.

Link exchange

In-station search (query can be made according to position, talent, region, keywords, etc. )

2.2 system preview

Three-system demand analysis

① Functional requirements: In order to meet the market demand for talent recruitment solutions, reduce costs as much as possible, create better employment conditions for more people, and bring convenience to enterprise recruitment.

② Performance requirements: 1. Hardware requirements: CPU:interpentuimii or equivalent processor, 300MHZ or higher.

Memory: 96MB available memory Hard disk: more than 275MB available disk.

space

Display screen: 256-color display screen with 800×600 pixels or higher.

2. Software requirements: operating system windows 98/2000/NT (or higher version).

Browser: netscape navigator4.0 or microsoft internet explover4.0 or higher.

System design and architecture

4. 1 system design idea

① Modularization of pages

This system integrates some common parts of the page into modules, such as the header and footer of the page.

When designing a new page, if there are duplicate parts, you only need to assemble them with ready-made modules.

② Humanization of the process.

The process of the plan fully conforms to the recruitment process of the talent market. Register first, then write.

Personal basic information, and then fill in professional experience, personal business level and other information. At the same time, after the enterprise registration is completed, fill in the basic information of the enterprise, then fill in the name, demand and salary of the required position, and finally fill in the contact information. This process is convenient for users to quickly get familiar with the whole system process and complete job hunting or recruitment.

③ The comprehensiveness of functions.

The design of the program not only considers the realization of the basic function-talent recruitment, but also integrates the modules of news release management and laws and regulations release management into a website program. Improve the function of the website.

4.2 System Structure Design

According to the design idea of object-oriented and three-tier structure, the following system structure design drawing can be obtained:

4.3 system function module subdivision

According to the system function analysis of this system, the function module diagram of the system can be drawn as follows:

4.4 Design, Generation and Configuration of Database

Database plays a very important role in information management of small tonnage year, and the design of database structure will directly affect the efficiency and realization effect of application system. Reasonable database structure design can improve the efficiency of data storage and ensure the integrity and consistency of data.

When designing a database system, we should fully understand the needs of users in all aspects, including existing and possible future needs. Database design has the following steps:

Database requirement analysis

Conceptual structure design of database

Database logical structure design

The following steps are explained respectively:

① database requirement analysis

In the recruitment system, the database should meet the following requirements:

Save candidates' information, including their contact information.

Save the candidate's resume, including the candidate's professional experience and business level.

Save the information of the recruiting unit, including the introduction information of the recruiting unit.

Save recruitment information, including job information and requirements for candidates.

Save other information, such as news, policies and regulations.

① Conceptual structure design of database

With the above data items and data structures, we can design a system that can meet the needs of users.

Various entities and their relationships laid the foundation for the later logical structure design. These entities contain all kinds of specific information and form data streams through their interaction. By analyzing the requirements of this system, we can get the following relationship diagram between entities:

② Design of logical structure of database

After the conceptual structure of the database is designed, the above database concepts can be converted into some numbers.

The actual data model supported by the database system is the logical structure of the database.

The following table is the letter table in the station. Personal and enterprise stationery are placed in the cmailbox table and the pmailbox table respectively, but the structure of the tables is the same:

Field Type Null Key Default Extra Comment

Id int not null prinullidentity (1,1) primary key, added.

Reid Varchar Null null

Senduid Varchar Not Null empty sender id

Sendname Varchar Not Null empty header

Title Varchar Not Null sender user name

Mailtext text is not empty message content.

Newmail Int is not empty. Do you want to read it?

Sdate date time is not empty. Send time

The following table is the news table of jobnwes website, which stores the news information displayed on the homepage of the website:

Field Type Null Key Default Extra Comment

Id int null prinullidentity (1,1) primary key, adding.

Title varchar not null news headlines

Text text non-empty news content

Isate Datetime Not Null empty add time

Click Int Not Null hits.

Left Varchar non-empty author

Chu Varchar non-empty provenance

The following table is the system table of the system website, which stores the common information needed for website operation:

Field Type Null Key Default Extra Comment

Title Varchar Not Null empty website title

Homename Varchar Not Null empty website name

Homeeurl Text Not Null empty web address

Note that Datetime is not empty. Note that the information is empty.

Copyen Int Not Null English copyright information

Tel Varchar non-empty telephone

Top Varchar Not Null home page navigation link

Link 1 1 links a text.

Link 1 link an address.

Ymail business mailbox

Smail technical mailbox

Link22 links two characters.

Link 2 Link 2 Address

Copycn China copyright

Link 3 links three characters.

Link33 links three addresses.

Link4 links four characters.

Link44 links four addresses.

Link5 links five characters.

Link55 links five addresses.

Link6 links six characters.

Link66 Link Six Address

Address company office address

The following table is perscn personal user table, in which the contact information and resume information of individual users are stored:

Field Type Null Key Default Extra Comment

Id varchar not null prinullidentity (1,1) primary key, added.

Uname Varchar Not Null empty user name

Pedvarchar non-empty password

Email Varchar Not Null empty email

Idate Datetime Not Null registration date is empty.

Ji Guo Walchar is of non-empty nationality.

Shengao Varchar Not Null empty height

Nianling Varchar Not Null empty age

Tizhong Varchar Not Null empty weight

Iname Varchar Not Null empty real name

Sex Varchar Not Null empty gender

The following table is copmany enterprise user table, which stores the contact information and enterprise information of enterprise users:

Field Type Null Key Default Extra Comment

Id varchar not null prinullidentity (1,1) primary key, added.

Uname Varchar Not Null empty user name

Pedvarchar non-empty password

Email Varchar Not Null empty email

Idate Datetime Not Null registration date is empty.

Cname Varchar Not Null Null enterprise name

Trade Varchar Not Null Null belongs to industry.

Rstel Varchar non-empty telephone

Trainer Varchar Not Null personnel supervisor

Address Varchar Not Null Null enterprise address

The following table is the zp recruitment position table, which stores the position information of enterprise recruitment:

Field Type Null Key Default Extra Comment

Id varchar not null prinullidentity (1,1) primary key, added.

Usid Varchar Not Null empty user number

Uname Varchar Not Null empty user name

Job Varchar Not Null empty job name

Zptext Datetime Not Null null location information

Click Int Not Null 0 times.

Idate Datetime is not empty, and the release date is empty.

Zpnum text is not empty, and the recruitment number is empty.

Varchar zero age requirement for tree rings

Edus varchar has no educational requirements.

Language requires varchar null.

Jobtypes Varchar Null Null work type

Computer varchar null computer level

Gender requirement is empty.

The valid time is empty.

Marital status requirement is invalid.

Zyes Varchar Null Null

Currency Varchar Null invalid job offer

Gzdd Varchar Null Null

Cname Varchar Null Null

Add time date time Null Null

Cypic Varchar Null Null

4.5 Writing of public modules

① database connection file

The database connection object is defined in the database connection file dbconn.inc, and the data connection is opened.

Connect the backup, open a recordset at the same time, take out some constants needed by the system and save them in local variables.

The contents of the dbconn.inc file are as follows:

Database connection file dbconn.inc

& lt%

Set conn = server. CreateObject("ADODB。 Connect ")

conn . Open " Driver =; DBQ = " & amp; Server. MapPath("database/jy.mdb ")

set RS = createobject(" adodb . recordset ")

sql="select * from system "

Rs.open sql, Connecticut

If not, then

title=rs("title ")

homename=rs("homename ")

homeurl=rs("homeurl ")

copyen=rs("copyen ")

Notification =rs ("notification")

Telephone = Rs. ("Telephone")

top=rs("top ")

link 1=rs("link 1 ")

link 1 1 = RS(" link 1 1 ")

link2=rs("link2 ")

link22=rs("link22 ")

link3=rs("link3 ")

link33=rs("link33 ")

link4=rs("link4 ")

link44=rs("link44 ")

link5=rs("link5 ")

link55=rs("link55 ")

link6=rs("link6 ")

link66=rs("link66 ")

ymail=rs("ymail ")