基于javaweb和mysql的ssm医院电子病历管理系统(java+ssm+jsp+easyui+mysql)

Java源码jdk

917人浏览 · 2025-11-29 22:35:44

Java源码jdk · 2025-11-29 22:35:44 发布

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb的SSM医院电子病历管理系统(java+ssm+jsp+easyui+mysql)

项目介绍

本项目分为管理员、医生两种角色。管理员角色包含以下功能：登录页面,个人信息,修改密码,医生管理(职位管理、科室管理、医生管理)、患者管理(患者管理、患者统计)、患者病历(病历类型、病历管理、已删病历)、系统管理(登录日志)等功能。

医生角色包含以下功能：登录页面,个人信息,修改密码,患者管理、患者病历(病历管理、已删病历)等功能。

环境需要

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项目：否

技术栈

后端：Spring+SpringMVC+Mybatis 2. 前端：JSP+css+javascript+jQuery+bootstrap+easyui

使用说明

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

				yonghuService.modifyYonghu(yonghu);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			} else {
				int total = yonghuService.queryYonghus(null, yonghuName, 0, 0, null, null).size();
				if (total==0) {
					yonghuService.save(yonghu);
					request.setAttribute("error", "注册成功，请登录！");
					request.getRequestDispatcher("index.jsp").forward(request,
							response);
				} else {
					request.setAttribute("error", "用户名重复，请重新输入！");
					request.getRequestDispatcher("zhuceyonghu.jsp").forward(request,
							response);
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/deleteYonghu")
	public void deleteYonghu(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++) {
				yonghuService.deleteYonghu(Integer.parseInt(str[i]));
			}
			result.put("success", "true");
			result.put("delNums", str.length);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/yonghuComboList")
	public void yonghuComboList(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String yonghuSex = (String) request.getParameter("yonghuSex");

		response.setCharacterEncoding("UTF-8");
		try {
			JSONObject result = new JSONObject();
			
			String bumenName = (String) request.getParameter("bumenName");
			String bumenMark = (String) request.getParameter("bumenMark");
			String bumenMark1 = (String) request.getParameter("bumenMark1");
			String bumenMark2 = (String) request.getParameter("bumenMark2");
			String bumenId = (String) request.getParameter("bumenId");
			Bumen bumen = new Bumen();
			
			if (StringUtil.isNotEmpty(bumenId)) {
				bumen = bumenService.getBumen(Integer.parseInt(bumenId));
			}
			if (StringUtil.isNotEmpty(bumenName)) {
				bumen.setBumenName(bumenName);
			}
			if (StringUtil.isNotEmpty(bumenMark)) {
				bumen.setBumenMark(bumenMark);
			}
			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();

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

	@RequestMapping("/utaolunComboList")
	public void utaolunComboList(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String utaolunId = (String) request.getParameter("utaolunId");
		String utaolunType = (String) request.getParameter("utaolunType");
		String utaolunType1 = (String) request.getParameter("utaolunType1");
		String userId = (String) request.getParameter("userId");
		String bumenId = (String) request.getParameter("bumenId");
		String yhbumenId = (String) request.getParameter("yhbumenId");
		String yonghuId = (String) request.getParameter("yonghuId");
		Utaolun utaolun = new Utaolun();
		if (StringUtil.isNotEmpty(utaolunId)) {
			utaolun.setUtaolunId(Integer.parseInt(utaolunId));
		}
		if (StringUtil.isNotEmpty(utaolunType)) {
			utaolun.setUtaolunType(Integer.parseInt(utaolunType));
		}
		if (StringUtil.isNotEmpty(utaolunType1)) {
			utaolun.setUtaolunType1(Integer.parseInt(utaolunType1));
		}
		if (StringUtil.isNotEmpty(userId)) {
			utaolun.setUserId(Integer.parseInt(userId));
		}
		if (StringUtil.isNotEmpty(bumenId)) {
			utaolun.setBumenId(Integer.parseInt(bumenId));
		}
		if (StringUtil.isNotEmpty(yonghuId)) {
			utaolun.setYonghuId(Integer.parseInt(yonghuId));
		}
		if (StringUtil.isNotEmpty(yhbumenId)) {
			utaolun.setYhbumenId(Integer.parseInt(yhbumenId));
		}
		if (StringUtil.isNotEmpty(yonghuId)) {
			utaolun.setYonghuId(Integer.parseInt(yonghuId));


//导入导出

@Controller
public class UxinxiAction {
	@Autowired
	private UxinxiService uxinxiService;
	@Autowired
	private UxtypeService uxtypeService;
	@Autowired
	private UserService userService;

	/***上传导入开始***/
	private InputStream excelFile;

	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");

		if (StringUtil.isNotEmpty(uyijianMark)) {
			uyijian.setUyijianMark(uyijianMark);
		}
		if (StringUtil.isNotEmpty(uyijianMark1)) {
			uyijian.setUyijianMark1(uyijianMark1);
		}
		if (StringUtil.isNotEmpty(uyijianMark2)) {
			uyijian.setUyijianMark2(uyijianMark2);
		}
		if (StringUtil.isNotEmpty(uyijianDate)) {
			uyijian.setUyijianDate(DateUtil.formatString(uyijianDate,
					"yyyy-MM-dd hh:mm:ss"));
		}
		if (StringUtil.isNotEmpty(uyijianDate1)) {
			uyijian.setUyijianDate1(DateUtil.formatString(uyijianDate1,
					"yyyy-MM-dd hh:mm:ss"));
		}
		if (StringUtil.isNotEmpty(uyijianType)) {
			uyijian.setUyijianType(Integer.parseInt(uyijianType));
		}
		if (StringUtil.isNotEmpty(uyijianType1)) {
			uyijian.setUyijianType1(Integer.parseInt(uyijianType1));
		}
		if (StringUtil.isNotEmpty(userId)) {
			uyijian.setUserId(Integer.parseInt(userId));
			User user = new User();
			user = userService.getUser(Integer.parseInt(userId));
			uyijian.setUserName(user.getUserName());
			uyijian.setBumenId(user.getBumenId());
			uyijian.setBumenName(user.getBumenName());
		}
		try {
			if (StringUtil.isNotEmpty(uyijianId)) {
				uyijianService.modifyUyijian(uyijian);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			} else {
				Date date = new Date();
				uyijian.setUyijianDate(date);
				uyijian.setUyijianType(0);
				uyijianService.save(uyijian);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/deleteUyijian")
	public void deleteUyijian(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		JSONObject result = new JSONObject();
		String delIds = (String) request.getParameter("delIds");

	}
	/***上传导入结束***/

	@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));
			}
			if (StringUtil.isNotEmpty(bumenId)) {
				uxinxi.setBumenId(Integer.parseInt(bumenId));
			}


	/***上传导入开始***/
	private InputStream excelFile;

	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)) {

			}
			result.put("success", "true");

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

	@RequestMapping("/deleteYhrole")
	public void deleteYhrole(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++) {
				yhroleService.deleteYhrole(Integer.parseInt(str[i]));
			}
			result.put("success", "true");
			result.put("delNums", str.length);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/yhroleComboList")
	public void yhroleComboList(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String yhroleMark2 = (String) request.getParameter("yhroleMark2");
		Yhrole yhrole = new Yhrole();

		if (StringUtil.isNotEmpty(yhroleMark2)) {
			yhrole.setYhroleMark2(Integer.parseInt(yhroleMark2));
		}
		try {
			JSONArray jsonArray = new JSONArray();


@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);

					case 7:
						user.setUserMark1(cellValue);
						break;
					case 8:
						user.setUserMark2(cellValue);
						break;
					case 9:
						user.setUserMark3(cellValue);
						break;
					case 10:
						user.setUserMark4(cellValue);
						break;
					case 11:
						user.setUserType1(Integer.parseInt(cellValue));
						break;
					case 12:
						user.setUserType2(Integer.parseInt(cellValue));
						break;
					}
				}
				userService.save(user);
			}
			JSONObject result = new JSONObject();
			result.put("success", "true");
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/daochuUser")
	public void daochuUser(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String delIds = (String) request.getParameter("delIds");
		JSONObject result = new JSONObject();
		String str[] = delIds.split(",");

		// 创建一个Excel文件
		HSSFWorkbook workbook = new HSSFWorkbook();
		// 创建一个工作表
		HSSFSheet sheet = workbook.createSheet("users记录");
		// 添加表头行
		HSSFRow hssfRow = sheet.createRow(0);
		// 设置单元格格式居中
		HSSFCellStyle cellStyle = workbook.createCellStyle();
		cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);

		// 添加表头内容
		HSSFCell headCell = hssfRow.createCell(0);
		headCell.setCellValue("编号");
		headCell.setCellStyle(cellStyle);

			spchu.setSpchuMark2(spchuMark2);
		}
		if (StringUtil.isNotEmpty(spchuMark3)) {
			spchu.setSpchuMark3(spchuMark3);
		}
		if (StringUtil.isNotEmpty(spchuZong)) {
			spchu.setSpchuZong(Integer.parseInt(spchuZong));
		}
		if (StringUtil.isNotEmpty(spchuJine)) {
			spchu.setSpchuJine(Double.parseDouble(spchuJine));
		}
		if (StringUtil.isNotEmpty(spchuDate)) {
			spchu.setSpchuDate(DateUtil.formatString(spchuDate,
					"yyyy-MM-dd hh:mm:ss"));
		}
		if (StringUtil.isNotEmpty(spchuDate1)) {
			spchu.setSpchuDate1(DateUtil.formatString(spchuDate1,
					"yyyy-MM-dd hh:mm:ss"));
		}
		if (StringUtil.isNotEmpty(spchuType)) {
			spchu.setSpchuType(Integer.parseInt(spchuType));
		}
		if (StringUtil.isNotEmpty(spchuType1)) {
			spchu.setSpchuType1(Integer.parseInt(spchuType1));
		}
		if (StringUtil.isNotEmpty(sptypeId)) {
			spchu.setSptypeId(Integer.parseInt(sptypeId));
			Sptype sptype = new Sptype();
			sptype = sptypeService.getSptype(Integer.parseInt(sptypeId));
			spchu.setSptypeName(sptype.getSptypeName());
		}
		if (StringUtil.isNotEmpty(shangpinId)) {
			spchu.setShangpinId(Integer.parseInt(shangpinId));
			Shangpin shangpin = new Shangpin();
			shangpin = shangpinService.getShangpin(Integer.parseInt(shangpinId));
			spchu.setShangpinName(shangpin.getShangpinName());
			spchu.setSptypeId(shangpin.getSptypeId());
			spchu.setSptypeName(shangpin.getSptypeName());
			spchu.setUserId(shangpin.getUserId());
			spchu.setUserName(shangpin.getUserName());
			spchu.setBumenId(shangpin.getBumenId());
			spchu.setBumenName(shangpin.getBumenName());
			spchu.setRoleId(shangpin.getRoleId());
			spchu.setRoleName(shangpin.getRoleName());
		}
		if (StringUtil.isNotEmpty(userId)) {
			spchu.setUserId(Integer.parseInt(userId));

			int rowNum = sheet.getLastRowNum() + 1;
			for (int i = 1; i < rowNum; i++) {
				Spchu spchu = new Spchu();
				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;
					}

					switch (j) {// 通过列数来判断对应插如的字段
					case 1:
						spchu.setSpchuName(cellValue);
						break;
					case 2:
						spchu.setSpchuMark(cellValue);
						break;
					}
				}
				spchuService.save(spchu);
			}
			JSONObject result = new JSONObject();
			result.put("success", "true");
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/daochuSpchu")
	public void daochuSpchu(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String delIds = (String) request.getParameter("delIds");
		JSONObject result = new JSONObject();
		String str[] = delIds.split(",");

			Role role = new Role();
			role = roleService.getRole(Integer.parseInt(roleId));
			user.setRoleName(role.getRoleName());
		}
		if (StringUtil.isNotEmpty(bumenId)) {
			user.setBumenId(Integer.parseInt(bumenId));
			Bumen bumen = new Bumen();
			bumen = bumenService.getBumen(Integer.parseInt(bumenId));
			user.setBumenName(bumen.getBumenName());
		}
		try {
			if (StringUtil.isNotEmpty(userId)) {
				userService.modifyUser(user);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			} else {
				int total = userService.queryUsers(null, userName, 0, 0, null, null).size();
				if (total==0) {
					Date date = new Date();
					user.setUserDate1(date);
					user.setUserType1(0);
					userService.save(user);
					result.put("success", "true");
					ResponseUtil.write(response, result);
				} else {
					result.put("success", "true");
					result.put("errorMsg", "学号重复！");
					ResponseUtil.write(response, result);
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/mimaUser")
	public void mimaUser(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String userId = (String) request.getParameter("userId");
		String userPassword = (String) request.getParameter("userPassword");
		String userPassword1 = (String) request.getParameter("userPassword1");
		User user = new User();
		try {
			user = userService.getUser(Integer.parseInt(userId));
			if (!user.getUserPassword().equals(userPassword)) {
				request.setAttribute("error", "原密码错误，请重新输入！");
				request.getRequestDispatcher("usermima.jsp").forward(request,
						response);
			}else{
				user.setUserPassword(userPassword1);
				userService.modifyUser(user);

		if (StringUtil.isNotEmpty(uzhanneiType1)) {
			uzhannei.setUzhanneiType1(Integer.parseInt(uzhanneiType1));
		}
		if (StringUtil.isNotEmpty(uxtypeId)) {
			uzhannei.setUxtypeId(Integer.parseInt(uxtypeId));
			Uxtype uxtype = new Uxtype();
			uxtype = uxtypeService.getUxtype(Integer.parseInt(uxtypeId));
			uzhannei.setUxtypeName(uxtype.getUxtypeName());
		}
		if (StringUtil.isNotEmpty(userId)) {
			uzhannei.setUserId(Integer.parseInt(userId));
			User user = new User();
			user = userService.getUser(Integer.parseInt(userId));
			uzhannei.setUserName(user.getUserName());
			uzhannei.setBumenId(user.getBumenId());
			uzhannei.setBumenName(user.getBumenName());
		}
		if (StringUtil.isNotEmpty(shouuserId)) {
			uzhannei.setShouuserId(Integer.parseInt(shouuserId));
			User user = new User();
			user = userService.getUser(Integer.parseInt(shouuserId));
			uzhannei.setShouuserName(user.getUserName());
		}
		try {
			if (StringUtil.isNotEmpty(uzhanneiId)) {
				uzhanneiService.modifyUzhannei(uzhannei);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			} else {
				Date date = new Date();
				uzhannei.setUzhanneiDate(date);
				uzhanneiService.save(uzhannei);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/deleteUzhannei")
	public void deleteUzhannei(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		JSONObject result = new JSONObject();
		String delIds = (String) request.getParameter("delIds");
		try {

			jsonObject.put("spgysName", "请选择...");
			jsonArray.add(jsonObject);
			jsonArray.addAll(JSONArray.fromObject(spgysService.querySpgyss(spgys, 0, 0, null, null)));
			ResponseUtil.write(response, jsonArray);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

@Controller
public class YhbumenAction {
	@Autowired
	private YhbumenService yhbumenService;

	@RequestMapping("/getYhbumens")
	public void getYhbumens(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 yhbumenName = (String) request.getParameter("yhbumenName");
		String yhbumenId = (String) request.getParameter("yhbumenId");
		String yhbumenMark2 = (String) request.getParameter("yhbumenMark2");
		PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
		Yhbumen yhbumen = new Yhbumen();
		try {
			if (StringUtil.isNotEmpty(yhbumenName)) {
				yhbumen.setYhbumenName(yhbumenName);
			}
			if (StringUtil.isNotEmpty(yhbumenId)) {
				yhbumen.setYhbumenId(Integer.parseInt(yhbumenId));

			result.put("rows", jsonArray);
			result.put("total", total);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/addBumen")
	public void addBumen(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		try {
			JSONObject result = new JSONObject();
			
			String bumenName = (String) request.getParameter("bumenName");
			String bumenMark = (String) request.getParameter("bumenMark");
			String bumenMark1 = (String) request.getParameter("bumenMark1");
			String bumenMark2 = (String) request.getParameter("bumenMark2");
			String bumenId = (String) request.getParameter("bumenId");
			Bumen bumen = new Bumen();
			
			if (StringUtil.isNotEmpty(bumenId)) {
				bumen = bumenService.getBumen(Integer.parseInt(bumenId));
			}
			if (StringUtil.isNotEmpty(bumenName)) {
				bumen.setBumenName(bumenName);
			}
			if (StringUtil.isNotEmpty(bumenMark)) {
				bumen.setBumenMark(bumenMark);
			}
			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();
		}
	}

	        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++) {
				Spjin spjin = new Spjin();
				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;
					}

					switch (j) {// 通过列数来判断对应插如的字段
					case 1:
						spjin.setSpjinName(cellValue);
						break;
					case 2:
						spjin.setSpjinMark(cellValue);
						break;
					}
				}
				spjinService.save(spjin);
			}
			JSONObject result = new JSONObject();
			result.put("success", "true");
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/daochuSpjin")
	public void daochuSpjin(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String delIds = (String) request.getParameter("delIds");
		JSONObject result = new JSONObject();
		String str[] = delIds.split(",");

		// 创建一个Excel文件

请添加图片描述

AI Agent技术社区

Agent 垂直技术社区，欢迎活跃、内容共建。

更多推荐

别让你的 Agent 一口吃成胖子：AI Agent 任务拆分的工程实践指南

AI Agent技术社区

AI Agent律师行业智能体的实践步骤

AI Agent技术社区

MCP + 企业IM架构：AI Agent调用OA、ERP、MES时，身份和权限如何传递？

<think>我们只需要根据内容生成摘要，不超过150字。先理解文章核心：MCP+企业IM架构，AI Agent调用OA/ERP/MES时身份和权限传递。要点：IM从消息入口变任务入口；MCP解决连接，但不解决权限；需要五层身份映射；权限分层（可见性、调用、数据范围、确认）；建议组合MCP+API网关。摘要需简洁。参考生成： "本文探讨MCP与企业IM集成中AI Agent调用业务系统时的身份权