博主主页:猫头鹰源码
博主简介:Java领域优质创作者、CSDN博客专家、公司架构师、全网粉丝5万+、专注Java技术领域和毕业设计项目实战
主要内容:毕业设计(Javaweb项目|小程序等)、简历模板、学习资料、面试题库、技术咨询
文末联系获取
本系统采用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);
- }
以上就是部分功能展示,从整体上来看,本系统功能是十分完整的,界面设计简洁大方,交互友好,数据库设计也很合理,规模适中,适合学习使用。
好了,今天就到这儿吧,小伙伴们点赞、收藏、评论,一键三连走起呀,下期见~~