Java源码社

基于javaweb的JSP+Servlet养老院管理系统(java+jsp+bootstrap+servlet+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

460023592402

470023592402

480023592402

490023592402

500023592402

510023592402

基于javaweb的JSP+Servlet养老院管理系统(java+jsp+bootstrap+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项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目

技术栈

  1. 后端：servlet 2. 前端：JSP+css+javascript+bootstrap+jQuery

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中util/DBO.java配置文件中的数据库配置改为自己的配置; 4. 运行项目，在浏览器中输入http://localhost:8080/yanglaoyuan 登录  管理员账号密码：admin/111 护工账号密码：111/111

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
 */

public class CheckCode {

	public String getCheckCode(){
		Random random = new Random();
		String sRand="";
		for (int i=0;i<4;i++){
	    String rand=String.valueOf(random.nextInt(10));
	    sRand+=rand;
		}
	    return sRand;
	}
}
<%@ page language="java" import="java.util.*"  contentType="text/html;charset=gb2312"%> 
<jsp:useBean id="cb" scope="page" class="com.bean.ComBean" />
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="<%=basePath %>images/css/bootstrap.css" />
<link rel="stylesheet" href="<%=basePath %>images/css/css.css" />
</head> 
<script  language="javascript" >
function top2(){
   	form3.action="<%=basePath%>admin/lr/index.jsp?page=1";
    form3.submit();
}
function last2(){
    form3.action="<%=basePath%>admin/lr/index.jsp?page=1";
    form3.submit();
	}else{
	form3.action="<%=basePath%>admin/lr/index.jsp?page="+form3.pageCount.value;
    	form3.submit();
	}
}
function pre2(){
  var page=parseInt(form3.page.value);
  if(page<=1){
  }else{
    form3.action="<%=basePath%>admin/lr/index.jsp?page="+(page-1);
    form3.submit();
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
}
package com.util;


public class DBO {

    private Connection conn;
    private Statement stmt;
    private DataSource ds;

    public DBO() {
    }

    /**
     * 打开数据库
     */
    public void open() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai&autoReconnect=true&failOverReadOnly=false&allowPublicKeyRetrieval=true&allowMultiQueries=true&zeroDateTimeBehavior=convertToNull",
                    "root", "123456");
            stmt = conn.createStatement();
            System.out.println("打开数据库连接");
        } catch (Exception ex) {
            System.err.println("打开数据库时出错: " + ex.getMessage());
        }
    }

    /**
     * 关闭数据库，将连接返还给连接池
     */
    public void close() {
        try {
            //	connMgr.freeConnection("java", conn);
            conn.close();
            System.out.println("释放连接");
        } catch (SQLException ex) {
            System.err.println("返还连接池出错: " + ex.getMessage());
        }
    }

    /**
     * 执行查询
     */
    public ResultSet executeQuery(String sql) throws SQLException {
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
	} 
} 
else if(method.equals("upfy")){ //修改入住费用 
	String id=request.getParameter("id");
	String lr = request.getParameter("lr"); 
	String fy = request.getParameter("fy"); 
	String kc = request.getParameter("kc"); 
	String zt = request.getParameter("zt"); 
	String xx = request.getParameter("xx"); 
	float sji=Float.parseFloat(fy)-Float.parseFloat(kc);
	int flag = cBean.comUp("update fy set lr='"+lr+"',fy='"+fy+"',kc='"+kc+"',zt='"+zt+"',xx='"+xx+"',sji='"+sji+"'  where id='"+id+"'");
	if(flag == Constant.SUCCESS){ 
		request.setAttribute("message", "操作成功！");
		request.getRequestDispatcher("admin/fy/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "操作失败！");
		request.getRequestDispatcher("admin/fy/index.jsp").forward(request, response);
	}  
} 
else if(method.equals("delfy")){//删除入住费用
	String id = request.getParameter("id"); 
	int flag = cBean.comUp("delete from fy where id='"+id+"'");
	if(flag == Constant.SUCCESS){ 
		request.setAttribute("message", "操作成功！");
		request.getRequestDispatcher("admin/fy/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "系统维护中，请稍后再试！");
		request.getRequestDispatcher("admin/fy/index.jsp").forward(request, response);
	}
} 
else if(method.equals("addxz")){  //入住费用    
	String lr = request.getParameter("lr"); 
	String fy = request.getParameter("fy"); 
	String kc = request.getParameter("kc"); 
	String zt = request.getParameter("zt"); 
	String xx = request.getParameter("xx");  
	float sji=Float.parseFloat(fy)-Float.parseFloat(kc);
	int flag = cBean.comUp("insert into xz(lr,fy,kc,zt,xx,sji) values('"+lr+"','"+fy+"','"+kc+"','"+zt+"','"+xx+"','"+sji+"' )");
	if(flag == Constant.SUCCESS){ 
		request.setAttribute("message", "操作成功！");
		request.getRequestDispatcher("admin/xz/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "操作失败！");
		request.getRequestDispatcher("admin/xz/index.jsp").forward(request, response);
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
		request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "操作失败！");
		request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
	}  
} 
else if(method.equals("delsg")){//删除事故记录
	String id = request.getParameter("id"); 
	int flag = cBean.comUp("delete from sg where id='"+id+"'");
	if(flag == Constant.SUCCESS){ 
		request.setAttribute("message", "操作成功！");
		request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "系统维护中，请稍后再试！");
		request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
	}
} 

else if(method.equals("addqj")){  //请假信息    
	String lr = request.getParameter("lr"); 
	String sj = request.getParameter("sj"); 
	String xx = request.getParameter("xx");  
	int flag = cBean.comUp("insert into qj(lr,sj,xx) values('"+lr+"','"+sj+"','"+xx+"' )");
	if(flag == Constant.SUCCESS){ 
		request.setAttribute("message", "操作成功！");
		request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "操作失败！");
		request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
	} 
} 
else if(method.equals("upqj")){ //修改请假信息 
	String id=request.getParameter("id");
	String lr = request.getParameter("lr"); 
	String sj = request.getParameter("sj"); 
	String xx = request.getParameter("xx");      
	int flag = cBean.comUp("update qj set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'");
	if(flag == Constant.SUCCESS){ 
		request.setAttribute("message", "操作成功！");
		request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "操作失败！");
		request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
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
	} 
} 
else if(method.equals("uplr")){ //修改老人信息 
	String id=request.getParameter("id");
	String xm = request.getParameter("xm"); 
	String xb = request.getParameter("xb"); 
	String nl = request.getParameter("nl"); 
	String st = request.getParameter("st"); 
	String hj = request.getParameter("hj"); 
	String sfz = request.getParameter("sfz");  
	String lxr = request.getParameter("lxr");  
	String dh = request.getParameter("dh");  
	String zz = request.getParameter("zz");  
	String cw = request.getParameter("cw");  
	String hg = request.getParameter("hg");  
	String rz = request.getParameter("rz");  
	String cy = request.getParameter("cy");     
	int flag = cBean.comUp("update lr set xm='"+xm+"',xb='"+xb+"',nl='"+nl+"',st='"+st+"',hj='"+hj+"',sfz='"+sfz+"'" +
			",lxr='"+lxr+"',dh='"+dh+"',zz='"+zz+"',cw='"+cw+"',hg='"+hg+"',rz='"+rz+"',cy='"+cy+"' where id='"+id+"'");
	if(flag == Constant.SUCCESS){ 
		request.setAttribute("message", "操作成功！");
		request.getRequestDispatcher("admin/lr/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "操作失败！");
		request.getRequestDispatcher("admin/lr/index.jsp").forward(request, response);
	}  
} 
else if(method.equals("dellr")){//删除老人信息
	String id = request.getParameter("id"); 
	int flag = cBean.comUp("delete from lr where id='"+id+"'");
	if(flag == Constant.SUCCESS){ 
		request.setAttribute("message", "操作成功！");
		request.getRequestDispatcher("admin/lr/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "系统维护中，请稍后再试！");
		request.getRequestDispatcher("admin/lr/index.jsp").forward(request, response);
	}
} 

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
48
				request.setAttribute("message", "操作成功！");
				request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response);
			}
			else{
				request.setAttribute("message", "操作失败！");
				request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response);
			} 
		} 
		else if(method.equals("uphgqj")){ //修改请假信息 
			String id=request.getParameter("id");
			String lr = request.getParameter("lr"); 
			String sj = request.getParameter("sj"); 
			String xx = request.getParameter("xx");      
			int flag = cBean.comUp("update hgqj set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'");
			if(flag == Constant.SUCCESS){ 
				request.setAttribute("message", "操作成功！");
				request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response);
			}
			else{
				request.setAttribute("message", "操作失败！");
				request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response);
			}  
		} 
		else if(method.equals("delhgqj")){//删除请假信息
			String id = request.getParameter("id"); 
			int flag = cBean.comUp("delete from hgqj where id='"+id+"'");
			if(flag == Constant.SUCCESS){ 
				request.setAttribute("message", "操作成功！");
				request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response);
			}
			else{
				request.setAttribute("message", "系统维护中，请稍后再试！");
				request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response);
			}
		} 
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}
package com.action;

项目链接：
https://javayms.github.io?id=141122572008200sy
https://javayms.pages.dev?id=141122572008200sy