devbox
小小林熬夜学编程
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

springboot医药进销存管理系统

作者：小小林熬夜学编程 | 2024-03-26 11:28:48

赞

踩

springboot医药进销存管理系统

 博主介绍：✌在职Java研发工程师、专注于程序设计、源码分享、技术交流、专注于Java技术领域和毕业设计✌
温馨提示：文末有 CSDN 平台官方提供的老师 Wechat / QQ 名片 :)

项目名称

springboot医药进销存管理系统

演示视频

springboot医药进销存管理系统_哔哩哔哩_bilibili

系统介绍

# 037springboot医药进销存系统

#### 介绍
```
医药进销存系统，主要分两种角色：员工、客户。本系统具有进销存系统的通用性，可以修改为其它进销存系统，如家电进销存、手机进销存等；
员工登录后主要功能模块有：
我的面板：个人信息、修改信息、修改密码；
员工管理：员工添加、员工查询；
药品管理：药品类别添加、药品类别查询、药品添加、药品查询；
客户管理：客户查询；
供货商管理：供货商添加、供货商查询；
账单管理：进货添加、进货查询、退货账单、销售账单查询；
客户登录后主要功能模块有：
我的面板：个人信息、修改信息、修改密码；
购买药品：药品展示、已购药品；
```

#### 环境需要
```
1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；
5.是否Maven项目: 是；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目
6.数据库：MySql 5.7版本；
```

#### 系统框架
```
1.后端：SpringBoot
2.前端：HTML+Echarts+JQuery
```

