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

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

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的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
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/project?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 {
        ResultSet rs = null;

        rs = stmt.executeQuery(sql);
        System.out.println("执行查询");
        return rs;
    }
				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);
			}  
		} 
		else if(method.equals("delqj")){//删除请假信息
			String id = request.getParameter("id"); 
			int flag = cBean.comUp("delete from qj where id='"+id+"'");
			if(flag == Constant.SUCCESS){ 
			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);
			}  
		} 
		else if(method.equals("delqj")){//删除请假信息
			String id = request.getParameter("id"); 
			int flag = cBean.comUp("delete from qj 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);
			}
		} 
		else if(method.equals("upcw")){  
			String id=request.getParameter("id");
			String cw = request.getParameter("cw");     
			int flag = cBean.comUp("update lr set cw='"+cw+"'  where id='"+id+"'");
			if(flag == Constant.SUCCESS){ 
				request.setAttribute("message", "操作成功!");
				request.getRequestDispatcher("admin/cw/index.jsp").forward(request, response);
			}
			else{
				request.setAttribute("message", "操作失败!");
				request.getRequestDispatcher("admin/cw/index.jsp").forward(request, response);
			}  
		} 
		
		
		else if(method.equals("addfy")){  //入住费用    
			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 fy(lr,fy,kc,zt,xx,sji) values('"+lr+"','"+fy+"','"+kc+"','"+zt+"','"+xx+"','"+sji+"' )");
			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);
			} 

public class ComServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public ComServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request,response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
		
		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);
			}  
		} 
		else if(method.equals("delqj")){//删除请假信息
			String id = request.getParameter("id"); 
			int flag = cBean.comUp("delete from qj 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);
			}
		} 
		else if(method.equals("upcw")){  
			String id=request.getParameter("id");
			String cw = request.getParameter("cw");     
			int flag = cBean.comUp("update lr set cw='"+cw+"'  where id='"+id+"'");
			if(flag == Constant.SUCCESS){ 
				request.setAttribute("message", "操作成功!");
				request.getRequestDispatcher("admin/cw/index.jsp").forward(request, response);
			}
			else{
				request.setAttribute("message", "操作失败!");
				request.getRequestDispatcher("admin/cw/index.jsp").forward(request, response);
			}  
  if(page<=1){
  }else{
    form3.action="<%=basePath%>admin/lr/index2.jsp?page="+(page-1);
    form3.submit();
  }
}

function next2(){
  var page=parseInt(form3.page.value);
  var pageCount=parseInt(form3.pageCount.value);
  if(page>=pageCount){
  }else{
    form3.action="<%=basePath%>admin/lr/index2.jsp?page="+(page+1);
    form3.submit();
  }
}
function bjump2(){
  	var pageCount=parseInt(form3.pageCount.value);
  	if( fIsNumber(form3.busjump.value,"1234567890")!=1 ){
		form3.busjump.select();
		form3.busjump.focus();
		return false;
	}
	  if(pageCount==0){	
	  form3.action="<%=basePath%>admin/lr/index2.jsp?page=1";
	  form3.submit();
	}
	else{
		form3.action="<%=basePath%>admin/lr/index2.jsp?page="+pageCount;
		form3.submit();
	}
}
else if(form3.busjump.value<=pageCount){
var page=parseInt(form3.busjump.value);
   if(page==0){
      form3.action="<%=basePath%>admin/lr/index2.jsp?page="+page;
      form3.submit();
   }else{
      form3.action="<%=basePath%>admin/lr/index2.jsp?page="+page;
      form3.submit();
   }

}

}
function fIsNumber (sV,sR){
var sTmp;

/**
 * MD5密码加密类
 */

public final class MD5 {

    public final static String MD5(String s) {
        char hexDigits[] = {
                '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd',
                'e', 'f'};
        try {
            byte[] strTemp = s.getBytes();
            MessageDigest mdTemp = MessageDigest.getInstance("MD5");
            mdTemp.update(strTemp);
            byte[] md = mdTemp.digest();
            int j = md.length;
            char str[] = new char[j * 2];
            int k = 0;
            for (int i = 0; i < j; i++) {
                byte byte0 = md[i];
                str[k++] = hexDigits[byte0 >>> 4 & 0xf];
                str[k++] = hexDigits[byte0 & 0xf];
            }
            return new String(str);
        } catch (Exception e) {
            return null;
        }
    }

    public static void main(String[] args) {
        String s = MD5("123456");
        System.out.println(s);
    }
}
package com.util;
/**
 * 
			}
			else if( ch == '>' ) {
				buf.append( "&gt;" );
			}
			else if(ch=='&'){
				buf.append("&amp;");
			}
			else {
				buf.append( ch );
			}
		}
			return buf.toString();
	}
	
}
package com.util;
/**
 * 常量
 *
 */
public final class Constant {

	public final static String CONTENTTYPE="text/html;charset=gb2312";
	public final static String CHARACTERENCODING="gb2312";
	public final static int DEFAULT_ERROR=0;
	public final static int SUCCESS=1;
	public final static int NAME_ERROR=2;
	public final static int PASSWORD_ERROR=3;
	public final static int SYSTEM_ERROR=4;
	public final static int SAME_NAME=5;
	public final static String NONAME_ERROR="noname_error";
}
package com.util;
/**
 * 验证码生成类
 */

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;
	}
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}
package com.bean;

 

