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

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

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的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
			} else {
				ewmid = ewmid.concat("" + num2);
			}
			ewmid = ewmid.concat("-" + ncpid);
			//查询数据库是否存在相同的ewmid,存在则num+1,继续循环
			QueryWrapper<Ewm> ewmidQueryWrapper = new QueryWrapper<>();
			ewmidQueryWrapper.eq("ewmid", ewmid);
			int isExist = ewmService.count(ewmidQueryWrapper);
			if(isExist > 0) {
				num2 += 1;
				ewmid = "ewm";
				continue;
			} else {
				break;
			}
		}
		
		//获取服务器地址、端口、项目名
		HttpServletRequest httpRequest=(HttpServletRequest)request;
		//插入二维码表
		String ewmsj = baseUrl+ httpRequest.getContextPath() + "/info/product-info?ncpid=" + ncpid;
		Ewm ewm = new Ewm();
		ewm.setEwmid(ewmid);
		ewm.setEwmsj(ewmsj);
		boolean flag = ewmService.save(ewm);
		
		//如果二维码表插入成功,则插入ncp表
		//在插入农产品表的时候可能会出错导致插入失败,这样上面插入的二维码表字段就作废了,所以在这里catch农产品表的错误,并把上面二维码表字段删除
		try {
			if(flag) {
				ncp.setEwmid(ewmid);
				boolean flag2 = ncpService.save(ncp);
				return flag2;
			} else {
				return flag;
			}
		} catch (Exception e) {
			ewmQueryWrapper.eq("ewmid", ewm.getEwmid());
			ewmService.remove(ewmQueryWrapper);
			e.printStackTrace();
			return false;
		}
	}
	
	/**
	 * 农产品列表
	 * @param ncp
	 * @param page
	 * @param limit
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/product/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);
			}
			QueryWrapper<Qy> qyQueryWrapper = new QueryWrapper<>();
			qyQueryWrapper.eq("qyid", qyid);

/**
 * <p>
 * 前端控制器
 * </p>
 *
 */
@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
	 */
 * <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页面");
		return "user/home";
	}
	
	@RequestMapping("/setting")

/**
 * <p>
 * 前端控制器
 * </p>
 *
 */
