《《数据库原理及应用课程设计报告》.doc》由会员分享，可在线阅读，更多相关《《数据库原理及应用课程设计报告》.doc（34页珍藏版）》请在三一文库上搜索。
1、 数据库原理及应用课程设计报告设计题目员工信息管理系统系统专业：计算机科学与技术班级：10计算机科学与技术（2）班姓名：曹 锋100312202程 昞100312206刘 劝100312223孙志强100312232王海川100312233谢 凯100312241指导老师：黄孝年 月日学号1003122020623323341姓名曹 锋程 昞刘 劝孙志强王海川谢 凯评价CCABBC开发背景 对于一个只有十个以下员工的企业来说，老板可以凭借自己的记忆力记住员工的基本信息、简历、工资信息等资料。 但是对于一个几十人、上百人、甚至上千人的企业来说，光凭管理者的记忆力肯定是不够的，采用手工记账的方式会
2、非常不方便。如果有一款管理软件能够完成公司员工信息的管理，这样会大大减轻管理者的负担。 需求分析 一个典型的员工信息管理系统需要有下面的功能： 需要有一个记录员工的员工编号、姓名、性别、籍贯、出生日期、住址等基本信息的员工基本信息管理模块； 需要有一个能够管理员工的学历、毕业院校、毕业时间、工作经历等信息的员工简历信息管理模块； 需要有一个能够管理员工的基本工资、奖金、个税、实发工资、发工资时间等信息的员工工资信息管理模块。绘制用例图设计系统功能 绘制用例图设计系统功能 系统开发环境 系统开发平台：Visual C+ 6.0。 数据库管理系统软件：Access 2003。 运行平台：win7数
3、据库分析 数据库概念设计 1,员工基本信息2.员工简历信息3. 员工工资信息数据库逻辑结构设计 1.“basicInfo”表的逻辑结构字段名数据类型是否主键描述id文本(varchar)是员工编号name文本(varchar否员工姓名sex文本(varchar)否性别home文本(varchar)否籍贯birthday文本(varchar)否出生日期phone_number文本(varchar)否电话号码status文本(varchar)否现任职务address文本(varchar)否家庭住址2.“work_resume”表的逻辑结构字段名数据类型是否主键描述id文本(varchar)是员工编
4、号name文本(varchar否员工姓名highest_degree文本(varchar)否最高学位highest_degree_time整数(int)否毕业时间college_school_name文本(varchar)否大学学校名称work_experience1文本(varchar)否工作经历1work_experience2文本(varchar)否工作经历2work_experience3文本(varchar)否工作经历33.“salary”表的逻辑结构字段名数据类型是否主键描述id文本(varchar)是员工编号name文本(varchar否员工姓名basic整数(int)否基本工资
5、bonus整数(int)否奖金tax整数(int)否个人税total整数(int)否实发工资year_month文本(varchar)否发工资年月应用系统界面的设计登陆口令登陆界面主界面员工基本信息添加信息Opinions and suggestions on the partys mass line educational practiceAccording to the central and provincial, municipal unified deployment, according to municipal Party committee about carrying out
6、 the partys mass line educational practice activity in the citys implementation opinions, the spirit of the partys mass line educational practice activities from 20* in January to 99 months, carried out at all levels of departments and directly affiliated institutions and grass-roots party organizat
7、ions. According to my actual County, the county to carry out the education practice put forward the following implementation opinions.First, the overall requirementsCounty county education practice to the eighteen Party of eight, the spirit of the the third Plenary Session of the 18th CPC Central Co
8、mmittee as the guidance, conscientiously implement the spirit of general secretary Xi Jinping book series of important speech, earnestly implement the Central Committee really, opinions and advice , party implementing the guiding ideology of opinions to determine the objectives and requirements, ste
9、p method, in accordance with the look in the mirror, dress up, wash bath, cure treatment, the general requirements of for the people pragmatic honest people as the theme, in carrying forward the spirit of Zhuanglang Zhuang, improve their work style, service to the masses of the people, the foundatio
10、n of consolidating grassroots, promote transformation across efforts, to further implement the central eight regulations and The opposition party and government austerity waste regulations , double section provincial regulations, municipal provisions of the twelve plan and the implementation measure
11、s for on improving the work style of close ties with the masses law, highlight style building, carry out the whole wind spirit, resolutely oppose formalism, bureaucracy, hedonism and wasteful extravagance to solve the problems, Party members and cadres of the style and the masses of people strong, t
12、he Ministry of Party members and cadres to further improve their thinking and understanding, to further change the style of the wind, the masses to close, honest and pragmatic people honest image to further establish the foundation to further reinforce the basic level. Style of the building of the n
13、ew results to promote the construction of a powerful force of the county and the ecological culture of the county and county construction.In educational practice activities of the unit is mainly: the county and below county departments under the organs, enterprises and institutions directly under th
14、e township, street, and community, village, non-public economic organizations, social organizations and other grass-roots organizations. Agencies and branches, each single unit, follow the rules on internal institutions. Educational practice with step by step.To adhere to the county leadership, lead
15、ership and leading cadres to focus on outstanding catch to directly contact the service of the masses of law supervision departments and window units, service industry, educational practice, pay attention to grasp the heavy towns, streets and villages, community education activities and the masses o
16、f grassroots groups in close contact to strengthen, and the majority of Party members, cadres and the mass line line Marx doctrine view of the masses and the partys education.Always speak seriously as a basic attitude, adhere to positive education, to carry out criticism and self criticism group, ad
17、here to the pragmatic, more emphasis on leadership, pay more attention to the layers of the demonstration, more focus on the four winds, solve the problem, pay more attention to open the door, the participation of the masses, pay more attention to the classification guidance. Orderly, pay more atten
18、tion to the cooperation and cohesion driven, more strict requirements on injection, really supervision practice, ensure education practice is not empty is not empty is not partial, not as a mere formality.Two, the key point of the taskThe main task of the countys education practice is to seize again
19、st four wind this focus on centralized solve outstanding problems asked County, township leadership and leading cadres of the four winds, the disadvantages of the style, scale behavior to a large scale investigation, overhaul, cleaning greatly. At the same time, respond to the concerns of the masses
20、, safeguard the interests of the masses, pay attention to solve practical problems, solve the people around the unwholesome tendencies especially on eat, take the card, Yong lazy luxury, extravagance and waste fees, privileges and other issues, timely and effective, without any discount to solve, to
21、 improve the style of real implementation of the requirements of real to the grassroots, real let group Benefit the public.(a) focus on solving the four winds outstanding issuesThe central and provincial requirements, the county leadership and leading cadres of key performance concept is not correct
22、, do not dare to play, to engage in image project, political project, a leadership guide, a set of ideas, orders and prohibitions, and a policy, there are countermeasures county. The units directly under the heavy focus on solving Yung lazy drag, buck passing skin, work is not implemented, the servi
23、ce is not active. The dynamic problem of law enforcement and supervision departments and window units, service industry mainly solve the door hard, ugly face, something difficult, and arbitrary charges, fines, levies, and breach of privilege, chinakayao, not the problem of law. The township, street
24、The collar of leading bodies and leading cadres to solve key does nottheir own conditions to develop the correct road, the maximum to avoid investment risk, gain profit.(three) vigorously promote the brand. To establish brand awareness, awareness of the use of brand, brand value, brand acquisition p
25、erformance, enhance the competitive strength. Concentrated manpower, careful planning, packaging and publicity of a number of unique, market influence and coverage of the brand, the implementation of key breakthroughs, to enhance the competitive strength, walking business road the competition of ali
26、enation and characteristics, the pursuit of stability and development of the market.(four) to promote the integration of resources. To further broaden their horizons, effective integration of resources within the group, the city resources, other industries and regional resources, mutual trust, mutua
27、l benefit, seeking win-win principle, in the framework of national policies and regulations, strict inspection and argumentation, legal consultation, examination and approval procedures, strict regulation of economic activities, attract injection the social investment to the industry group, to achie
28、ve leveraging the development, ensure that the value of state-owned assets.(five) to strengthen the construction management personnel. Strengthen the management of education and training of cadres and workers of the existing business, firmly establish the concept of the market, enhance the sense of
29、crisis to adapt to market competition, the sense of urgency, improve the ability to respond to market competition, improve management and operation of the market. At the same time, according to the need of industrial development, vigorously the introduction of high-quality management management pers
30、onnel, and strive to build a high-quality professional management team, hard work, and promote the entire workforce knowledge structure, age structure, structure optimization and upgrading ability, enhance core competitiveness, adapt to the need of market competition.(six) seriously study the policy
31、 for policy. Serious research about social support the development of cultural undertakings in the country and the XX policy, especially the policy of industrial development, financial investment policy, financial policy and tax policy, and actively seek policy, projects and funds, enterprise and in
32、dustry group mission to promote leapfrog development.修改性别删除该信息刘劝密码修改程序及代码登陆口令void CDlgLogin:OnOK() / TODO: Add extra validation hereCString username,password;/定义两个字符串变量m_edit_UserName.GetWindowText(username);/将文本框中的值赋给usernamem_edit_password.GetWindowText(password);/将文本框中的值赋给帕passwordm_logined_user
33、= username; if(!m_database.IsOpen()/如果数据没有打开，则打开数据库if(m_database.Open(_T(StaffManageSystem)/如果正确打开数据库m_recordSet.m_pDatabase=&m_database;/将m_database对象赋给m_pDatabaseCString strSQL;strSQL.Format(select * from UserInfo where name=%s and password=%s,username, password); m_recordSet.Open(CRecordset:forwa
34、rdOnly,strSQL);/打开记录集if(m_recordSet.GetRecordCount()=0)/如果找不到记录MessageBox(密码错误,请重新输入,密码错误,MB_OK|MB_ICONWARNING);/提示密码错误 m_edit_password.SetWindowText();/清空密码文本框 m_edit_password.SetFocus();/设置用户名文本框为当前的焦点else/如果找到记录 CDialog:OnOK();/进入到主窗口m_recordSet.Close();/关闭记录集m_database.Close();/关闭数据库else/如果没有正确打
35、开数据库MessageBox(不能打开数据库);修改密码按键void CDlgAddUser:OnOK() / TODO: Add extra validation hereUpdateData();/判断新密码是是为空if(m_add_user_password.IsEmpty()|m_add_confirm_password.IsEmpty()MessageBox(密码不为空);elseif (m_add_confirm_password != m_add_user_password)MessageBox(两次输入密码不一致，请重新输入新密码);m_add_confirm_password
36、.Empty();m_add_user_password.Empty();UpdateData(FALSE);elseCDialog:OnOK();添加员工基本信息void CCase1View:OnAddBasicinfo() / TODO: Add your command handler code herem_dlgBasicInfo.m_addFlag = true;m_dlgBasicInfo.m_editFlag = false;/-/ 调用“员工基本信息管理”对话框if (IDCANCEL = m_dlgBasicInfo.DoModal()return;/-/ 新的员工基本信息
37、写入数据库CString strSexInfo;if (m_dlgBasicInfo.m_sex = 0)strSexInfo = 男;else if (m_dlgBasicInfo.m_sex = 1)strSexInfo = 女;elseMessageBox(请选择员工性别);if(m_dlgBasicInfo.m_str_id.IsEmpty() | (m_dlgBasicInfo.m_str_name.IsEmpty()MessageBox(员工编号和姓名不能为空);elseCString strSQL;strSQL.Format(INSERT INTO basicInfo (id,
38、name, sex, home, birthday, phone_number, status, address) VALUES (%s, %s, %s, %s, %s, %s, %s, %s), m_dlgBasicInfo.m_str_id, m_dlgBasicInfo.m_str_name, strSexInfo, m_dlgBasicInfo.m_str_home, m_dlgBasicInfo.m_str_birth_day,m_dlgBasicInfo.m_str_phone, m_dlgBasicInfo.m_str_status, m_dlgBasicInfo.m_str_a
39、ddress);m_Db.ExecuteSQL(strSQL); AfxMessageBox(员工基本信息添加完毕！);strSQL = select * from basicInfo;DrawBasicInfoList(strSQL);员工简历信息按键void CCase1View:OnAddResume() / TODO: Add your command handler code herem_dlgResume.m_addFlag = true;m_dlgResume.m_editFlag = false;/-/打开“员工简历管理”对话框if (IDCANCEL = m_dlgResum
40、e.DoModal()return;/-/ 新的简历信息写入数据库if(m_dlgResume.m_str_id.IsEmpty() | (m_dlgResume.m_str_name.IsEmpty()MessageBox(员工编号和姓名不能为空);elseCString strSQL;strSQL.Format(INSERT INTO work_resume (id, name, highest_degree, highest_degree_time, college_school_name, work_experience1, work_experience2, work_experie
41、nce3) VALUES (%s, %s, %s, %d, %s, %s, %s, %s), m_dlgResume.m_str_id, m_dlgResume.m_str_name, m_dlgResume.m_str_degree,atoi(m_dlgResume.m_str_grad_year), m_dlgResume.m_str_school, m_dlgResume.m_str_work_exp1, m_dlgResume.m_str_work_exp2, m_dlgResume.m_str_work_exp3);m_Db.ExecuteSQL(strSQL);AfxMessage
42、Box(员工简历信息添加完毕！);strSQL = select * from work_resume;DrawResumeList(strSQL);/-员工工资信息按键void CCase1View:OnAddSalary() / TODO: Add your command handler code herem_dlgSalary.m_addFlag = true;m_dlgSalary.m_editFlag = false;/-/打开“员工工资管理”对话框if (IDCANCEL = m_dlgSalary.DoModal()return;/-/ 新的工资信息写入数据库if(m_dlgS
43、alary.m_str_id.IsEmpty() | (m_dlgSalary.m_str_name.IsEmpty()MessageBox(员工编号和姓名不能为空);elseint i_total = atoi(m_dlgSalary.m_str_basic_salary) + atoi(m_dlgSalary.m_str_bonus) - atoi(m_dlgSalary.m_str_tax);CString strSQL;strSQL.Format(INSERT INTO salary (id, name, basic, bonus, tax, total, year_month) VALUES (%s, %s, %d, %d, %d, %d, %s), m_dlgSalary.m_str_id, m_dlgSalary.m_str_name, atoi(m_dlgSalary.m_str_basic_salary),atoi(m_dlgSalary.m_str_bonus), atoi(m_dlgSalary.m_str_tax),i_total, m_dlgSalary.m_str_d