devbox
小小林熬夜学编程
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

基于ssm+vue校园二手物品交易平台源码和论文_基于vue的校园二手交易平台系统国内外文献综述

作者：小小林熬夜学编程 | 2024-03-07 10:31:08

赞

踩

基于vue的校园二手交易平台系统国内外文献综述

基于ssm+vue校园二手物品交易平台源码和论文144

 开发工具：idea 或eclipse
 数据库mysql5.7+
 数据库链接工具：navcat,小海豚等
  技术：ssm

摘  要

现代经济快节奏发展以及不断完善升级的信息化技术，让传统数据信息的管理升级为软件存储，归纳，集中处理数据信息的管理方式。本校园二手物品交易平台就是在这样的大环境下诞生，其可以帮助管理者在短时间内处理完毕庞大的数据信息，使用这种软件工具可以帮助管理人员提高事务处理效率，达到事半功倍的效果。此校园二手物品交易平台利用当下成熟完善的SSM框架，使用跨平台的可开发大型商业网站的Java语言，以及最受欢迎的RDBMS应用软件之一的Mysql数据库进行程序开发.校园二手物品交易平台的开发根据操作人员需要设计的界面简洁美观，在功能模块布局上跟同类型网站保持一致，程序在实现基本要求功能时，也为数据信息面临的安全问题提供了一些实用的解决方案。可以说该程序在帮助管理者高效率地处理工作事务的同时，也实现了数据信息的整体化，规范化与自动化。