@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);
	/**
	 * 注册
	 * 
	 * @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);
			}
			QueryWrapper<Qy> qyQueryWrapper = new QueryWrapper<>();
			qyQueryWrapper.eq("qyid", qyid);
			int isExist = qyService.count(qyQueryWrapper);
			if(isExist > 0) {
				num += 1;
				qyid = "qy";
				continue;
			} else {
				break;
			}
		}
		// 将企业信息保存到数据库
		qy.setQyid(qyid);
		boolean flag = qyService.save(qy);
		return flag;
	}

	/**
	 * 登录
	 * 
	 * @param qy
	 * @return
	 */
	@RequestMapping("/login")
	@ResponseBody
	public Qy login(@RequestBody Qy qy) {
		logger.info("/handle/login===> Qy={}", qy);
		QueryWrapper<Qy> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("zh", qy.getZh()).eq("mm", qy.getMm());
		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());
			boolean flag2 = ewmService.remove(ewmQueryWrapper);
			return flag2;
		} else {
			return flag;
		}
	}
}

	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);
		response.put("msg", "");
		response.put("count", count);
		response.put("data", sylyList);
		
		return response;
	}
	 * @return
	 */
	@RequestMapping("/source/pie")
	@ResponseBody
	public Map sourcePie(@RequestBody Syly syly) {
		logger.info("/handle/source/pie===> syly={}", syly);
		//获取溯源总数
		QueryWrapper<Syly> sylyQueryWrapper = new QueryWrapper<>();
		sylyQueryWrapper.eq("syqyid", syly.getSyqyid());
		int count = sylyService.count(sylyQueryWrapper);
		int alreadyGet = 0;
		//获取最大溯源量的4个ncp
		List<SylyCountNcpGroupByNcpid> dataList = sylyMapper.selectSylyCountNcpGroupByNcpid(syly.getSyqyid());
		//新建两个列表对象储存返回数据
		List<String> ncpmcList = new ArrayList<>();
		List<Integer> countList = new ArrayList<>();
		//插入查询到的数据到list
		for(SylyCountNcpGroupByNcpid item : dataList) {
			ncpmcList.add(item.getNcpmc());
			countList.add(item.getCount());
			alreadyGet += item.getCount();
		}
		ncpmcList.add("其他");
		countList.add(count-alreadyGet);
		Map map = new HashMap();
		map.put("ncpmcList", ncpmcList);
		map.put("countList", countList);
		return map;
	}
	
	/**
	 * 获取总溯源数
	 * @param syly
	 * @return
	 */
	@RequestMapping("/source/total")
	@ResponseBody
	public List<String> sourceTotal(@RequestBody Syly syly) {
		logger.info("/handle/source/total===> syly={}", syly);
		//获取溯源总数
		QueryWrapper<Syly> sylyQueryWrapper = new QueryWrapper<>();
		sylyQueryWrapper.eq("syqyid", syly.getSyqyid());
		int count = sylyService.count(sylyQueryWrapper);
		List<String> list = new ArrayList<>();
		list.add(count+"");
		return list;
	}
	
	/**
	 * 获取当日溯源数和同比增长比例
	 * @param syly
			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")
	 * 新增农产品(生成二维码数据,插入二维码表)
	 * @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 {
				break;
			}
		}
		ncp.setNcpid(ncpid);
		
		//生成二维码id
		QueryWrapper<Ewm> ewmQueryWrapper = new QueryWrapper<>();
		ewmQueryWrapper.likeLeft("ewmid", ncp.getQyid());
		//int num2 = ewmService.count(ewmQueryWrapper) + 1;
		int num2 = num;
		String ewmid = "ewm";
		while(ncp.getEwmid() == null) {
			if(num2 /10 == 0) {
				ewmid = ewmid.concat("00" + num2);
			} else if(num2 / 10 >= 1 && num2 / 10 < 10) {
	 * 修改企业信息
	 * @param qy
	 * @return
	 */
	@RequestMapping("/user/stqy")
	@ResponseBody
	public boolean qy_modifiy(@RequestBody Qy qy) {
		logger.info("/handle/user/stqy===> Qy={}", qy);
		QueryWrapper<Qy> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("qyid", qy.getQyid());

		return qyService.update(qy, queryWrapper);
	}
}

