基于javaweb+mysql的医院预约挂号系统(java+jdbc+jsp+mysql+ajax)

一、项目简述
功能： 用户分为患者，医生，管理员，患者可进行注册选择医生 挂号，选择日期，选择号源，医生可进行接诊，管理员可 对用户，医生信息的维护等等功能。

二、项目运行
环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)

项目技术： Jdbc+ Servlert + Jsp + css + JavaScript + JQuery + Ajax + Fileupload等等。

适用

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

    /**
     * 分页查询
     */
    @RequestMapping("/findDept")
    public String findDept(String deptNo, String deptName,Integer pageIndex
            , Integer pageSize, Model model,HttpSession session){
        PageInfo<Dept> de = deptService.findPageInfo(deptNo,deptName, pageIndex,pageSize);
        model.addAttribute("de",de);
        session.setAttribute("u",deptNo);
        session.setAttribute("t",deptName);
        return "Dept_list";
    }
    /**
     * 添加管理员信息
     */
    @RequestMapping(value = "/addDept" ,method = RequestMethod.POST)
    @ResponseBody

        int a = potionService.updatePotion(potion);
        return "redirect:/findPotion";
    }
    /**
     * 根据管理员Id搜索;将请求数据a_id写入参数a_id
     */
    @RequestMapping("/findPotionById")
    public String findPotionById(Integer potionId, HttpSession session) {
        Potion po2= potionService.findPotionById(potionId);
        session.setAttribute("po2",po2);
        return "potion_edit";
    }
    /**
     * 导出Excel
     */
    @RequestMapping(value = "/exportPotionlist" , method = RequestMethod.POST)
    @ResponseBody
    public List<Potion> exportPotion(){
        List<Potion> potions = potionService.getAll();
        return potions;
    }
}
部门信息控制层:
@Controller
public class DeptController {
    @Autowired

    public String updateAdmin(Tms tms) {
        tms.setTmsPswd(MD5Util.MD5EncodeUtf8(tms.getTmsPswd()));
        int a = tmsService.updateTms(tms);
        return "redirect:/findAdmin";
    }
}
 仪器信息控制层：
@Controller
public class PotionController {
    @Autowired
    private PotionService potionService;
    /**
     * 分页查询
     */
    @RequestMapping("/findPotion")
    public String findPotion(String potionNo, String potionName,Integer pageIndex
            , Integer pageSize, Model model,HttpSession session){

    public String updateDept(Dept dept) {
        int a = deptService.updateDept(dept);
        return "redirect:/findDept";
    }
    /**
     * 根据Id搜索;
     */
    @RequestMapping("/findDeptById")
    public String findDeptById(Integer deptId, HttpSession session) {
        Dept de2= deptService.findDeptById(deptId);
        session.setAttribute("de2",de2);
        return "Dept_edit";
    }
    /**
     * 导出Excel

    /**
     * 根据管理员Id搜索;将请求数据a_id写入参数a_id
     */
    @RequestMapping("/findPotionById")
    public String findPotionById(Integer potionId, HttpSession session) {
        Potion po2= potionService.findPotionById(potionId);
        session.setAttribute("po2",po2);
        return "potion_edit";
    }
    /**
     * 导出Excel
     */
    @RequestMapping(value = "/exportPotionlist" , method = RequestMethod.POST)

        model.addAttribute("dep",dep);
        return "dept_Personnellist";
    }
}
管理员信息控制层：
@Controller
public class TmsController {
    @Autowired
    private TmsService tmsService;
    @RequestMapping(value = "/login")
    public String login(Tms tms, Model model, HttpSession session){
        // 通过账号和密码查询用户
        tms.setTmsPswd(MD5Util.MD5EncodeUtf8(tms.getTmsPswd()));
        Tms ad = tmsService.findTms(tms);
        if(ad!=null){
            session.setAttribute("ad", ad);
            return "homepage";
        }
        model.addAttribute("msg", "error");

        return "admin_list";
    }
    /**
     * 导出Excel
     */
    @RequestMapping(value = "/exportadminlist" , method = RequestMethod.POST)
    @ResponseBody
    public List<Tms> exportAdmin(){
        List<Tms> admin = tmsService.getAll();
        return admin;
    }
    /**
     * 根据管理员Id搜索;
     */
    @RequestMapping( "/findAdminById")
    public String findAdminById( Integer tmId,HttpSession session) {
        Tms a= tmsService.findTmsById(tmId);
        session.setAttribute("a",a);
        return "admin_edit";

    public String addPotion(@RequestBody Potion potion) {
        int a = potionService.addPotion(potion);
        return "potion_list";
    }
    /**
     * 删除仪器信息
     */
    @RequestMapping( "/deletePotion")
    @ResponseBody
    public String deletePotion(Integer potionId) {
        int a = potionService.deletePotion(potionId);
        return "potion_list";
    }
    /**
     * 修改仪器信息
     */
    @RequestMapping( value = "/updatePotion", method = RequestMethod.POST)
    public String updatePotion(Potion potion) {
        int a = potionService.updatePotion(potion);
        return "redirect:/findPotion";
    }
    /**

    @RequestMapping( value = "/updatePotion", method = RequestMethod.POST)
    public String updatePotion(Potion potion) {
        int a = potionService.updatePotion(potion);
        return "redirect:/findPotion";
    }
    /**
     * 根据管理员Id搜索;将请求数据a_id写入参数a_id
     */
    @RequestMapping("/findPotionById")
    public String findPotionById(Integer potionId, HttpSession session) {
        Potion po2= potionService.findPotionById(potionId);
        session.setAttribute("po2",po2);
        return "potion_edit";
    }
    /**
     * 导出Excel
     */
    @RequestMapping(value = "/exportPotionlist" , method = RequestMethod.POST)
    @ResponseBody
    public List<Potion> exportPotion(){
        List<Potion> potions = potionService.getAll();
        return potions;

        PageInfo<Tms> ai = tmsService.findPageInfo(tmsUser,tmsName, pageIndex,pageSize);
        model.addAttribute("ai",ai);
        session.setAttribute("u",tmsUser);
        session.setAttribute("t",tmsName);
        return "admin_list";
    }
    /**
     * 添加管理员信息
     */
    @RequestMapping(value = "/addAdmin" ,method = RequestMethod.POST)
    @ResponseBody
    public String addAdmin(@RequestBody Tms tms) {
        tms.setTmsPswd(MD5Util.MD5EncodeUtf8(tms.getTmsPswd()));
        int a = tmsService.addTms(tms);
        return "admin_list";
    }

     * 导出Excel
     */
    @RequestMapping(value = "/exportadminlist" , method = RequestMethod.POST)
    @ResponseBody
    public List<Tms> exportAdmin(){
        List<Tms> admin = tmsService.getAll();
        return admin;
    }
    /**
     * 根据管理员Id搜索;
     */
    @RequestMapping( "/findAdminById")
    public String findAdminById( Integer tmId,HttpSession session) {
        Tms a= tmsService.findTmsById(tmId);