关键词：校园二手物品交易平台；SSM框架；Mysql；自动化

  1. package com.controller;
  2.  
  3. import java.text.SimpleDateFormat;
  4. import java.util.ArrayList;
  5. import java.util.Arrays;
  6. import java.util.Calendar;
  7. import java.util.Map;
  8. import java.util.HashMap;
  9. import java.util.Iterator;
  10. import java.util.Date;
  11. import java.util.List;
  12. import javax.servlet.http.HttpServletRequest;
  13.  
  14. import com.utils.ValidatorUtils;
  15. import org.apache.commons.lang3.StringUtils;
  16. import org.springframework.beans.factory.annotation.Autowired;
  17. import org.springframework.web.bind.annotation.PathVariable;
  18. import org.springframework.web.bind.annotation.RequestBody;
  19. import org.springframework.web.bind.annotation.RequestMapping;
  20. import org.springframework.web.bind.annotation.RequestParam;
  21. import org.springframework.web.bind.annotation.RestController;
  22. import com.baomidou.mybatisplus.mapper.EntityWrapper;
  23. import com.baomidou.mybatisplus.mapper.Wrapper;
  24. import com.annotation.IgnoreAuth;
  25.  
  26. import com.entity.ShangpinxinxiEntity;
  27. import com.entity.view.ShangpinxinxiView;
  28.  
  29. import com.service.ShangpinxinxiService;
  30. import com.service.TokenService;
  31. import com.utils.PageUtils;
  32. import com.utils.R;
  33. import com.utils.MD5Util;
  34. import com.utils.MPUtil;
  35. import com.utils.CommonUtil;
  36.  
  37.  
  38. /**
  39.  * 商品信息
  40.  * 后端接口
  41.  * @author 
  42.  * @email 
  43.  * @date 2023-09-01 17:42:09
  44.  */
  45. @RestController
  46. @RequestMapping("/shangpinxinxi")
  47. public class ShangpinxinxiController {
  48.     @Autowired
  49.     private ShangpinxinxiService shangpinxinxiService;
  50.     
  51.  
  52.  
  53.     /**
  54.      * 后端列表
  55.      */
  56.     @RequestMapping("/page")
  57.     public R page(@RequestParam Map<String, Object> params,ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request){
  58.  
  59. 		String tableName = request.getSession().getAttribute("tableName").toString();
  60. 		if(tableName.equals("shangjia")) {
  61. 			shangpinxinxi.setZhanghao((String)request.getSession().getAttribute("username"));
  62. 		}
  63.         EntityWrapper<ShangpinxinxiEntity> ew = new EntityWrapper<ShangpinxinxiEntity>();
  64. 		PageUtils page = shangpinxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shangpinxinxi), params), params));
  65.         return R.ok().put("data", page);
  66.     }
  67.     
  68.     /**
  69.      * 前端列表
  70.      */
  71. 	@IgnoreAuth
  72.     @RequestMapping("/list")
  73.     public R list(@RequestParam Map<String, Object> params,ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request){
  74.         EntityWrapper<ShangpinxinxiEntity> ew = new EntityWrapper<ShangpinxinxiEntity>();
  75. 		PageUtils page = shangpinxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shangpinxinxi), params), params));
  76.         return R.ok().put("data", page);
  77.     }
  78.  
  79. 	/**
  80.      * 列表
  81.      */
  82.     @RequestMapping("/lists")
  83.     public R list( ShangpinxinxiEntity shangpinxinxi){
  84.        	EntityWrapper<ShangpinxinxiEntity> ew = new EntityWrapper<ShangpinxinxiEntity>();
  85.       	ew.allEq(MPUtil.allEQMapPre( shangpinxinxi, "shangpinxinxi")); 
  86.         return R.ok().put("data", shangpinxinxiService.selectListView(ew));
  87.     }
  88.  
  89. 	 /**
  90.      * 查询
  91.      */
  92.     @RequestMapping("/query")
  93.     public R query(ShangpinxinxiEntity shangpinxinxi){
  94.         EntityWrapper< ShangpinxinxiEntity> ew = new EntityWrapper< ShangpinxinxiEntity>();
  95.  		ew.allEq(MPUtil.allEQMapPre( shangpinxinxi, "shangpinxinxi")); 
  96. 		ShangpinxinxiView shangpinxinxiView =  shangpinxinxiService.selectView(ew);
  97. 		return R.ok("查询商品信息成功").put("data", shangpinxinxiView);
  98.     }
  99. 	
  100.     /**
  101.      * 后端详情
  102.      */
  103.     @RequestMapping("/info/{id}")
  104.     public R info(@PathVariable("id") Long id){
  105.         ShangpinxinxiEntity shangpinxinxi = shangpinxinxiService.selectById(id);
  106. 		shangpinxinxi.setClicknum(shangpinxinxi.getClicknum()+1);
  107. 		shangpinxinxi.setClicktime(new Date());
  108. 		shangpinxinxiService.updateById(shangpinxinxi);
  109.         return R.ok().put("data", shangpinxinxi);
  110.     }
  111.  
  112.     /**
  113.      * 前端详情
  114.      */
  115.     @RequestMapping("/detail/{id}")
  116.     public R detail(@PathVariable("id") Long id){
  117.         ShangpinxinxiEntity shangpinxinxi = shangpinxinxiService.selectById(id);
  118. 		shangpinxinxi.setClicknum(shangpinxinxi.getClicknum()+1);
  119. 		shangpinxinxi.setClicktime(new Date());
  120. 		shangpinxinxiService.updateById(shangpinxinxi);
  121.         return R.ok().put("data", shangpinxinxi);
  122.     }
  123.     
  124.  
  125.  
  126.  
  127.     /**
  128.      * 后端保存
  129.      */
  130.     @RequestMapping("/save")
  131.     public R save(@RequestBody ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request){
  132.     	shangpinxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
  133.     	//ValidatorUtils.validateEntity(shangpinxinxi);
  134.  
  135.         shangpinxinxiService.insert(shangpinxinxi);
  136.         return R.ok();
  137.     }
  138.     
  139.     /**
  140.      * 前端保存
  141.      */
  142.     @RequestMapping("/add")
  143.     public R add(@RequestBody ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request){
  144.     	shangpinxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
  145.     	//ValidatorUtils.validateEntity(shangpinxinxi);
  146.  
  147.         shangpinxinxiService.insert(shangpinxinxi);
  148.         return R.ok();
  149.     }
  150.  
  151.     /**
  152.      * 修改
  153.      */
  154.     @RequestMapping("/update")
  155.     public R update(@RequestBody ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request){
  156.         //ValidatorUtils.validateEntity(shangpinxinxi);
  157.         shangpinxinxiService.updateById(shangpinxinxi);//全部更新
  158.         return R.ok();
  159.     }
  160.     
  161.  
  162.     /**
  163.      * 删除
  164.      */
  165.     @RequestMapping("/delete")
  166.     public R delete(@RequestBody Long[] ids){
  167.         shangpinxinxiService.deleteBatchIds(Arrays.asList(ids));
  168.         return R.ok();
  169.     }
  170.     
  171.     /**
  172.      * 提醒接口
  173.      */
  174. 	@RequestMapping("/remind/{columnName}/{type}")
  175. 	public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request, 
  176. 						 @PathVariable("type") String type,@RequestParam Map<String, Object> map) {
  177. 		map.put("column", columnName);
  178. 		map.put("type", type);
  179. 		
  180. 		if(type.equals("2")) {
  181. 			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  182. 			Calendar c = Calendar.getInstance();
  183. 			Date remindStartDate = null;
  184. 			Date remindEndDate = null;
  185. 			if(map.get("remindstart")!=null) {
  186. 				Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
  187. 				c.setTime(new Date()); 
  188. 				c.add(Calendar.DAY_OF_MONTH,remindStart);
  189. 				remindStartDate = c.getTime();
  190. 				map.put("remindstart", sdf.format(remindStartDate));
  191. 			}
  192. 			if(map.get("remindend")!=null) {
  193. 				Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
  194. 				c.setTime(new Date());
  195. 				c.add(Calendar.DAY_OF_MONTH,remindEnd);
  196. 				remindEndDate = c.getTime();
  197. 				map.put("remindend", sdf.format(remindEndDate));
  198. 			}
  199. 		}
  200. 		
  201. 		Wrapper<ShangpinxinxiEntity> wrapper = new EntityWrapper<ShangpinxinxiEntity>();
  202. 		if(map.get("remindstart")!=null) {
  203. 			wrapper.ge(columnName, map.get("remindstart"));
  204. 		}
  205. 		if(map.get("remindend")!=null) {
  206. 			wrapper.le(columnName, map.get("remindend"));
  207. 		}
  208.  
  209. 		String tableName = request.getSession().getAttribute("tableName").toString();
  210. 		if(tableName.equals("shangjia")) {
  211. 			wrapper.eq("zhanghao", (String)request.getSession().getAttribute("username"));
  212. 		}
  213.  
  214. 		int count = shangpinxinxiService.selectCount(wrapper);
  215. 		return R.ok().put("count", count);
  216. 	}
  217. 	
  218. 	/**
  219.      * 前端智能排序
  220.      */
  221. 	@IgnoreAuth
  222.     @RequestMapping("/autoSort")
  223.     public R autoSort(@RequestParam Map<String, Object> params,ShangpinxinxiEntity shangpinxinxi, HttpServletRequest request,String pre){
  224.         EntityWrapper<ShangpinxinxiEntity> ew = new EntityWrapper<ShangpinxinxiEntity>();
  225.         Map<String, Object> newMap = new HashMap<String, Object>();
  226.         Map<String, Object> param = new HashMap<String, Object>();
  227. 		Iterator<Map.Entry<String, Object>> it = param.entrySet().iterator();
  228. 		while (it.hasNext()) {
  229. 			Map.Entry<String, Object> entry = it.next();
  230. 			String key = entry.getKey();
  231. 			String newKey = entry.getKey();
  232. 			if (pre.endsWith(".")) {
  233. 				newMap.put(pre + newKey, entry.getValue());
  234. 			} else if (StringUtils.isEmpty(pre)) {
  235. 				newMap.put(newKey, entry.getValue());
  236. 			} else {
  237. 				newMap.put(pre + "." + newKey, entry.getValue());
  238. 			}
  239. 		}
  240. 		params.put("sort", "clicknum");
  241.         
  242.         params.put("order", "desc");
  243. 		PageUtils page = shangpinxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shangpinxinxi), params), params));
  244.         return R.ok().put("data", page);
  245.     }
  246.  
  247.  
  248. }
  1. package com.controller;
  2.  
  3. import java.io.File;
  4. import java.io.FileNotFoundException;
  5. import java.io.IOException;
  6. import java.text.SimpleDateFormat;
  7. import java.util.ArrayList;
  8. import java.util.Calendar;
  9. import java.util.Date;
  10. import java.util.HashMap;
  11. import java.util.List;
  12. import java.util.Map;
  13.  
  14. import javax.servlet.http.HttpServletRequest;
  15.  
  16. import org.apache.commons.lang3.StringUtils;
  17. import org.json.JSONObject;
  18. import org.slf4j.Logger;
  19. import org.slf4j.LoggerFactory;
  20. import org.springframework.beans.factory.annotation.Autowired;
  21. import org.springframework.util.ResourceUtils;
  22. import org.springframework.web.bind.annotation.PathVariable;
  23. import org.springframework.web.bind.annotation.RequestBody;
  24. import org.springframework.web.bind.annotation.RequestMapping;
  25. import org.springframework.web.bind.annotation.RequestParam;
  26. import org.springframework.web.bind.annotation.RestController;
  27.  
  28. import com.annotation.IgnoreAuth;
  29. import com.baidu.aip.face.AipFace;
  30. import com.baidu.aip.face.MatchRequest;
  31. import com.baidu.aip.util.Base64Util;
  32. import com.baomidou.mybatisplus.mapper.EntityWrapper;
  33. import com.baomidou.mybatisplus.mapper.Wrapper;
  34. import com.entity.ConfigEntity;
  35. import com.service.CommonService;
  36. import com.service.ConfigService;
  37. import com.utils.BaiduUtil;
  38. import com.utils.FileUtil;
  39. import com.utils.R;
  40.  
  41. /**
  42.  * 通用接口
  43.  */
  44. @RestController
  45. public class CommonController{
  46. 	private static final Logger logger = LoggerFactory.getLogger(CommonController.class);
  47. 	@Autowired
  48. 	private CommonService commonService;
  49. 	
  50. 	@Autowired
  51. 	private ConfigService configService;
  52. 	
  53. 	private static AipFace client = null;
  54. 	
  55. 	private static String BAIDU_DITU_AK = null;
  56. 	
  57. 	@RequestMapping("/location")
  58. 	public R location(String lng,String lat) {
  59. 		if(BAIDU_DITU_AK==null) {
  60. 			BAIDU_DITU_AK = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "baidu_ditu_ak")).getValue();
  61. 			if(BAIDU_DITU_AK==null) {
  62. 				return R.error("请在配置管理中正确配置baidu_ditu_ak");
  63. 			}
  64. 		}
  65. 		Map<String, String> map = BaiduUtil.getCityByLonLat(BAIDU_DITU_AK, lng, lat);
  66. 		return R.ok().put("data", map);
  67. 	}
  68. 	
  69. 	/**
  70. 	 * 人脸比对
  71. 	 * 
  72. 	 * @param face1 人脸1
  73. 	 * @param face2 人脸2
  74. 	 * @return
  75. 	 */
  76. 	@RequestMapping("/matchFace")
  77. 	public R matchFace(String face1, String face2, HttpServletRequest request) {
  78. 		if(client==null) {
  79. 			/*String AppID = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "AppID")).getValue();*/
  80. 			String APIKey = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "APIKey")).getValue();
  81. 			String SecretKey = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "SecretKey")).getValue();
  82. 			String token = BaiduUtil.getAuth(APIKey, SecretKey);
  83. 			if(token==null) {
  84. 				return R.error("请在配置管理中正确配置APIKey和SecretKey");
  85. 			}
  86. 			client = new AipFace(null, APIKey, SecretKey);
  87. 			client.setConnectionTimeoutInMillis(2000);
  88. 			client.setSocketTimeoutInMillis(60000);
  89. 		}
  90. 		JSONObject res = null;
  91. 		try {
  92. 			File file1 = new File(request.getSession().getServletContext().getRealPath("/upload")+"/"+face1);
  93. 			File file2 = new File(request.getSession().getServletContext().getRealPath("/upload")+"/"+face2);
  94. 			String img1 = Base64Util.encode(FileUtil.FileToByte(file1));
  95. 			String img2 = Base64Util.encode(FileUtil.FileToByte(file2));
  96. 			MatchRequest req1 = new MatchRequest(img1, "BASE64");
  97. 			MatchRequest req2 = new MatchRequest(img2, "BASE64");
  98. 			ArrayList<MatchRequest> requests = new ArrayList<MatchRequest>();
  99. 			requests.add(req1);
  100. 			requests.add(req2);
  101. 			res = client.match(requests);
  102. 			System.out.println(res.get("result"));
  103. 		} catch (FileNotFoundException e) {
  104. 			e.printStackTrace();
  105. 			return R.error("文件不存在");
  106. 		} catch (IOException e) {
  107. 			e.printStackTrace();
  108. 		} 
  109. 		return R.ok().put("data", com.alibaba.fastjson.JSONObject.parse(res.get("result").toString()));
  110. 	}
  111.     
  112. 	/**
  113. 	 * 获取table表中的column列表(联动接口)
  114. 	 * @return
  115. 	 */
  116. 	@RequestMapping("/option/{tableName}/{columnName}")
  117. 	@IgnoreAuth
  118. 	public R getOption(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName,String level,String parent) {
  119. 		Map<String, Object> params = new HashMap<String, Object>();
  120. 		params.put("table", tableName);
  121. 		params.put("column", columnName);
  122. 		if(StringUtils.isNotBlank(level)) {
  123. 			params.put("level", level);
  124. 		}
  125. 		if(StringUtils.isNotBlank(parent)) {
  126. 			params.put("parent", parent);
  127. 		}
  128. 		List<String> data = commonService.getOption(params);
  129. 		return R.ok().put("data", data);
  130. 	}
  131. 	
  132. 	/**
  133. 	 * 根据table中的column获取单条记录
  134. 	 * @return
  135. 	 */
  136. 	@RequestMapping("/follow/{tableName}/{columnName}")
  137. 	@IgnoreAuth
  138. 	public R getFollowByOption(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName, @RequestParam String columnValue) {
  139. 		Map<String, Object> params = new HashMap<String, Object>();
  140. 		params.put("table", tableName);
  141. 		params.put("column", columnName);
  142. 		params.put("columnValue", columnValue);
  143. 		Map<String, Object> result = commonService.getFollowByOption(params);
  144. 		return R.ok().put("data", result);
  145. 	}
  146. 	
  147. 	/**
  148. 	 * 修改table表的sfsh状态
  149. 	 * @param map
  150. 	 * @return
  151. 	 */
  152. 	@RequestMapping("/sh/{tableName}")
  153. 	public R sh(@PathVariable("tableName") String tableName, @RequestBody Map<String, Object> map) {
  154. 		map.put("table", tableName);
  155. 		commonService.sh(map);
  156. 		return R.ok();
  157. 	}
  158. 	
  159. 	/**
  160. 	 * 获取需要提醒的记录数
  161. 	 * @param tableName
  162. 	 * @param columnName
  163. 	 * @param type 1:数字 2:日期
  164. 	 * @param map
  165. 	 * @return
  166. 	 */
  167. 	@RequestMapping("/remind/{tableName}/{columnName}/{type}")
  168. 	@IgnoreAuth
  169. 	public R remindCount(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName, 
  170. 						 @PathVariable("type") String type,@RequestParam Map<String, Object> map) {
  171. 		map.put("table", tableName);
  172. 		map.put("column", columnName);
  173. 		map.put("type", type);
  174. 		
  175. 		if(type.equals("2")) {
  176. 			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  177. 			Calendar c = Calendar.getInstance();
  178. 			Date remindStartDate = null;
  179. 			Date remindEndDate = null;
  180. 			if(map.get("remindstart")!=null) {
  181. 				Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
  182. 				c.setTime(new Date()); 
  183. 				c.add(Calendar.DAY_OF_MONTH,remindStart);
  184. 				remindStartDate = c.getTime();
  185. 				map.put("remindstart", sdf.format(remindStartDate));
  186. 			}
  187. 			if(map.get("remindend")!=null) {
  188. 				Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
  189. 				c.setTime(new Date());
  190. 				c.add(Calendar.DAY_OF_MONTH,remindEnd);
  191. 				remindEndDate = c.getTime();
  192. 				map.put("remindend", sdf.format(remindEndDate));
  193. 			}
  194. 		}
  195. 		
  196. 		int count = commonService.remindCount(map);
  197. 		return R.ok().put("count", count);
  198. 	}
  199.  
  200. 	/**
  201. 	 * 圖表统计
  202. 	 */
  203. 	@IgnoreAuth
  204. 	@RequestMapping("/group/{tableName}")
  205. 	public R group1(@PathVariable("tableName") String tableName, @RequestParam Map<String,Object> params) {
  206. 		params.put("table1", tableName);
  207. 		List<Map<String, Object>> result = commonService.chartBoth(params);
  208. 		return R.ok().put("data", result);
  209. 	}
  210.  
  211. 	
  212. 	/**
  213. 	 * 单列求和
  214. 	 */
  215. 	@RequestMapping("/cal/{tableName}/{columnName}")
  216. 	@IgnoreAuth
  217. 	public R cal(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName) {
  218. 		Map<String, Object> params = new HashMap<String, Object>();
  219. 		params.put("table", tableName);
  220. 		params.put("column", columnName);
  221. 		Map<String, Object> result = commonService.selectCal(params);
  222. 		return R.ok().put("data", result);
  223. 	}
  224. 	
  225. 	/**
  226. 	 * 分组统计
  227. 	 */
  228. 	@RequestMapping("/group/{tableName}/{columnName}")
  229. 	@IgnoreAuth
  230. 	public R group(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName) {
  231. 		Map<String, Object> params = new HashMap<String, Object>();
  232. 		params.put("table", tableName);
  233. 		params.put("column", columnName);
  234. 		List<Map<String, Object>> result = commonService.selectGroup(params);
  235. 		return R.ok().put("data", result);
  236. 	}
  237. 	
  238. 	/**
  239. 	 * （按值统计）
  240. 	 */
  241. 	@RequestMapping("/value/{tableName}/{xColumnName}/{yColumnName}")
  242. 	@IgnoreAuth
  243. 	public R value(@PathVariable("tableName") String tableName, @PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName) {
  244. 		Map<String, Object> params = new HashMap<String, Object>();
  245. 		params.put("table", tableName);
  246. 		params.put("xColumn", xColumnName);
  247. 		params.put("yColumn", yColumnName);
  248. 		List<Map<String, Object>> result = commonService.selectValue(params);
  249. 		return R.ok().put("data", result);
  250. 	}
  251.  
  252.  
  253. 	/**
  254. 	 * 下面为新加的
  255. 	 *
  256. 	 *
  257. 	 *
  258. 	 */
  259.  
  260. 	/**
  261. 	 * 分组求和
  262. 	 */
  263. 	@RequestMapping("/sum/group")
  264. 	@IgnoreAuth
  265. 	public R newSelectGroupSum(/*@PathVariable("tableName") String tableName, @PathVariable("groupColumn") String groupColumn, @PathVariable("sumCloum") String sumCloum*/) {
  266. //		logger.debug("newSelectGroupSum:,,Controller:{},,tableName:{},groupColumn:{},sumCloum:{}",this.getClass().getName(),tableName,groupColumn,sumCloum);
  267. 		logger.debug("newSelectGroupSum");
  268. 		Map<String, Object> params = new HashMap<String, Object>();
  269. //		params.put("tableName", tableName);
  270. //		params.put("groupColumn", groupColumn);
  271. //		params.put("sumColumn", sumCloum);
  272. 		List<Map<String, Object>> result = commonService.newSelectGroupSum(params);
  273. 		return R.ok().put("data", result);
  274. 	}
  275.  
  276. 	/**
  277. 	 * 查询字典表的分组统计总条数
  278. 	 * @param tableName  		表名
  279. 	 * @param groupColumn  		分组字段
  280. 	 * @return
  281. 	 */
  282. 	@RequestMapping("/count/group/{tableName}/{groupColumn}")
  283. 	@IgnoreAuth
  284. 	public R newSelectGroupCount(@PathVariable("tableName") String tableName, @PathVariable("groupColumn") String groupColumn) {
  285. 		logger.debug("newSelectGroupCount:,,Controller:{},,tableName:{},groupColumn:{}",this.getClass().getName(),tableName,groupColumn);
  286. 		Map<String, Object> params = new HashMap<String, Object>();
  287. 		params.put("tableName", tableName);
  288. 		params.put("groupColumn", groupColumn);
  289. 		List<Map<String, Object>> result = commonService.newSelectGroupCount(params);
  290. 		return R.ok().put("data", result);
  291. 	}
  292.  
  293.  
  294. 	/**
  295. 	 * 当前表的日期分组求和
  296. 	 * @param tableName  		表名
  297. 	 * @param groupColumn  		分组字段
  298. 	 * @param sumCloum			统计字段
  299. 	 * @param dateFormatType	日期格式化类型   1:年 2:月 3:日
  300. 	 * @return
  301. 	 */
  302. 	@RequestMapping("/sum/group/{tableName}/{groupColumn}/{sumCloum}/{dateFormatType}")
  303. 	@IgnoreAuth
  304. 	public R newSelectDateGroupSum(@PathVariable("tableName") String tableName, @PathVariable("groupColumn") String groupColumn, @PathVariable("sumCloum") String sumCloum, @PathVariable("dateFormatType") String dateFormatType) {
  305. 		logger.debug("newSelectDateGroupSum:,,Controller:{},,tableName:{},groupColumn:{},sumCloum:{},dateFormatType:{}",this.getClass().getName(),tableName,groupColumn,sumCloum,dateFormatType);
  306. 		Map<String, Object> params = new HashMap<String, Object>();
  307. 		params.put("tableName", tableName);
  308. 		params.put("groupColumn", groupColumn);
  309. 		params.put("sumColumn", sumCloum);
  310. 		if("1".equals(dateFormatType)){
  311. 			params.put("dateFormat", "%Y");
  312. 		}else if("2".equals(dateFormatType)){
  313. 			params.put("dateFormat", "%Y-%m");
  314. 		}else if("3".equals(dateFormatType)){
  315. 			params.put("dateFormat", "%Y-%m-%d");
  316. 		}else{
  317. 			R.error("日期格式化不正确");
  318. 		}
  319. 		List<Map<String, Object>> result = commonService.newSelectDateGroupSum(params);
  320. 		return R.ok().put("data", result);
  321. 	}
  322.  
  323. 	/**
  324. 	 *
  325. 	 * 查询字典表的分组统计总条数
  326. 	 * @param tableName  		表名
  327. 	 * @param groupColumn  		分组字段
  328. 	 * @param dateFormatType	日期格式化类型   1:年 2:月 3:日
  329. 	 * @return
  330. 	 */
  331. 	@RequestMapping("/count/group/{tableName}/{groupColumn}/{dateFormatType}")
  332. 	@IgnoreAuth
  333. 	public R newSelectDateGroupCount(@PathVariable("tableName") String tableName, @PathVariable("groupColumn") String groupColumn, @PathVariable("dateFormatType") String dateFormatType) {
  334. 		logger.debug("newSelectDateGroupCount:,,Controller:{},,tableName:{},groupColumn:{},dateFormatType:{}",this.getClass().getName(),tableName,groupColumn,dateFormatType);
  335. 		Map<String, Object> params = new HashMap<String, Object>();
  336. 		params.put("tableName", tableName);
  337. 		params.put("groupColumn", groupColumn);
  338. 		if("1".equals(dateFormatType)){
  339. 			params.put("dateFormat", "%Y");
  340. 		}else if("2".equals(dateFormatType)){
  341. 			params.put("dateFormat", "%Y-%m");
  342. 		}else if("3".equals(dateFormatType)){
  343. 			params.put("dateFormat", "%Y-%m-%d");
  344. 		}else{
  345. 			R.error("日期格式化类型不正确");
  346. 		}
  347. 		List<Map<String, Object>> result = commonService.newSelectDateGroupCount(params);
  348. 		return R.ok().put("data", result);
  349. 	}
  350.  
  351. 	/**
  352. 	 * 字段加数字
  353. 	 * @param tableName 表名
  354. 	 * @param id		id
  355. 	 * @param column	字段
  356. 	 * @param number	数量
  357. 	 * @return
  358. 	 */
  359. 	@RequestMapping("/plus/{tableName}/{id}/{column}/{number}")
  360. 	public R plusCloumNumber(@PathVariable("tableName") String tableName, @PathVariable("id") Integer id, @PathVariable("column") String column, @PathVariable("number") String number) {
  361. 		logger.debug("plusCloumNumber:,,Controller:{},,tableName:{},id:{},column:{},number:{}",this.getClass().getName(),tableName,id,column,number);
  362. 		Map<String, Object> params = new HashMap<String, Object>();
  363. 		params.put("tableName", tableName);
  364. 		params.put("id", id);
  365. 		params.put("column", column);
  366. 		params.put("number", number);
  367. 		int i = commonService.plusCloumNumber(params);
  368. 		if(i>0){
  369. 			return R.ok();
  370. 		}
  371. 		return R.error("添加失败");
  372. 	}
  373.  
  374. 	/**
  375. 	 * 字段减数字
  376. 	 * @param tableName
  377. 	 * @param id
  378. 	 * @param column
  379. 	 * @param number
  380. 	 * @return
  381. 	 */
  382. 	@RequestMapping("/reduce/{tableName}/{id}/{column}/{number}")
  383. 	public R reduceCloumNumber(@PathVariable("tableName") String tableName, @PathVariable("id") Integer id, @PathVariable("column") String column, @PathVariable("number") String number) {
  384. 		logger.debug("reduceCloumNumber:,,Controller:{},,tableName:{},id:{},column:{},number:{}",this.getClass().getName(),tableName,id,column,number);
  385. 		Map<String, Object> params = new HashMap<String, Object>();
  386. 		params.put("tableName", tableName);
  387. 		params.put("id", id);
  388. 		params.put("column", column);
  389. 		params.put("number", number);
  390. 		int i = commonService.reduceCloumNumber(params);
  391. 		if(i>0){
  392. 			return R.ok();
  393. 		}
  394. 		return R.error("添加失败");
  395. 	}
  396.  
  397. 	@RequestMapping("/update/{tableName}/{id}/{column}/{value}")
  398. 	public R updateCloumValue(@PathVariable("tableName") String tableName, @PathVariable("id") Integer id, @PathVariable("column") String column, @PathVariable("value") String value) {
  399. 		logger.debug("updateCloumValue:,,Controller:{},,tableName:{},id:{},column:{},number:{}",this.getClass().getName(),tableName,id,column,value);
  400. 		Map<String, Object> params = new HashMap<String, Object>();
  401. 		params.put("tableName", tableName);
  402. 		params.put("id", id);
  403. 		params.put("column", column);
  404. 		params.put("value", value);
  405. 		int i = commonService.updateCloumValue(params);
  406. 		if(i>0){
  407. 			return R.ok();
  408. 		}
  409. 		return R.error("添加失败");
  410. 	}
  411.  
  412.  
  413.  
  414. }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小小林熬夜学编程/article/detail/205076?site
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号