基于Java的垃圾分类查询管理系统设计源码

package com.gcms.controller.admin; import com.alibaba.fastjson.JSON; import com.gcms.pojo.Categorization; import com.gcms.pojo.UserGarbage; import com.gcms.service.CategorizationService; import com.gcms.service.UserGarbageService; import com.gcms.utils.City; import com.gcms.utils.JsonRootBean; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.transaction.annotation.Transactional; import org.springframework.transaction.interceptor.TransactionAspectSupport; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import java.util.Date; import java.util.List; import java.util.Random; @Controller("AdminCategorizationController") @RequestMapping("/admin/fenlei") public class AdminCategorizationController { @Autowired private CategorizationService categorizationService; @Autowired private UserGarbageService userGarbageService; private final Logger logger = LoggerFactory.getLogger(this.getClass()); /** * 分类列表页面 */ @RequestMapping("/fenleiList") public String fenleiList() { return "sa/fenleiList"; } @RequestMapping("/fenleiListUpdate") public String fenleiListUpdate() { return "sa/fenleiListUpdate"; } /** * 分类列表页面 */ @RequestMapping("user/fenleiList") public String userFenleiList() { return "user/fenleiList"; } /** * 返回查询数据 */ @RequestMapping("/getAllByLimit") @ResponseBody public Object getAllByLimit(Categorization categorization) { return categorizationService.getAllByLimit(categorization); } @RequestMapping(value = "/del") @ResponseBody @Transactional public String delUser(Long id) { try { categorizationService.deleteById(id); return "SUCCESS"; } catch (Exception e) { logger.error("删除异常", e); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); return "ERROR"; } } @RequestMapping(value = "/add") public String addUserPage(Long id, Model model) { if (id!=null){ Categorization c = categorizationService.getById(id); model.addAttribute("c", c); } return "sa/fenleiAdd"; } @RequestMapping(value = "/doAdd") @ResponseBody @Transactional public String doAdd(Categorization categorization) { try { categorization.setViewCount(0L); int add = categorizationService.add(categorization); if (add <= 0 ){ return "RRR"; } return "SUCCESS"; } catch (Exception e) { logger.error("添加异常", e); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); return "ERROR"; } } @RequestMapping(value = "/doUpdate") @ResponseBody @Transactional public String doUpdate(Categorization categorization) { try { categorizationService.update(categorization); return "SUCCESS"; } catch (Exception e) { logger.error("添加异常", e); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); return "ERROR"; } } @RequestMapping(value = "/addData") public String addData() { return "sa/addData"; } @RequestMapping(value = "/adds") @ResponseBody @Transactional public String adds() { try { suijiadd(); return "SUCCESS"; } catch (Exception e) { logger.error("添加异常", e); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); return "ERROR"; } } @RequestMapping(value = "/addsjs") @ResponseBody @Transactional public String addsjs() { try { suijiaddjiangsu(); return "SUCCESS"; } catch (Exception e) { logger.error("添加异常", e); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); return "ERROR"; } } private void suijiadd(){ String json1 ="[\n" + " {\n" + " \"name\": \"北京\",\n" + " \"city\": [{\n" + " \"name\": \"北京\",\n" + " \"area\": [\"东城区\", \"西城区\", \"崇文区\", \"宣武区\", \"朝阳区\", \"丰台区\", \"石景山区\", \"海淀区\", \"门头沟区\", \"房山区\", \"通州区\", \"顺义区\", \"昌平区\", \"大兴区\", \"平谷区\", \"怀柔区\", \"密云县\", \"延庆县\"]\n" + " }]\n" + " },\n" + " {\n" + " \"name\": \"天津\",\n" + " \"city\": [{\n" + " \"name\": \"天津\",\n" + " \"area\": [\"和平区\", \"河东区\", \"河西区\", \"南开区\", \"河北区\", \"红桥区\", \"塘沽区\", \"汉沽区\", \"大港区\", \"东丽区\", \"西青区\", \"津南区\", \"北辰区\", \"武清区\", \"宝坻区\", \"宁河县\", \"静海县\", \"蓟县\"]\n" + " }]\n" + " },\n" + " {\n" + " \"name\": \"河北\",\n" + " \"city\": [{\n" + " \"name\": \"石家庄\",\n" + " \"area\": [\"长安区\", \"桥东区\", \"桥西区\", \"新华区\", \"郊区\", \"井陉矿区\", \"井陉县\", \"正定县\", \"栾城县\", \"行唐县\", \"灵寿县\", \"高邑县\", \"深泽县\", \"赞皇县\", \"无极县\", \"平山县\", \"元氏县\", \"赵县\", \"辛集市\", \"藁\", \"晋州市\", \"新乐市\", \"鹿泉市\"]\n" + " }, {\n" + " \"name\": \"唐山\",\n" + " \"area\": [\"路南区\", \"路北区\", \"古冶区\", \"开平区\", \"新区\", \"丰润县\", \"滦县\", \"滦南县\", \"乐亭县\", \"迁西县\", \"玉田县\", \"唐海县\", \"遵化市\", \"丰南市\", \"迁安市\"]\n" + " }, {\"name\": \"秦皇岛\", \"area\": [\"海港区\", \"山海关区\", \"北戴河区\", \"青龙满族自治县\", \"昌黎县\", \"抚宁县\", \"卢龙县\"]}, {\n" + " \"name\": \"邯郸\",\n" + " \"area\": [\"邯山区\", \"丛台区\", \"复兴区\", \"峰峰矿区\", \"邯郸县\", \"临漳县\", \"成安县\", \"大名县\", \"涉县\", \"磁县\", \"肥乡县\", \"永年县\", \"邱县\", \"鸡泽县\", \"广平县\", \"馆陶县\", \"魏县\", \"曲周县\", \"武安市\"]\n" + " }, {\n" + " \"name\": \"邢台\",\n" + " \"area\": [\"桥东区\", \"桥西区\", \"邢台县\", \"临城县\", \"内丘县\", \"柏乡县\", \"隆尧县\", \"任县\", \"南和县\", \"宁晋县\", \"巨鹿县\", \"新河县\", \"广宗县\", \"平乡县\", \"威县\", \"清河县\", \"临西县\", \"南宫市\", \"沙河市\"]\n" + " }, {\n" + " \"name\": \"保定\",\n" + " \"area\": [\"新市区\", \"北市区\", \"南市区\", \"满城县\", \"清苑县\", \"涞水县\", \"阜平县\", \"徐水县\", \"定兴县\", \"唐