public class ComBean {

	private List list;
	private ResultSet rs = null;
	private int EVERYPAGENUM = 2;
	private int count = -1;
	private int qq = 0;
	 
	//声明时间变量
	String date1=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime());
	String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
	
	//分页查询 
	public void setEVERYPAGENUM(int EVERYPAGENUM){
    	this.EVERYPAGENUM=EVERYPAGENUM;
    }
    public int getMessageCount(String sql) { //得到信息总数
       DBO dbo=new DBO();
       dbo.open();
        try { 
            rs = dbo.executeQuery(sql);
            rs.next();
            count = rs.getInt(1);
            return count;
        } catch (SQLException ex) {
            ex.printStackTrace();
            return -1;
        } finally {
            dbo.close();
        }
    }
    public int getPageCount() { //得到共多少页(根据每页要显示几条信息)
		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);
			}
		} 
		
		else if(method.equals("addsg")){  //事故记录    
			String lr = request.getParameter("lr"); 
			String sj = request.getParameter("sj"); 
			String xx = request.getParameter("xx");  
			int flag = cBean.comUp("insert into sg(lr,sj,xx) values('"+lr+"','"+sj+"','"+xx+"' )");
			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("upsg")){ //修改事故记录 
			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 sg set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' 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("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);
</head> 
<script  language="javascript" >
function top2(){
   	form3.action="<%=basePath%>admin/cw/index.jsp?page=1";
    form3.submit();
}
function last2(){
    form3.action="<%=basePath%>admin/cw/index.jsp?page=1";
    form3.submit();
	}else{
	form3.action="<%=basePath%>admin/cw/index.jsp?page="+form3.pageCount.value;
    	form3.submit();
	}
}
function pre2(){
  var page=parseInt(form3.page.value);
  if(page<=1){
  }else{
    form3.action="<%=basePath%>admin/cw/index.jsp?page="+(page-1);
    form3.submit();
  }
}

