基于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 用户不需要账号密码

 *  前端控制器
 * </p>
 *
 */
@Controller
@RequestMapping("/handle")
public class NcpController {

	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;

	 */
	@RequestMapping("/admin/select")
	@ResponseBody
	public boolean adminSelect(@RequestBody Cjgly cjgly) {
		logger.info("/handle/admin/delete===> cjgly={}", cjgly);
		QueryWrapper<Cjgly> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("id", cjgly.getId());

		return cjglyService.remove(queryWrapper);
	}

	@RequestMapping("/admin/add")
	@ResponseBody
	public boolean adminAdd(@RequestBody Cjgly cjgly) {
		logger.info("/handle/admin/add===> cjgly={}", cjgly);
		// QueryWrapper<Cjgly> queryWrapper = new QueryWrapper<>();
		// queryWrapper.eq("id",cjgly.getId());
		if (cjgly.getId() == null || "".equals(cjgly.getId()) || cjgly.getMc() == null || "".equals(cjgly.getMc())
				|| cjgly.getMm() == null || "".equals(cjgly.getMm()) || cjgly.getZh() == null
				|| "".equals(cjgly.getZh())) {
			return false;
		}
		return cjglyService.save(cjgly);
	}

	/**
	 * 查询超级管理员列表
	 * 
	 * @param page
	 * @param limit
	 * @return
	 * @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);
		// 查询到的总量，返回数据要用

@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")
	public String setting(Model model) {
		logger.info("访问user/setting页面");
		return "user/setting";
	}
	
	@RequestMapping("/user/index")
	public String userIndex(Model model) {

	/**
	 * 获取总溯源数
	 * @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
	 * @return
	 */
	@RequestMapping("/source/today")
	@ResponseBody
	public List<String> sourceToday(@RequestBody Syly syly) {
		logger.info("/handle/source/today===> syly={}", syly);
		//获取今天日期
		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
		String todayString = df.format(new Date());
		//获取昨天日期
		SimpleDateFormat df2 = new SimpleDateFormat("yyyy-MM-dd");
		String yesterdayString = df.format(new Date(new Date().getTime()-86400000L));
		//查询今天总数
		QueryWrapper<Syly> todayQueryWrapper = new QueryWrapper<>();
		todayQueryWrapper.eq("syqyid", syly.getSyqyid()).eq("sysj", todayString);
		int todayCount = sylyService.count(todayQueryWrapper);
		//查询昨天总数
		QueryWrapper<Syly> yesterdayQueryWrapper = new QueryWrapper<>();
		yesterdayQueryWrapper.eq("syqyid", syly.getSyqyid()).eq("sysj", yesterdayString);
		int yesterdayCount = sylyService.count(yesterdayQueryWrapper);
		//算出同比增长比例
		float rise = ((float)todayCount - (float)yesterdayCount) / (float)yesterdayCount * 100;
		
		List<String> list = new ArrayList<>();
		list.add(todayCount+"");
		list.add(rise+"%");

		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;
		}
	}
}

			} 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());
		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;

		//获取今天日期
		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
		String todayString = df.format(new Date());
		//获取昨天日期
		SimpleDateFormat df2 = new SimpleDateFormat("yyyy-MM-dd");
		String yesterdayString = df.format(new Date(new Date().getTime()-86400000L));
		//查询今天总数
		QueryWrapper<Syly> todayQueryWrapper = new QueryWrapper<>();
		todayQueryWrapper.eq("syqyid", syly.getSyqyid()).eq("sysj", todayString);
		int todayCount = sylyService.count(todayQueryWrapper);
		//查询昨天总数
		QueryWrapper<Syly> yesterdayQueryWrapper = new QueryWrapper<>();
		yesterdayQueryWrapper.eq("syqyid", syly.getSyqyid()).eq("sysj", yesterdayString);
		int yesterdayCount = sylyService.count(yesterdayQueryWrapper);
		//算出同比增长比例
		float rise = ((float)todayCount - (float)yesterdayCount) / (float)yesterdayCount * 100;
		
		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);
		
		//通过两期数据算出同比增长比例

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

	@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")
	public String setting(Model model) {
		logger.info("访问user/setting页面");
		return "user/setting";
	}
	
	@RequestMapping("/user/index")
	public String userIndex(Model model) {
		logger.info("访问user/index");
		return "user/index";
	}
	
	@RequestMapping("/product/list")
	public String productList(Model model) {
		logger.info("访问product/list页面");
		return "product/list";
	}
	
	@RequestMapping("/product/add")
	public String productAdd(Model model) {
		logger.info("访问product/add页面");
		return "product/add";
	}
	
	@RequestMapping("/product/modify")
	public String productModify(Model model) {
		logger.info("访问product/modify页面");
		return "product/modify";
	}
	
	@RequestMapping("/product/info")

	
	@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")
	public String setting(Model model) {
		logger.info("访问user/setting页面");
		return "user/setting";
	}
	
	@RequestMapping("/user/index")
	public String userIndex(Model model) {
		logger.info("访问user/index");
		return "user/index";
	}
	
	@RequestMapping("/product/list")
	public String productList(Model model) {
		logger.info("访问product/list页面");
		return "product/list";
	}
	
	@RequestMapping("/product/add")
	public String productAdd(Model model) {
		logger.info("访问product/add页面");
		return "product/add";
	}

		//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) {
				ewmid = ewmid.concat("0" + num2);
			} 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();

			//获取属性名
			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;
	}
	
	/**
	 * 获取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<>();

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

/**
 * <p>
 *  前端控制器
 * </p>
 *
 */