/**
 * <p>
 * 前端控制器
 * </p>
 *
	protected Logger logger = LoggerFactory.getLogger(this.getClass());
	
	@Autowired
	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 {
				break;
			}
		}
		ncp.setNcpid(ncpid);
		
		//生成二维码id
		QueryWrapper<Ewm> ewmQueryWrapper = new QueryWrapper<>();
		ewmQueryWrapper.likeLeft("ewmid", ncp.getQyid());
		//int num2 = ewmService.count(ewmQueryWrapper) + 1;
		int num2 = num;
		String ewmid = "ewm";
	 * 登录
	 * 
	 * @param qy
	 * @return
	 */
	@RequestMapping("/login")
	@ResponseBody
	public Qy login(@RequestBody Qy qy) {
		logger.info("/handle/login===> Qy={}", qy);
		QueryWrapper<Qy> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("zh", qy.getZh()).eq("mm", qy.getMm());
		Qy qyEntity = qyService.getOne(queryWrapper);
		return qyEntity;
	}

	@RequestMapping("/user/get")
	@ResponseBody
	public Qy get(@RequestBody Qy qy) {
		logger.info("/handle/user/get===> Qy={}", qy);
		QueryWrapper<Qy> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("qyid", qy.getQyid());
		qy = qyService.getOne(queryWrapper);
		return qy;
	}
	/**
	 * 查询企业列表
	 * @param page
	 * @param limit
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/user/getlist")
	@ResponseBody
	public Map qyList(@RequestParam int page, @RequestParam int limit) throws Exception {
		List<Qy> dataList = qyService.list(null);
		logger.info("=========={}", dataList);
		// 查询到的总量,返回数据要用
		int count = dataList.size();
		// list截取分页的索引
		int fromIndex = (page - 1) * limit;
		int toIndex = page * limit;
		// 截取分页数据
		if (page * limit > count) {
			} else {
				return flag;
			}
		} catch (Exception e) {
			ewmQueryWrapper.eq("ewmid", ewm.getEwmid());
			ewmService.remove(ewmQueryWrapper);
			e.printStackTrace();
			return false;
		}
	}
	
	/**
	 * 农产品列表
	 * @param ncp
	 * @param page
	 * @param limit
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/product/list")
	@ResponseBody
	public Map productList(Ncp ncp, @RequestParam int page, @RequestParam int limit) throws Exception {
		logger.info("/handle/product/list===> ncp={}", ncp);
		logger.info("page = {}", page);
		logger.info("limit = {}", limit);
		QueryWrapper<Ncp> ncpQueryWrapper = new QueryWrapper<>();
		//遍历ncp对象的属性
		Field field[] = ncp.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 = ncp.getClass().getMethod("get" + getterName);
				//调用getter方法
				String value = (String) m.invoke(ncp);
				//如果非空,则加入查询条件
				if (value != null) {
					ncpQueryWrapper.eq(name, value);
				}
			}
		}
		List<Ncp> ncpList = ncpService.list(ncpQueryWrapper);
		logger.info("=========={}", ncpList);
	}
	
	/**
	 * 获取7天溯源数据
	 * @param syly
	 * @return
	 */
	@RequestMapping("/source/line")
	@ResponseBody
	public Map sourceChart(@RequestBody Syly syly) {
		logger.info("/handle/source/line===> syly={}", syly);
		//groud by 溯源时间查询list
		QueryWrapper<Syly> sylyQueryWrapper = new QueryWrapper<>();
		//map对象用来储存返回数据
		Map map = new HashMap();
		//新建sysjList和counts,用于保存时间和访问数
		List<String> sysjList = new ArrayList<>();
		List<Integer> countList = new ArrayList<>();
		for(int i = 6; i >= 0; i--) {
			//获取i天前日期对象
			Date date = tool.getDateBefore(new Date(), i);
			//溯源时间转字符串
			SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
			String sysjString = df.format(date);
			//查询i天前溯源数量
			QueryWrapper<Syly> countQueryWrapper = new QueryWrapper<>();
			countQueryWrapper.eq("sysj", sysjString).eq("syqyid", syly.getSyqyid());
			int count = sylyService.count(countQueryWrapper);
			//将结果插入list
			countList.add(count);
			sysjList.add(sysjString);
		}
		map.put("sysjList", sysjList);
		map.put("counts",countList);
		return map;
	}
	
	/**
	 * 获取溯源农产品分布数据
	 * @param syly
	 * @return
	 */
	@RequestMapping("/source/pie")
	@ResponseBody
	public Map sourcePie(@RequestBody Syly syly) {
		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("/")
	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) {
		//在插入农产品表的时候可能会出错导致插入失败,这样上面插入的二维码表字段就作废了,所以在这里catch农产品表的错误,并把上面二维码表字段删除
		try {
			if(flag) {
				ncp.setEwmid(ewmid);
				boolean flag2 = ncpService.save(ncp);
				return flag2;
			} else {
				return flag;
			}
		} catch (Exception e) {
			ewmQueryWrapper.eq("ewmid", ewm.getEwmid());
			ewmService.remove(ewmQueryWrapper);
			e.printStackTrace();
			return false;
		}
	}
	
	/**
	 * 农产品列表
	 * @param ncp
	 * @param page
	 * @param limit
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/product/list")
	@ResponseBody
	public Map productList(Ncp ncp, @RequestParam int page, @RequestParam int limit) throws Exception {
		logger.info("/handle/product/list===> ncp={}", ncp);
		logger.info("page = {}", page);
		logger.info("limit = {}", limit);
		QueryWrapper<Ncp> ncpQueryWrapper = new QueryWrapper<>();
		//遍历ncp对象的属性
		Field field[] = ncp.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();
			//根据类型做操作

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

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值