基于javaweb+jsp的医院预约挂号系统(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("/findDeptById")
public String findDeptById(Integer deptId, HttpSession session) {
Dept de2= deptService.findDeptById(deptId);
session.setAttribute("de2",de2);
return "Dept_edit";
}
/**
* 导出Excel
*/
@RequestMapping(value = "/exportDeptlist" , method = RequestMethod.POST)
@ResponseBody
public List<Dept> exportDept(){
List<Dept> depts = deptService.getAll();
return depts;
}
/**
* 部门人员信息查询
*/
@RequestMapping(value = "/findDeptPersonnel")
public String findClassStudent(Dept dept,Model model, HttpSession session) {
List<Dept> dep = deptService.findDeptPersonnel(dept);
model.addAttribute("dep",dep);
return "dept_Personnellist";
/**
* 删除仪器信息
*/
@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);
PageInfo<Potion> po = potionService.findPageInfo(potionNo,potionName, pageIndex,pageSize);
model.addAttribute("po",po);
session.setAttribute("u",potionNo);
session.setAttribute("t",potionName);
return "potion_list";
}
/**
* 添加管理员信息
*/
@RequestMapping(value = "/addPotion" ,method = RequestMethod.POST)
@ResponseBody
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";
public String addAdmin(@RequestBody Tms tms) {
tms.setTmsPswd(MD5Util.MD5EncodeUtf8(tms.getTmsPswd()));
int a = tmsService.addTms(tms);
return "admin_list";
}
/**
* 删除管理员信息
*/
@RequestMapping( "/deleteAdmin")
@ResponseBody
public String deleteAdmin(Integer tmsId) {
int a = tmsService.deleteTms(tmsId);
return "admin_list";
}
/**
* 导出Excel
*/
@RequestMapping(value = "/exportadminlist" , method = RequestMethod.POST)
@ResponseBody
public List<Tms> exportAdmin(){
List<Tms> admin = tmsService.getAll();
return admin;
}
/**
@RequestMapping(value = "/exportDeptlist" , method = RequestMethod.POST)
@ResponseBody
public List<Dept> exportDept(){
List<Dept> depts = deptService.getAll();
return depts;
}
/**
* 部门人员信息查询
*/
@RequestMapping(value = "/findDeptPersonnel")
public String findClassStudent(Dept dept,Model model, HttpSession session) {
List<Dept> dep = deptService.findDeptPersonnel(dept);
model.addAttribute("dep",dep);
return "dept_Personnellist";
}
}
管理员信息控制层:
@Controller
public class TmsController {
@Autowired
private TmsService tmsService;
@RequestMapping(value = "/login")
}
/**
* 部门人员信息查询
*/
@RequestMapping(value = "/findDeptPersonnel")
public String findClassStudent(Dept dept,Model model, HttpSession session) {
List<Dept> dep = deptService.findDeptPersonnel(dept);
model.addAttribute("dep",dep);
return "dept_Personnellist";
}
}
管理员信息控制层:
@Controller
*/
@RequestMapping(value = "/findAdmin")
public String findAdmin(String tmsUser, String tmsName,Integer pageIndex
, Integer pageSize, Model model,HttpSession session) {
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
}
/**
* 退出登录
*/
@RequestMapping(value = "/loginOut")
public String loginOut(Tms tms, Model model, HttpSession session) {
session.invalidate();
return "login";
}
/**
* 修改仪器信息
*/
@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 = "/addPotion" ,method = RequestMethod.POST)
@ResponseBody
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";
}
/**
* 修改仪器信息
* 导出Excel
*/
@RequestMapping(value = "/exportPotionlist" , method = RequestMethod.POST)
@ResponseBody
public List<Potion> exportPotion(){
List<Potion> potions = potionService.getAll();
return potions;
}
}
部门信息控制层:
@Controller
public class DeptController {
@Autowired
private DeptService deptService;
/**
* 分页查询
*/
@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);
}
/**
* 修改仪器信息
*/
@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")
}
/**
* 修改管理员信息
*/
/**
* 将提交数据写入Tms对象
*/
@RequestMapping( value = "/updateAdmin", method = RequestMethod.POST)
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")
@ResponseBody
public List<Dept> exportDept(){
List<Dept> depts = deptService.getAll();
return depts;
}
/**
* 部门人员信息查询
*/
@RequestMapping(value = "/findDeptPersonnel")
public String findClassStudent(Dept dept,Model model, HttpSession session) {
List<Dept> dep = deptService.findDeptPersonnel(dept);
model.addAttribute("dep",dep);
return "dept_Personnellist";
}
}
管理员信息控制层:
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")
* 分页查询
*/
@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
public String addDept(@RequestBody Dept dept) {
int a = deptService.addDept(dept);
return "Dept_list";
}
/**
* 修改信息
* 导出Excel
*/
@RequestMapping(value = "/exportadminlist" , method = RequestMethod.POST)
@ResponseBody
public List<Tms> exportAdmin(){
List<Tms> admin = tmsService.getAll();
return admin;
}
/**
* 根据管理员Id搜索;
*/
@RequestMapping( "/findAdminById")
public class PotionController {
@Autowired
private PotionService potionService;
/**
* 分页查询
*/
@RequestMapping("/findPotion")
public String findPotion(String potionNo, String potionName,Integer pageIndex
, Integer pageSize, Model model,HttpSession session){
PageInfo<Potion> po = potionService.findPageInfo(potionNo,potionName, pageIndex,pageSize);
model.addAttribute("po",po);
session.setAttribute("u",potionNo);
@RequestMapping("/findPotion")
public String findPotion(String potionNo, String potionName,Integer pageIndex
, Integer pageSize, Model model,HttpSession session){
PageInfo<Potion> po = potionService.findPageInfo(potionNo,potionName, pageIndex,pageSize);
model.addAttribute("po",po);
session.setAttribute("u",potionNo);
session.setAttribute("t",potionName);
return "potion_list";
}
/**
* 添加管理员信息
*/
@RequestMapping(value = "/addPotion" ,method = RequestMethod.POST)
@ResponseBody
public String addPotion(@RequestBody Potion potion) {
int a = potionService.addPotion(potion);
return "potion_list";
}
public String loginOut(Tms tms, Model model, HttpSession session) {
session.invalidate();
return "login";
}
/**
* 分页查询
*/
@RequestMapping(value = "/findAdmin")
public String findAdmin(String tmsUser, String tmsName,Integer pageIndex
, Integer pageSize, Model model,HttpSession session) {
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 = "/updateDept", method = RequestMethod.POST)
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);
public String findClassStudent(Dept dept,Model model, HttpSession session) {
List<Dept> dep = deptService.findDeptPersonnel(dept);
model.addAttribute("dep",dep);
return "dept_Personnellist";
}
}
管理员信息控制层:
@Controller
public class TmsController {
@Autowired
public List<Potion> exportPotion(){
List<Potion> potions = potionService.getAll();
return potions;
}
}
部门信息控制层:
@Controller
public class DeptController {
@Autowired
private DeptService deptService;
/**
* 分页查询
*/
* 删除管理员信息
*/
@RequestMapping( "/deleteAdmin")
@ResponseBody
public String deleteAdmin(Integer tmsId) {
int a = tmsService.deleteTms(tmsId);
return "admin_list";
}
/**
* 导出Excel
*/
@RequestMapping(value = "/exportadminlist" , method = RequestMethod.POST)
@ResponseBody
public List<Tms> exportAdmin(){
List<Tms> admin = tmsService.getAll();
return admin;
}
session.setAttribute("u",deptNo);
session.setAttribute("t",deptName);
return "Dept_list";
}
/**
* 添加管理员信息
*/
@RequestMapping(value = "/addDept" ,method = RequestMethod.POST)
@ResponseBody
public String addDept(@RequestBody Dept dept) {
int a = deptService.addDept(dept);
return "Dept_list";
}
/**
* 修改信息
@RequestMapping(value = "/loginOut")
public String loginOut(Tms tms, Model model, HttpSession session) {
session.invalidate();
return "login";
}
/**
* 分页查询
*/
@RequestMapping(value = "/findAdmin")
public String findAdmin(String tmsUser, String tmsName,Integer pageIndex
, Integer pageSize, Model model,HttpSession session) {
PageInfo<Tms> ai = tmsService.findPageInfo(tmsUser,tmsName, pageIndex,pageSize);
model.addAttribute("ai",ai);
session.setAttribute("u",tmsUser);
session.setAttribute("t",tmsName);
/**
* 分页查询
*/
@RequestMapping(value = "/findAdmin")
public String findAdmin(String tmsUser, String tmsName,Integer pageIndex
, Integer pageSize, Model model,HttpSession session) {
PageInfo<Tms> ai = tmsService.findPageInfo(tmsUser,tmsName, pageIndex,pageSize);
model.addAttribute("ai",ai);
session.setAttribute("u",tmsUser);
session.setAttribute("t",tmsName);
return "admin_list";
}