基于javaweb的JSP+Servlet员工出差请假考勤管理系统(java+jsp+layui+html+servlet+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计,大作业,毕业设计,项目练习,学习演示等

功能说明

270023582402

290023582402

300023582402

310023582402

320023582402

330023582402

基于javaweb的JSP+Servlet员工出差请假考勤管理系统(java+jsp+layui+html+servlet+mysql)

项目介绍

本项目为后台管理系统;

管理员角色包含以下功能:

登录,首页,考勤记录增删改查,假期申请记录增删改查,出差申请记录增删改查,加班申请记录增删改查,调休申请,考勤查询,查看考勤详情,员工管理增删改查等功能。

环境需要

1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS;  5.数据库:MySql 5.7版本; 6.是否Maven项目:否;

技术栈

HTML+JSP+CSS+JavaScript+LayUI+Servlet+Mysql

使用说明

  1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中c3p0-config.xml与utils/C3P0Utils.java配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入http://localhost:8080/kaoqin 登录 管理员账号/密码:admin/123456

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}

}
package cn.itheima.web;



/**
* Servlet implementation class ChuchaishenqingAdd
*/
public class ChuchaishenqingAdd extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public ChuchaishenqingAdd() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String chuchaishijian = request.getParameter("chuchaishijian");
String chuchaitianshu = request.getParameter("chuchaitianshu");
String[] tongxingrenyuan = request.getParameterValues("tongxingrenyuan");
StringBuilder sb = new StringBuilder();
String mudidi = request.getParameter("mudidi");
String chuxingfangshi = request.getParameter("chuxingfangshi");
String shiyou = request.getParameter("shiyou");
for(int i = 0 ; i<tongxingrenyuan.length-1; i++) {
sb.append(tongxingrenyuan[i]).append(',');
}
sb.append(tongxingrenyuan[tongxingrenyuan.length-1]);
Chuchaishenqing c = new Chuchaishenqing();
c.setChuchaishijian(chuchaishijian);
c.setChuchaitianshu(chuchaitianshu);
c.setTongxingrenyuan(sb.toString());
c.setMudidi(mudidi);
c.setChuxingfangshi(chuxingfangshi);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
package cn.itheima.web;




/**
* Servlet implementation class KaoqinjiluAdd
*/
public class KaoqinjiluAdd extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public KaoqinjiluAdd() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String kaoqinshijian = request.getParameter("kaoqinshijian");
String leibie = request.getParameter("leibie");
String staff_name = request.getParameter("staff_name");
String kaoqinshiduan = request.getParameter("kaoqinshiduan");
String shuoming = request.getParameter("shuoming");
String jiluren = request.getParameter("jiluren");
Kaoqinjilu k = new Kaoqinjilu();
k.setKaoqinshijian(kaoqinshijian);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
				request.setAttribute("shujuzidianList", shujuzidianList);		
request.setAttribute("count", count);
request.getRequestDispatcher("view/views/system/shujuzidian.jsp").forward(request, response);
}else {
pageBean = service.findPageBean(name,currentPage,currentCount);
shujuzidianList = service.findShujuzidianByName(name);
count = service.CountByName(name);
request.setAttribute("pageBean", pageBean);
request.setAttribute("shujuzidianname", name);
request.setAttribute("shujuzidianValueList", shujuzidianList);
request.setAttribute("count", count);
request.getRequestDispatcher("view/views/system/shujuzidian.jsp").forward(request, response);
}
} catch (SQLException e) {
e.printStackTrace();
}


}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}

}
package cn.itheima.web;



/**
* Servlet implementation class ChuchaishenqingEdit
*/
public class ChuchaishenqingEdit extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38



/**
* Servlet implementation class KaoqinjiluAdd
*/
public class KaoqinjiluAdd extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public KaoqinjiluAdd() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String kaoqinshijian = request.getParameter("kaoqinshijian");
String leibie = request.getParameter("leibie");
String staff_name = request.getParameter("staff_name");
String kaoqinshiduan = request.getParameter("kaoqinshiduan");
String shuoming = request.getParameter("shuoming");
String jiluren = request.getParameter("jiluren");
Kaoqinjilu k = new Kaoqinjilu();
k.setKaoqinshijian(kaoqinshijian);
k.setLeibie(leibie);
k.setStaff_name(staff_name);
k.setKaoqinshiduan(kaoqinshiduan);
k.setShuoming(shuoming);
k.setJiluren(jiluren);
KaoqinjiluService service = new KaoqinjiluService();
try {
service.add(k);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
		j.setShenqingshijian(shenqingshijian);
j.setStaff_name(staff_name);
j.setYuanyin(yuanyin);
JiabanshenqingService service = new JiabanshenqingService();
try {
service.update(j);
Thread.sleep(3000);
response.sendRedirect(request.getContextPath() + "/JiabanshenqingList");
} catch (Exception e) {
// TODO: handle exception
}
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
* response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}

}
package cn.itheima.web;




/**
* Servlet implementation class JiaqishenqingList
*/
public class JiaqishenqingList extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public JiaqishenqingList() {
super();
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}

}
package cn.itheima.web;




/**
* Servlet implementation class KaoqinjiluList
*/
public class KaoqinjiluList extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public KaoqinjiluList() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
KaoqinjiluService service = new KaoqinjiluService();
String currentPageStr =request.getParameter("currentPage");
if(currentPageStr==null) currentPageStr="1";
int currentPage = Integer.parseInt(currentPageStr);
int currentCount=4;
Long count = null;


项目链接:
https://javayms.github.io?id=191122572008200td
https://javayms.pages.dev?id=191122572008200td