基于javaweb和mysql的ssm物流管理系统(java+ssm+jsp+jquery+easyui+mysql)

m0_70122726

369人浏览 · 2025-11-24 22:17:45

m0_70122726 · 2025-11-24 22:17:45 发布

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

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

功能说明

基于javaweb的SSM物流管理系统(java+ssm+jsp+jquery+easyui+mysql)


管理员

admin   123456

员工

tom	123456

jack	123456

客户

zhangsan	123456

lisi	123456

SSM的物流管理系统

系统主要分为三种用户角色，分别是管理员、员工以及客户，其具体功能如下：

管理员：个人信息、员工管理、客户管理、反馈信息、基础信息、货物信息、货物运输、统计信息、系统管理

员工：个人信息、客户管理、反馈信息、基础信息、货物信息、货物运输

客户：个人信息、配送范围、货物信息、货物运输、反馈信息

后台框架：Spring、SpringMVC、MyBatis

UI界面：JSP、jQuery、EasyUI

数据库：MySQL


		headCell = hssfRow.createCell(13);
		headCell.setCellValue("标志1");
		headCell.setCellStyle(cellStyle);

		headCell = hssfRow.createCell(14);
		headCell.setCellValue("备注2");
		headCell.setCellStyle(cellStyle);

		headCell = hssfRow.createCell(15);
		headCell.setCellValue("权限");
		headCell.setCellStyle(cellStyle);

		headCell = hssfRow.createCell(16);
		headCell.setCellValue("部门");
		headCell.setCellStyle(cellStyle);

		// 添加数据内容
		for (int i = 0; i < str.length; i++) {
			hssfRow = sheet.createRow((int) i + 1);
			Spchu spchu = spchuService.getSpchu(Integer.parseInt(str[i]));

			// 创建单元格，并设置值
			HSSFCell cell = hssfRow.createCell(0);
			cell.setCellValue(spchu.getSpchuId());
			cell.setCellStyle(cellStyle);

			cell = hssfRow.createCell(1);
			cell.setCellValue(spchu.getSpchuName());
			cell.setCellStyle(cellStyle);

			cell = hssfRow.createCell(7);
			cell.setCellValue(spchu.getSpchuMark());
			cell.setCellStyle(cellStyle);

			cell = hssfRow.createCell(16);
			cell.setCellValue(spchu.getSptypeName());
			cell.setCellStyle(cellStyle);
		}

		// 保存Excel文件
		try {
			Date date = new Date();
			String strdate = DateUtil.formatDate(date, "yyyyMMddhhmmss");
			OutputStream outputStream = new FileOutputStream("D:/spchu"
					+ strdate + ".xls");
			workbook.write(outputStream);
			outputStream.close();
			result.put("success", "true");
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

		Integer zongshu = 0;
		try {
			uxtypes = uxtypeService.queryUxtypes(null, 0,0);
			for(int i=0;i<uxtypes.size();i++){
				uxtypeIds.add(uxtypes.get(i).getUxtypeId());
				uxtypeNames.add(uxtypes.get(i).getUxtypeName());
			}
			for(int i=0;i<uxtypeIds.size();i++){
				Integer uzhanneiZongshu = 0;
				uzhannei.setUxtypeId(uxtypeIds.get(i));
				uzhanneis = uzhanneiService.queryUzhanneis(uzhannei, 0, 0, sdate, edate);
				for(int j=0;j<uzhanneis.size();j++){
					uzhanneiZongshu = uzhanneiZongshu + uzhanneis.size();
				}
				zongshu = zongshu + uzhanneiZongshu;
				uzhanneiZongshus.add(uzhanneiZongshu);
			}
			
			HttpSession session = request.getSession();
			session.setAttribute("uxtypeNames", uxtypeNames);
			session.setAttribute("uzhanneiZongshus", uzhanneiZongshus);
			session.setAttribute("zongshu", zongshu);
			response.sendRedirect("admin/uzhanneitongji.jsp");	
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/shangchuanUzhannei")
	public void shangchuanUzhannei(HttpServletRequest request, HttpServletResponse response,MultipartFile uploadFile)
			throws Exception {
		try {
			String uzhanneiId = (String) request.getParameter("uzhanneiId");
			String directory = "/file";
			String targetDirectory = request.getSession().getServletContext().getRealPath(directory);
	        String fileName = uploadFile.getOriginalFilename();  
			File dir = new File(targetDirectory,fileName);        
	        if(!dir.exists()){
	            dir.mkdirs();
	        }

		if (StringUtil.isNotEmpty(uxinxiType)) {
			uxinxi.setUxinxiType(Integer.parseInt(uxinxiType));
		}
		if (StringUtil.isNotEmpty(uxinxiType1)) {
			uxinxi.setUxinxiType1(Integer.parseInt(uxinxiType1));
		}
		if (StringUtil.isNotEmpty(uxtypeId)) {
			uxinxi.setUxtypeId(Integer.parseInt(uxtypeId));
			Uxtype uxtype = new Uxtype();
			uxtype = uxtypeService.getUxtype(Integer.parseInt(uxtypeId));
			uxinxi.setUxtypeName(uxtype.getUxtypeName());
		}
		if (StringUtil.isNotEmpty(userId)) {
			uxinxi.setUserId(Integer.parseInt(userId));
			User user = new User();
			user = userService.getUser(Integer.parseInt(userId));
			uxinxi.setUserName(user.getUserName());
			uxinxi.setBumenId(user.getBumenId());
			uxinxi.setBumenName(user.getBumenName());
		}
		try {
			if (StringUtil.isNotEmpty(uxinxiId)) {
				uxinxiService.modifyUxinxi(uxinxi);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			} else {
				Date date = new Date();
				uxinxi.setUxinxiDate(date);
				uxinxiService.save(uxinxi);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/deleteUxinxi")
	public void deleteUxinxi(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		JSONObject result = new JSONObject();
		String delIds = (String) request.getParameter("delIds");
		try {
			String str[] = delIds.split(",");
			for (int i = 0; i < str.length; i++) {

        response.addHeader("Content-Disposition", "attachment;filename=" + filename);    
        //1.设置文件ContentType类型，这样设置，会自动判断下载文件类型    
        response.setContentType("multipart/form-data");   
        BufferedOutputStream out = new BufferedOutputStream(response.getOutputStream());  
        int len = 0;  
        while((len = bis.read()) != -1){  
            out.write(len);  
            out.flush();  
        }  
        out.close();
	}

	@RequestMapping("/daoruUyijian")
	public void daoruUyijian(HttpServletRequest request, HttpServletResponse response,MultipartFile uploadFile)
			throws Exception {
		try {
			String directory = "/file";
			String targetDirectory = request.getSession().getServletContext().getRealPath(directory);
	        String fileName = uploadFile.getOriginalFilename();  
			File dir = new File(targetDirectory,fileName);        
	        if(!dir.exists()){
	            dir.mkdirs();
	        }
	        //MultipartFile自带的解析方法
	        uploadFile.transferTo(dir);
			excelFile = new FileInputStream(dir);
			Workbook wb = new HSSFWorkbook(excelFile);
			Sheet sheet = wb.getSheetAt(0);
			int rowNum = sheet.getLastRowNum() + 1;
			for (int i = 1; i < rowNum; i++) {
				Uyijian uyijian = new Uyijian();
				Row row = sheet.getRow(i);
				int cellNum = row.getLastCellNum();
				for (int j = 0; j < cellNum; j++) {
					Cell cell = row.getCell(j);
					String cellValue = null;
					switch (cell.getCellType()) { // 判断excel单元格内容的格式，并对其进行转换，以便插入数据库
					case 0:
						cellValue = String.valueOf((int) cell
								.getNumericCellValue());
						break;
					case 1:
						cellValue = cell.getStringCellValue();
						break;
					case 2:
						cellValue = cell.getStringCellValue();
						break;
					}


@Controller
public class SpgysAction {
	@Autowired
	private SpgysService spgysService;

	@RequestMapping("/getSpgyss")
	public void getSpgyss(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String page = (String) request.getParameter("page");
		String rows = (String) request.getParameter("rows");
		String spgysName = (String) request.getParameter("spgysName");
		String spgysId = (String) request.getParameter("spgysId");
		String spgysType = (String) request.getParameter("spgysType");
		String spgysType1 = (String) request.getParameter("spgysType1");
		String sdate = (String) request.getParameter("sdate");
		String edate = (String) request.getParameter("edate");
		PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
		Spgys spgys = new Spgys();
		try {
			if (StringUtil.isNotEmpty(spgysName)) {
				spgys.setSpgysName(spgysName);
			}
			if (StringUtil.isNotEmpty(spgysId)) {
				spgys.setSpgysId(Integer.parseInt(spgysId));
			}
			if (StringUtil.isNotEmpty(spgysType)) {
				spgys.setSpgysType(Integer.parseInt(spgysType));
			}
			if (StringUtil.isNotEmpty(spgysType1)) {
				spgys.setSpgysType1(Integer.parseInt(spgysType1));
			}
			JSONArray jsonArray = JSONArray.fromObject(spgysService.querySpgyss(spgys, pageBean.getStart(), pageBean.getRows(), sdate, edate));
			JSONObject result = new JSONObject();
			int total = spgysService.querySpgyss(spgys, 0, 0, sdate, edate).size();
			result.put("rows", jsonArray);
			result.put("total", total);

				spjin.setShangpinId(Integer.parseInt(shangpinId));
			}
			if (StringUtil.isNotEmpty(spcangkuId)) {
				spjin.setSpcangkuId(Integer.parseInt(spcangkuId));
			}
			if (StringUtil.isNotEmpty(spgysId)) {
				spjin.setSpgysId(Integer.parseInt(spgysId));
			}
			JSONArray jsonArray = JSONArray.fromObject(spjinService.querySpjins(
					spjin, pageBean.getStart(), pageBean.getRows(), sdate, edate));
			JSONObject result = new JSONObject();
			int total = spjinService.querySpjins(spjin, 0, 0, sdate, edate).size();
			result.put("rows", jsonArray);
			result.put("total", total);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/addSpjin")
	public void addSpjin(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		JSONObject result = new JSONObject();
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String spjinName = (String) request.getParameter("spjinName");
		String spjinMark = (String) request.getParameter("spjinMark");
		String spjinMark1 = (String) request.getParameter("spjinMark1");
		String spjinMark2 = (String) request.getParameter("spjinMark2");
		String spjinMark3 = (String) request.getParameter("spjinMark3");
		String spjinZong = (String) request.getParameter("spjinZong");
		String spjinDate = (String) request.getParameter("spjinDate");
		String spjinDate1 = (String) request.getParameter("spjinDate1");
		String spjinType = (String) request.getParameter("spjinType");
		String spjinType1 = (String) request.getParameter("spjinType1");
		String sptypeId = (String) request.getParameter("sptypeId");
		String userId = (String) request.getParameter("userId");
		String spjinJine = (String) request.getParameter("spjinJine");
		String shangpinId = (String) request.getParameter("shangpinId");
		String spgysId = (String) request.getParameter("spgysId");
		String spcangkuId = (String) request.getParameter("spcangkuId");

			JSONObject result = new JSONObject();
			int total = utaolunService.queryUtaoluns(utaolun, 0, 0, sdate, edate).size();
			result.put("rows", jsonArray);
			result.put("total", total);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/addUtaolun")
	public void addUtaolun(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		JSONObject result = new JSONObject();
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String utaolunName = (String) request.getParameter("utaolunName");
		String utaolunMark = (String) request.getParameter("utaolunMark");
		String utaolunMark1 = (String) request.getParameter("utaolunMark1");
		String utaolunMark2 = (String) request.getParameter("utaolunMark2");
		String utaolunDate = (String) request.getParameter("utaolunDate");
		String utaolunDate1 = (String) request.getParameter("utaolunDate1");
		String utaolunType = (String) request.getParameter("utaolunType");
		String utaolunType1 = (String) request.getParameter("utaolunType1");
		String userId = (String) request.getParameter("userId");
		String yonghuId = (String) request.getParameter("yonghuId");
		String utaolunId = (String) request.getParameter("utaolunId");
		Utaolun utaolun = new Utaolun();

		if (StringUtil.isNotEmpty(utaolunId)) {
			utaolun = utaolunService.getUtaolun(Integer.parseInt(utaolunId));
		}
		if (StringUtil.isNotEmpty(utaolunName)) {
			utaolun.setUtaolunName(utaolunName);
		}
		if (StringUtil.isNotEmpty(utaolunMark)) {
			utaolun.setUtaolunMark(utaolunMark);
		}
		if (StringUtil.isNotEmpty(utaolunMark1)) {
			utaolun.setUtaolunMark1(utaolunMark1);
		}
		if (StringUtil.isNotEmpty(utaolunMark2)) {
			utaolun.setUtaolunMark2(utaolunMark2);
		}
		if (StringUtil.isNotEmpty(utaolunDate)) {
			utaolun.setUtaolunDate(DateUtil.formatString(utaolunDate,
					"yyyy-MM-dd hh:mm:ss"));
		}
		if (StringUtil.isNotEmpty(utaolunDate1)) {
			utaolun.setUtaolunDate1(DateUtil.formatString(utaolunDate1,
					"yyyy-MM-dd hh:mm:ss"));

		response.setCharacterEncoding("UTF-8");
		String userName = (String) request.getParameter("userName");
		String userPassword = (String) request.getParameter("userPassword");
		String userAge = (String) request.getParameter("userAge");
		String userXingming = (String) request.getParameter("userXingming");
		String userSex = (String) request.getParameter("userSex");
		String userPhone = (String) request.getParameter("userPhone");
		String userMark1 = (String) request.getParameter("userMark1");
		String userMark2 = (String) request.getParameter("userMark2");
		String userMark3 = (String) request.getParameter("userMark3");
		String userMark4 = (String) request.getParameter("userMark4");
		String userDate1 = (String) request.getParameter("userDate1");
		String userDate2 = (String) request.getParameter("userDate2");
		String userType1 = (String) request.getParameter("userType1");
		String userType2 = (String) request.getParameter("userType2");
		String roleId = (String) request.getParameter("roleId");
		String bumenId = (String) request.getParameter("bumenId");
		String userId = (String) request.getParameter("userId");
		User user = new User();

		if (StringUtil.isNotEmpty(userId)) {
			user = userService.getUser(Integer.parseInt(userId));
		}
		if (StringUtil.isNotEmpty(userName)) {
			user.setUserName(userName);
		}
		if (StringUtil.isNotEmpty(userPassword)) {
			user.setUserPassword(userPassword);
		}
		if (StringUtil.isNotEmpty(userAge)) {
			user.setUserAge(Integer.parseInt(userAge));
		}
		if (StringUtil.isNotEmpty(userXingming)) {
			user.setUserXingming(userXingming);
		}
		if (StringUtil.isNotEmpty(userSex)) {
			user.setUserSex(Integer.parseInt(userSex));
		}
		if (StringUtil.isNotEmpty(userPhone)) {
			user.setUserPhone(userPhone);
		}

			if (StringUtil.isNotEmpty(bumenMark1)) {
				bumen.setBumenMark1(bumenMark1);
			}
			if (StringUtil.isNotEmpty(bumenMark2)) {
				bumen.setBumenMark2(Integer.parseInt(bumenMark2));
			}

			if (StringUtil.isNotEmpty(bumenId)) {
				bumenService.modifyBumen(bumen);
			} else {
				bumenService.save(bumen);
			}
			result.put("success", "true");

			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/deleteBumen")
	public void deleteBumen(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		try {
			String delIds = (String) request.getParameter("delIds");
			System.out.println("delIds = " + delIds);
			JSONObject result = new JSONObject();
			String str[] = delIds.split(",");
			for (int i = 0; i < str.length; i++) {
				bumenService.deleteBumen(Integer.parseInt(str[i]));
			}
			result.put("success", "true");
			result.put("delNums", str.length);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/bumenComboList")
	public void bumenComboList(HttpServletRequest request, HttpServletResponse response)
			throws Exception {

			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String uzhanneiId = (String) request.getParameter("uzhanneiId");
		String uxtypeId = (String) request.getParameter("uxtypeId");
		String uzhanneiType = (String) request.getParameter("uzhanneiType");
		String uzhanneiType1 = (String) request.getParameter("uzhanneiType1");
		String userId = (String) request.getParameter("userId");
		String bumenId = (String) request.getParameter("bumenId");
		Uzhannei uzhannei = new Uzhannei();
		if (StringUtil.isNotEmpty(uzhanneiId)) {
			uzhannei.setUzhanneiId(Integer.parseInt(uzhanneiId));
		}
		if (StringUtil.isNotEmpty(uxtypeId)) {
			uzhannei.setUxtypeId(Integer.parseInt(uxtypeId));
		}
		if (StringUtil.isNotEmpty(uzhanneiType)) {
			uzhannei.setUzhanneiType(Integer.parseInt(uzhanneiType));
		}
		if (StringUtil.isNotEmpty(uzhanneiType1)) {
			uzhannei.setUzhanneiType1(Integer.parseInt(uzhanneiType1));
		}
		if (StringUtil.isNotEmpty(userId)) {
			uzhannei.setUserId(Integer.parseInt(userId));
		}
		if (StringUtil.isNotEmpty(bumenId)) {
			uzhannei.setBumenId(Integer.parseInt(bumenId));
		}
		try {
			JSONArray jsonArray = new JSONArray();
			JSONObject jsonObject = new JSONObject();
			jsonObject.put("id", "");
			jsonObject.put("uzhanneiName", "请选择...");
			jsonArray.add(jsonObject);
			jsonArray.addAll(JSONArray.fromObject(uzhanneiService.queryUzhanneis(uzhannei, 0, 0, null, null)));
			ResponseUtil.write(response, jsonArray);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/uzhanneiTongji")
	public void uzhanneiTongji(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String sdate=request.getParameter("sdate");
		String edate=request.getParameter("edate");
		List<Integer> uxtypeIds = new ArrayList<Integer>();
		List<String> uxtypeNames = new ArrayList<String>();
		List<Integer> uzhanneiZongshus = new ArrayList<Integer>();
		List<Uxtype> uxtypes = new ArrayList<Uxtype>();

		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String page = (String) request.getParameter("page");
		String rows = (String) request.getParameter("rows");
		String spchuName = (String) request.getParameter("spchuName");
		String spchuId = (String) request.getParameter("spchuId");
		String sptypeId = (String) request.getParameter("sptypeId");
		String spchuType = (String) request.getParameter("spchuType");
		String spchuType1 = (String) request.getParameter("spchuType1");
		String userId = (String) request.getParameter("userId");
		String bumenId = (String) request.getParameter("bumenId");
		String roleId = (String) request.getParameter("roleId");
		String yhroleId = (String) request.getParameter("yhroleId");
		String yonghuId = (String) request.getParameter("yonghuId");
		String yhbumenId = (String) request.getParameter("yhbumenId");
		String shangpinId = (String) request.getParameter("shangpinId");
		String sdate = (String) request.getParameter("sdate");
		String edate = (String) request.getParameter("edate");
		PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
		Spchu spchu = new Spchu();
		try {
			if (StringUtil.isNotEmpty(spchuName)) {
				spchu.setSpchuName(spchuName);
			}
			if (StringUtil.isNotEmpty(spchuId)) {
				spchu.setSpchuId(Integer.parseInt(spchuId));
			}
			if (StringUtil.isNotEmpty(sptypeId)) {
				spchu.setSptypeId(Integer.parseInt(sptypeId));
			}
			if (StringUtil.isNotEmpty(spchuType)) {
				spchu.setSpchuType(Integer.parseInt(spchuType));
			}
			if (StringUtil.isNotEmpty(spchuType1)) {
				spchu.setSpchuType1(Integer.parseInt(spchuType1));
			}
			if (StringUtil.isNotEmpty(userId)) {
				spchu.setUserId(Integer.parseInt(userId));
			}
			if (StringUtil.isNotEmpty(bumenId)) {
				spchu.setBumenId(Integer.parseInt(bumenId));
			}
			if (StringUtil.isNotEmpty(roleId)) {
				spchu.setRoleId(Integer.parseInt(roleId));
			}


//导入导出

@Controller

				shangpin.setShangpinXiao(0.0);
				shangpin.setShangpinLirun(0.0);
				shangpinService.save(shangpin);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/deleteShangpin")
	public void deleteShangpin(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		JSONObject result = new JSONObject();
		String delIds = (String) request.getParameter("delIds");
		try {
			String str[] = delIds.split(",");
			for (int i = 0; i < str.length; i++) {
				shangpinService.deleteShangpin(Integer.parseInt(str[i]));
			}
			result.put("success", "true");
			result.put("delNums", str.length);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/shangpinComboList")
	public void shangpinComboList(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String shangpinId = (String) request.getParameter("shangpinId");
		String sptypeId = (String) request.getParameter("sptypeId");
		String shangpinType = (String) request.getParameter("shangpinType");
		String shangpinType1 = (String) request.getParameter("shangpinType1");
		String userId = (String) request.getParameter("userId");
		String bumenId = (String) request.getParameter("bumenId");
		Shangpin shangpin = new Shangpin();
		if (StringUtil.isNotEmpty(shangpinId)) {
			shangpin.setShangpinId(Integer.parseInt(shangpinId));

			cell = hssfRow.createCell(7);
			cell.setCellValue(uzhannei.getUzhanneiMark());
			cell.setCellStyle(cellStyle);

			cell = hssfRow.createCell(16);
			cell.setCellValue(uzhannei.getUxtypeName());
			cell.setCellStyle(cellStyle);
		}

		// 保存Excel文件
		try {
			Date date = new Date();
			String strdate = DateUtil.formatDate(date, "yyyyMMddhhmmss");
			OutputStream outputStream = new FileOutputStream("D:/uzhannei"
					+ strdate + ".xls");
			workbook.write(outputStream);
			outputStream.close();
			result.put("success", "true");
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

	public InputStream getExcelFile() {
		return excelFile;
	}
	/***上传导入结束***/

	@RequestMapping("/getUxinxis")
	public void getUxinxis(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String page = (String) request.getParameter("page");
		String rows = (String) request.getParameter("rows");
		String uxinxiName = (String) request.getParameter("uxinxiName");
		String uxinxiId = (String) request.getParameter("uxinxiId");
		String uxtypeId = (String) request.getParameter("uxtypeId");
		String uxinxiType = (String) request.getParameter("uxinxiType");
		String uxinxiType1 = (String) request.getParameter("uxinxiType1");
		String userId = (String) request.getParameter("userId");
		String bumenId = (String) request.getParameter("bumenId");
		String sdate = (String) request.getParameter("sdate");
		String edate = (String) request.getParameter("edate");
		PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
		Uxinxi uxinxi = new Uxinxi();
		try {
			if (StringUtil.isNotEmpty(uxinxiName)) {
				uxinxi.setUxinxiName(uxinxiName);
			}
			if (StringUtil.isNotEmpty(uxinxiId)) {
				uxinxi.setUxinxiId(Integer.parseInt(uxinxiId));
			}
			if (StringUtil.isNotEmpty(uxtypeId)) {
				uxinxi.setUxtypeId(Integer.parseInt(uxtypeId));
			}
			if (StringUtil.isNotEmpty(uxinxiType)) {
				uxinxi.setUxinxiType(Integer.parseInt(uxinxiType));
			}
			if (StringUtil.isNotEmpty(uxinxiType1)) {
				uxinxi.setUxinxiType1(Integer.parseInt(uxinxiType1));
			}
			if (StringUtil.isNotEmpty(userId)) {
				uxinxi.setUserId(Integer.parseInt(userId));

				spjin.setSpcangkuId(Integer.parseInt(spcangkuId));
			}
			if (StringUtil.isNotEmpty(spgysId)) {
				spjin.setSpgysId(Integer.parseInt(spgysId));
			}
			JSONArray jsonArray = JSONArray.fromObject(spjinService.querySpjins(
					spjin, pageBean.getStart(), pageBean.getRows(), sdate, edate));
			JSONObject result = new JSONObject();
			int total = spjinService.querySpjins(spjin, 0, 0, sdate, edate).size();
			result.put("rows", jsonArray);
			result.put("total", total);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/addSpjin")
	public void addSpjin(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		JSONObject result = new JSONObject();
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String spjinName = (String) request.getParameter("spjinName");
		String spjinMark = (String) request.getParameter("spjinMark");
		String spjinMark1 = (String) request.getParameter("spjinMark1");
		String spjinMark2 = (String) request.getParameter("spjinMark2");
		String spjinMark3 = (String) request.getParameter("spjinMark3");
		String spjinZong = (String) request.getParameter("spjinZong");
		String spjinDate = (String) request.getParameter("spjinDate");
		String spjinDate1 = (String) request.getParameter("spjinDate1");
		String spjinType = (String) request.getParameter("spjinType");
		String spjinType1 = (String) request.getParameter("spjinType1");
		String sptypeId = (String) request.getParameter("sptypeId");
		String userId = (String) request.getParameter("userId");
		String spjinJine = (String) request.getParameter("spjinJine");
		String shangpinId = (String) request.getParameter("shangpinId");
		String spgysId = (String) request.getParameter("spgysId");
		String spcangkuId = (String) request.getParameter("spcangkuId");
		String spjinId = (String) request.getParameter("spjinId");
		Spjin spjin = new Spjin();

		if (StringUtil.isNotEmpty(spjinId)) {
			spjin = spjinService.getSpjin(Integer.parseInt(spjinId));
		}
		if (StringUtil.isNotEmpty(spjinName)) {
			spjin.setSpjinName(spjinName);
		}
		if (StringUtil.isNotEmpty(spjinMark)) {
			spjin.setSpjinMark(spjinMark);

			if (StringUtil.isNotEmpty(spcangkuDizhi)) {
				spcangku.setSpcangkuDizhi(spcangkuDizhi);
			}
			if (StringUtil.isNotEmpty(spcangkuDate)) {
				spcangku.setSpcangkuDate(DateUtil.formatString(spcangkuDate,
						"yyyy-MM-dd hh:mm:ss"));
			}
			if (StringUtil.isNotEmpty(spcangkuDate1)) {
				spcangku.setSpcangkuDate1(DateUtil.formatString(spcangkuDate1,
						"yyyy-MM-dd hh:mm:ss"));
			}
			if (StringUtil.isNotEmpty(spcangkuType)) {
				spcangku.setSpcangkuType(Integer.parseInt(spcangkuType));
			}
			if (StringUtil.isNotEmpty(spcangkuType1)) {
				spcangku.setSpcangkuType1(Integer.parseInt(spcangkuType1));
			}

			if (StringUtil.isNotEmpty(spcangkuId)) {
				spcangkuService.modifySpcangku(spcangku);
			} else {
				Date date = new Date();
				spcangku.setSpcangkuDate(date);
				spcangku.setSpcangkuType(0);
				spcangkuService.save(spcangku);
			}
			result.put("success", "true");

			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/deleteSpcangku")
	public void deleteSpcangku(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		try {
			String delIds = (String) request.getParameter("delIds");
			System.out.println("delIds = " + delIds);
			JSONObject result = new JSONObject();
			String str[] = delIds.split(",");
			for (int i = 0; i < str.length; i++) {
				spcangkuService.deleteSpcangku(Integer.parseInt(str[i]));
			}
			result.put("success", "true");
			result.put("delNums", str.length);
			ResponseUtil.write(response, result);

			response.sendRedirect("admin/uxinxitongji.jsp");	
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/shangchuanUxinxi")
	public void shangchuanUxinxi(HttpServletRequest request, HttpServletResponse response,MultipartFile uploadFile)
			throws Exception {
		try {
			String uxinxiId = (String) request.getParameter("uxinxiId");
			String directory = "/file";
			String targetDirectory = request.getSession().getServletContext().getRealPath(directory);
	        String fileName = uploadFile.getOriginalFilename();  
			File dir = new File(targetDirectory,fileName);        
	        if(!dir.exists()){
	            dir.mkdirs();
	        }
	        //MultipartFile自带的解析方法
	        uploadFile.transferTo(dir);

			String shangchuandizhi = "/file" + "/" + fileName;
			String shangchuanname = fileName;
			Uxinxi uxinxi = uxinxiService.getUxinxi(Integer.parseInt(uxinxiId));
			uxinxi.setUxinxiImg(shangchuandizhi);
			uxinxi.setUxinxiImgName(shangchuanname);
			uxinxiService.modifyUxinxi(uxinxi);
			JSONObject result = new JSONObject();
			result.put("success", "true");
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/xiazaiUxinxi")
	public void xiazaiUxinxi(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String filename = (String) request.getParameter("filename");
        //模拟文件，myfile.txt为需要下载的文件  
        String path = request.getSession().getServletContext().getRealPath("file")+"\\"+filename;  
        //获取输入流  
        InputStream bis = new BufferedInputStream(new FileInputStream(new File(path)));
        //转码，免得文件名中文乱码  
        filename = URLEncoder.encode(filename,"UTF-8");  
        //设置文件下载头  
        response.addHeader("Content-Disposition", "attachment;filename=" + filename);    
        //1.设置文件ContentType类型，这样设置，会自动判断下载文件类型

请添加图片描述

快递鸟一站式物流API解决方案

电商企业物流数字化转型必备！快递鸟 API 接口，72 小时快速完成物流系统集成。全流程实战1V1指导，营造开放的API技术生态圈。

更多推荐

短视频电商广告的 AI 视频创作工具有哪些？从素材生产到广告投放的选择参考

麦斯创意定位于 TikTok 跨境电商内容创作场景，覆盖视频混剪、视频翻配、图生视频、商品套图等功能，并接入 Seedance2.0、Veo 等模型能力，帮助运营团队处理不同类型的广告素材需求。麦斯创意支持 AI 视频混剪功能，可以导入本地素材或素材库内容，根据产品信息、视频参数、语种等配置生成短视频版本，适用于需要批量测试广告素材的团队。近年来，AI 视频创作工具逐渐进入电商广告制作流程，从商品