基于javaweb+mysql的jsp+servlet私人牙科诊所病历管理系统(java+jsp+css+javascript+mysql)

基于javaweb+mysql的jsp+servlet私人牙科诊所病历管理系统(java+jsp+css+javascript+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明


前台病人:

user1   123456

user2   123456

后台:

管理员账号/密码:admin/123456

挂号人员账号/密码:gh/123456

医生人员账号/密码:doctor/123456

收费人员账号/密码:sf/123456

药房人员账号/密码:yf/123456

预约挂号的操作流程:

1 前台user1:预约挂号

2 后台gh:受理

3 后台doctor:问诊

4 后台sf:收费

5 后台yf:确认取药

6 前台user1:查询病历(就诊信息)

基于javaweb+mysql的JSP+Servlet私人牙科诊所病历管理系统(java+jsp+css+javascript+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项目:否;

技术栈

1.后端技术:Servlet 2.前端技术:JSP+CSS+JavaScript

使用说明

  1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中dbconnection.properties配置文件中的数据库配置改为自己的配置; 将项目中src/dao/CommDAO.java中第71行的数据库配置用户名密码改为自己的配置; 4. 运行项目,输入http://localhost:8080/srykzsblmis/ 登录 注:Tomcat中配置路径必须为srykzsblmis 管理员账号/密码:admin/123 病人账号/密码: xm/123 挂号人员账号/密码:gh/123 收费人员账号/密码:sf/123 药房人员账号/密码:yf/123 医生人员账号/密码:doctor1/123
                    if (inmap.get("innum") != null) {
                        innum = Integer.parseInt(inmap.get("innum").toString());
                    }
                    if (outmap.get("outnum") != null) {
                        outnum = Integer.parseInt(outmap.get("outnum").toString());
                    }
                    int kc = innum - outnum;
                    if (num > kc) {
                        m++;
                    }
                    //

                }
            }
            if (m == 0) {
                for (int i = 0; i < a.length; i++) {
                    String ynos[] = a[i].split("\\-");
                    ArrayList amlist = (ArrayList) dao.select("select * from ypcf where yno='" + ynos[0] + "' and type='药品' ");
                    if (amlist.size() != 0) {
                        HashMap am = dao.select("select * from ypcf where yno='" + ynos[0] + "' and type='药品' ").get(0);
                        String yno = am.get("yno").toString();//药品编号
                        int num = Integer.parseInt(b[i]);//购买药品数量
                        //查药品数量
                        HashMap inmap = dao.select("select sum(num) as innum from kcrecord where type='in' and yno='" + ynos[0] + "' ").get(0);
                        HashMap outmap = dao.select("select sum(num) as outnum from kcrecord where type='out' and yno='" + ynos[0] + "' ").get(0);
                        int innum = 0;
                        int outnum = 0;
                        if (inmap.get("innum") != null) {
                            innum = Integer.parseInt(inmap.get("innum").toString());
                        }
                        if (outmap.get("outnum") != null) {
                            outnum = Integer.parseInt(outmap.get("outnum").toString());
                        }
                        int kc = innum - outnum;

                        dao.commOper("insert into kcrecord (yno,num,type,savetime,oper) values ('" + yno + "','" + num + "','out','" + Info.getDateStr() + "','" + admin.get("uname") + "') ");
                    }
                }
                dao.commOper("update zd set fyoper='" + admin.get("uname") + "',fysavetime='" + Info.getDateStr() + "',qystatus='已取药'  where ghno='" + ghno + "'");
                request.setAttribute("suc", "");
                go("/admin/dfy.jsp", request, response);
            request.setAttribute("suc", "");
            go("/admin/ypcfadd.jsp", request, response);
        }

        //修改密码
        if (ac.equals("uppass")) {
            String id = request.getParameter("id");
            String upass = request.getParameter("upass");
            String tname = request.getParameter("tname");
            String sex = request.getParameter("sex");
            String birth = request.getParameter("birth");
            String tel = request.getParameter("tel");
            String ismarage = request.getParameter("ismarage");
            String addr = request.getParameter("addr");
            String email = request.getParameter("email");
            String idcard = request.getParameter("idcard");
            String byschool = request.getParameter("byschool");
            String sql = "update sysuser set upass='" + upass + "',tname='" + tname + "',sex='" + sex + "'  ,birth='" + birth + "',tel='" + tel + "',ismarage='" + ismarage + "',addr='" + addr + "',email='" + email + "'" +
                    " ,idcard='" + idcard + "',byschool='" + byschool + "' where id=" + id;
            dao.commOper(sql);
            request.setAttribute("suc", "");
            go("/admin/uppass.jsp", request, response);
        }
        //退出
        if (ac.equals("exit")) {
            session.removeAttribute("admin");
            request.setAttribute("suc", "");
            go("/admin/login.jsp", request, response);
        }
        //新增挂号
        if (ac.equals("ghadd")) {
            String ghno = request.getParameter("ghno");
            String tname = request.getParameter("tname");
            String sex = request.getParameter("sex");
            String age = request.getParameter("age");
            String idcard = request.getParameter("idcard");
            String tel = request.getParameter("tel");
            String addr = request.getParameter("addr");
            String ghdept = request.getParameter("ghdept");
            String price = request.getParameter("price");
            String status = "待问诊";
            String delstatus = "0";
            String oper = admin.get("uname").toString();
            String savetime = Info.getDateStr();

package util;

public class PageManager {
	private PageManager() {

	}

	// 默认一页最大记录数
	public static final int DEFAULTPAGESIZE = 20;

	// 分页段
	public static final int segment = 10;

	// 当前页数
	protected int currentPage;

	// 一页长度
	protected int pageSize;

	// 总页数
	protected long pageNumber;

	// 总记录数
	protected long count;

	// 数据
	protected Collection collection;

	// 数据查询对象
	protected CommDAO dao = new CommDAO();

	// 表现层代码
	protected String info;

        if (ac.equals("chatadd")) {
            String msg = request.getParameter("msg");
            String hfmsg = "";
            String savetime = Info.getDateStr();
            String uid = user.get("id").toString();
            String sql = "insert into chat (msg,hfmsg,savetime,uid) values('" + msg + "','" + hfmsg + "','" + savetime + "','" + uid + "')";
            dao.commOper(sql);
            request.setAttribute("suc", "");
            go("chat.jsp", request, response);
        }
        //回复留言
        if (ac.equals("chathf")) {
            String id = request.getParameter("id");
            String hfmsg = request.getParameter("hfmsg");
            String sql = "update chat set hfmsg='" + hfmsg + "' where id= " + id;
            dao.commOper(sql);
            request.setAttribute("suc", "");
            go("/admin/chathf.jsp?id=" + id, request, response);
        }

        dao.close();
        out.flush();
        out.close();
    }

    public void init() throws ServletException {
        // Put your code here
    }

}
package util;

		}
		this.parameter = para.toString();

	}

	/**
	 * 刷新分页路径
	 * 
	 */
	protected void refreshUrl() {
		StringBuffer buf = new StringBuffer();
		buf.append("<font color='#1157B7'>共").append(count);
		buf.append("条");
		buf.append("&nbsp;&nbsp;");
		buf.append("第").append(this.currentPage).append("/").append(
				this.pageNumber).append("页");
		buf.append("&nbsp;&nbsp;&nbsp;&nbsp;");
		if (this.currentPage == 1)
			buf.append("首页");
		else
			buf.append("<a href='").append(this.path).append("&currentPage=1")
					.append(parameter)
					.append("' class='ls'>").append("首页")
					.append("</a>");
		// #1157B7
		buf.append("&nbsp;&nbsp;&nbsp;");

		if (this.currentPage > 1) {
			buf.append("<a href='").append(this.path).append("&currentPage=")
					.append(currentPage - 1).append(parameter).append(
							"' class='ls'>").append("上页")
					.append("</a>");
		} else {
			buf.append("上页");

		}
		buf.append("&nbsp;&nbsp;");

		int currentSegment = this.currentPage % segment == 0 ? this.currentPage
				/ segment : this.currentPage / segment + 1;

		/*for (int i = 1; i <= this.pageNumber; i++) {
			if (this.currentPage == i)
				buf.append("<font color='red'>").append(i).append("</font>");

			else
				buf.append("<a href='").append(this.path).append(

			try {
				this.currentPage = Integer.parseInt((String) request
						.getSession().getAttribute("currentPage"));

			} catch (Exception e1) {
				this.currentPage = 1;

			}

		}

	}
	
	
	
	

	
	

	/**
	 * 
	 * @param 下一页的分页链接
	 * @param 一页最大记录数
	 * @param 当前HttpServletRequest对象
	 * @param 数据库操作对象
	 */
	public static PageManager getPage(String path, int pageSize,
			HttpServletRequest request) {
		return new PageManager(path, pageSize, request);

	}

	/**
	 * 
	 * 
	 * @param hql语句
	 * 
	 */
	public void doList(String hql) {
        //String sql = "select count(*)  "+hql.substring(hql.indexOf("from"));
        //sql = sql.substring(0,sql.indexOf("order"));
		this.count = this.dao.select(hql).size();
	    public static String tform(HashMap map)
		{
	    	String jscode = "";
	    	try{
	    	jscode+="<script type=\"text/javascript\">\n";
	    	jscode+="function getPvalue()\n";
	    	jscode+="{\n";
	    	
	    	 Set set = map.entrySet();
	    	 Iterator it = set.iterator();
	    	 while(it.hasNext())
	    	 {
	    	  String pm=((Object)it.next()).toString();
	    	  String str1 = "";
	    	  String str2 = "";
	    	  String[] strs = pm.split("=");
	    	  str1 = strs[0];
	    	  if(strs.length==1)str2="";
	    	  if(strs.length==2)str2=strs[1];
	    	  str2 = str2.replaceAll("\r\n", "-----");
	    	  
	    	  jscode+=" if(document.getElementsByName(\""+str1+"\").length>1)\n";
	    	 
	    	  jscode+=" {\n";
	    	  jscode+=" var radios = document.getElementsByName(\""+str1+"\");\n";
	    	  jscode+=" if(radios[0].type=='radio'){\n";
	    	  jscode+=" for(var i=0;i<radios.length;i++)\n";
	    	  jscode+=" {\n";
	    	  jscode+=" if(radios[i].value==\""+str2+"\")\n";
	    	  jscode+=" {\n";
	    	  jscode+=" radios[i].checked=\"checked\";\n";
	    	  jscode+=" }\n";
	    	  jscode+=" }\n";
	    	  jscode+=" }\n";
	    	  
	    	  jscode+=" if(radios.type=='select'){\n";
	    	  jscode+=" f1."+str1+".value=\""+str2+"\";\n";
	    	  jscode+=" }\n";
	    	  
	    	  
	    	  jscode+=" }else{\n";
	    	  jscode+=" if(f1."+str1+")\n";
	    	  jscode+="{\n";
	    	  jscode+="f1."+str1+".value=\""+str2+"\";\n";
	    	  jscode+="}\n";
	    	  jscode+="}\n";
	            } else {
	                return "den";
	            }
	        } catch (Exception exception) {
	            exception.printStackTrace();
	        }
	        return "den";
	    }
	    
	    /**
	 	 * 过滤html代码
	 	 * 
	 	 */
	    public static String filterStrIgnoreCase(String source, String from, String to){
	        String sourceLowcase=source.toLowerCase();
	        String sub1,sub2,subLowcase1,subLowcase2;
	        sub1=sub2=subLowcase1=subLowcase2="";
	        int start=0,end;
	        boolean done=true;
	        if(source==null) return null;
	        if(from==null||from.equals("")||to==null||to.equals("")) 
	         return source;
	        while(done){
	         start=sourceLowcase.indexOf(from,start);
	         if(start==-1) {
	          break;
	         }
	         subLowcase1=sourceLowcase.substring(0,start);
	         sub1=source.substring(0,start);
	         end=sourceLowcase.indexOf(to,start);
	         if(end==-1){
	          end=sourceLowcase.indexOf("/>",start); 
	          if(end==-1) {
	           done=false;
	          }
	         }
	         else{
	          end=end+to.length();
	          subLowcase2=sourceLowcase.substring(end,source.length());
	          sub2=source.substring(end,source.length());
	          sourceLowcase=subLowcase1+subLowcase2;
	          source=sub1+sub2;
	         }
	         //System.out.println(start+" "+end);
	        }
	        return source;
	   }
	    
	    public static String tform(HashMap map)
		{
	    	String jscode = "";
	    	try{
	    	jscode+="<script type=\"text/javascript\">\n";

                rlist.add(mlist);
            }
            String[] pros = {"挂号编号", "挂号金额", "挂号科室", "操作人", "操作时间"};
            Info.writeExcel(request.getRealPath("/upfile/") + "/ghexport.xls", pros, rlist, request, response);
        }

        if (ac.equals("test")) {
            String str = request.getParameter("str");
            String sql = "select * from sysuser where uname like '%" + str + "%' or tname like '%" + str + "%' ";
            if (str.equals("")) {
                sql = "select * from sysuser";
            }
            System.out.println(sql);
            String returnStr = "";
            ArrayList<HashMap> list = (ArrayList<HashMap>) dao.select(sql);
            System.out.println("aa-=" + list.size());
            if (list.size() != 0) {
                for (HashMap map : list) {
                    returnStr += map.get("uname") + "-" + map.get("tname") + "$";
                }
                out.println(returnStr);
            } else {
                out.println("");
            }
        }
        if (ac.equals("testadd")) {
            String Hidden1 = request.getParameter("Hidden1");
            //String str[] = Hidden1.split("\\$");
            String cfno = "czd001";
            //for(int i=0;i<str.length;i++){
            //	System.out.println("aaa="+str[i]);
            //}
            System.out.println("Hidden1==" + Hidden1);
            String sql = "update czd set info='" + Hidden1 + "' where cfno='" + cfno + "' ";
            dao.commOper(sql);
            request.setAttribute("suc", "");
            go("/admin/testadd1.jsp?cfno=" + cfno, request, response);
        }
        //自动补全药品
        if (ac.equals("ajaxsearch")) {
            String str = request.getParameter("str");
            System.out.println("aaaaaaaaaaaa==" + str);
            String sql = "select * from ypcf where (yno like '%" + str + "%' or yname like '%" + str + "%') and delstatus='0'  ";
            if (str.equals("")) {
                sql = "select * from ypcf";
            }
            System.out.println(sql);
            String returnStr = "";
            ArrayList<HashMap> list = (ArrayList<HashMap>) dao.select(sql);
            System.out.println("aa-=" + list.size());
            if (list.size() != 0) {
                for (HashMap map : list) {
            go("/admin/ghadd.jsp", request, response);
        }
        //药品入库
        if (ac.equals("yprk")) {
            String yno = request.getParameter("yno");
            String num = request.getParameter("num");
            String type = "in";
            String oper = admin.get("uname").toString();
            String savetime = Info.getDateStr();
            dao.commOper("insert into kcrecord (yno,num,type,savetime,oper) values ('" + yno + "','" + num + "','" + type + "','" + savetime + "','" + oper + "') ");
            request.setAttribute("suc", "");
            go("/admin/yprk.jsp", request, response);
        }

        if (ac.equals("export")) {

            String sql = "select * from zd where fkstatus='已付款' ";
            sql += "order by ghno desc";
            ArrayList<HashMap> list = (ArrayList) dao.select(sql);
            List<List> rlist = new ArrayList();
            DecimalFormat decimal = new DecimalFormat("#.#");
            for (HashMap map : list) {

                HashMap am = dao.select("select * from ghinfo where ghno='" + map.get("ghno") + "'").get(0);
                HashMap mstu = dao.select("select * from zd where ghno='" + map.get("ghno") + "'").get(0);
                String info = mstu.get("info").toString();
                String numinfo = mstu.get("numinfo").toString();
                String yinfo = "";
                String a[] = info.split("\\$");
                String b[] = numinfo.split("\\$");
                for (int i = 0; i < a.length; i++) {
                    yinfo += a[i] + "&nbsp;&nbsp;数量:" + b[i] + "<br/>";
                }
                List mlist = new ArrayList();
                mlist.add(map.get("ghno"));
                mlist.add(am.get("tname"));
                mlist.add(am.get("sex"));
                mlist.add(am.get("age"));
                mlist.add(mstu.get("bq"));
                mlist.add(mstu.get("zd"));
                mlist.add(yinfo);
                mlist.add(decimal.format(Double.valueOf(map.get("totalprice").toString())) + "元");
                mlist.add(map.get("sfoper"));
                mlist.add(map.get("sfsavetime"));
                rlist.add(mlist);
            }
            //String[] pros = {"挂号编号","患者姓名","收费金额","收费人","收费时间"};
            String[] pros = {"挂号编号", "患者姓名", "性别", "年龄", "病情", "诊断", "药品处置", "收费金额", "收费人", "收费时间"};
            Info.writeExcel(request.getRealPath("/upfile/") + "/sfexport.xls", pros, rlist, request, response);
        }

        if (ac.equals("ghexport")) {

        //添加科室
        if (ac.equals("deptadd")) {
            String deptname = request.getParameter("deptname");
            String tel = request.getParameter("tel");
            String addr = request.getParameter("addr");
            String delstatus = "0";
            String sql = "insert into dept (deptname,tel,addr,delstatus) values('" + deptname + "','" + tel + "','" + addr + "','" + delstatus + "')";
            dao.commOper(sql);
            request.setAttribute("suc", "");
            go("/admin/deptadd.jsp", request, response);
        }
        //修改科室
        if (ac.equals("deptedit")) {
            String id = request.getParameter("id");
            String tel = request.getParameter("tel");
            String addr = request.getParameter("addr");
            String deptname = request.getParameter("deptname");

            String sql = "update dept set deptname='" + deptname + "',tel='" + tel + "',addr='" + addr + "' where id= " + id;
            dao.commOper(sql);
            request.setAttribute("suc", "");
            go("/admin/deptadd.jsp", request, response);
        }
        //添加药品、处置
        if (ac.equals("ypcfadd")) {
            String yno = request.getParameter("yno");
            String cksql = "select * from ypcf where yno='" + yno + "'";
            ArrayList cklist = (ArrayList) dao.select(cksql);
            if (cklist.size() != 0) {
                request.getParameter("no");
                go("/admin/ypcfadd.jsp", request, response);
            } else {
                String yname = request.getParameter("yname");
                String price = request.getParameter("price");
                String type = request.getParameter("type");
                String gg = request.getParameter("gg");
                String company = request.getParameter("company");
                if (!type.equals("药品")) {
                    gg = "";
                    company = "";
	            ws.setColumnView(2,20);
	            ws.setColumnView(3,20);
	            ws.setColumnView(4,20);
	            ws.setColumnView(5,20);

	            try {
	            	
	            for(int i=0;i<pros.length;i++)
	            {
	            Label label1 = new Label(i, 0,"");
	            
	            label1.setString(pros[i]);
	            ws.addCell(label1);
	            }
	            
	            } catch (RowsExceededException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				} catch (WriteException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}    
	             //下面开始添加单元格  
				int i=1;
	            for(List t:list){  
	            	try {
	            		
	            	Iterator it = t.iterator();
	            	int jj=0;
	            		while(it.hasNext())
	            		{
	            	Label label1 = new Label(jj, i,"");
	            	String a = it.next().toString();
		            label1.setString(a);
		            ws.addCell(label1);
		            jj++;
	            		}
		            
		            i++;
	            } catch (RowsExceededException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				} catch (WriteException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}    
	            }    
	   
					    bos = new BufferedOutputStream(fos);

					    int bytesRead = 0;
					    byte[] buffer = new byte[5 * 1024];
					    while ((bytesRead = bis.read(buffer)) != -1) {
					     bos.write(buffer, 0, bytesRead);
					    }
					    bos.close();
					    bis.close();
					    fos.close();
				
		               //new Info().delPic(request.getRealPath("/upfile/")+"/", filename);
		     } catch (Exception e) {
				e.printStackTrace();
			}finally{
			}
	}

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

}
package util;

public class SetChar extends HttpServlet implements Filter {
	private FilterConfig filterConfig;

	// Handle the passed-in FilterConfig
	public void init(FilterConfig filterConfig) throws ServletException {
		this.filterConfig = filterConfig;
	}

	// Process the request/response pair
	public void doFilter(ServletRequest request, ServletResponse response,
            String delstatus = "0";
            String oper = admin.get("uname").toString();
            String savetime = Info.getDateStr();
            dao.commOper("insert into ghinfo (ghno,tname,sex,age,idcard,tel,addr,ghdept,price,status,delstatus,oper,savetime) " +
                    " values('" + ghno + "','" + tname + "','" + sex + "','" + age + "','" + idcard + "','" + tel + "','" + addr + "','" + ghdept + "','" + price + "','" + status + "','" + delstatus + "','" + oper + "','" + savetime + "')  ");
            request.setAttribute("suc", "");
            go("/admin/ghadd.jsp", request, response);
        }
        //药品入库
        if (ac.equals("yprk")) {
            String yno = request.getParameter("yno");
            String num = request.getParameter("num");
            String type = "in";
            String oper = admin.get("uname").toString();
            String savetime = Info.getDateStr();
            dao.commOper("insert into kcrecord (yno,num,type,savetime,oper) values ('" + yno + "','" + num + "','" + type + "','" + savetime + "','" + oper + "') ");
            request.setAttribute("suc", "");
            go("/admin/yprk.jsp", request, response);
        }

        if (ac.equals("export")) {

            String sql = "select * from zd where fkstatus='已付款' ";
            sql += "order by ghno desc";
            ArrayList<HashMap> list = (ArrayList) dao.select(sql);
            List<List> rlist = new ArrayList();
            DecimalFormat decimal = new DecimalFormat("#.#");
            for (HashMap map : list) {

                HashMap am = dao.select("select * from ghinfo where ghno='" + map.get("ghno") + "'").get(0);
                HashMap mstu = dao.select("select * from zd where ghno='" + map.get("ghno") + "'").get(0);
                String info = mstu.get("info").toString();
                String numinfo = mstu.get("numinfo").toString();
                String yinfo = "";
                String a[] = info.split("\\$");
                String b[] = numinfo.split("\\$");
                for (int i = 0; i < a.length; i++) {
                    yinfo += a[i] + "&nbsp;&nbsp;数量:" + b[i] + "<br/>";
                }
                List mlist = new ArrayList();

        //修改密码
        if (ac.equals("uppass")) {
            String id = request.getParameter("id");
            String upass = request.getParameter("upass");
            String tname = request.getParameter("tname");
            String sex = request.getParameter("sex");
            String birth = request.getParameter("birth");
            String tel = request.getParameter("tel");
            String ismarage = request.getParameter("ismarage");
            String addr = request.getParameter("addr");
            String email = request.getParameter("email");
            String idcard = request.getParameter("idcard");
            String byschool = request.getParameter("byschool");
            String sql = "update sysuser set upass='" + upass + "',tname='" + tname + "',sex='" + sex + "'  ,birth='" + birth + "',tel='" + tel + "',ismarage='" + ismarage + "',addr='" + addr + "',email='" + email + "'" +
                    " ,idcard='" + idcard + "',byschool='" + byschool + "' where id=" + id;
            dao.commOper(sql);
            request.setAttribute("suc", "");
            go("/admin/uppass.jsp", request, response);
        }
        //退出
        if (ac.equals("exit")) {
            session.removeAttribute("admin");
            request.setAttribute("suc", "");
            go("/admin/login.jsp", request, response);
        }
        //新增挂号
        if (ac.equals("ghadd")) {
            String ghno = request.getParameter("ghno");
            String tname = request.getParameter("tname");
            String sex = request.getParameter("sex");
            String age = request.getParameter("age");
            String idcard = request.getParameter("idcard");
            String tel = request.getParameter("tel");
            String addr = request.getParameter("addr");
            String ghdept = request.getParameter("ghdept");
            String price = request.getParameter("price");
            String status = "待问诊";
            String delstatus = "0";
            String oper = admin.get("uname").toString();
            String savetime = Info.getDateStr();
            dao.commOper("insert into ghinfo (ghno,tname,sex,age,idcard,tel,addr,ghdept,price,status,delstatus,oper,savetime) " +
                    " values('" + ghno + "','" + tname + "','" + sex + "','" + age + "','" + idcard + "','" + tel + "','" + addr + "','" + ghdept + "','" + price + "','" + status + "','" + delstatus + "','" + oper + "','" + savetime + "')  ");
            request.setAttribute("suc", "");
            go("/admin/ghadd.jsp", request, response);
        }
			String c = b.substring(0,4);
			String d = b.substring(5,7);
			String f = b.substring(8,10);
			String aa = c+"/"+d+"/"+f;
			String a = "";
			DateFormat dateFormat =  DateFormat.getDateInstance(DateFormat.MEDIUM);
				GregorianCalendar grc=new GregorianCalendar();
				grc.setTime(new Date(aa));
	            grc.add(GregorianCalendar.DAY_OF_MONTH,day);
	            String resu = dateFormat.format(grc.getTime());
	        String t[]= resu.split("-");
	        String sesuu = "";
	        for(int i=0;i<t.length;i++)
	        {
	        	if(t[i].length()==1)
	        	{
	        		t[i]="0"+t[i];
	        	}
	        	sesuu += t[i]+"-";
	        }
	        
			return sesuu.substring(0,10);
		}
		

	    
	    
	    /**
	 	 * 计算两个时期之间的天数
	 	 * 
	 	 */
	    public static int dayToday(String DATE1, String DATE2) {
	       int i = 0;
	       DATE1 = DATE1.substring(0,DATE1.indexOf(" "));
	       DATE2 = DATE2.substring(0,DATE2.indexOf(" "));
	       
	       String[] d1 = DATE1.split("-");
	       if(d1[1].length()==1)
	       {
	    	   DATE1 = d1[0]+"-0"+d1[1];
            go("/admin/ypcfadd.jsp", request, response);
        }

        //修改密码
        if (ac.equals("uppass")) {
            String id = request.getParameter("id");
            String upass = request.getParameter("upass");
            String tname = request.getParameter("tname");
            String sex = request.getParameter("sex");
            String birth = request.getParameter("birth");
            String tel = request.getParameter("tel");
            String ismarage = request.getParameter("ismarage");
            String addr = request.getParameter("addr");
            String email = request.getParameter("email");
            String idcard = request.getParameter("idcard");
            String byschool = request.getParameter("byschool");
            String sql = "update sysuser set upass='" + upass + "',tname='" + tname + "',sex='" + sex + "'  ,birth='" + birth + "',tel='" + tel + "',ismarage='" + ismarage + "',addr='" + addr + "',email='" + email + "'" +
                    " ,idcard='" + idcard + "',byschool='" + byschool + "' where id=" + id;
            dao.commOper(sql);
            request.setAttribute("suc", "");
            go("/admin/uppass.jsp", request, response);
        }
        //退出
        if (ac.equals("exit")) {
            session.removeAttribute("admin");
            request.setAttribute("suc", "");
            go("/admin/login.jsp", request, response);
        }
        //新增挂号
        if (ac.equals("ghadd")) {
            String ghno = request.getParameter("ghno");
            String tname = request.getParameter("tname");
            String sex = request.getParameter("sex");
            String age = request.getParameter("age");
            String idcard = request.getParameter("idcard");
            String tel = request.getParameter("tel");
            String addr = request.getParameter("addr");
            String ghdept = request.getParameter("ghdept");
            String price = request.getParameter("price");
            String status = "待问诊";
            String delstatus = "0";
            String oper = admin.get("uname").toString();
            String savetime = Info.getDateStr();
            dao.commOper("insert into ghinfo (ghno,tname,sex,age,idcard,tel,addr,ghdept,price,status,delstatus,oper,savetime) " +
                    " values('" + ghno + "','" + tname + "','" + sex + "','" + age + "','" + idcard + "','" + tel + "','" + addr + "','" + ghdept + "','" + price + "','" + status + "','" + delstatus + "','" + oper + "','" + savetime + "')  ");
            request.setAttribute("suc", "");
            go("/admin/ghadd.jsp", request, response);
        }
        //药品入库
        if (ac.equals("yprk")) {
            String yno = request.getParameter("yno");
            String num = request.getParameter("num");

		}
		buf.append("&nbsp;&nbsp;");

		int currentSegment = this.currentPage % segment == 0 ? this.currentPage
				/ segment : this.currentPage / segment + 1;

		/*for (int i = 1; i <= this.pageNumber; i++) {
			if (this.currentPage == i)
				buf.append("<font color='red'>").append(i).append("</font>");

			else
				buf.append("<a href='").append(this.path).append(
						"&currentPage=").append(i).append(parameter).append(
						"' class='ls'>[").append(i).append(
						"]</a>");
		}*/

		buf.append("&nbsp;&nbsp;");
		if (this.currentPage < this.pageNumber) {
			buf.append("<a href='").append(this.path).append("&currentPage=")
					.append(currentPage + 1).append(parameter).append(
							"' class='ls'>").append("下页")
					.append("</a>");
		} else {

			buf.append("下页");

		}

		buf.append("&nbsp;&nbsp;&nbsp;&nbsp;");
		if (this.currentPage == this.pageNumber)
			buf.append("末页&nbsp;&nbsp;");
		else
			buf.append("<a href='").append(this.path).append("&currentPage=")
					.append(this.pageNumber).append(parameter).append(
							"' class='ls'>").append("末页")
					.append("</a></font>&nbsp;&nbsp;");
		// 
		// for (int i = 0; i < this.pageNumber; i++) {
		// if (this.currentPage == i + 1) {
		// buf.append("<font color=red>[" + (i + 1) + "]</font>").append(
		// "&nbsp;");
		// } else {
		// buf.append("<a href='").append(this.path).append(

请添加图片描述

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值