#### 使用说明
```
1. 使用IDEA/Eclipse/MyEclipse导入后端项目源码；
2. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
3. 运行项目前，需要配置好MqSQL数据库，在application.properties中修改数据库对应的配置文件；
4. 运行成功后，在浏览器中访问：http://localhost:8888
5. 客户和员工对应数据库表t_customers和t_employees表，用户名是手机号，密码也是对应的手机号
客户账号：15133480838 密码：15133480838
员工账号：15133330551 密码：15133330551

系统截图

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 
5.数据库：MySql 5.7版本；
6.是否Maven项目：否；

技术栈

1. 后端：Spring+SpringMVC+Mybatis
2. 前端：JSP+CSS+JavaScript+jQuery

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
3. 将项目中springmvc-servlet.xml配置文件中的数据库配置改为自己的配置;
4. 运行项目，在浏览器中输入http://localhost:8080/ 登录

POM依赖:

  1. <dependencies>
  2.      
  3.     <dependency>
  4.       <groupId>org.springframework.boot</groupId>
  5.       <artifactId>spring-boot-starter-data-jpa</artifactId>
  6.     </dependency>
  7.     <dependency>
  8.       <groupId>mysql</groupId>
  9.       <artifactId>mysql-connector-java</artifactId>
  10.       <scope>runtime</scope>
  11.     </dependency>
  12.      
  13.     <dependency>
  14.       <groupId>org.springframework.boot</groupId>
  15.       <artifactId>spring-boot-starter-freemarker</artifactId>
  16.     </dependency>
  17.     <dependency>
  18.       <groupId>org.springframework.boot</groupId>
  19.       <artifactId>spring-boot-starter-web</artifactId>
  20.     </dependency>
  21.     
  22.     <dependency>
  23.       <groupId>org.springframework.boot</groupId>
  24.       <artifactId>spring-boot-starter-test</artifactId>
  25.       <scope>test</scope>
  26.     </dependency>
  27.     
  28.     <dependency>
  29.         <groupId>org.apache.commons</groupId>
  30.         <artifactId>commons-lang3</artifactId>
  31.     </dependency>
  32.     <dependency>
  33. 	    <groupId>commons-codec</groupId>
  34. 	    <artifactId>commons-codec</artifactId>
  35. 	</dependency>
  36.     
  37.     <dependency>
  38.         <groupId>com.alibaba</groupId>
  39.         <artifactId>fastjson</artifactId>
  40.         <version>1.2.31</version>
  41.     </dependency>
  42.     
  43.     <dependency>
  44. 		<groupId>org.springframework.boot</groupId>
  45. 		<artifactId>spring-boot-devtools</artifactId>
  46. 		<!-- optional=true, 依赖不会传递, 该项目依赖devtools; 
  47. 			之后依赖boot项目的项目如果想要使用devtools, 需要重新引入 -->
  48. 		<optional>true</optional>
  49. 	</dependency>
  50. 	
  51. 	<dependency>
  52.       <groupId>org.springframework.boot</groupId>
  53.       <artifactId>spring-boot-starter-websocket</artifactId>
  54.       <version>2.1.3.RELEASE</version><!--$NO-MVN-MAN-VER$-->
  55.     </dependency>
  56. 	
  57. 	 <!-- webSocket 开始-->
  58. 	<dependency>
  59. 	    <groupId>javax.websocket</groupId>
  60. 	    <artifactId>javax.websocket-api</artifactId>
  61. 	    <scope>provided</scope>
  62. 	</dependency>
  63. 	 
  64. 	<dependency>
  65. 	    <groupId>javax</groupId>
  66. 	    <artifactId>javaee-api</artifactId>
  67. 	    <version>8.0</version>
  68. 	    <scope>provided</scope>
  69. 	</dependency>
  70. 	<!-- webSocket 结束-->
  71. 	
  72.   </dependencies>

管理员管理控制层:

  1.  
  2. package com.sxl.controller.admin;
  3.  
  4. import java.util.List;
  5. import java.util.Map;
  6.  
  7. import javax.servlet.http.HttpServletRequest;
  8.  
  9. import org.springframework.http.ResponseEntity;
  10. import org.springframework.stereotype.Controller;
  11. import org.springframework.ui.Model;
  12. import org.springframework.web.bind.annotation.RequestMapping;
  13.  
  14. import com.sxl.controller.MyController;
  15.  
  16. @Controller("adminController")
  17. @RequestMapping(value = "/admin")
  18. public class AdminController extends MyController {
  19. 	
  20.  
  21. 	@RequestMapping(value = "/index")
  22. 	public String frame(Model model, HttpServletRequest request)throws Exception {
  23. 		return "/admin/index";
  24. 	}
  25. 	
  26. 	@RequestMapping(value = "/main")
  27. 	public String main(Model model, HttpServletRequest request)throws Exception {
  28. 		return "/admin/main";
  29. 	}
  30. 	
  31. 	@RequestMapping(value = "/tj1")
  32. 	public String tj1(Model model, HttpServletRequest request)throws Exception {
  33. 		String sql="select DATE_FORMAT(insertDate,'%Y-%m-%d') dates,sum(allPrice) price from t_order order by DATE_FORMAT(insertDate,'%Y-%m-%d')  desc";
  34. 		List<Map> list = db.queryForList(sql);
  35. 		model.addAttribute("list", list);
  36. 		System.out.println(list);
  37. 		return "/admin/tj/tj1";
  38. 	}
  39. 	
  40. 	
  41. 	@RequestMapping(value = "/password")
  42. 	public String password(Model model, HttpServletRequest request)throws Exception {
  43. 		return "/admin/password";
  44. 	}
  45. 	
  46. 	
  47. 	@RequestMapping(value = "/changePassword")
  48. 	public ResponseEntity<String> loginSave(Model model,HttpServletRequest request,String oldPassword,String newPassword) throws Exception {
  49. 		Map admin = getAdmin(request);
  50. 		if(oldPassword.equals(admin.get("password").toString())){
  51. 			String sql="update t_admin set password=? where id=?";
  52. 			db.update(sql, new Object[]{newPassword,admin.get("id")});
  53. 			return renderData(true,"1",null);
  54. 		}else{
  55. 			return renderData(false,"1",null);
  56. 		}
  57. 	}
  58. }

修改密码业务逻辑:

  1.  
  2. package com.sxl.controller.admin;
  3.  
  4. import java.util.Map;
  5.  
  6. import javax.servlet.http.HttpServletRequest;
  7.  
  8. import org.springframework.http.ResponseEntity;
  9. import org.springframework.stereotype.Controller;
  10. import org.springframework.ui.Model;
  11. import org.springframework.web.bind.annotation.RequestMapping;
  12.  
  13. import com.sxl.controller.MyController;
  14.  
  15. @Controller("userController")
  16. @RequestMapping(value = "/user")
  17. public class UserController extends MyController {
  18. 	
  19.  
  20. 	@RequestMapping(value = "/index")
  21. 	public String frame(Model model, HttpServletRequest request)throws Exception {
  22. 		return "/user/index";
  23. 	}
  24. 	
  25. 	@RequestMapping(value = "/main")
  26. 	public String main(Model model, HttpServletRequest request)throws Exception {
  27. 		return "/user/main";
  28. 	}
  29. 	
  30. 	
  31. 	@RequestMapping(value = "/password")
  32. 	public String password(Model model, HttpServletRequest request)throws Exception {
  33. 		return "/user/password";
  34. 	}
  35. 	
  36. 	
  37. 	@RequestMapping(value = "/changePassword")
  38. 	public ResponseEntity<String> loginSave(Model model,HttpServletRequest request,String oldPassword,String newPassword) throws Exception {
  39. 		Map user = getUser(request);
  40. 		if(oldPassword.equals(user.get("password").toString())){
  41. 			String sql="update t_user set password=? where id=?";
  42. 			db.update(sql, new Object[]{newPassword,user.get("id")});
  43. 			return renderData(true,"1",null);
  44. 		}else{
  45. 			return renderData(false,"1",null);
  46. 		}
  47. 	}
  48. 	@RequestMapping(value = "/mine")
  49. 	public String mine(Model model, HttpServletRequest request)throws Exception {
  50. Map user =getUser(request);Map map = db.queryForMap("select * from t_user where id=?",new Object[]{user.get("id")});model.addAttribute("map", map);		return "/user/mine";
  51. 	}
  52. 	
  53. 	
  54.  
  55. 	@RequestMapping(value = "/mineSave")
  56. 	public ResponseEntity<String> mineSave(Model model,HttpServletRequest request,Long id
  57. 		,String username,String password,String name,String gh,String mobile) throws Exception{
  58. 		int result = 0;
  59. 			String sql="update t_user set name=?,gh=?,mobile=? where id=?";
  60. 			result = db.update(sql, new Object[]{name,gh,mobile,id});
  61. 		if(result==1){
  62. 			return renderData(true,"操作成功",null);
  63. 		}else{
  64. 			return renderData(false,"操作失败",null);
  65. 		}
  66. 	}
  67. 	}

通用管理模块:

  1. package com.sxl.controller;
  2.  
  3.  
  4. import java.nio.charset.Charset;
  5. import java.util.Locale;
  6. import java.util.ResourceBundle;
  7.  
  8. import javax.servlet.http.HttpServletRequest;
  9.  
  10. import org.apache.commons.lang.StringUtils;
  11. import org.springframework.beans.factory.annotation.Autowired;
  12. import org.springframework.http.HttpHeaders;
  13. import org.springframework.http.HttpStatus;
  14. import org.springframework.http.MediaType;
  15. import org.springframework.http.ResponseEntity;
  16.  
  17. import com.sxl.util.JacksonJsonUtil;
  18. import com.sxl.util.StringUtil;
  19. import com.sxl.util.SystemProperties;
  20.  
  21.  
  22. public class BaseController {
  23. 	public static final Long EXPIRES_IN = 1000 * 3600 * 24 * 1L;// 1天
  24.  
  25. 	@Autowired
  26. 	private SystemProperties systemProperties;
  27.  
  28. 	/**
  29. 	 * 获得配置文件内容
  30. 	 */
  31. 	public String getConfig(String key) {
  32. 		return systemProperties.getProperties(key);
  33. 	}
  34.  
  35. 	/**
  36. 	 * 返回服务器地址 like http://192.168.1.1:8441/UUBean/
  37. 	 */
  38. 	public String getHostUrl(HttpServletRequest request) {
  39. 		String hostName = request.getServerName();
  40. 		Integer hostPort = request.getServerPort();
  41. 		String path = request.getContextPath();
  42.  
  43. 		if (hostPort == 80) {
  44. 			return "http://" + hostName + path + "/";
  45. 		} else {
  46. 			return "http://" + hostName + ":" + hostPort + path + "/";
  47. 		}
  48. 	}
  49.  
  50. 	/***
  51. 	 * 获取当前的website路径 String
  52. 	 */
  53. 	public static String getWebSite(HttpServletRequest request) {
  54. 		String returnUrl = request.getScheme() + "://"
  55. 				+ request.getServerName();
  56.  
  57. 		if (request.getServerPort() != 80) {
  58. 			returnUrl += ":" + request.getServerPort();
  59. 		}
  60.  
  61. 		returnUrl += request.getContextPath();
  62.  
  63. 		return returnUrl;
  64. 	}
  65.  
  66.  
  67.  
  68. 	/**
  69. 	 * 初始化HTTP头.
  70. 	 * 
  71. 	 * @return HttpHeaders
  72. 	 */
  73. 	public HttpHeaders initHttpHeaders() {
  74. 		HttpHeaders headers = new HttpHeaders();
  75. 		MediaType mediaType = new MediaType("text", "html",
  76. 				Charset.forName("utf-8"));
  77. 		headers.setContentType(mediaType);
  78. 		return headers;
  79. 	}
  80.  
  81. 	/**
  82. 	 * 返回 信息数据
  83. 	 * 
  84. 	 * @param status
  85. 	 * @param msg
  86. 	 * @return
  87. 	 */
  88. 	public ResponseEntity<String> renderMsg(Boolean status, String msg) {
  89. 		if (StringUtils.isEmpty(msg)) {
  90. 			msg = "";
  91. 		}
  92. 		String str = "{\"status\":\"" + status + "\",\"msg\":\"" + msg + "\"}";
  93. 		ResponseEntity<String> responseEntity = new ResponseEntity<String>(str,
  94. 				initHttpHeaders(), HttpStatus.OK);
  95. 		return responseEntity;
  96. 	}
  97.  
  98. 	/**
  99. 	 * 返回obj数据
  100. 	 * 
  101. 	 * @param status
  102. 	 * @param msg
  103. 	 * @param obj
  104. 	 * @return
  105. 	 */
  106. 	public ResponseEntity<String> renderData(Boolean status, String msg,
  107. 			Object obj) {
  108. 		if (StringUtils.isEmpty(msg)) {
  109. 			msg = "";
  110. 		}
  111. 		StringBuffer sb = new StringBuffer();
  112. 		sb.append("{");
  113. 		sb.append("\"status\":\"" + status + "\",\"msg\":\"" + msg + "\",");
  114. 		sb.append("\"data\":" + JacksonJsonUtil.toJson(obj) + "");
  115. 		sb.append("}");
  116.  
  117. 		ResponseEntity<String> responseEntity = new ResponseEntity<String>(
  118. 				sb.toString(), initHttpHeaders(), HttpStatus.OK);
  119. 		return responseEntity;
  120. 	}
  121.  
  122.  
  123. 	/***
  124. 	 * 获取IP（如果是多级代理，则得到的是一串IP值）
  125. 	 */
  126. 	public static String getIpAddr(HttpServletRequest request) {
  127. 		String ip = request.getHeader("x-forwarded-for");
  128. 		if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
  129. 			ip = request.getHeader("Proxy-Client-IP");
  130. 		}
  131.  
  132. 		if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
  133. 			ip = request.getHeader("WL-Proxy-Client-IP");
  134. 		}
  135.  
  136. 		if (ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
  137. 			ip = request.getRemoteAddr();
  138. 		}
  139.  
  140. 		if (ip != null && ip.length() > 0) {
  141. 			String[] ips = ip.split(",");
  142. 			for (int i = 0; i < ips.length; i++) {
  143. 				if (!"unknown".equalsIgnoreCase(ips[i])) {
  144. 					ip = ips[i];
  145. 					break;
  146. 				}
  147. 			}
  148. 		}
  149.  
  150. 		return ip;
  151. 	}
  152.  
  153. 	/**
  154. 	 * 国际化获得语言内容
  155. 	 * 
  156. 	 * @param key
  157. 	 *            语言key
  158. 	 * @param args
  159. 	 * @param argsSplit
  160. 	 * @param defaultMessage
  161. 	 * @param locale
  162. 	 * @return
  163. 	 */
  164. 	public static String getLanguage(String key, String args, String argsSplit,
  165. 			String defaultMessage, String locale) {
  166. 		String language = "zh";
  167. 		String contry = "cn";
  168. 		String returnValue = defaultMessage;
  169.  
  170. 		if (!StringUtil.isEmpty(locale)) {
  171. 			try {
  172. 				String[] localeArray = locale.split("_");
  173. 				language = localeArray[0];
  174. 				contry = localeArray[1];
  175. 			} catch (Exception e) {
  176. 			}
  177. 		}
  178.  
  179. 		try {
  180. 			ResourceBundle resource = ResourceBundle.getBundle("lang.resource",
  181. 					new Locale(language, contry));
  182. 			returnValue = resource.getString(key);
  183. 			if (!StringUtil.isEmpty(args)) {
  184. 				String[] argsArray = args.split(argsSplit);
  185. 				for (int i = 0; i < argsArray.length; i++) {
  186. 					returnValue = returnValue.replace("{" + i + "}",
  187. 							argsArray[i]);
  188. 				}
  189. 			}
  190. 		} catch (Exception e) {
  191. 		}
  192.  
  193. 		return returnValue;
  194. 	}
  195. }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小小林熬夜学编程/article/detail/316933
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号