网站建设行业发展状况,余姚网站seo运营,百度网盘搜索引擎网站,手机wordpress无法登录ssm学生公寓管理系统的设计与实现106 开发工具#xff1a;idea 数据库mysql5.7 数据库链接工具#xff1a;navcat,小海豚等 技术#xff1a;ssm 摘 要
现代经济快节奏发展以及不断完善升级的信息化技术#xff0c;让传统数据信息的管理升级为软件存储#xff0c;归…ssm学生公寓管理系统的设计与实现106 开发工具idea 数据库mysql5.7 数据库链接工具navcat,小海豚等 技术ssm 摘 要
现代经济快节奏发展以及不断完善升级的信息化技术让传统数据信息的管理升级为软件存储归纳集中处理数据信息的管理方式。本学生公寓管理系统就是在这样的大环境下诞生其可以帮助管理者在短时间内处理完毕庞大的数据信息使用这种软件工具可以帮助管理人员提高事务处理效率达到事半功倍的效果。此学生公寓管理系统利用当下成熟完善的SSM框架使用跨平台的可开发大型商业网站的Java语言以及最受欢迎的RDBMS应用软件之一的Mysql数据库进行程序开发。实现了学生基础数据的管理宿舍信息管理访客信息管理卫生信息管理,班级信息管理的发布等功能。学生公寓管理系统的开发根据操作人员需要设计的界面简洁美观在功能模块布局上跟同类型网站保持一致程序在实现基本要求功能时也为数据信息面临的安全问题提供了一些实用的解决方案。可以说该程序在帮助管理者高效率地处理工作事务的同时也实现了数据信息的整体化规范化与自动化。 关键词学生公寓管理系统SSM框架Mysql自动化 package com.controller;import java.io.File;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;import javax.servlet.http.HttpServletRequest;import org.apache.commons.lang3.StringUtils;
import org.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.util.ResourceUtils;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;import com.annotation.IgnoreAuth;
import com.baidu.aip.face.AipFace;
import com.baidu.aip.face.MatchRequest;
import com.baidu.aip.util.Base64Util;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.entity.ConfigEntity;
import com.service.CommonService;
import com.service.ConfigService;
import com.utils.BaiduUtil;
import com.utils.FileUtil;
import com.utils.R;/*** 通用接口*/
RestController
public class CommonController{Autowiredprivate CommonService commonService;Autowiredprivate ConfigService configService;private static AipFace client null;private static String BAIDU_DITU_AK null;RequestMapping(/location)public R location(String lng,String lat) {if(BAIDU_DITU_AKnull) {BAIDU_DITU_AK configService.selectOne(new EntityWrapperConfigEntity().eq(name, baidu_ditu_ak)).getValue();if(BAIDU_DITU_AKnull) {return R.error(请在配置管理中正确配置baidu_ditu_ak);}}MapString, String map BaiduUtil.getCityByLonLat(BAIDU_DITU_AK, lng, lat);return R.ok().put(data, map);}/*** 人脸比对* * param face1 人脸1* param face2 人脸2* return*/RequestMapping(/matchFace)public R matchFace(String face1, String face2, HttpServletRequest request) {if(clientnull) {/*String AppID configService.selectOne(new EntityWrapperConfigEntity().eq(name, AppID)).getValue();*/String APIKey configService.selectOne(new EntityWrapperConfigEntity().eq(name, APIKey)).getValue();String SecretKey configService.selectOne(new EntityWrapperConfigEntity().eq(name, SecretKey)).getValue();String token BaiduUtil.getAuth(APIKey, SecretKey);if(tokennull) {return R.error(请在配置管理中正确配置APIKey和SecretKey);}client new AipFace(null, APIKey, SecretKey);client.setConnectionTimeoutInMillis(2000);client.setSocketTimeoutInMillis(60000);}JSONObject res null;try {File file1 new File(request.getSession().getServletContext().getRealPath(/upload)/face1);File file2 new File(request.getSession().getServletContext().getRealPath(/upload)/face2);String img1 Base64Util.encode(FileUtil.FileToByte(file1));String img2 Base64Util.encode(FileUtil.FileToByte(file2));MatchRequest req1 new MatchRequest(img1, BASE64);MatchRequest req2 new MatchRequest(img2, BASE64);ArrayListMatchRequest requests new ArrayListMatchRequest();requests.add(req1);requests.add(req2);res client.match(requests);System.out.println(res.get(result));} catch (FileNotFoundException e) {e.printStackTrace();return R.error(文件不存在);} catch (IOException e) {e.printStackTrace();} return R.ok().put(data, com.alibaba.fastjson.JSONObject.parse(res.get(result).toString()));}/*** 获取table表中的column列表(联动接口)* return*/RequestMapping(/option/{tableName}/{columnName})IgnoreAuthpublic R getOption(PathVariable(tableName) String tableName, PathVariable(columnName) String columnName,String level,String parent) {MapString, Object params new HashMapString, Object();params.put(table, tableName);params.put(column, columnName);if(StringUtils.isNotBlank(level)) {params.put(level, level);}if(StringUtils.isNotBlank(parent)) {params.put(parent, parent);}ListString data commonService.getOption(params);return R.ok().put(data, data);}/*** 根据table中的column获取单条记录* return*/RequestMapping(/follow/{tableName}/{columnName})IgnoreAuthpublic R getFollowByOption(PathVariable(tableName) String tableName, PathVariable(columnName) String columnName, RequestParam String columnValue) {MapString, Object params new HashMapString, Object();params.put(table, tableName);params.put(column, columnName);params.put(columnValue, columnValue);MapString, Object result commonService.getFollowByOption(params);return R.ok().put(data, result);}/*** 修改table表的sfsh状态* param map* return*/RequestMapping(/sh/{tableName})public R sh(PathVariable(tableName) String tableName, RequestBody MapString, Object map) {map.put(table, tableName);commonService.sh(map);return R.ok();}/*** 获取需要提醒的记录数* param tableName* param columnName* param type 1:数字 2:日期* param map* return*/RequestMapping(/remind/{tableName}/{columnName}/{type})IgnoreAuthpublic R remindCount(PathVariable(tableName) String tableName, PathVariable(columnName) String columnName, PathVariable(type) String type,RequestParam MapString, Object map) {map.put(table, tableName);map.put(column, columnName);map.put(type, type);if(type.equals(2)) {SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);Calendar c Calendar.getInstance();Date remindStartDate null;Date remindEndDate null;if(map.get(remindstart)!null) {Integer remindStart Integer.parseInt(map.get(remindstart).toString());c.setTime(new Date()); c.add(Calendar.DAY_OF_MONTH,remindStart);remindStartDate c.getTime();map.put(remindstart, sdf.format(remindStartDate));}if(map.get(remindend)!null) {Integer remindEnd Integer.parseInt(map.get(remindend).toString());c.setTime(new Date());c.add(Calendar.DAY_OF_MONTH,remindEnd);remindEndDate c.getTime();map.put(remindend, sdf.format(remindEndDate));}}int count commonService.remindCount(map);return R.ok().put(count, count);}/*** 圖表统计*/IgnoreAuthRequestMapping(/group/{tableName})public R group1(PathVariable(tableName) String tableName, RequestParam MapString,Object params) {params.put(table1, tableName);ListMapString, Object result commonService.chartBoth(params);return R.ok().put(data, result);}/*** 单列求和*/RequestMapping(/cal/{tableName}/{columnName})IgnoreAuthpublic R cal(PathVariable(tableName) String tableName, PathVariable(columnName) String columnName) {MapString, Object params new HashMapString, Object();params.put(table, tableName);params.put(column, columnName);MapString, Object result commonService.selectCal(params);return R.ok().put(data, result);}/*** 分组统计*/RequestMapping(/group/{tableName}/{columnName})IgnoreAuthpublic R group(PathVariable(tableName) String tableName, PathVariable(columnName) String columnName) {MapString, Object params new HashMapString, Object();params.put(table, tableName);params.put(column, columnName);ListMapString, Object result commonService.selectGroup(params);return R.ok().put(data, result);}/*** 按值统计*/RequestMapping(/value/{tableName}/{xColumnName}/{yColumnName})IgnoreAuthpublic R value(PathVariable(tableName) String tableName, PathVariable(yColumnName) String yColumnName, PathVariable(xColumnName) String xColumnName) {MapString, Object params new HashMapString, Object();params.put(table, tableName);params.put(xColumn, xColumnName);params.put(yColumn, yColumnName);ListMapString, Object result commonService.selectValue(params);return R.ok().put(data, result);}/*** 下面为新加的****//*** 查询字典表的分组求和* param tableName 表名* param groupColumn 分组字段* param sumCloum 统计字段* return*/RequestMapping(/sum/group/{tableName}/{groupColumn}/{sumCloum})IgnoreAuthpublic R newSelectGroupSum(PathVariable(tableName) String tableName, PathVariable(groupColumn) String groupColumn, PathVariable(sumCloum) String sumCloum) {MapString, Object params new HashMapString, Object();params.put(tableName, tableName);params.put(groupColumn, groupColumn);params.put(sumColumn, sumCloum);ListMapString, Object result commonService.newSelectGroupSum(params);return R.ok().put(data, result);}/*** 查询字典表的分组统计总条数* param tableName 表名* param groupColumn 分组字段* return*/RequestMapping(/count/group/{tableName}/{groupColumn})IgnoreAuthpublic R newSelectGroupCount(PathVariable(tableName) String tableName, PathVariable(groupColumn) String groupColumn) {MapString, Object params new HashMapString, Object();params.put(tableName, tableName);params.put(groupColumn, groupColumn);ListMapString, Object result commonService.newSelectGroupCount(params);return R.ok().put(data, result);}/*** 当前表的日期分组求和* param tableName 表名* param groupColumn 分组字段* param sumCloum 统计字段* param dateFormatType 日期格式化类型 1:年 2:月 3:日* return*/// /sum/group/cheliangjilu/insert_time /monery /%Y-%mRequestMapping(/sum/group/{tableName}/{groupColumn}/{sumCloum}/{dateFormatType})IgnoreAuthpublic R newSelectDateGroupSum(PathVariable(tableName) String tableName, PathVariable(groupColumn) String groupColumn, PathVariable(sumCloum) String sumCloum, PathVariable(dateFormatType) String dateFormatType) {MapString, Object params new HashMapString, Object();params.put(tableName, tableName);params.put(groupColumn, groupColumn);params.put(sumColumn, sumCloum);if(1.equals(dateFormatType)){params.put(dateFormat, %Y);}else if(2.equals(dateFormatType)){params.put(dateFormat, %Y-%m);}else if(3.equals(dateFormatType)){params.put(dateFormat, %Y-%m-%d);}else{R.error(日期格式化不正确);}ListMapString, Object result commonService.newSelectDateGroupSum(params);return R.ok().put(data, result);}/**** 查询字典表的分组统计总条数* param tableName 表名* param groupColumn 分组字段* param dateFormatType 日期格式化类型 1:年 2:月 3:日* return*/RequestMapping(/count/group/{tableName}/{groupColumn}/{dateFormatType})IgnoreAuthpublic R newSelectDateGroupCount(PathVariable(tableName) String tableName, PathVariable(groupColumn) String groupColumn, PathVariable(dateFormatType) String dateFormatType) {MapString, Object params new HashMapString, Object();params.put(tableName, tableName);params.put(groupColumn, groupColumn);if(1.equals(dateFormatType)){params.put(dateFormat, %Y);}else if(2.equals(dateFormatType)){params.put(dateFormat, %Y-%m);}else if(3.equals(dateFormatType)){params.put(dateFormat, %Y-%m-%d);}else{R.error(日期格式化类型不正确);}ListMapString, Object result commonService.newSelectDateGroupCount(params);return R.ok().put(data, result);}}package com.controller;import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;import com.entity.NewsEntity;
import com.entity.view.NewsView;import com.service.NewsService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MPUtil;
import com.utils.CommonUtil;/*** 新闻资讯* 后端接口* author * email * date*/
RestController
RequestMapping(/news)
public class NewsController {Autowiredprivate NewsService newsService;/*** 后端列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params,NewsEntity news, HttpServletRequest request){EntityWrapperNewsEntity ew new EntityWrapperNewsEntity();PageUtils page newsService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, news), params), params));request.setAttribute(data, page);return R.ok().put(data, page);}/*** 前端列表*/IgnoreAuthRequestMapping(/list)public R list(RequestParam MapString, Object params,NewsEntity news, HttpServletRequest request){EntityWrapperNewsEntity ew new EntityWrapperNewsEntity();PageUtils page newsService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, news), params), params));request.setAttribute(data, page);return R.ok().put(data, page);}/*** 列表*/RequestMapping(/lists)public R list( NewsEntity news){EntityWrapperNewsEntity ew new EntityWrapperNewsEntity();ew.allEq(MPUtil.allEQMapPre( news, news)); return R.ok().put(data, newsService.selectListView(ew));}/*** 查询*/RequestMapping(/query)public R query(NewsEntity news){EntityWrapper NewsEntity ew new EntityWrapper NewsEntity();ew.allEq(MPUtil.allEQMapPre( news, news)); NewsView newsView newsService.selectView(ew);return R.ok(查询新闻资讯成功).put(data, newsView);}/*** 后端详情*/RequestMapping(/info/{id})public R info(PathVariable(id) String id){NewsEntity news newsService.selectById(id);return R.ok().put(data, news);}/*** 前端详情*/IgnoreAuthRequestMapping(/detail/{id})public R detail(PathVariable(id) String id){NewsEntity news newsService.selectById(id);return R.ok().put(data, news);}/*** 后端保存*/RequestMapping(/save)public R save(RequestBody NewsEntity news, HttpServletRequest request){news.setId(new Date().getTime()new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(news);newsService.insert(news);return R.ok();}/*** 前端保存*/RequestMapping(/add)public R add(RequestBody NewsEntity news, HttpServletRequest request){news.setId(new Date().getTime()new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(news);newsService.insert(news);return R.ok();}/*** 修改*/RequestMapping(/update)public R update(RequestBody NewsEntity news, HttpServletRequest request){//ValidatorUtils.validateEntity(news);newsService.updateById(news);//全部更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Long[] ids){newsService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 提醒接口*/RequestMapping(/remind/{columnName}/{type})public R remindCount(PathVariable(columnName) String columnName, HttpServletRequest request, PathVariable(type) String type,RequestParam MapString, Object map) {map.put(column, columnName);map.put(type, type);if(type.equals(2)) {SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);Calendar c Calendar.getInstance();Date remindStartDate null;Date remindEndDate null;if(map.get(remindstart)!null) {Integer remindStart Integer.parseInt(map.get(remindstart).toString());c.setTime(new Date()); c.add(Calendar.DAY_OF_MONTH,remindStart);remindStartDate c.getTime();map.put(remindstart, sdf.format(remindStartDate));}if(map.get(remindend)!null) {Integer remindEnd Integer.parseInt(map.get(remindend).toString());c.setTime(new Date());c.add(Calendar.DAY_OF_MONTH,remindEnd);remindEndDate c.getTime();map.put(remindend, sdf.format(remindEndDate));}}WrapperNewsEntity wrapper new EntityWrapperNewsEntity();if(map.get(remindstart)!null) {wrapper.ge(columnName, map.get(remindstart));}if(map.get(remindend)!null) {wrapper.le(columnName, map.get(remindend));}int count newsService.selectCount(wrapper);return R.ok().put(count, count);}}
