项目介绍:
本系统采用servlet技术,mysql数据库,mvc架构,适合基础一般的同学,适合选题:牙医、医院、就医、问诊等,系统分为6个角色。
项目技术:
后端:servlet
前端:js、css等基础技术
开发工具:eclipse
数据库:mysql 5.7
JDK版本:jdk1.8
服务器:tomcat8
功能介绍:
病人:注册登录,查看公告、查看或维护个人信息、留言、预约挂号
挂号管理员:受理挂号信息、新增挂号、挂号管理、个人信息维护
医生:查看挂号信息、问诊、个人信息维护
收费管理员:待收费记录、收费、收费统计、个人信息维护
药房管理员:待发药记录、发药记录、药品入库、药品库存管理、个人信息维护
管理员:公告管理、留言管理、用户管理、科室管理、药品处置维护,统计报表,信息维护
部分功能展示:
系统首页,游客可以进行注册成为病人
注册完成后,可以进行预约挂号,选择对应科室即可
病人也可以进行查看公告和留言
病人挂号后,需要等待挂号管理员进行受理,之后医生才能看到挂号信息
受理完成后,医生可以看到挂号信息
然后医生进行问诊,记录病人的病情,可以开药
问诊结束后,病人需要到收费处进行缴费,缴费后可以领取药品
领取药品时,如果药品库存不够,可以进行药品入库
还有一个管理员角色,功能较多,如下
以上就是部分功能情况,其他功能由于篇幅原因,就不详细展示了。
部分代码:
//登录 if(ac.equals("login")) { String utype = request.getParameter("utype"); String username = request.getParameter("uname"); String password = request.getParameter("upass"); String sql = "select * from sysuser where uname='"+username+"' and upass='"+password+"' "; List<HashMap> userlist = dao.select(sql); if(userlist.size()!=1) { request.setAttribute("error", ""); go("/admin/login.jsp", request, response); }else{ request.getSession(). setAttribute("admin", userlist.get(0)); gor("/srykzsblmis/admin/index.jsp", request, response); } } //添加用户 if(ac.equals("sysuseradd")){ String uname = request.getParameter("uname"); String cksql = "select * from sysuser where uname='"+uname+"'"; ArrayList cklist = (ArrayList)dao.select(cksql); if(cklist.size()!=0){ request.getParameter("no"); go("/admin/sysuseradd.jsp", request, response); }else{ String upass = request.getParameter("upass"); String tname = request.getParameter("tname"); String utype = request.getParameter("utype"); 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 dept = request.getParameter("dept"); if(!utype.equals("医生")){ dept = ""; } String sql = "insert into sysuser (uname,upass,tname,utype,sex,dept,birth,tel,ismarage,addr,email,idcard,byschool)values" + " ('"+uname+"','"+upass+"','"+tname+"','"+utype+"','"+sex+"','"+dept+"','"+birth+"','"+tel+"','"+ismarage+"'" + " ,'"+addr+"','"+email+"','"+idcard+"','"+byschool+"')"; dao.commOper(sql); request.setAttribute("suc", ""); go("/admin/sysuseradd.jsp", request, response); } } //编辑用户 if(ac.equals("sysuseredit")){ String id = request.getParameter("id"); String upass = request.getParameter("upass"); String tname = request.getParameter("tname"); String utype = request.getParameter("utype"); String sex = request.getParameter("sex"); String dept = request.getParameter("dept"); 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"); if(!utype.equals("医生")){ dept = ""; } String sql = "update sysuser set upass='"+upass+"',tname='"+tname+"',utype='"+utype+"',sex='"+sex+"',dept='"+dept+"' " + " ,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/sysuseradd.jsp", request, response); } //修改个人信息 if(ac.equals("stuedit1")){ String id = request.getParameter("id"); String upass = request.getParameter("upass"); String tname = request.getParameter("tname"); String sfcard = request.getParameter("sfcard"); String sex = request.getParameter("sex"); String tel = request.getParameter("tel"); String yx = request.getParameter("yx"); String bj = request.getParameter("bj"); String sql = "update student set upass='"+upass+"',tname='"+tname+"',sfcard='"+sfcard+"',sex='"+sex+"',tel='"+tel+"',yx='"+yx+"',bj='"+bj+"' where id="+id; dao.commOper(sql); request.setAttribute("suc", ""); go("/admin/stuinfo.jsp", request, response); } //添加科室 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); }
以上就是部分功能展示,从整体上来看,本系统功能是十分完整的,界面设计简洁大方,交互友好,数据库设计也很合理,规模适中,适合学习使用。
好了,今天就到这儿吧,小伙伴们点赞、收藏、评论,一键三连走起呀,下期见~~