菜单 搜索
首页 前端知识 基于javaweb mysql的ssm maven农产品溯源管理系统(java ssm jsp layui jquery mysql)

基于javaweb mysql的ssm maven农产品溯源管理系统(java ssm jsp layui jquery mysql)

2024-02-29 12:02:59 前端知识 前端哥 287 973 我要收藏

基于javaweb+mysql的ssm+maven农产品溯源管理系统(java+ssm+jsp+layui+jquery+mysql)

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb的SSM+Maven农产品溯源管理系统(java+ssm+jsp+layui+jquery+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项目：是；

技术栈

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

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中database.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入http://localhost:8080/ncpsy 登录 注：Tomcat中配置路径必须为/ncpsy 否则会有异常 管理员账号/密码：admin/admin 企业账号/密码：user/123456
		response.put("msg", "");
		response.put("count", count);
		response.put("data", ncpList);
		
		return response;
	}
	
	/**
	 * 获取农产品表一个数据
	 * @param ncp
	 * @return
	 */
	@RequestMapping("/product/getone")
	@ResponseBody
	public Ncp productGetone(@RequestBody Ncp ncp) {
		logger.info("/handle/product/getone===> ncp={}", ncp);
		QueryWrapper<Ncp> ncpQueryWrapper = new QueryWrapper<>();
		ncpQueryWrapper.eq("ncpid", ncp.getNcpid());
		ncp = ncpService.getOne(ncpQueryWrapper);
		return ncp;
	}
	
	@RequestMapping("/product/modify")
	@ResponseBody
	public boolean productModify(@RequestBody Ncp ncp) {
		logger.info("/handle/product/modify===> ncp={}", ncp);
		QueryWrapper<Ncp> ncpQueryWrapper = new QueryWrapper<>();
		ncpQueryWrapper.eq("ncpid", ncp.getNcpid());
		Ncp ncpEntity = ncpService.getOne(ncpQueryWrapper);
		ncp.setQyid(ncpEntity.getQyid());
		ncp.setEwmid(ncpEntity.getEwmid());
		UpdateWrapper<Ncp> ncpUpdateWrapper = new UpdateWrapper<>();
		ncpUpdateWrapper.eq("ncpid", ncp.getNcpid());
		boolean flag = ncpService.update(ncp, ncpUpdateWrapper);
		return flag;
	}
	
	/**
	 * 删除农产品
	 * @param ncp
	 * @return
 
复制
	 */
	@RequestMapping("/product/getone")
	@ResponseBody
	public Ncp productGetone(@RequestBody Ncp ncp) {
		logger.info("/handle/product/getone===> ncp={}", ncp);
		QueryWrapper<Ncp> ncpQueryWrapper = new QueryWrapper<>();
		ncpQueryWrapper.eq("ncpid", ncp.getNcpid());
		ncp = ncpService.getOne(ncpQueryWrapper);
		return ncp;
	}
	
	@RequestMapping("/product/modify")
	@ResponseBody
	public boolean productModify(@RequestBody Ncp ncp) {
		logger.info("/handle/product/modify===> ncp={}", ncp);
		QueryWrapper<Ncp> ncpQueryWrapper = new QueryWrapper<>();
		ncpQueryWrapper.eq("ncpid", ncp.getNcpid());
		Ncp ncpEntity = ncpService.getOne(ncpQueryWrapper);
		ncp.setQyid(ncpEntity.getQyid());
		ncp.setEwmid(ncpEntity.getEwmid());
		UpdateWrapper<Ncp> ncpUpdateWrapper = new UpdateWrapper<>();
		ncpUpdateWrapper.eq("ncpid", ncp.getNcpid());
		boolean flag = ncpService.update(ncp, ncpUpdateWrapper);
		return flag;
	}
	
	/**
	 * 删除农产品
	 * @param ncp
	 * @return
	 */
	@RequestMapping("/product/delete")
	@ResponseBody
	public boolean productDelete(@RequestBody Ncp ncp) {
		logger.info("/handle/product/list===> ncp={}", ncp);
		QueryWrapper<Ncp> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("ncpid", ncp.getNcpid());
		ncp = ncpService.getOne(queryWrapper);
		boolean flag = ncpService.remove(queryWrapper);
		if(flag) {
			QueryWrapper<Ewm> ewmQueryWrapper = new QueryWrapper<>();
			ewmQueryWrapper.eq("ewmid", ncp.getEwmid());
复制
	 * @throws Exception
	 */
	@RequestMapping("/admin/list")
	@ResponseBody
	public Map adminList(@RequestParam int page, @RequestParam int limit) throws Exception {
		// QueryWrapper<Cjgly> ncpQueryWrapper = new QueryWrapper<>();
		List<Cjgly> dataList = cjglyService.list(null);
		logger.info("=========={}", dataList);
		// 查询到的总量，返回数据要用
		int count = dataList.size();
		// list截取分页的索引
		int fromIndex = (page - 1) * limit;
		int toIndex = page * limit;
		// 截取分页数据
		if (page * limit > count) {
			toIndex = count;
		}
		dataList = dataList.subList(fromIndex, toIndex);
 
		Map response = new HashMap();
		response.put("code", 0);
		response.put("msg", "");
		response.put("count", count);
		response.put("data", dataList);
		return response;
	}
	
 
}
 
/**
 * <p>
 *  页面控制器
 * </p>
 *
 */
@Controller
public class ViewsController {
	
	protected Logger logger = LoggerFactory.getLogger(this.getClass());
	
	@RequestMapping("/")
复制
 
/**
 * <p>
 *  前端控制器
 * </p>
 *
 */
@Controller
@RequestMapping("/handle")
public class SylyController {
	
	protected Logger logger = LoggerFactory.getLogger(this.getClass());
	
	@Autowired
	private ISylyService sylyService;
	
	@Autowired
	private SylyMapper sylyMapper;
	
	private static Tool tool = new Tool();
	
	/**
	 * 溯源来源计数
	 * @param syly
	 * @param request
	 * @return
	 */
	@RequestMapping("/source/count")
	@ResponseBody
	public boolean sourceCount(@RequestBody Syly syly, HttpServletRequest request) {
复制
	public List<String> sourceMonth(@RequestBody Syly syly) {
		logger.info("/handle/source/month===> syly={}", syly);
		//获取今天和30天前的日期
		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
		String dateString = df.format(new Date());
		String monthBeforeString = df.format(tool.getDateBefore(new Date(), 29));
		//查询介于两个日期之间的总数
		QueryWrapper<Syly> countQueryWrapper = new QueryWrapper<>();
		countQueryWrapper.between("sysj", monthBeforeString, dateString).eq("syqyid", syly.getSyqyid());
		int count = sylyService.count(countQueryWrapper);
		
		//获取上一期的两个日期
		String lastDateString = df.format(tool.getDateBefore(new Date(), 30));
		String lastMonthBeforeString = df.format(tool.getDateBefore(new Date(), 59));
		//同样查询两个日期之间的总数
		QueryWrapper<Syly> lastCountQueryWrapper = new QueryWrapper<>();
		lastCountQueryWrapper.between("sysj", lastMonthBeforeString, lastDateString).eq("syqyid", syly.getSyqyid());
		int lastCount = sylyService.count(lastCountQueryWrapper);
		
		//通过两期数据算出同比增长比例
		float rise = ((float)count - (float)lastCount) / (float)lastCount * 100;
		
		//返回数据
		List<String> list = new ArrayList<>();
		list.add(count+"");
		list.add(rise+"%");
		return list;
	}
 
}
 
复制
 
/**
 * <p>
 * 前端控制器
 * </p>
 *
 */
@Controller
@RequestMapping("/handle")
public class QyController {
 
	protected Logger logger = LoggerFactory.getLogger(this.getClass());
 
	@Autowired
	private IQyService qyService;
 
	/**
	 * 注册
	 * 
	 * @param qy
	 * @return
	 */
	@RequestMapping("/register")
	@ResponseBody
	public boolean register(@RequestBody Qy qy) {
		logger.info("/handle/register===> Qy={}", qy);
		// 获取企业表里企业数量，+1
		QueryWrapper<Qy> queryWrapper = new QueryWrapper<>();
		int num = qyService.count(queryWrapper) + 1;
		// 拼接企业id("qy" + 0的个数 + num)
		String qyid = "qy";
		while(true) {
			if (num / 10 == 0) {
				qyid = qyid.concat("00" + num);
			} else if (num / 10 >= 1 && num / 10 < 10) {
				qyid = qyid.concat("0" + num);
			} else {
				qyid = qyid.concat("" + num);
复制
	
	@RequestMapping("/admin/login")
	public String adminLogin(Model model) {
		logger.info("访问admin/login页面");
		return "admin/login";
	}
	
	@RequestMapping("/admin/setting")
	public String adminSetting(Model model) {
		logger.info("访问admin/setting页面");
		return "admin/setting";
	}
	
	@RequestMapping("/admin/user-list")
	public String adminUserList(Model model) {
		logger.info("访问admin/user-list页面");
		return "admin/user-list";
	}
	@RequestMapping("/admin/addAdmin")
	public String adminAdd(Model model) {
		logger.info("访问admin/addAdmin页面");
		return "admin/addAdmin";
	}
	@RequestMapping("/info/product-info")
	public String infoProductInfo(Model model) {
		logger.info("访问info/product-info页面");
		return "info/product-info";
	}
}
 
复制
	 */
	@RequestMapping("/source/list")
	@ResponseBody
	public Map sourceList(Syly syly, @RequestParam int page, @RequestParam int limit) throws Exception {
		logger.info("/handle/source/list===> syly={}", syly);
		logger.info("page = {}", page);
		logger.info("limit = {}", limit);
		QueryWrapper<Syly> sylyQueryWrapper = new QueryWrapper<>();
		//遍历syly对象的属性
		Field field[] = syly.getClass().getDeclaredFields();
		for(int i = 0; i < field.length; i++) {
			//获取属性名
			String name = field[i].getName();
			//将属性的首字符大写，方便构造get，set方法
			String getterName = name.substring(0,1).toUpperCase()+name.substring(1);
			//获取属性的类型
			String type = field[i].getGenericType().toString();
			//根据类型做操作
			if (type.equals("class java.lang.String")) {
				//获得getter方法
				Method m = syly.getClass().getMethod("get" + getterName);
				//调用getter方法
				String value = (String) m.invoke(syly);
				//如果非空，则加入查询条件
				if (value != null) {
					sylyQueryWrapper.eq(name, value);
				}
			}
		}
		
		List<Syly> sylyList = sylyService.list(sylyQueryWrapper);
		logger.info("=========={}", sylyList);
		//查询到的总量，返回数据要用
		int count = sylyList.size();
		//list截取分页的索引
		int fromIndex = (page-1)*limit;
		int toIndex = page * limit;
		//截取分页数据
		if(page*limit > count) {
			toIndex = count;
		}
		sylyList = sylyList.subList(fromIndex, toIndex);
		
		Map response = new HashMap();
		response.put("code", 0);
复制
	@RequestMapping("/source/list")
	@ResponseBody
	public Map sourceList(Syly syly, @RequestParam int page, @RequestParam int limit) throws Exception {
		logger.info("/handle/source/list===> syly={}", syly);
		logger.info("page = {}", page);
		logger.info("limit = {}", limit);
		QueryWrapper<Syly> sylyQueryWrapper = new QueryWrapper<>();
		//遍历syly对象的属性
		Field field[] = syly.getClass().getDeclaredFields();
		for(int i = 0; i < field.length; i++) {
			//获取属性名
			String name = field[i].getName();
			//将属性的首字符大写，方便构造get，set方法
			String getterName = name.substring(0,1).toUpperCase()+name.substring(1);
			//获取属性的类型
			String type = field[i].getGenericType().toString();
			//根据类型做操作
			if (type.equals("class java.lang.String")) {
				//获得getter方法
				Method m = syly.getClass().getMethod("get" + getterName);
				//调用getter方法
				String value = (String) m.invoke(syly);
				//如果非空，则加入查询条件
				if (value != null) {
					sylyQueryWrapper.eq(name, value);
				}
			}
		}
		
		List<Syly> sylyList = sylyService.list(sylyQueryWrapper);
		logger.info("=========={}", sylyList);
		//查询到的总量，返回数据要用
		int count = sylyList.size();
		//list截取分页的索引
		int fromIndex = (page-1)*limit;
		int toIndex = page * limit;
		//截取分页数据
		if(page*limit > count) {
			toIndex = count;
		}
		sylyList = sylyList.subList(fromIndex, toIndex);
		
		Map response = new HashMap();
复制
	private INcpService ncpService;
	
	@Autowired
	private IEwmService ewmService;
 
	private String baseUrl = "http://192.168.0.121:8080";
	
	/**
	 * 新增农产品(生成二维码数据，插入二维码表)
	 * @param ncp
	 * @return
	 */
	@RequestMapping("/product/add")
	@ResponseBody
	public boolean productAdd(@RequestBody Ncp ncp, HttpServletRequest request) {
		logger.info("/handle/product/add===> ncp={}", ncp);
		QueryWrapper<Ncp> queryWrapper = new QueryWrapper<>();
		
		//设置农产品id
		queryWrapper.eq("qyid", ncp.getQyid());
		int num = ncpService.count(queryWrapper) + 1;
		String ncpid = "ncp";
		while(ncp.getNcpid() == null) {
			if(num /10 == 0) {
				ncpid = ncpid.concat("00" + num);
			} else if(num / 10 >= 1 && num / 10 < 10) {
				ncpid = ncpid.concat("0" + num);
			} else {
				ncpid = ncpid.concat("" + num);
			}
			ncpid = ncpid.concat("-" + ncp.getQyid());
			//查询数据库是否存在相同的ncpid，存在则num+1，继续循环
			QueryWrapper<Ncp> ncpidQueryWrapper = new QueryWrapper<>();
			ncpidQueryWrapper.eq("ncpid", ncpid);
			int isExist = ncpService.count(ncpidQueryWrapper);
			if(isExist > 0) {
				num += 1;
				ncpid = "ncp";
				continue;
			} else {
复制
 */
@Controller
@RequestMapping("/handle")
public class CjglyController {
 
	protected Logger logger = LoggerFactory.getLogger(this.getClass());
 
	@Autowired
	private ICjglyService cjglyService;
 
	@RequestMapping("/admin/login")
	@ResponseBody
	public Cjgly adminLogin(@RequestBody Cjgly cjgly) {
		logger.info("/handle/admin/login===> cjgly={}", cjgly);
		QueryWrapper<Cjgly> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("zh", cjgly.getZh()).eq("mm", cjgly.getMm());
		Cjgly cjglyEntity = cjglyService.getOne(queryWrapper);
		return cjglyEntity;
	}
 
	/**
	 * 删除超级管理员
	 * 
	 * @param cjgly
	 * @return
	 */
	@RequestMapping("/admin/delete")
	@ResponseBody
	public boolean adminDelete(@RequestBody Cjgly cjgly) {
		logger.info("/handle/admin/delete===> cjgly={}", cjgly);
		QueryWrapper<Cjgly> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("id", cjgly.getId());
 
		return cjglyService.remove(queryWrapper);
	}
 
	/**
	 * 删除超级管理员
	 * 
	 * @param cjgly
	 * @return
	 */
	@RequestMapping("/admin/select")
	@ResponseBody
	public boolean adminSelect(@RequestBody Cjgly cjgly) {
		logger.info("/handle/admin/delete===> cjgly={}", cjgly);
复制
	}
	
	@RequestMapping("/source/month")
	@ResponseBody
	public List<String> sourceMonth(@RequestBody Syly syly) {
		logger.info("/handle/source/month===> syly={}", syly);
		//获取今天和30天前的日期
		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
		String dateString = df.format(new Date());
		String monthBeforeString = df.format(tool.getDateBefore(new Date(), 29));
		//查询介于两个日期之间的总数
		QueryWrapper<Syly> countQueryWrapper = new QueryWrapper<>();
		countQueryWrapper.between("sysj", monthBeforeString, dateString).eq("syqyid", syly.getSyqyid());
		int count = sylyService.count(countQueryWrapper);
		
		//获取上一期的两个日期
		String lastDateString = df.format(tool.getDateBefore(new Date(), 30));
		String lastMonthBeforeString = df.format(tool.getDateBefore(new Date(), 59));
		//同样查询两个日期之间的总数
		QueryWrapper<Syly> lastCountQueryWrapper = new QueryWrapper<>();
		lastCountQueryWrapper.between("sysj", lastMonthBeforeString, lastDateString).eq("syqyid", syly.getSyqyid());
		int lastCount = sylyService.count(lastCountQueryWrapper);
		
		//通过两期数据算出同比增长比例
		float rise = ((float)count - (float)lastCount) / (float)lastCount * 100;
		
		//返回数据
		List<String> list = new ArrayList<>();
		list.add(count+"");
		list.add(rise+"%");
		return list;
	}
 
}
 
复制
 
/**
 * <p>
 *  页面控制器
 * </p>
 *
 */
@Controller
public class ViewsController {
	
	protected Logger logger = LoggerFactory.getLogger(this.getClass());
	
	@RequestMapping("/")
	public String index(Model model) {
		logger.info("访问index页面");
		return "index";
	}
	
	@RequestMapping("/index")
	public String index2(Model model) {
		logger.info("访问index页面");
		return "index";
	}
	
	@RequestMapping("/login")
	public String login(Model model) {
		logger.info("访问user/login页面");
		return "user/login";
	}
	
	@RequestMapping("/register")
	public String register(Model model) {
		logger.info("访问user/register页面");
		return "user/register";
	}
	
	@RequestMapping("/home")
	public String home(Model model) {
		logger.info("访问user/home页面");
复制
			//获取属性的类型
			String type = field[i].getGenericType().toString();
			//根据类型做操作
			if (type.equals("class java.lang.String")) {
				//获得getter方法
				Method m = syly.getClass().getMethod("get" + getterName);
				//调用getter方法
				String value = (String) m.invoke(syly);
				//如果非空，则加入查询条件
				if (value != null) {
					sylyQueryWrapper.eq(name, value);
				}
			}
		}
		
		List<Syly> sylyList = sylyService.list(sylyQueryWrapper);
		logger.info("=========={}", sylyList);
		//查询到的总量，返回数据要用
		int count = sylyList.size();
		//list截取分页的索引
		int fromIndex = (page-1)*limit;
		int toIndex = page * limit;
		//截取分页数据
		if(page*limit > count) {
			toIndex = count;
		}
		sylyList = sylyList.subList(fromIndex, toIndex);
		
		Map response = new HashMap();
		response.put("code", 0);
		response.put("msg", "");
		response.put("count", count);
		response.put("data", sylyList);
		
		return response;
	}
	
	/**
	 * 获取7天溯源数据
	 * @param syly
	 * @return
	 */
	@RequestMapping("/source/line")
	@ResponseBody
	public Map sourceChart(@RequestBody Syly syly) {
		logger.info("/handle/source/line===> syly={}", syly);
		//groud by 溯源时间查询list
复制
		List<String> list = new ArrayList<>();
		list.add(todayCount+"");
		list.add(rise+"%");
		return list;
	}
	
	/**
	 * 获取7天溯源人数和同比增长比例
	 * @param syly
	 * @return
	 */
	@RequestMapping("/source/week")
	@ResponseBody
	public List<String> sourceWeek(@RequestBody Syly syly) {
		logger.info("/handle/source/week===> syly={}", syly);
		//获取今天和七天前的日期
		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
		String dateString = df.format(new Date());
		String weekBeforeString = df.format(tool.getDateBefore(new Date(), 6));
		//查询介于两个日期之间的总数
		QueryWrapper<Syly> countQueryWrapper = new QueryWrapper<>();
		countQueryWrapper.between("sysj", weekBeforeString, dateString).eq("syqyid", syly.getSyqyid());
		int count = sylyService.count(countQueryWrapper);
		
		//获取上一期的两个日期
		String lastDateString = df.format(tool.getDateBefore(new Date(), 7));
		String lastWeekBeforeString = df.format(tool.getDateBefore(new Date(), 13));
		//同样查询两个日期之间的总数
		QueryWrapper<Syly> lastCountQueryWrapper = new QueryWrapper<>();
		lastCountQueryWrapper.between("sysj", lastWeekBeforeString, lastDateString).eq("syqyid", syly.getSyqyid());
		int lastCount = sylyService.count(lastCountQueryWrapper);
		
		//通过两期数据算出同比增长比例
		float rise = ((float)count - (float)lastCount) / (float)lastCount * 100;
		
		//返回数据
		List<String> list = new ArrayList<>();
		list.add(count+"");
		list.add(rise+"%");
		return list;
	}
复制
		countQueryWrapper.eq("syqyid", syly.getSyqyid());
		int count = sylyService.count(countQueryWrapper) + 1;
		//获取当前日期，设置溯源时间
		Date now = new Date();
		syly.setSysj(now);
		//设置溯源id
		SimpleDateFormat df = new SimpleDateFormat("yyyyMMddHHmmss");
		String newNo = df.format(now);
		String syid = "syly-" + newNo + "-" + count;
		syly.setSyid(syid);
		//设置溯源ip
		String syip = request.getRemoteAddr();
		syly.setSyip(syip);
		
		boolean flag = sylyService.save(syly);
		return flag;
	}
	
	/**
	 * 溯源列表
	 * @param syly
	 * @param page
	 * @param limit
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/source/list")
	@ResponseBody
	public Map sourceList(Syly syly, @RequestParam int page, @RequestParam int limit) throws Exception {
		logger.info("/handle/source/list===> syly={}", syly);
		logger.info("page = {}", page);
		logger.info("limit = {}", limit);
		QueryWrapper<Syly> sylyQueryWrapper = new QueryWrapper<>();
		//遍历syly对象的属性
		Field field[] = syly.getClass().getDeclaredFields();
		for(int i = 0; i < field.length; i++) {
			//获取属性名
			String name = field[i].getName();
			//将属性的首字符大写，方便构造get，set方法
			String getterName = name.substring(0,1).toUpperCase()+name.substring(1);
			//获取属性的类型
			String type = field[i].getGenericType().toString();
			//根据类型做操作
			if (type.equals("class java.lang.String")) {
				//获得getter方法
				Method m = syly.getClass().getMethod("get" + getterName);
				//调用getter方法
				String value = (String) m.invoke(syly);
				//如果非空，则加入查询条件
				if (value != null) {
					sylyQueryWrapper.eq(name, value);
				}
			}
复制
 
/**
 * <p>
 *  前端控制器
 * </p>
 *
 */
@Controller
@RequestMapping("/handle")
public class SylyController {
	
	protected Logger logger = LoggerFactory.getLogger(this.getClass());
	
	@Autowired
	private ISylyService sylyService;
	
	@Autowired
	private SylyMapper sylyMapper;
	
	private static Tool tool = new Tool();
	
	/**
复制
	}
	
	/**
	 * 删除农产品
	 * @param ncp
	 * @return
	 */
	@RequestMapping("/product/delete")
	@ResponseBody
	public boolean productDelete(@RequestBody Ncp ncp) {
		logger.info("/handle/product/list===> ncp={}", ncp);
		QueryWrapper<Ncp> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("ncpid", ncp.getNcpid());
		ncp = ncpService.getOne(queryWrapper);
		boolean flag = ncpService.remove(queryWrapper);
		if(flag) {
			QueryWrapper<Ewm> ewmQueryWrapper = new QueryWrapper<>();
			ewmQueryWrapper.eq("ewmid", ncp.getEwmid());
			boolean flag2 = ewmService.remove(ewmQueryWrapper);
			return flag2;
		} else {
			return flag;
		}
	}
}
 
复制

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

转载请注明出处或者链接地址：https://www.qianduange.cn//article/2971.html
标签
mysqlmaven
上一篇：HTML基本结构及基本标签
评论
相关文章

前端哥

前端哥

广告位招租：QQ85750956
发布的文章

CSS3 Flexbox

2024-03-18 11:03:22

VUE环境下 CSS3 JS 实现发牌 翻牌

2024-03-18 11:03:21

【编解码：WebP协议】

2024-03-18 11:03:21

纯CSS实现背景色渐变

2024-03-18 11:03:20

CSS3：最新特性和实例教程

2024-03-18 11:03:20

微信小程序 navigator点击后有阴影 ，去掉navigator阴影效果

2024-03-18 11:03:20

HTML5 & CSS3常见新特性

2024-03-18 11:03:19

前端框架的CSS模块化（CSS Modules）

2024-03-18 11:03:54

CSS 3

2024-03-18 11:03:53

aardio简单网站css或js下载练习

2024-03-18 11:03:52

广告位招租：QQ85750956
大家推荐的文章
1

【Echarts系列】—— 实现电池图、3D立体圆形柱状图

2024-03-03 11:03:011000
2

ECharts 饼状图颜色设置

2024-02-16 14:02:001000
3

echarts实现动态渲染多柱图

2024-02-12 14:02:341000
4

移动端css布局大全

2024-02-06 15:02:421000
5

使用HTML5和JS实现日期下拉框功能

2024-02-04 11:02:521000
6

JS生成条形码JsBarcode.all.js，转成图片canvas2image.js，并打印二维码jQuery.print.js

2024-01-27 01:01:181000
7

echarts 图表，定时器实现数据实时动态

2024-03-13 00:03:28999
8

jQuery事件处理

2024-03-12 01:03:32999
9

HTML5实现下拉列表的标签有哪些

2024-03-11 10:03:35999
10

成都工业学院Web技术基础（WEB）实验一：HTML5排版标签使用

2024-02-27 11:02:41999

rss订阅 百度xml 谷歌xml 搜狗xml soxml 神马搜索xml 网站地图

Copyright © 2018-2022 前端哥 陕ICP备2023000550号-1 前端哥

讲个笑话：程序员心理活动：看别人的代码，这都写得什么玩意儿，垃圾！！看自己一个月前的代码：这TM谁写得代码，垃圾！再一看，这代码怎么这么眼熟？我自己写得？仔细一看，卧槽！还TM的真是我自己写的！！

前端技术交流源码工具分享网站

会员中心 联系我 留言建议 回顶部
复制成功！