使用旧方法对面向智慧教育的实习实践系统的信息进行系统化管理已经不再让人们信赖了，把现在的网络信息技术运用在面向智慧教育的实习实践系统的管理上面可以解决许多信息管理上面的难题，比如处理数据时间很长，数据存在错误不能及时纠正等问题。这次开发的面向智慧教育的实习实践系统对字典管理、公告管理、菜单管理、企业管理、任务管理、任务交流管理、任务收藏管理、任务留言管理、任务订单管理、用户管理、管理员管理等进行集中化处理。经过前面自己查阅的网络知识，加上自己在学校课堂上学习的知识，决定开发系统选择小程序模式这种高效率的模式完成系统功能开发。这种模式让操作员基于浏览器的方式进行网站访问，采用的主流的Java语言这种面向对象的语言进行面向智慧教育的实习实践系统程序的开发，在数据库的选择上面，选择功能强大的Mysql数据库进行数据的存放操作。面向智慧教育的实习实践系统的开发让用户查看实践任务信息变得容易，让管理员高效管理实践任务信息。
关键词：面向智慧教育的实习实践系统；实践任务信息；公告；自助资讯
基于springboot面向智慧教育的实习实践系统源码和论文513
演示视频：
基于springboot面向智慧教育的实习实践系统源码和论文
Abstract
Using the old method to systematically manage the tourist attraction information no longer makes people trust. Applying the current network information technology to the management of tourist attraction information can solve many problems in information management, such as processing data for a long time, data There are problems such as errors that cannot be corrected in time. The self-guided website developed this time centralizes the city information of attractions, tourist attractions information, comment information, and self-help information. After learning the network knowledge I had previously consulted and the knowledge I learned in the school classroom, I decided to develop the system to select the 小程序 mode, an efficient mode to complete system function development. This mode allows the operator to access the website based on the browser. The mainstream Java language is used in the object-oriented language to develop the self-guided website program. In the database selection, select the powerful Mysql database for data. Store operation. The development of self-guided websites makes it easy for users to view information on attractions, allowing administrators to efficiently manage information on attractions.
Key Words：Self-guided tour website; tourist attractions; reviews; self-help information
1.1 研究背景
现在大家正处于互联网加的时代，这个时代它就是一个信息内容无比丰富，信息处理与管理变得越加高效的网络化的时代，这个时代让大家的生活不仅变得更加地便利化，也让时间变得更加地宝贵化，因为每天的每分钟，每秒钟这些时间都能让人们处理大批量的日常事务，这些场景，是之前的手工模式无法与之相抗衡的。对于实践任务信息的管理来说，传统的通过纸质文档记录信息的方式已经落后了，依靠手工管理实践任务信息，不仅花费较长的工作时间，在对记录各种信息的文档进行信息查询以及信息核对操作时，也不能及时保证信息的准确性，基于这样的办公低效率环境下，对于实践任务信息的处理就要提出新的解决方案。因为这个时代的信息一直都在高速发展，要是不抱着发展的观念看待事情，极有可能被这个市场快速遗忘，甚至被无情地淘汰掉。所以尽早开发一款面向智慧教育的实习实践系统进行信息的快速处理，既跟上了时代的发展脚步，也能让自己的核心竞争力有所提升。
1.2目的和意义
互联网加的时代一方面是加快信息的发展，另一方面也是对传统行业进行筛选，能够继续发展的，肯定是那些能够充分运用互联网技术进行自身升级改革的行业。那些停步不前的行业只能就此结束，进而被大家所遗忘。这次设计出来的面向智慧教育的实习实践系统，它不仅能够让管理人员在信息增加，信息的编辑等事务处理上，节省很多的时间，也会砍掉一部分的人工成本，节省不必要开支的资金。另外，此系统的操作界面是可视化的界面，管理人员无需付费培训就能尽快上手。面向智慧教育的实习实践系统的开发意义如下：
1、管理人员再也不用在查询信息上花费大量宝贵的时间了，通过信息关键词字段就可以在几秒内获取需要的信息，在各种突发事件面前管理人员也不用慌张，可以从容淡定地处理各种相关信息。
package com.controller;
import java.io.File;
import java.math.BigDecimal;
import java.net.URL;
import java.text.SimpleDateFormat;
import com.alibaba.fastjson.JSONObject;
import java.util.*;
import org.springframework.beans.BeanUtils;
import javax.servlet.http.HttpServletRequest;
import org.springframework.web.context.ContextLoader;
import javax.servlet.ServletContext;
import com.service.TokenService;
import com.utils.*;
import java.lang.reflect.InvocationTargetException;
import com.service.DictionaryService;
import org.apache.commons.lang3.StringUtils;
import com.annotation.IgnoreAuth;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.entity.*;
import com.entity.view.*;
import com.service.*;
import com.utils.PageUtils;
import com.utils.R;
import com.alibaba.fastjson.*;
/**
* 专家
* 后端接口
* @author
* @email
*/
@RestController
@Controller
@RequestMapping("/zhuanjia")
public class ZhuanjiaController {
private static final Logger logger = LoggerFactory.getLogger(ZhuanjiaController.class);
private static final String TABLE_NAME = "zhuanjia";
@Autowired
private ZhuanjiaService zhuanjiaService;
@Autowired
private TokenService tokenService;
@Autowired
private DictionaryService dictionaryService;//字典
@Autowired
private ForumService forumService;//论坛
@Autowired
private GonggaoService gonggaoService;//竞赛公告
@Autowired
private HuojiangService huojiangService;//获奖
@Autowired
private LaoshiService laoshiService;//老师
@Autowired
private PingshenService pingshenService;//评审
@Autowired
private PingshenFenpeiService pingshenFenpeiService;//评审分配
@Autowired
private PingshenPingfenService pingshenPingfenService;//评审打分
@Autowired
private SaishiService saishiService;//赛事
@Autowired
private SaishiTijiaoService saishiTijiaoService;//赛事提交
@Autowired
private SaishiYuyueService saishiYuyueService;//赛事报名
@Autowired
private YonghuService yonghuService;//用户
@Autowired
private UsersService usersService;//管理员
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params, HttpServletRequest request){
logger.debug("page方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
String role = String.valueOf(request.getSession().getAttribute("role"));
if(false)
return R.error(511,"永不会进入");
else if("用户".equals(role))
params.put("yonghuId",request.getSession().getAttribute("userId"));
else if("老师".equals(role))
params.put("laoshiId",request.getSession().getAttribute("userId"));
else if("专家".equals(role))
params.put("zhuanjiaId",request.getSession().getAttribute("userId"));
CommonUtil.checkMap(params);
PageUtils page = zhuanjiaService.queryPage(params);
//字典表数据转换
List<ZhuanjiaView> list =(List<ZhuanjiaView>)page.getList();
for(ZhuanjiaView c:list){
//修改对应字典表字段
dictionaryService.dictionaryConvert(c, request);
}
return R.ok().put("data", page);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id, HttpServletRequest request){
logger.debug("info方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
ZhuanjiaEntity zhuanjia = zhuanjiaService.selectById(id);
if(zhuanjia !=null){
//entity转view
ZhuanjiaView view = new ZhuanjiaView();
BeanUtils.copyProperties( zhuanjia , view );//把实体数据重构到view中
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody ZhuanjiaEntity zhuanjia, HttpServletRequest request){
logger.debug("save方法:,,Controller:{},,zhuanjia:{}",this.getClass().getName(),zhuanjia.toString());
String role = String.valueOf(request.getSession().getAttribute("role"));
if(false)
return R.error(511,"永远不会进入");
Wrapper<ZhuanjiaEntity> queryWrapper = new EntityWrapper<ZhuanjiaEntity>()
.eq("username", zhuanjia.getUsername())
.or()
.eq("zhuanjia_phone", zhuanjia.getZhuanjiaPhone())
.or()
.eq("zhuanjia_id_number", zhuanjia.getZhuanjiaIdNumber())
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ZhuanjiaEntity zhuanjiaEntity = zhuanjiaService.selectOne(queryWrapper);
if(zhuanjiaEntity==null){
zhuanjia.setCreateTime(new Date());
zhuanjia.setPassword("123456");
zhuanjiaService.insert(zhuanjia);
return R.ok();
}else {
return R.error(511,"账户或者专家手机号或者专家身份证号已经被使用");
}
}
/**
* 后端修改
*/
@RequestMapping("/update")
public R update(@RequestBody ZhuanjiaEntity zhuanjia, HttpServletRequest request) throws NoSuchFieldException, ClassNotFoundException, IllegalAccessException, InstantiationException {
logger.debug("update方法:,,Controller:{},,zhuanjia:{}",this.getClass().getName(),zhuanjia.toString());
ZhuanjiaEntity oldZhuanjiaEntity = zhuanjiaService.selectById(zhuanjia.getId());//查询原先数据
String role = String.valueOf(request.getSession().getAttribute("role"));
// if(false)
// return R.error(511,"永远不会进入");
if("".equals(zhuanjia.getZhuanjiaPhoto()) || "null".equals(zhuanjia.getZhuanjiaPhoto())){
zhuanjia.setZhuanjiaPhoto(null);
}
zhuanjiaService.updateById(zhuanjia);//根据id更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Integer[] ids, HttpServletRequest request){
logger.debug("delete:,,Controller:{},,ids:{}",this.getClass().getName(),ids.toString());
List<ZhuanjiaEntity> oldZhuanjiaList =zhuanjiaService.selectBatchIds(Arrays.asList(ids));//要删除的数据
zhuanjiaService.deleteBatchIds(Arrays.asList(ids));
return R.ok();
}
/**
* 批量上传
*/
@RequestMapping("/batchInsert")
public R save( String fileName, HttpServletRequest request){
logger.debug("batchInsert方法:,,Controller:{},,fileName:{}",this.getClass().getName(),fileName);
Integer yonghuId = Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId")));
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//.eq("time", new SimpleDateFormat("yyyy-MM-dd").format(new Date()))
try {
List<ZhuanjiaEntity> zhuanjiaList = new ArrayList<>();//上传的东西
Map<String, List<String>> seachFields= new HashMap<>();//要查询的字段
Date date = new Date();
int lastIndexOf = fileName.lastIndexOf(".");
if(lastIndexOf == -1){
return R.error(511,"该文件没有后缀");
}else{
String suffix = fileName.substring(lastIndexOf);
if(!".xls".equals(suffix)){
return R.error(511,"只支持后缀为xls的excel文件");
}else{
URL resource = this.getClass().getClassLoader().getResource("static/upload/" + fileName);//获取文件路径
File file = new File(resource.getFile());
if(!file.exists()){
return R.error(511,"找不到上传文件，请联系管理员");
}else{
List<List<String>> dataList = PoiUtil.poiImport(file.getPath());//读取xls文件
dataList.remove(0);//删除第一行，因为第一行是提示
for(List<String> data:dataList){
//循环
ZhuanjiaEntity zhuanjiaEntity = new ZhuanjiaEntity();
// zhuanjiaEntity.setUsername(data.get(0)); //账户 要改的
// zhuanjiaEntity.setPassword("123456");//密码
// zhuanjiaEntity.setZhuanjiaName(data.get(0)); //专家姓名 要改的
// zhuanjiaEntity.setZhuanjiaPhone(data.get(0)); //专家手机号 要改的
// zhuanjiaEntity.setZhuanjiaIdNumber(data.get(0)); //专家身份证号 要改的
// zhuanjiaEntity.setZhuanjiaPhoto("");//详情和图片
// zhuanjiaEntity.setSexTypes(Integer.valueOf(data.get(0))); //性别 要改的
// zhuanjiaEntity.setZhuanjiaEmail(data.get(0)); //专家邮箱 要改的
// zhuanjiaEntity.setCreateTime(date);//时间
zhuanjiaList.add(zhuanjiaEntity);
//把要查询是否重复的字段放入map中
//账户
if(seachFields.containsKey("username")){
List<String> username = seachFields.get("username");
username.add(data.get(0));//要改的
}else{
List<String> username = new ArrayList<>();
username.add(data.get(0));//要改的
seachFields.put("username",username);
}
//专家手机号
if(seachFields.containsKey("zhuanjiaPhone")){
List<String> zhuanjiaPhone = seachFields.get("zhuanjiaPhone");
zhuanjiaPhone.add(data.get(0));//要改的
}else{
List<String> zhuanjiaPhone = new ArrayList<>();
zhuanjiaPhone.add(data.get(0));//要改的
seachFields.put("zhuanjiaPhone",zhuanjiaPhone);
}
//专家身份证号
if(seachFields.containsKey("zhuanjiaIdNumber")){
List<String> zhuanjiaIdNumber = seachFields.get("zhuanjiaIdNumber");
zhuanjiaIdNumber.add(data.get(0));//要改的
}else{
List<String> zhuanjiaIdNumber = new ArrayList<>();
zhuanjiaIdNumber.add(data.get(0));//要改的
seachFields.put("zhuanjiaIdNumber",zhuanjiaIdNumber);
}
}
//查询是否重复
//账户
List<ZhuanjiaEntity> zhuanjiaEntities_username = zhuanjiaService.selectList(new EntityWrapper<ZhuanjiaEntity>().in("username", seachFields.get("username")));
if(zhuanjiaEntities_username.size() >0 ){
ArrayList<String> repeatFields = new ArrayList<>();
for(ZhuanjiaEntity s:zhuanjiaEntities_username){
repeatFields.add(s.getUsername());
}
return R.error(511,"数据库的该表中的 [账户] 字段已经存在 存在数据为:"+repeatFields.toString());
}
//专家手机号
List<ZhuanjiaEntity> zhuanjiaEntities_zhuanjiaPhone = zhuanjiaService.selectList(new EntityWrapper<ZhuanjiaEntity>().in("zhuanjia_phone", seachFields.get("zhuanjiaPhone")));
if(zhuanjiaEntities_zhuanjiaPhone.size() >0 ){
ArrayList<String> repeatFields = new ArrayList<>();
for(ZhuanjiaEntity s:zhuanjiaEntities_zhuanjiaPhone){
repeatFields.add(s.getZhuanjiaPhone());
}
return R.error(511,"数据库的该表中的 [专家手机号] 字段已经存在 存在数据为:"+repeatFields.toString());
}
//专家身份证号
List<ZhuanjiaEntity> zhuanjiaEntities_zhuanjiaIdNumber = zhuanjiaService.selectList(new EntityWrapper<ZhuanjiaEntity>().in("zhuanjia_id_number", seachFields.get("zhuanjiaIdNumber")));
if(zhuanjiaEntities_zhuanjiaIdNumber.size() >0 ){
ArrayList<String> repeatFields = new ArrayList<>();
for(ZhuanjiaEntity s:zhuanjiaEntities_zhuanjiaIdNumber){
repeatFields.add(s.getZhuanjiaIdNumber());
}
return R.error(511,"数据库的该表中的 [专家身份证号] 字段已经存在 存在数据为:"+repeatFields.toString());
}
zhuanjiaService.insertBatch(zhuanjiaList);
return R.ok();
}
}
}
}catch (Exception e){
e.printStackTrace();
return R.error(511,"批量插入数据异常，请联系管理员");
}
}
/**
* 登录
*/
@IgnoreAuth
@RequestMapping(value = "/login")
public R login(String username, String password, String captcha, HttpServletRequest request) {
ZhuanjiaEntity zhuanjia = zhuanjiaService.selectOne(new EntityWrapper<ZhuanjiaEntity>().eq("username", username));
if(zhuanjia==null || !zhuanjia.getPassword().equals(password))
return R.error("账号或密码不正确");
String token = tokenService.generateToken(zhuanjia.getId(),username, "zhuanjia", "专家");
R r = R.ok();
r.put("token", token);
r.put("role","专家");
r.put("username",zhuanjia.getZhuanjiaName());
r.put("tableName","zhuanjia");
r.put("userId",zhuanjia.getId());
return r;
}
/**
* 注册
*/
@IgnoreAuth
@PostMapping(value = "/register")
public R register(@RequestBody ZhuanjiaEntity zhuanjia, HttpServletRequest request) {
// ValidatorUtils.validateEntity(user);
Wrapper<ZhuanjiaEntity> queryWrapper = new EntityWrapper<ZhuanjiaEntity>()
.eq("username", zhuanjia.getUsername())
.or()
.eq("zhuanjia_phone", zhuanjia.getZhuanjiaPhone())
.or()
.eq("zhuanjia_id_number", zhuanjia.getZhuanjiaIdNumber())
;
ZhuanjiaEntity zhuanjiaEntity = zhuanjiaService.selectOne(queryWrapper);
if(zhuanjiaEntity != null)
return R.error("账户或者专家手机号或者专家身份证号已经被使用");
zhuanjia.setCreateTime(new Date());
zhuanjiaService.insert(zhuanjia);
return R.ok();
}
/**
* 重置密码
*/
@GetMapping(value = "/resetPassword")
public R resetPassword(Integer id, HttpServletRequest request) {
ZhuanjiaEntity zhuanjia = zhuanjiaService.selectById(id);
zhuanjia.setPassword("123456");
zhuanjiaService.updateById(zhuanjia);
return R.ok();
}
/**
* 修改密码
*/
@GetMapping(value = "/updatePassword")
public R updatePassword(String oldPassword, String newPassword, HttpServletRequest request) {
ZhuanjiaEntity zhuanjia = zhuanjiaService.selectById((Integer)request.getSession().getAttribute("userId"));
if(newPassword == null){
return R.error("新密码不能为空") ;
}
if(!oldPassword.equals(zhuanjia.getPassword())){
return R.error("原密码输入错误");
}
if(newPassword.equals(zhuanjia.getPassword())){
return R.error("新密码不能和原密码一致") ;
}
zhuanjia.setPassword(newPassword);
zhuanjiaService.updateById(zhuanjia);
return R.ok();
}
/**
* 忘记密码
*/
@IgnoreAuth
@RequestMapping(value = "/resetPass")
public R resetPass(String username, HttpServletRequest request) {
ZhuanjiaEntity zhuanjia = zhuanjiaService.selectOne(new EntityWrapper<ZhuanjiaEntity>().eq("username", username));
if(zhuanjia!=null){
zhuanjia.setPassword("123456");
zhuanjiaService.updateById(zhuanjia);
return R.ok();
}else{
return R.error("账号不存在");
}
}
/**
* 获取用户的session用户信息
*/
@RequestMapping("/session")
public R getCurrZhuanjia(HttpServletRequest request){
Integer id = (Integer)request.getSession().getAttribute("userId");
ZhuanjiaEntity zhuanjia = zhuanjiaService.selectById(id);
if(zhuanjia !=null){
//entity转view
ZhuanjiaView view = new ZhuanjiaView();
BeanUtils.copyProperties( zhuanjia , view );//把实体数据重构到view中
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 退出
*/
@GetMapping(value = "logout")
public R logout(HttpServletRequest request) {
request.getSession().invalidate();
return R.ok("退出成功");
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params, HttpServletRequest request){
logger.debug("list方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
CommonUtil.checkMap(params);
PageUtils page = zhuanjiaService.queryPage(params);
//字典表数据转换
List<ZhuanjiaView> list =(List<ZhuanjiaView>)page.getList();
for(ZhuanjiaView c:list)
dictionaryService.dictionaryConvert(c, request); //修改对应字典表字段
return R.ok().put("data", page);
}
/**
* 前端详情
*/
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id, HttpServletRequest request){
logger.debug("detail方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
ZhuanjiaEntity zhuanjia = zhuanjiaService.selectById(id);
if(zhuanjia !=null){
//entity转view
ZhuanjiaView view = new ZhuanjiaView();
BeanUtils.copyProperties( zhuanjia , view );//把实体数据重构到view中
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody ZhuanjiaEntity zhuanjia, HttpServletRequest request){
logger.debug("add方法:,,Controller:{},,zhuanjia:{}",this.getClass().getName(),zhuanjia.toString());
Wrapper<ZhuanjiaEntity> queryWrapper = new EntityWrapper<ZhuanjiaEntity>()
.eq("username", zhuanjia.getUsername())
.or()
.eq("zhuanjia_phone", zhuanjia.getZhuanjiaPhone())
.or()
.eq("zhuanjia_id_number", zhuanjia.getZhuanjiaIdNumber())
// .notIn("zhuanjia_types", new Integer[]{102})
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ZhuanjiaEntity zhuanjiaEntity = zhuanjiaService.selectOne(queryWrapper);
if(zhuanjiaEntity==null){
zhuanjia.setCreateTime(new Date());
zhuanjia.setPassword("123456");
zhuanjiaService.insert(zhuanjia);
return R.ok();
}else {
return R.error(511,"账户或者专家手机号或者专家身份证号已经被使用");
}
}
}
package com.controller;
import java.io.File;
import java.math.BigDecimal;
import java.net.URL;
import java.text.SimpleDateFormat;
import com.alibaba.fastjson.JSONObject;
import java.util.*;
import org.springframework.beans.BeanUtils;
import javax.servlet.http.HttpServletRequest;
import org.springframework.web.context.ContextLoader;
import javax.servlet.ServletContext;
import com.service.TokenService;
import com.utils.*;
import java.lang.reflect.InvocationTargetException;
import com.service.DictionaryService;
import org.apache.commons.lang3.StringUtils;
import com.annotation.IgnoreAuth;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.entity.*;
import com.entity.view.*;
import com.service.*;
import com.utils.PageUtils;
import com.utils.R;
import com.alibaba.fastjson.*;
/**
* 论坛
* 后端接口
* @author
* @email
*/
@RestController
@Controller
@RequestMapping("/forum")
public class ForumController {
private static final Logger logger = LoggerFactory.getLogger(ForumController.class);
private static final String TABLE_NAME = "forum";
@Autowired
private ForumService forumService;
@Autowired
private TokenService tokenService;
@Autowired
private DictionaryService dictionaryService;//字典
@Autowired
private JuanzhengService juanzhengService;//捐赠信息
@Autowired
private NewsService newsService;//公告资讯
@Autowired
private QiuzhuService qiuzhuService;//求助信息
@Autowired
private QiuzhuCollectionService qiuzhuCollectionService;//求助收藏
@Autowired
private QiuzhuLiuyanService qiuzhuLiuyanService;//求助留言
@Autowired
private YonghuService yonghuService;//用户
@Autowired
private UsersService usersService;//管理员
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params, HttpServletRequest request){
logger.debug("page方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
CommonUtil.checkMap(params);
PageUtils page = forumService.queryPage(params);
//字典表数据转换
List<ForumView> list =(List<ForumView>)page.getList();
for(ForumView c:list){
//修改对应字典表字段
dictionaryService.dictionaryConvert(c, request);
}
return R.ok().put("data", page);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id, HttpServletRequest request){
logger.debug("info方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
ForumEntity forum = forumService.selectById(id);
if(forum !=null){
//entity转view
ForumView view = new ForumView();
BeanUtils.copyProperties( forum , view );//把实体数据重构到view中
//级联表 用户
//级联表
YonghuEntity yonghu = yonghuService.selectById(forum.getYonghuId());
if(yonghu != null){
BeanUtils.copyProperties( yonghu , view ,new String[]{ "id", "createTime", "insertTime", "updateTime", "yonghuId"
, "usersId"});//把级联的数据添加到view中,并排除id和创建时间字段,当前表的级联注册表
view.setYonghuId(yonghu.getId());
}
//级联表 管理员
//管理员表做额外的处理
UsersEntity users = usersService.selectById(forum.getUsersId());
if(users != null){
view.setUsersId(users.getId());
view.setUusername(users.getUsername());
view.setUpassword(users.getPassword());
view.setUrole(users.getRole());
view.setUaddtime(users.getAddtime());
}
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody ForumEntity forum, HttpServletRequest request){
logger.debug("save方法:,,Controller:{},,forum:{}",this.getClass().getName(),forum.toString());
String role = String.valueOf(request.getSession().getAttribute("role"));
if(false)
return R.error(511,"永远不会进入");
else if("用户".equals(role))
forum.setYonghuId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
else if("管理员".equals(role))
forum.setUsersId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
Wrapper<ForumEntity> queryWrapper = new EntityWrapper<ForumEntity>()
.eq("forum_name", forum.getForumName())
.eq("yonghu_id", forum.getYonghuId())
.eq("users_id", forum.getUsersId())
.eq("super_ids", forum.getSuperIds())
.eq("forum_state_types", forum.getForumStateTypes())
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ForumEntity forumEntity = forumService.selectOne(queryWrapper);
if(forumEntity==null){
forum.setInsertTime(new Date());
forum.setCreateTime(new Date());
forumService.insert(forum);
return R.ok();
}else {
return R.error(511,"表中有相同数据");
}
}
/**
* 后端修改
*/
@RequestMapping("/update")
public R update(@RequestBody ForumEntity forum, HttpServletRequest request) throws NoSuchFieldException, ClassNotFoundException, IllegalAccessException, InstantiationException {
logger.debug("update方法:,,Controller:{},,forum:{}",this.getClass().getName(),forum.toString());
ForumEntity oldForumEntity = forumService.selectById(forum.getId());//查询原先数据
String role = String.valueOf(request.getSession().getAttribute("role"));
// if(false)
// return R.error(511,"永远不会进入");
// else if("用户".equals(role))
// forum.setYonghuId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
// else if("管理员".equals(role))
// forum.setUsersId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
forum.setUpdateTime(new Date());
forumService.updateById(forum);//根据id更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Integer[] ids, HttpServletRequest request){
logger.debug("delete:,,Controller:{},,ids:{}",this.getClass().getName(),ids.toString());
List<ForumEntity> oldForumList =forumService.selectBatchIds(Arrays.asList(ids));//要删除的数据
forumService.deleteBatchIds(Arrays.asList(ids));
return R.ok();
}
/**
* 批量上传
*/
@RequestMapping("/batchInsert")
public R save( String fileName, HttpServletRequest request){
logger.debug("batchInsert方法:,,Controller:{},,fileName:{}",this.getClass().getName(),fileName);
Integer yonghuId = Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId")));
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//.eq("time", new SimpleDateFormat("yyyy-MM-dd").format(new Date()))
try {
List<ForumEntity> forumList = new ArrayList<>();//上传的东西
Map<String, List<String>> seachFields= new HashMap<>();//要查询的字段
Date date = new Date();
int lastIndexOf = fileName.lastIndexOf(".");
if(lastIndexOf == -1){
return R.error(511,"该文件没有后缀");
}else{
String suffix = fileName.substring(lastIndexOf);
if(!".xls".equals(suffix)){
return R.error(511,"只支持后缀为xls的excel文件");
}else{
URL resource = this.getClass().getClassLoader().getResource("static/upload/" + fileName);//获取文件路径
File file = new File(resource.getFile());
if(!file.exists()){
return R.error(511,"找不到上传文件，请联系管理员");
}else{
List<List<String>> dataList = PoiUtil.poiImport(file.getPath());//读取xls文件
dataList.remove(0);//删除第一行，因为第一行是提示
for(List<String> data:dataList){
//循环
ForumEntity forumEntity = new ForumEntity();
// forumEntity.setForumName(data.get(0)); //帖子标题 要改的
// forumEntity.setYonghuId(Integer.valueOf(data.get(0))); //用户 要改的
// forumEntity.setUsersId(Integer.valueOf(data.get(0))); //管理员 要改的
// forumEntity.setForumContent("");//详情和图片
// forumEntity.setSuperIds(Integer.valueOf(data.get(0))); //父id 要改的
// forumEntity.setForumStateTypes(Integer.valueOf(data.get(0))); //帖子状态 要改的
// forumEntity.setInsertTime(date);//时间
// forumEntity.setUpdateTime(sdf.parse(data.get(0))); //修改时间 要改的
// forumEntity.setCreateTime(date);//时间
forumList.add(forumEntity);
//把要查询是否重复的字段放入map中
}
//查询是否重复
forumService.insertBatch(forumList);
return R.ok();
}
}
}
}catch (Exception e){
e.printStackTrace();
return R.error(511,"批量插入数据异常，请联系管理员");
}
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params, HttpServletRequest request){
logger.debug("list方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
CommonUtil.checkMap(params);
PageUtils page = forumService.queryPage(params);
//字典表数据转换
List<ForumView> list =(List<ForumView>)page.getList();
for(ForumView c:list)
dictionaryService.dictionaryConvert(c, request); //修改对应字典表字段
return R.ok().put("data", page);
}
/**
* 前端详情
*/
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id, HttpServletRequest request){
logger.debug("detail方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
ForumEntity forum = forumService.selectById(id);
if(forum !=null){
//entity转view
ForumView view = new ForumView();
BeanUtils.copyProperties( forum , view );//把实体数据重构到view中
//级联表
YonghuEntity yonghu = yonghuService.selectById(forum.getYonghuId());
if(yonghu != null){
BeanUtils.copyProperties( yonghu , view ,new String[]{ "id", "createDate"});//把级联的数据添加到view中,并排除id和创建时间字段
view.setYonghuId(yonghu.getId());
}
UsersEntity users = usersService.selectById(forum.getUsersId());
if(users != null){
view.setUsersId(users.getId());
view.setUusername(users.getUsername());
view.setUpassword(users.getPassword());
view.setUrole(users.getRole());
view.setUaddtime(users.getAddtime());
}
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody ForumEntity forum, HttpServletRequest request){
logger.debug("add方法:,,Controller:{},,forum:{}",this.getClass().getName(),forum.toString());
Wrapper<ForumEntity> queryWrapper = new EntityWrapper<ForumEntity>()
.eq("forum_name", forum.getForumName())
.eq("yonghu_id", forum.getYonghuId())
.eq("users_id", forum.getUsersId())
.eq("super_ids", forum.getSuperIds())
.eq("forum_state_types", forum.getForumStateTypes())
// .notIn("forum_types", new Integer[]{102})
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ForumEntity forumEntity = forumService.selectOne(queryWrapper);
if(forumEntity==null){
forum.setInsertTime(new Date());
forum.setCreateTime(new Date());
forumService.insert(forum);
return R.ok();
}else {
return R.error(511,"表中有相同数据");
}
}
}
475
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