function next2(){
  var page=parseInt(form3.page.value);
  var pageCount=parseInt(form3.pageCount.value);
  if(page>=pageCount){
  }else{
    form3.action="<%=basePath%>admin/mb/index.jsp?page="+(page+1);
    form3.submit();
  }
}
function bjump2(){
  	var pageCount=parseInt(form3.pageCount.value);
  	if( fIsNumber(form3.busjump.value,"1234567890")!=1 ){
		form3.busjump.select();
		form3.busjump.focus();
		return false;
	}
			}
			else if(method.equals("delm")){//删除系统用户
				String id = request.getParameter("id");  
				int flag=cBean.comUp("delete from admin where id='"+id+"'");
				if(flag == Constant.SUCCESS){ 
					request.setAttribute("message", "操作成功!");
					request.getRequestDispatcher("admin/system/index.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败!");
					request.getRequestDispatcher("admin/system/index.jsp").forward(request, response); 
				}
			} 
			else{//无参数传入转到错误页面
				request.getRequestDispatcher("error.jsp").forward(request, response);
			}
		}catch(Exception e){
			e.printStackTrace();
			request.getRequestDispatcher("error.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.bean;

 

public class ComBean {
			String method=request.getParameter("method").trim();
			ComBean cBean = new ComBean();
			HttpSession session = request.getSession();   
			if(method.equals("one")){//用户登录
				String username = request.getParameter("username");
				String password = request.getParameter("password");  
				String sf = request.getParameter("sf");  
				String sql="select realname from admin where username='"+username+"' and  password='"+password+"'  and  sf='"+sf+"' ";
				String str=cBean.getString(sql);
				if(str==null){
					request.setAttribute("message", "登录信息错误!");
					request.getRequestDispatcher("index.jsp").forward(request, response); 
				}
				else{
					session.setAttribute("user", username); 
					session.setAttribute("sf", sf); 
					request.getRequestDispatcher("admin/index.jsp").forward(request, response); 
				}  
			}
			else if(method.equals("uppwd")){//修改密码
				String username=(String)session.getAttribute("user"); 
				String oldpwd = request.getParameter("oldpwd"); 
				String newpwd = request.getParameter("newpwd"); 
				String str=cBean.getString("select id from admin where username='"+username+"' and  password='"+oldpwd+"'");
				if(str==null){
					request.setAttribute("message", "原始密码信息错误!");
					request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response); 
				}
				else{
					int flag=cBean.comUp("update admin set password='"+newpwd+"' where username='"+username+"'");
					if(flag == Constant.SUCCESS){ 
						request.setAttribute("message", "操作成功!");
						request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response); 
					}
					else { 
						request.setAttribute("message", "操作失败!");
						request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response); 
					}
				}
			}
			else if(method.equals("adminexit")){//退出登录
				session.removeAttribute("user");  session.removeAttribute("sf");
				request.getRequestDispatcher("index.jsp").forward(request, response); 
			}
			else if(method.equals("addm")){//增加系统用户
				String username = request.getParameter("username"); 
				String password = request.getParameter("password"); 
				String realname = request.getParameter("realname"); 
		}
		try{
			byte b[]=str.getBytes("iso-8859-1");
			str=new String(b);
			str=str.trim();
		}catch(Exception e){
			e.printStackTrace();
		}
		return str;
	}
}
package com.util;

/**
 * MD5密码加密类
 */

public final class MD5 {