@Controller

/**
 * <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) {
		logger.info("/handle/source/count===> syly={}", syly);
		
		//查询syly总数,即溯源总数
		QueryWrapper<Syly> countQueryWrapper = new QueryWrapper<>();
		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();

	public String sourceList(Model model) {
		logger.info("访问source/list页面");
		return "source/list";
	}
	
	@RequestMapping("/source/chart")
	public String sourceChart(Model model) {
		logger.info("访问source/chart页面");
		return "source/chart";
	}
	
	@RequestMapping("/admin/home")
	public String adminHome(Model model) {
		logger.info("访问admin/home页面");
		return "admin/home";
	}
	
	@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";
	}
}

			return false;
		}
		return cjglyService.save(cjgly);
	}

	/**
	 * 查询超级管理员列表
	 * 
	 * @param page
	 * @param limit
	 * @return
	 * @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;
	}
	

}

		return cjglyService.remove(queryWrapper);
	}

	/**
	 * 删除超级管理员
	 * 
	 * @param cjgly
	 * @return
	 */
	@RequestMapping("/admin/select")
	@ResponseBody
	public boolean adminSelect(@RequestBody Cjgly cjgly) {
		logger.info("/handle/admin/delete===> cjgly={}", cjgly);
		QueryWrapper<Cjgly> queryWrapper = new QueryWrapper<>();
		queryWrapper.eq("id", cjgly.getId());

		return cjglyService.remove(queryWrapper);
	}

	@RequestMapping("/admin/add")
	@ResponseBody
	public boolean adminAdd(@RequestBody Cjgly cjgly) {
		logger.info("/handle/admin/add===> cjgly={}", cjgly);
		// QueryWrapper<Cjgly> queryWrapper = new QueryWrapper<>();
		// queryWrapper.eq("id",cjgly.getId());
		if (cjgly.getId() == null || "".equals(cjgly.getId()) || cjgly.getMc() == null || "".equals(cjgly.getMc())
				|| cjgly.getMm() == null || "".equals(cjgly.getMm()) || cjgly.getZh() == null
				|| "".equals(cjgly.getZh())) {
			return false;
		}
		return cjglyService.save(cjgly);
	}

	/**
	 * 查询超级管理员列表
	 * 
	 * @param page
	 * @param limit
	 * @return
	 * @throws Exception
	 */
	@RequestMapping("/admin/list")
	@ResponseBody
	public Map adminList(@RequestParam int page, @RequestParam int limit) throws Exception {
		// QueryWrapper<Cjgly> ncpQueryWrapper = new QueryWrapper<>();