基于javaweb+mysql的springboot医院药品管理系统设计和实现(java+springboot+ssm+mysql+thymeleaf+html+maven)
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot医院药品管理系统设计和实现(java+springboot+ssm+mysql+thymeleaf+html+maven)
功能描叙: 药品销售管理,药品明晰管理,药片库存管理,登记出入 库信息,问题药品记录,药片保质期检查,销售记录,退 货记录,药品信息,供应商信息等等。
IPage<Returnsupplier> iPage = returnsupplierService.selectReturnsupplierPage(pageNum,pageSize,param);
return ResultMapUtil.getHashMapMysqlPage(iPage);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 转向退货给供应商新增页面
*/
@RequestMapping(value = "/returnsupplierPage")
public String returnsupplierPage(){
return "/returnsupplierPage";
}
/**
* 添加一个退货给供应商
*/
@RequestMapping(value = "/returnsupplierAdd")
@ResponseBody
public Object returnsupplierAdd(Returnsupplier returnsupplier){
try{
int i = returnsupplierService.addReturnsupplier(returnsupplier);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 转向退货给供应商编辑页面
*/
@RequestMapping(value = "/returnsupplierQueryById")
public String returnsupplierQueryById(@RequestParam(name = "id",required = true)Integer id, Model model){
Returnsupplier returnsupplier = returnsupplierService.queryReturnsupplierById(id);
model.addAttribute("obj",returnsupplier);
return "/returnsupplierPage";
}
/**
* 修改一个退货给供应商
*/
@RequestMapping(value = "/returnsupplierEdit")
@ResponseBody
public Object returnsupplierEdit(Returnsupplier returnsupplier){
try{
int i = returnsupplierService.editReturnsupplier(returnsupplier);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 删除一个销售记录
*/
@RequestMapping(value = "/saleinfoDelById")
@ResponseBody
public Object saleinfoDelById(Integer id){
try{
int i = saleinfoService.delSaleinfoById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
}
package com.javaclimb.drug.controller;
@ResponseBody
public Object druginfoList(){
List<Druginfo> druginfoList = druginfoService.queryDruginfoList();
return ResultMapUtil.getHashMapList(druginfoList);
}
/**
* 转向药品保质期检查页面
*/
@RequestMapping(value = "/warranty")
public String warranty(){
return "/warranty";
}
}
package com.javaclimb.drug.controller;
/**
* 退货给供应商相关的controller
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 转向药品出入库编辑页面
*/
@RequestMapping(value = "/owinfoQueryById")
public String owinfoQueryById(@RequestParam(name = "id",required = true)Integer id, Model model){
Owinfo owinfo = owinfoService.queryOwinfoById(id);
model.addAttribute("obj",owinfo);
return "/owinfoPage";
}
/**
* 修改一个药品出入库
*/
@RequestMapping(value = "/owinfoEdit")
@ResponseBody
public Object owinfoEdit(Owinfo owinfo){
try{
int i = owinfoService.editOwinfo(owinfo);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 删除一个药品出入库
*/
@RequestMapping(value = "/owinfoDelById")
@ResponseBody
public Object owinfoDelById(Integer id){
try{
int i = owinfoService.delOwinfoById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
}
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 删除一个销售记录
*/
@RequestMapping(value = "/saleinfoDelById")
@ResponseBody
public Object saleinfoDelById(Integer id){
try{
int i = saleinfoService.delSaleinfoById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
}
package com.javaclimb.drug.controller;
* 用户相关的controller
*/
@Controller
public class UserController {
/**
* 转向登录页面
*/
@RequestMapping(value = "/login")
public String login(){
return "/login";
}
/**
* 判断用户登录是否成功
*/
@RequestMapping(value = "/toLogin")
@ResponseBody
public Object toLogin(String username,String password){
if(username==null||password==null){
return ResultMapUtil.getHashMapLogin("用户名密码不能为空","2");
}
Subject subject = SecurityUtils.getSubject();
UsernamePasswordToken token = new UsernamePasswordToken(username,password);
try{
subject.login(token);
}catch (UnknownAccountException e){
return ResultMapUtil.getHashMapLogin("用户名不存在","2");
}catch (IncorrectCredentialsException e){
return ResultMapUtil.getHashMapLogin("密码错误","2");
}
return ResultMapUtil.getHashMapLogin("验证成功","1");
}
/**
* 转向后台管理首页
*/
@RequestMapping(value = "/index")
public String index(){
return "/index";
}
/**
* 退出登录
*/
@RequestMapping(value = "/logout")
public String logout(){
Subject subject = SecurityUtils.getSubject();
subject.logout();
return "redirect:/login";
}
}
return "/supplierPage";
}
/**
* 添加一个供应商
*/
@RequestMapping(value = "/supplierAdd")
@ResponseBody
public Object supplierAdd(Supplier supplier){
try{
supplier.setCreatetime(new Date());
int i = supplierService.addSupplier(supplier);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 转向供应商编辑页面
*/
@RequestMapping(value = "/supplierQueryById")
public String supplierQueryById(@RequestParam(name = "id",required = true)Integer id, Model model){
Supplier supplier = supplierService.querySupplierById(id);
model.addAttribute("obj",supplier);
return "/supplierPage";
}
/**
* 修改一个供应商
*/
@RequestMapping(value = "/supplierEdit")
@ResponseBody
public Object supplierEdit(Supplier supplier){
try{
int i = supplierService.editSupplier(supplier);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 删除一个供应商
*/
@RequestMapping(value = "/supplierDelById")
@ResponseBody
public Object supplierDelById(Integer id){
try{
int i = supplierService.delSupplierById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
/**
* 转向销售记录编辑页面
*/
@RequestMapping(value = "/saleinfoQueryById")
public String saleinfoQueryById(@RequestParam(name = "id",required = true)Integer id, Model model){
Saleinfo saleinfo = saleinfoService.querySaleinfoById(id);
model.addAttribute("obj",saleinfo);
return "/saleinfoPage";
}
/**
* 修改一个销售记录
*/
@RequestMapping(value = "/saleinfoEdit")
@ResponseBody
public Object saleinfoEdit(Saleinfo saleinfo){
try{
int i = saleinfoService.editSaleinfo(saleinfo);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 删除一个销售记录
*/
@RequestMapping(value = "/saleinfoDelById")
@ResponseBody
public Object saleinfoDelById(Integer id){
try{
int i = saleinfoService.delSaleinfoById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
}
/**
* 销售记录相关的controller
*/
@Controller
@RequestMapping(value = "/saleinfo")
public class SaleinfoController {
@Autowired
private ISaleinfoService saleinfoService;
/**
* 转向销售记录页面
*/
@RequestMapping
public String saleinfo(){
return "/saleinfo";
}
/**
* 分页查询销售记录列表
*/
@RequestMapping(value = "/saleinfoQueryPage")
@ResponseBody
public Object saleinfoQueryPage(String param, @RequestParam(defaultValue = "1")int pageNum,@RequestParam(defaultValue = "10")int pageSize){
try{
IPage<Saleinfo> iPage = saleinfoService.selectSaleinfoPage(pageNum,pageSize,param);
return ResultMapUtil.getHashMapMysqlPage(iPage);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 转向销售记录新增页面
*/
@RequestMapping(value = "/saleinfoPage")
public String saleinfoPage(){
return "/saleinfoPage";
}
/**
/**
* 用户相关的controller
*/
@Controller
public class UserController {
/**
* 转向登录页面
*/
@RequestMapping(value = "/login")
public String login(){
return "/login";
}
/**
* 判断用户登录是否成功
*/
@RequestMapping(value = "/toLogin")
@ResponseBody
public Object toLogin(String username,String password){
if(username==null||password==null){
return ResultMapUtil.getHashMapLogin("用户名密码不能为空","2");
}
Subject subject = SecurityUtils.getSubject();
UsernamePasswordToken token = new UsernamePasswordToken(username,password);
try{
subject.login(token);
}catch (UnknownAccountException e){
return ResultMapUtil.getHashMapLogin("用户名不存在","2");
}catch (IncorrectCredentialsException e){
return ResultMapUtil.getHashMapLogin("密码错误","2");
}
return ResultMapUtil.getHashMapLogin("验证成功","1");
}
/**
* 转向后台管理首页
*/
@RequestMapping(value = "/index")
public String index(){
return "/index";
/**
* 问题药品相关的controller
*/
@Controller
@RequestMapping(value = "/problem")
public class ProblemController {
@Autowired
private IProblemService problemService;
/**
* 转向问题药品页面
*/
@RequestMapping
public String problem(){
return "/problem";
}
/**
* 分页查询问题药品列表
*/
@RequestMapping(value = "/problemQueryPage")
@ResponseBody
public Object problemQueryPage(String param, @RequestParam(defaultValue = "1")int pageNum,@RequestParam(defaultValue = "10")int pageSize){
try{
IPage<Problem> iPage = problemService.selectProblemPage(pageNum,pageSize,param);
return ResultMapUtil.getHashMapMysqlPage(iPage);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 转向问题药品新增页面
*/
@RequestMapping(value = "/problemPage")
public String problemPage(){
return "/problemPage";
package com.javaclimb.drug.controller;
/**
* 用户相关的controller
*/
@Controller
public class UserController {
/**
* 转向登录页面
*/
@RequestMapping(value = "/login")
public String login(){
return "/login";
}
/**
* 判断用户登录是否成功
*/
@RequestMapping(value = "/toLogin")
@ResponseBody
public Object toLogin(String username,String password){
if(username==null||password==null){
return ResultMapUtil.getHashMapLogin("用户名密码不能为空","2");
}
Subject subject = SecurityUtils.getSubject();
UsernamePasswordToken token = new UsernamePasswordToken(username,password);
try{
subject.login(token);
}catch (UnknownAccountException e){
return ResultMapUtil.getHashMapLogin("用户名不存在","2");
public String supplierQueryById(@RequestParam(name = "id",required = true)Integer id, Model model){
Supplier supplier = supplierService.querySupplierById(id);
model.addAttribute("obj",supplier);
return "/supplierPage";
}
/**
* 修改一个供应商
*/
@RequestMapping(value = "/supplierEdit")
@ResponseBody
public Object supplierEdit(Supplier supplier){
try{
int i = supplierService.editSupplier(supplier);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 删除一个供应商
*/
@RequestMapping(value = "/supplierDelById")
@ResponseBody
public Object supplierDelById(Integer id){
try{
int i = supplierService.delSupplierById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 获取所有供应商
*/
@RequestMapping(value = "/supplierList")
@ResponseBody
public Object supplierList(){
List<Supplier> supplierList = supplierService.querySupplierList();
return ResultMapUtil.getHashMapList(supplierList);
}
}
package com.javaclimb.drug.controller;
/**
* 销售记录相关的controller
*/
@Controller
@RequestMapping(value = "/saleinfo")
public class SaleinfoController {
@Autowired
private ISaleinfoService saleinfoService;
/**
* 转向销售记录页面
*/
@RequestMapping
public String saleinfo(){
return "/saleinfo";
}
/**
* 分页查询销售记录列表
*/
@RequestMapping(value = "/saleinfoQueryPage")
@ResponseBody
public Object saleinfoQueryPage(String param, @RequestParam(defaultValue = "1")int pageNum,@RequestParam(defaultValue = "10")int pageSize){
try{
}
}
/**
* 删除一个销售记录
*/
@RequestMapping(value = "/saleinfoDelById")
@ResponseBody
public Object saleinfoDelById(Integer id){
try{
int i = saleinfoService.delSaleinfoById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
}
package com.javaclimb.drug.controller;
* 添加一个退货给供应商
*/
@RequestMapping(value = "/returnsupplierAdd")
@ResponseBody
public Object returnsupplierAdd(Returnsupplier returnsupplier){
try{
int i = returnsupplierService.addReturnsupplier(returnsupplier);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 转向退货给供应商编辑页面
*/
@RequestMapping(value = "/returnsupplierQueryById")
public String returnsupplierQueryById(@RequestParam(name = "id",required = true)Integer id, Model model){
Returnsupplier returnsupplier = returnsupplierService.queryReturnsupplierById(id);
model.addAttribute("obj",returnsupplier);
return "/returnsupplierPage";
}
/**
* 修改一个退货给供应商
*/
@RequestMapping(value = "/returnsupplierEdit")
@ResponseBody
public Object returnsupplierEdit(Returnsupplier returnsupplier){
try{
int i = returnsupplierService.editReturnsupplier(returnsupplier);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 删除一个退货给供应商
*/
@RequestMapping(value = "/returnsupplierDelById")
@ResponseBody
public Object returnsupplierDelById(Integer id){
try{
int i = returnsupplierService.delReturnsupplierById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
}
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
}
package com.javaclimb.drug.controller;
/**
* 账单信息相关的controller
*/
@Controller
@RequestMapping(value = "/billinfo")
public class BillinfoController {
@Autowired
private IBillinfoService billinfoService;
/**
* 转向账单信息页面
*/
@RequestMapping
*/
@RequestMapping(value = "/owinfoAdd")
@ResponseBody
public Object owinfoAdd(Owinfo owinfo){
try{
owinfo.setCreatetime(new Date());
int i = owinfoService.addOwinfo(owinfo);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 转向药品出入库编辑页面
*/
@RequestMapping(value = "/owinfoQueryById")
public String owinfoQueryById(@RequestParam(name = "id",required = true)Integer id, Model model){
Owinfo owinfo = owinfoService.queryOwinfoById(id);
model.addAttribute("obj",owinfo);
return "/owinfoPage";
}
/**
* 修改一个药品出入库
*/
@RequestMapping(value = "/owinfoEdit")
@ResponseBody
public Object owinfoEdit(Owinfo owinfo){
try{
int i = owinfoService.editOwinfo(owinfo);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 删除一个药品出入库
*/
@RequestMapping(value = "/owinfoDelById")
@ResponseBody
public Object owinfoDelById(Integer id){
try{
int i = owinfoService.delOwinfoById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
package com.javaclimb.drug.controller;
/**
* 退货给供应商相关的controller
*/
@Controller
@RequestMapping(value = "/returnsupplier")
public class ReturnsupplierController {
@Autowired
private IReturnsupplierService returnsupplierService;
/**
* 转向退货给供应商页面
*/
@RequestMapping
public String returnsupplier(){
return "/returnsupplier";
}
/**
* 分页查询退货给供应商列表
*/
@RequestMapping(value = "/returnsupplierQueryPage")
@ResponseBody
public Object returnsupplierQueryPage(String param, @RequestParam(defaultValue = "1")int pageNum,@RequestParam(defaultValue = "10")int pageSize){
try{
IPage<Returnsupplier> iPage = returnsupplierService.selectReturnsupplierPage(pageNum,pageSize,param);
/**
* 药品出入库相关的controller
*/
@Controller
@RequestMapping(value = "/owinfo")
public class OwinfoController {
@Autowired
private IOwinfoService owinfoService;
/**
* 转向药品出入库页面
*/
@RequestMapping
public String owinfo(){
return "/owinfo";
}
/**
* 分页查询药品出入库列表
*/
@RequestMapping(value = "/owinfoQueryPage")
@ResponseBody
public Object owinfoQueryPage(String param, @RequestParam(defaultValue = "1")int pageNum,@RequestParam(defaultValue = "10")int pageSize){
try{
IPage<Owinfo> iPage = owinfoService.selectOwinfoPage(pageNum,pageSize,param);
return ResultMapUtil.getHashMapMysqlPage(iPage);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
package com.javaclimb.drug.controller;
/**
* 账单信息相关的controller
*/
@Controller
@RequestMapping(value = "/billinfo")
public class BillinfoController {
@Autowired
private IBillinfoService billinfoService;
/**
* 转向账单信息页面
*/
@RequestMapping
public String billinfo(){
return "/billinfo";
}
/**
* 分页查询账单信息列表
*/
@RequestMapping(value = "/billinfoQueryPage")
@ResponseBody
public Object billinfoQueryPage(String param, @RequestParam(defaultValue = "1")int pageNum,@RequestParam(defaultValue = "10")int pageSize){
/**
* 转向销售记录编辑页面
*/
@RequestMapping(value = "/saleinfoQueryById")
public String saleinfoQueryById(@RequestParam(name = "id",required = true)Integer id, Model model){
Saleinfo saleinfo = saleinfoService.querySaleinfoById(id);
model.addAttribute("obj",saleinfo);
return "/saleinfoPage";
}
/**
* 修改一个销售记录
*/
@RequestMapping(value = "/saleinfoEdit")
@ResponseBody
public Object saleinfoEdit(Saleinfo saleinfo){
try{
int i = saleinfoService.editSaleinfo(saleinfo);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 删除一个销售记录
*/
@RequestMapping(value = "/saleinfoDelById")
@ResponseBody
public Object saleinfoDelById(Integer id){
try{
int i = saleinfoService.delSaleinfoById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
}
/**
* 收到退货相关的controller
*/
@Controller
@RequestMapping(value = "/returngoods")
public class ReturngoodsController {
@Autowired
private IReturngoodsService returngoodsService;
/**
* 转向收到退货页面
*/
@RequestMapping
public String returngoods(){
return "/returngoods";
}
/**
* 分页查询收到退货列表
*/
@RequestMapping(value = "/returngoodsQueryPage")
@ResponseBody
public Object returngoodsQueryPage(String param, @RequestParam(defaultValue = "1")int pageNum,@RequestParam(defaultValue = "10")int pageSize){
try{
IPage<Returngoods> iPage = returngoodsService.selectReturngoodsPage(pageNum,pageSize,param);
return ResultMapUtil.getHashMapMysqlPage(iPage);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 转向收到退货新增页面
*/
@RequestMapping(value = "/returngoodsPage")
public String returngoodsPage(){
return "/returngoodsPage";
}
*/
@Controller
@RequestMapping(value = "/saleinfo")
public class SaleinfoController {
@Autowired
private ISaleinfoService saleinfoService;
/**
* 转向销售记录页面
*/
@RequestMapping
public String saleinfo(){
return "/saleinfo";
}
/**
* 分页查询销售记录列表
*/
@RequestMapping(value = "/saleinfoQueryPage")
@ResponseBody
public Object saleinfoQueryPage(String param, @RequestParam(defaultValue = "1")int pageNum,@RequestParam(defaultValue = "10")int pageSize){
try{
IPage<Saleinfo> iPage = saleinfoService.selectSaleinfoPage(pageNum,pageSize,param);
return ResultMapUtil.getHashMapMysqlPage(iPage);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 转向销售记录新增页面
*/
@RequestMapping(value = "/saleinfoPage")
public String saleinfoPage(){
return "/saleinfoPage";
}
/**
* 添加一个销售记录
*/
@RequestMapping(value = "/saleinfoAdd")
@ResponseBody
public Object saleinfoAdd(Saleinfo saleinfo){
try{
int i = saleinfoService.addSaleinfo(saleinfo);
return ResultMapUtil.getHashMapSave(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
try{
int i = supplierService.delSupplierById(id);
return ResultMapUtil.getHashMapDel(i);
} catch (Exception e){
return ResultMapUtil.getHashMapException(e);
}
}
/**
* 获取所有供应商
*/
@RequestMapping(value = "/supplierList")
@ResponseBody
public Object supplierList(){
List<Supplier> supplierList = supplierService.querySupplierList();
return ResultMapUtil.getHashMapList(supplierList);
}
}
package com.javaclimb.drug.controller;