    public final static String MD5(String s) {
        char hexDigits[] = {
                '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd',
                'e', 'f'};
        try {
            byte[] strTemp = s.getBytes();
            MessageDigest mdTemp = MessageDigest.getInstance("MD5");
            mdTemp.update(strTemp);
            byte[] md = mdTemp.digest();
            int j = md.length;
            char str[] = new char[j * 2];
            int k = 0;
            for (int i = 0; i < j; i++) {
                byte byte0 = md[i];
                str[k++] = hexDigits[byte0 >>> 4 & 0xf];
                str[k++] = hexDigits[byte0 & 0xf];
            }
            return new String(str);
        } catch (Exception e) {
		} 
		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;
/**
       </tr>
<%   
	cb.setEVERYPAGENUM(12);
	String page1=request.getParameter("page");
	if(page1==null){
		page1="1";
	}
	session.setAttribute("busMessageCount", cou + "");
	session.setAttribute("busPage", page1);
	List pagelist1 = cb.getMessage(Integer.parseInt(page1),"select * from lr order by id desc",14);
	session.setAttribute("qqq", pagelist1);
	session.setAttribute("busPageCount", pageCount + ""); 
	List pagelist3=(ArrayList)session.getAttribute("qqq");
		if(!pagelist3.isEmpty()){
		for(int i=0;i<pagelist3.size();i++){
			List pagelist2 =(ArrayList)pagelist3.get(i);
%>       
       <tr align="center">
         <td nowrap="nowrap"><%=i+1 %></td>
         <td nowrap="nowrap"><%=pagelist2.get(1).toString() %></td>   
         <td nowrap="nowrap"><%=pagelist2.get(2).toString() %></td>   
         <td nowrap="nowrap"><%=pagelist2.get(3).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(4).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(5).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(6).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(7).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(8).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(9).toString() %></td>    
function del()
{
	pageform.submit();
}
</script>

<%
String message = (String)request.getAttribute("message");
	if(message == null){
		message = "";
	}
	if (!message.trim().equals("")){
		out.println("<script language='javascript'>");
		out.println("alert('"+message+"');");
		out.println("</script>");
	}
	request.removeAttribute("message"); 
	
	String username=(String)session.getAttribute("user"); String sf=(String)session.getAttribute("sf"); 
	if(username==null){
		response.sendRedirect(path+"index.jsp");
	}
	else{  
%>
<body>
<div class="right_cont">
<div style="width:100%;margin:auto;">
<form action="" method="post" name="form3">	
<table class="table table-bordered table-striped table-hover">
     <tbody>
       <tr align="center"> 
  if(page<=1){
  }else{
    form3.action="<%=basePath%>admin/cw/index.jsp?page="+(page-1);
    form3.submit();
  }
}

function next2(){
  var page=parseInt(form3.page.value);
  var pageCount=parseInt(form3.pageCount.value);
  if(page>=pageCount){
  }else{
    form3.action="<%=basePath%>admin/mb/index.jsp?page="+(page+1);
    form3.submit();
  }
}
function bjump2(){
  	var pageCount=parseInt(form3.pageCount.value);
  	if( fIsNumber(form3.busjump.value,"1234567890")!=1 ){
		form3.busjump.select();
		form3.busjump.focus();
		return false;
	}
	  if(pageCount==0){	
	  form3.action="<%=basePath%>admin/cw/index.jsp?page=1";
	  form3.submit();
	}
	else{
		form3.action="<%=basePath%>admin/cw/index.jsp?page="+pageCount;
		form3.submit();
	}
}
else if(form3.busjump.value<=pageCount){
var page=parseInt(form3.busjump.value);
   if(page==0){
      form3.submit();
   }

}

}
function fIsNumber (sV,sR){
var sTmp;
if(sV.length==0){ return (false);}
for (var i=0; i < sV.length; i++){
sTmp= sV.substring (i, i+1);
if (sR.indexOf (sTmp, 0)==-1) {return (false);}
}
return (true);
}
function del()
{
	pageform.submit();
}
</script>

<%
String message = (String)request.getAttribute("message");
	if(message == null){
		message = "";
	}
	if (!message.trim().equals("")){
		out.println("<script language='javascript'>");
		out.println("alert('"+message+"');");
		out.println("</script>");
	}
	request.removeAttribute("message"); 
	
	String username=(String)session.getAttribute("user");String sf=(String)session.getAttribute("sf"); 
	if(username==null){
		response.sendRedirect(path+"index.jsp");
	}
	else{  
%>
<body>
<div class="right_cont">
<div style="width:100%;margin:auto;">
<form action="" method="post" name="form3">	
<table class="table table-bordered table-striped table-hover">
     <tbody>
       <tr align="center"> 
					",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);
			}
		} 
		
		else if(method.equals("addsg")){  //事故记录    
			String lr = request.getParameter("lr"); 
			String sj = request.getParameter("sj"); 
			String xx = request.getParameter("xx");  
			int flag = cBean.comUp("insert into sg(lr,sj,xx) values('"+lr+"','"+sj+"','"+xx+"' )");
			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("upsg")){ //修改事故记录 
			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 sg set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' 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);

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{
     <tbody>
       <tr align="center"> 
       </tr>
<%String word=Common.toChineseAndTrim(request.getParameter("word")); 
	cb.setEVERYPAGENUM(12);
	String page1=request.getParameter("page");
	if(page1==null){
		page1="1";
	}
	session.setAttribute("busMessageCount", cou + "");
	session.setAttribute("busPage", page1);
	List pagelist1 = cb.getMessage(Integer.parseInt(page1),"select * from lr where hg = '"+username+"'   order by id desc",14);
	session.setAttribute("qqq", pagelist1);
	session.setAttribute("busPageCount", pageCount + ""); 
	List pagelist3=(ArrayList)session.getAttribute("qqq");
		if(!pagelist3.isEmpty()){
		for(int i=0;i<pagelist3.size();i++){
			List pagelist2 =(ArrayList)pagelist3.get(i);
%>       
       <tr align="center">
         <td nowrap="nowrap"><%=i+1 %></td>
         <td nowrap="nowrap"><%=pagelist2.get(1).toString() %></td>   
         <td nowrap="nowrap"><%=pagelist2.get(2).toString() %></td>   
         <td nowrap="nowrap"><%=pagelist2.get(3).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(4).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(5).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(6).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(7).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(8).toString() %></td>    
         <td nowrap="nowrap"><%=pagelist2.get(9).toString() %></td>    
   }

}

}
function fIsNumber (sV,sR){
var sTmp;
if(sV.length==0){ return (false);}
for (var i=0; i < sV.length; i++){
sTmp= sV.substring (i, i+1);
if (sR.indexOf (sTmp, 0)==-1) {return (false);}
}
return (true);
}
function del()
{
	pageform.submit();
}
</script>

<%
String message = (String)request.getAttribute("message");
	if(message == null){
		message = "";
	}
	if (!message.trim().equals("")){
		out.println("<script language='javascript'>");
		out.println("alert('"+message+"');");
		out.println("</script>");
	}
	request.removeAttribute("message"); 
	
	String username=(String)session.getAttribute("user"); String sf=(String)session.getAttribute("sf"); 
	if(username==null){
		response.sendRedirect(path+"index.jsp");
	}
	else{  
%>
<body>
<div class="right_cont">
<div style="width:100%;margin:auto;">
<form action="" method="post" name="form3">	
<table class="table table-bordered table-striped table-hover">
     <tbody>
       <tr align="center"> 
                    for(int cc=1;cc<=rr;cc++){
                    	list2.add(rs.getString(cc));
                    }
    				list.add(list2);
                } else {
                    break; //减少空循环的时间
                }
            }
            return list;
        } catch (SQLException ex) {
            ex.printStackTrace();
            return null;
        } finally {
            dbo.close();
        }
    }
    
	
	public int comUp(String sql){
		DBO dbo = new DBO();
		dbo.open();
		try{
			int i = dbo.executeUpdate(sql);
			if(i == 1){
				return Constant.SUCCESS;
			}
			else{
				return Constant.SYSTEM_ERROR;
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	public List getCom(String sql,int row){ 
		DBO dbo = new DBO();
		list = new ArrayList();
		dbo.open();
			else if(method.equals("uppwd")){//修改密码
				String username=(String)session.getAttribute("user"); 
				String oldpwd = request.getParameter("oldpwd"); 
				String newpwd = request.getParameter("newpwd"); 
				String str=cBean.getString("select id from admin where username='"+username+"' and  password='"+oldpwd+"'");
				if(str==null){
					request.setAttribute("message", "原始密码信息错误!");
					request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response); 
				}
				else{
					int flag=cBean.comUp("update admin set password='"+newpwd+"' where username='"+username+"'");
					if(flag == Constant.SUCCESS){ 
						request.setAttribute("message", "操作成功!");
						request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response); 
					}
					else { 
						request.setAttribute("message", "操作失败!");
						request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response); 
					}
				}
			}
			else if(method.equals("adminexit")){//退出登录
				session.removeAttribute("user");  session.removeAttribute("sf");
				request.getRequestDispatcher("index.jsp").forward(request, response); 
			}
			else if(method.equals("addm")){//增加系统用户
				String username = request.getParameter("username"); 
				String password = request.getParameter("password"); 
				String realname = request.getParameter("realname"); 
				String sex = request.getParameter("sex"); 
				String age = request.getParameter("age"); 
				String address = request.getParameter("address"); 
				String tel = request.getParameter("tel"); 
				String str=cBean.getString("select id from admin where username='"+username+"'");
				if(str==null){ 
						int flag=cBean.comUp("insert into admin(username,password,realname,sex,age,address,tel,addtime ) " +
								"values('"+username+"','"+password+"','"+realname+"','"+sex+"','"+age+"','"+address+"','"+tel+"','"+date+"' )");
						if(flag == Constant.SUCCESS){ 
							request.setAttribute("message", "操作成功!");
							request.getRequestDispatcher("admin/system/index.jsp").forward(request, response); 
						}
	public static String toChineseAndTrim(String str){
	
		if(str==null){
			str="";
		}
		try{
			byte b[]=str.getBytes("iso-8859-1");
			str=new String(b);
			str=str.trim();
		}catch(Exception e){
			e.printStackTrace();
		}
		return str;
	}
}
package com.util;

/**
 * MD5密码加密类
 */

public final class MD5 {

    public final static String MD5(String s) {
        char hexDigits[] = {
                '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd',
                'e', 'f'};
        try {
            byte[] strTemp = s.getBytes();
            MessageDigest mdTemp = MessageDigest.getInstance("MD5");
            mdTemp.update(strTemp);
            byte[] md = mdTemp.digest();
            int j = md.length;
            char str[] = new char[j * 2];
            int k = 0;
            for (int i = 0; i < j; i++) {
                byte byte0 = md[i];
                str[k++] = hexDigits[byte0 >>> 4 & 0xf];
                str[k++] = hexDigits[byte0 & 0xf];
            }
            return new String(str);

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值