随着我国经济的高速发展与人们生活水平的日益提高，人们对生活质量的追求也多种多样。尤其在人们生活节奏不断加快的当下，人们更趋向于足不出户解决生活上的问题，图书管理系统展现了其蓬勃生命力和广阔的前景。与此同时，为解决图书管理需求，图书管理发展愈发多元化、网络化与电子信息技术相结合。图书管理系统应运而生。
该系统利用Java语言、MySQL数据库，结合目前流行的 B/S架构，将图书管理的各个方面都集中到数据库中，以便于用户的需要。该系统在确保系统稳定的前提下，能够实现多功能模块的设计和应用。该系统由管理员功能模块和用户功能模块组成。不同角色的准入制度是有严格区别的。各功能模块的设计也便于以后的系统升级和维护。该系统采用了软件组件化、精化体系结构、分离逻辑和数据等方法。
关键字：Java技术；图书；MySQL；B/S结构
springboot vue图书管理系统源码和论文答辩PPT707
演示视频：
springboot vue图书管理系统源码和论文答辩PPT
With the rapid development of our economy and the increasing improvement of people's living standard, people's pursuit of quality of life is varied. Especially in the rapid pace of people's life at present, people tend to stay at home to solve problems in life, the library management system has shown its vigorous vitality and broad prospects. At the same time, in order to meet the needs of library management, library management development is increasingly diversified, network and electronic information technology. Library management system came into being.
The system uses Java language, MySQL database, combined with the current popular B/S architecture, all aspects of library management are concentrated in the database, so as to facilitate the needs of users. The system can realize the design and application of multifunctional modules on the premise of ensuring the stability of the system. The system consists of administrator function module and user function module. The admittance system of different roles is strictly different. The design of each function module is also convenient for future system upgrade and maintenance. The system adopts the methods of software componentization, refinement architecture, separation of logic and data.
Key words: Java technology; Books; MySQL; B/S structure
1绪 论
1.1开发背景
改革开放以来，中国社会经济体系复苏，人们生活水平稳步提升，中国社会已全面步入小康社会。同时也在逐渐转型，具有生活的现代化和劳动的社会化等特点。这不仅基于人们过快的工作节奏与生活方式，也是源于人们对于生活品质越来越严苛的要求。如何从工作压力与生活压力中得到解放，是现代人追求的永恒话题[1]。
单从工作压力来讲，图书管理在很大程度上可以解决一部分问题，逐渐进入人们的视野。图书管理采用的手工记录信息的方式，给工作人员的匹配工作造成很大的困难。这也充分说明了传统的信息处理方式已经很难适应现代管理系统的需要。
近年来，随着计算机技术的飞速发展以及其在全球范围内的普及，计算机技术的在人们生活中应用的占比越来越大，尤其是信息资源管理方面，广泛应用于各个行业，已经产生了不可估量的社会效益[6]。计算机技术在信息资源管理方面的应用大大提高了工作效率，简化了工作程序，改善了服务质量[7]。而这些特点正好对图书管理的难题对症下药。图书管理系统一经问世，就展现了其巨大的发展前景与优势。电子信息技术与图书管理的结合，使得用户足不出户就可以在系统上操作，符合人们现代生活方式发展；这种结合也对图书管理模式的变革也起到了决定性的作用，可以实现图书信息一次录入，永久使用的便捷，关键词输入即可将用户需求与图书管理人员信息进行匹配，达到客户需求最快最优实现的理想[8]。然后这种模式更加节省成本，无论是纸质文字的录入和保存，还有人工的费用都为图书管理的资本积累以及变革提供了保障。因此可以看出，图书管理网络化，不仅大大提高了本行业的工作效率，简化工作方式，更是一场图书管理的深刻变革。
1.2开发目的与意义
1.2.1开发目的
近年来，图书管理系统发展迅猛，在拥有广阔发展前景的同时，也面临着许许多多的问题。
我国线上管理起步晚，但发展快速，从业人员激增，多见于传统管理模式，管理体系不规范、不标准。且企业虽然多但规模普遍偏小，很难在市场形成有效的诚信经营的形象与品牌。
我国目前存在的图书管理监管制度缺失、市场监管不规范等问题。由于缺乏专业人士的素质和服务品质的明确测量，导致图书管理内部鱼龙混杂，难以获得用户的信赖。
图书管理系统是电子、信息技术的相结合，是一种必然的发展趋势。以互联网为基础，以服务于广大用户为目的，发展整体优势，扩大规模，提升服务质量，提高图书管理效率。图书管理系统实现了图书管理向现代化和网络化的转型，为管理决策和控制提供保障，这是图书管理系统发展中里程碑式的转型。
1.2.2开发意义
对于图书管理来说，系统的建设大大节省了管理成本和人工成本，增强用户信息安全建设，是实现管理现代化的有效途径，同时促进图书管理更加专业化和网络化。
对于用户来说，建立图书管理体系不仅丰富了图书管理的商业模式，还能刺激各行业进行自我改革，促使其专业性和规范性的提高。这是图书管理良性循环发展的里程碑。
1.3本文研究内容
首先，要掌握有关系统的基本理论，如 Java技术、 MySQL数据库等，并对其进行全面的分析。为了给系统打下坚实的技术基础，本系统采用了 MySQL数据库的架构，在开始这项工作前，首先要设计好要用到的数据库表。该系统的使用者有两类：管理员和用户，主要功能包括个人信息修改，用户管理、图书分类管理、图书信息管理、系统管理等功能。
package com.controller;
import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.text.ParseException;
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.transaction.annotation.Transactional;
import org.springframework.format.annotation.DateTimeFormat;
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.TushuxinxiEntity;
import com.entity.view.TushuxinxiView;
import com.service.TushuxinxiService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
import java.io.IOException;
import com.service.StoreupService;
import com.entity.StoreupEntity;
/**
* 图书信息
* 后端接口
* @author
* @email
* @date 2023-03-02 11:13:33
*/
@RestController
@RequestMapping("/tushuxinxi")
public class TushuxinxiController {
@Autowired
private TushuxinxiService tushuxinxiService;
@Autowired
private StoreupService storeupService;
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,TushuxinxiEntity tushuxinxi,
HttpServletRequest request){
EntityWrapper<TushuxinxiEntity> ew = new EntityWrapper<TushuxinxiEntity>();
PageUtils page = tushuxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, tushuxinxi), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,TushuxinxiEntity tushuxinxi,
HttpServletRequest request){
EntityWrapper<TushuxinxiEntity> ew = new EntityWrapper<TushuxinxiEntity>();
PageUtils page = tushuxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, tushuxinxi), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( TushuxinxiEntity tushuxinxi){
EntityWrapper<TushuxinxiEntity> ew = new EntityWrapper<TushuxinxiEntity>();
ew.allEq(MPUtil.allEQMapPre( tushuxinxi, "tushuxinxi"));
return R.ok().put("data", tushuxinxiService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(TushuxinxiEntity tushuxinxi){
EntityWrapper< TushuxinxiEntity> ew = new EntityWrapper< TushuxinxiEntity>();
ew.allEq(MPUtil.allEQMapPre( tushuxinxi, "tushuxinxi"));
TushuxinxiView tushuxinxiView = tushuxinxiService.selectView(ew);
return R.ok("查询图书信息成功").put("data", tushuxinxiView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
TushuxinxiEntity tushuxinxi = tushuxinxiService.selectById(id);
tushuxinxi.setClicktime(new Date());
tushuxinxiService.updateById(tushuxinxi);
return R.ok().put("data", tushuxinxi);
}
/**
* 前端详情
*/
@IgnoreAuth
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id){
TushuxinxiEntity tushuxinxi = tushuxinxiService.selectById(id);
tushuxinxi.setClicktime(new Date());
tushuxinxiService.updateById(tushuxinxi);
return R.ok().put("data", tushuxinxi);
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody TushuxinxiEntity tushuxinxi, HttpServletRequest request){
tushuxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(tushuxinxi);
tushuxinxiService.insert(tushuxinxi);
return R.ok();
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody TushuxinxiEntity tushuxinxi, HttpServletRequest request){
tushuxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(tushuxinxi);
tushuxinxiService.insert(tushuxinxi);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
@Transactional
public R update(@RequestBody TushuxinxiEntity tushuxinxi, HttpServletRequest request){
//ValidatorUtils.validateEntity(tushuxinxi);
tushuxinxiService.updateById(tushuxinxi);//全部更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
tushuxinxiService.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 Map<String, 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));
}
}
Wrapper<TushuxinxiEntity> wrapper = new EntityWrapper<TushuxinxiEntity>();
if(map.get("remindstart")!=null) {
wrapper.ge(columnName, map.get("remindstart"));
}
if(map.get("remindend")!=null) {
wrapper.le(columnName, map.get("remindend"));
}
int count = tushuxinxiService.selectCount(wrapper);
return R.ok().put("count", count);
}
/**
* 前端智能排序
*/
@IgnoreAuth
@RequestMapping("/autoSort")
public R autoSort(@RequestParam Map<String, Object> params,TushuxinxiEntity tushuxinxi, HttpServletRequest request,String pre){
EntityWrapper<TushuxinxiEntity> ew = new EntityWrapper<TushuxinxiEntity>();
Map<String, Object> newMap = new HashMap<String, Object>();
Map<String, Object> param = new HashMap<String, Object>();
Iterator<Map.Entry<String, Object>> it = param.entrySet().iterator();
while (it.hasNext()) {
Map.Entry<String, Object> entry = it.next();
String key = entry.getKey();
String newKey = entry.getKey();
if (pre.endsWith(".")) {
newMap.put(pre + newKey, entry.getValue());
} else if (StringUtils.isEmpty(pre)) {
newMap.put(newKey, entry.getValue());
} else {
newMap.put(pre + "." + newKey, entry.getValue());
}
}
params.put("sort", "clicktime");
params.put("order", "desc");
PageUtils page = tushuxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, tushuxinxi), params), params));
return R.ok().put("data", page);
}
/**
* 协同算法（按收藏推荐）
*/
@RequestMapping("/autoSort2")
public R autoSort2(@RequestParam Map<String, Object> params,TushuxinxiEntity tushuxinxi, HttpServletRequest request){
String userId = request.getSession().getAttribute("userId").toString();
String inteltypeColumn = "tushufenlei";
List<StoreupEntity> storeups = storeupService.selectList(new EntityWrapper<StoreupEntity>().eq("type", 1).eq("userid", userId).eq("tablename", "tushuxinxi").orderBy("addtime", false));
List<String> inteltypes = new ArrayList<String>();
Integer limit = params.get("limit")==null?10:Integer.parseInt(params.get("limit").toString());
List<TushuxinxiEntity> tushuxinxiList = new ArrayList<TushuxinxiEntity>();
//去重
if(storeups!=null && storeups.size()>0) {
for(StoreupEntity s : storeups) {
tushuxinxiList.addAll(tushuxinxiService.selectList(new EntityWrapper<TushuxinxiEntity>().eq(inteltypeColumn, s.getInteltype())));
}
}
EntityWrapper<TushuxinxiEntity> ew = new EntityWrapper<TushuxinxiEntity>();
params.put("sort", "id");
params.put("order", "desc");
PageUtils page = tushuxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, tushuxinxi), params), params));
List<TushuxinxiEntity> pageList = (List<TushuxinxiEntity>)page.getList();
if(tushuxinxiList.size()<limit) {
int toAddNum = (limit-tushuxinxiList.size())<=pageList.size()?(limit-tushuxinxiList.size()):pageList.size();
for(TushuxinxiEntity o1 : pageList) {
boolean addFlag = true;
for(TushuxinxiEntity o2 : tushuxinxiList) {
if(o1.getId().intValue()==o2.getId().intValue()) {
addFlag = false;
break;
}
}
if(addFlag) {
tushuxinxiList.add(o1);
if(--toAddNum==0) break;
}
}
} else if(tushuxinxiList.size()>limit) {
tushuxinxiList = tushuxinxiList.subList(0, limit);
}
page.setList(tushuxinxiList);
return R.ok().put("data", page);
}
/**
* （按值统计）
*/
@RequestMapping("/value/{xColumnName}/{yColumnName}")
public R value(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("yColumn", yColumnName);
EntityWrapper<TushuxinxiEntity> ew = new EntityWrapper<TushuxinxiEntity>();
List<Map<String, Object>> result = tushuxinxiService.selectValue(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* （按值统计）时间统计类型
*/
@RequestMapping("/value/{xColumnName}/{yColumnName}/{timeStatType}")
public R valueDay(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName, @PathVariable("timeStatType") String timeStatType,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("yColumn", yColumnName);
params.put("timeStatType", timeStatType);
EntityWrapper<TushuxinxiEntity> ew = new EntityWrapper<TushuxinxiEntity>();
List<Map<String, Object>> result = tushuxinxiService.selectTimeStatValue(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* 分组统计
*/
@RequestMapping("/group/{columnName}")
public R group(@PathVariable("columnName") String columnName,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("column", columnName);
EntityWrapper<TushuxinxiEntity> ew = new EntityWrapper<TushuxinxiEntity>();
List<Map<String, Object>> result = tushuxinxiService.selectGroup(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* 总数量
*/
@RequestMapping("/count")
public R count(@RequestParam Map<String, Object> params,TushuxinxiEntity tushuxinxi, HttpServletRequest request){
EntityWrapper<TushuxinxiEntity> ew = new EntityWrapper<TushuxinxiEntity>();
int count = tushuxinxiService.selectCount(MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, tushuxinxi), params), params));
return R.ok().put("data", count);
}
}
package com.controller;
import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.text.ParseException;
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.transaction.annotation.Transactional;
import org.springframework.format.annotation.DateTimeFormat;
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.YonghuEntity;
import com.entity.view.YonghuView;
import com.service.YonghuService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
import java.io.IOException;
/**
* 用户
* 后端接口
* @author
* @email
* @date 2023-03-02 11:13:33
*/
@RestController
@RequestMapping("/yonghu")
public class YonghuController {
@Autowired
private YonghuService yonghuService;
@Autowired
private TokenService tokenService;
/**
* 登录
*/
@IgnoreAuth
@RequestMapping(value = "/login")
public R login(String username, String password, String captcha, HttpServletRequest request) {
YonghuEntity u = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("zhanghao", username));
if(u==null || !u.getMima().equals(password)) {
return R.error("账号或密码不正确");
}
String token = tokenService.generateToken(u.getId(), username,"yonghu", "用户" );
return R.ok().put("token", token);
}
/**
* 注册
*/
@IgnoreAuth
@RequestMapping("/register")
public R register(@RequestBody YonghuEntity yonghu){
//ValidatorUtils.validateEntity(yonghu);
YonghuEntity u = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("zhanghao", yonghu.getZhanghao()));
if(u!=null) {
return R.error("注册用户已存在");
}
Long uId = new Date().getTime();
yonghu.setId(uId);
yonghuService.insert(yonghu);
return R.ok();
}
/**
* 退出
*/
@RequestMapping("/logout")
public R logout(HttpServletRequest request) {
request.getSession().invalidate();
return R.ok("退出成功");
}
/**
* 获取用户的session用户信息
*/
@RequestMapping("/session")
public R getCurrUser(HttpServletRequest request){
Long id = (Long)request.getSession().getAttribute("userId");
YonghuEntity u = yonghuService.selectById(id);
return R.ok().put("data", u);
}
/**
* 密码重置
*/
@IgnoreAuth
@RequestMapping(value = "/resetPass")
public R resetPass(String username, HttpServletRequest request){
YonghuEntity u = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("zhanghao", username));
if(u==null) {
return R.error("账号不存在");
}
u.setMima("123456");
yonghuService.updateById(u);
return R.ok("密码已重置为：123456");
}
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,YonghuEntity yonghu,
HttpServletRequest request){
EntityWrapper<YonghuEntity> ew = new EntityWrapper<YonghuEntity>();
PageUtils page = yonghuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, yonghu), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,YonghuEntity yonghu,
HttpServletRequest request){
EntityWrapper<YonghuEntity> ew = new EntityWrapper<YonghuEntity>();
PageUtils page = yonghuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, yonghu), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( YonghuEntity yonghu){
EntityWrapper<YonghuEntity> ew = new EntityWrapper<YonghuEntity>();
ew.allEq(MPUtil.allEQMapPre( yonghu, "yonghu"));
return R.ok().put("data", yonghuService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(YonghuEntity yonghu){
EntityWrapper< YonghuEntity> ew = new EntityWrapper< YonghuEntity>();
ew.allEq(MPUtil.allEQMapPre( yonghu, "yonghu"));
YonghuView yonghuView = yonghuService.selectView(ew);
return R.ok("查询用户成功").put("data", yonghuView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
YonghuEntity yonghu = yonghuService.selectById(id);
return R.ok().put("data", yonghu);
}
/**
* 前端详情
*/
@IgnoreAuth
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id){
YonghuEntity yonghu = yonghuService.selectById(id);
return R.ok().put("data", yonghu);
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody YonghuEntity yonghu, HttpServletRequest request){
yonghu.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(yonghu);
YonghuEntity u = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("zhanghao", yonghu.getZhanghao()));
if(u!=null) {
return R.error("用户已存在");
}
yonghu.setId(new Date().getTime());
yonghuService.insert(yonghu);
return R.ok();
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody YonghuEntity yonghu, HttpServletRequest request){
yonghu.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(yonghu);
YonghuEntity u = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("zhanghao", yonghu.getZhanghao()));
if(u!=null) {
return R.error("用户已存在");
}
yonghu.setId(new Date().getTime());
yonghuService.insert(yonghu);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
@Transactional
public R update(@RequestBody YonghuEntity yonghu, HttpServletRequest request){
//ValidatorUtils.validateEntity(yonghu);
yonghuService.updateById(yonghu);//全部更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
yonghuService.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 Map<String, 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));
}
}
Wrapper<YonghuEntity> wrapper = new EntityWrapper<YonghuEntity>();
if(map.get("remindstart")!=null) {
wrapper.ge(columnName, map.get("remindstart"));
}
if(map.get("remindend")!=null) {
wrapper.le(columnName, map.get("remindend"));
}
int count = yonghuService.selectCount(wrapper);
return R.ok().put("count", count);
}
}
152
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
