项目介绍
信息数据从传统到当代，是一直在变革当中，突如其来的互联网让传统的信息管理看到了革命性的曙光，因为传统信息管理从时效性，还是安全性，还是可操作性等各个方面来讲，遇到了互联网时代才发现能补上自古以来的短板，有效的提升管理的效率和业务水平。传统的管理模式，时间越久管理的内容越多，也需要更多的人来对数据进行整理，并且数据的汇总查询方面效率也是极其的低下，并且数据安全方面永远不会保证安全性能。结合数据内容管理的种种缺点，在互联网时代都可以得到有效的补充。结合先进的互联网技术，开发符合需求的软件，让数据内容管理不管是从录入的及时性，查看的及时性还是汇总分析的及时性，都能让正确率达到最高，管理更加的科学和便捷。本次开发的善筹网实现了参与的众筹管理、字典管理、商品管理、商品收藏管理、商品留言管理、用户管理、众筹管理、众筹收藏管理、众筹留言管理、管理员管理等功能。系统用到了关系型数据库中王者MySql作为系统的数据库，有效的对数据进行安全的存储，有效的备份，对数据可靠性方面得到了保证。并且程序也具备程序需求的所有功能，使得操作性还是安全性都大大提高，让善筹网更能从理念走到现实，确确实实的让人们提升信息处理效率。
开发环境
编程语言：Java
数据库 ：Mysql
系统架构：B/S
后端框架：SpringBoot
编译工具：idea或者eclipse，jdk1.8，maven
支持定做：java/php/python/android/小程序vue/爬虫/c#/asp.net
系统实现
5.1管理员功能实现
5.1.1 众筹管理
此页面让管理员管理众筹的数据，众筹管理页面见下图。此页面主要实现众筹的增加、修改、删除、查看的功能。
图5-1 众筹管理页面
5.1.2 商品信息管理
商品信息管理页面提供的功能操作有：新增商品，修改商品，删除商品操作。下图就是商品信息管理页面。
图5.3 商品信息管理页面
5.1.3商品类型管理
商品类型管理页面显示所有商品类型，在此页面既可以让管理员添加新的商品信息类型，也能对已有的商品类型信息执行编辑更新，失效的商品类型信息也能让管理员快速删除。下图就是商品类型管理页面。
图5.4 商品类型列表页面
核心代码
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("/zhongchou")
public class ZhongchouController {
private static final Logger logger = LoggerFactory.getLogger(ZhongchouController.class);
@Autowired
private ZhongchouService zhongchouService;
@Autowired
private TokenService tokenService;
@Autowired
private DictionaryService dictionaryService;
//级联表service
@Autowired
private ShangpinService shangpinService;
@Autowired
private YonghuService yonghuService;
@Autowired
private CanyuzhongchouService canyuzhongchouService;
/**
* 众筹
*/
@RequestMapping("/zhongchou")
public R zhongchou(@RequestParam Map<String, Object> params, HttpServletRequest request){
logger.debug("zhongchou方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
String role = String.valueOf(request.getSession().getAttribute("role"));
if(!"用户".equals(role))
return R.error("您没有权限参与众筹");
// yonghuId:localStorage.getItem("userid"),
// zhongchouId:this.detail.id,
// canyuMoney
YonghuEntity yonghuEntity = yonghuService.selectById(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
Double canyuMoney = Double.valueOf(String.valueOf(params.get("canyuMoney")));
if(canyuMoney == null)
return R.error("参与金额不能为空");
else if(canyuMoney <=0)
return R.error("参与金额必须大于0");
Double balance = yonghuEntity.getNewMoney()-canyuMoney;
if(balance <0 )
return R.error("当前账户金额不够,请充值后再参与");
yonghuEntity.setNewMoney(balance);
Integer zhongchouId = Integer.valueOf(String.valueOf(params.get("zhongchouId")));
ZhongchouEntity zhongchouEntity = zhongchouService.selectById(zhongchouId);
if(zhongchouEntity == null)
return R.error("查不到众筹项目");
zhongchouEntity.setYichouMoney(zhongchouEntity.getYichouMoney()+canyuMoney);
CanyuzhongchouEntity canyuzhongchouEntity = new CanyuzhongchouEntity();
canyuzhongchouEntity.setCreateTime(new Date());
canyuzhongchouEntity.setYonghuId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
canyuzhongchouEntity.setJieshuTime(new Date());
canyuzhongchouEntity.setZhongchouId(zhongchouId);
canyuzhongchouEntity.setZizuMoney(canyuMoney);
zhongchouService.updateById(zhongchouEntity);
canyuzhongchouService.insert(canyuzhongchouEntity);
yonghuService.updateById(yonghuEntity);
return R.ok();
}
/**
* 后端列表
*/
@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"));
params.put("zhongchouDeleteStart",1);params.put("zhongchouDeleteEnd",1);
if(params.get("orderBy")==null || params.get("orderBy")==""){
params.put("orderBy","id");
}
PageUtils page = zhongchouService.queryPage(params);
//字典表数据转换
List<ZhongchouView> list =(List<ZhongchouView>)page.getList();
for(ZhongchouView 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);
ZhongchouEntity zhongchou = zhongchouService.selectById(id);
if(zhongchou !=null){
//entity转view
ZhongchouView view = new ZhongchouView();
BeanUtils.copyProperties( zhongchou , view );//把实体数据重构到view中
//级联表
ShangpinEntity shangpin = shangpinService.selectById(zhongchou.getShangpinId());
if(shangpin != null){
BeanUtils.copyProperties( shangpin , view ,new String[]{ "id", "createTime", "insertTime", "updateTime"});//把级联的数据添加到view中,并排除id和创建时间字段
view.setShangpinId(shangpin.getId());
}
//级联表
YonghuEntity yonghu = yonghuService.selectById(zhongchou.getYonghuId());
if(yonghu != null){
BeanUtils.copyProperties( yonghu , view ,new String[]{ "id", "createTime", "insertTime", "updateTime"});//把级联的数据添加到view中,并排除id和创建时间字段
view.setYonghuId(yonghu.getId());
}
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody ZhongchouEntity zhongchou, HttpServletRequest request){
logger.debug("save方法:,,Controller:{},,zhongchou:{}",this.getClass().getName(),zhongchou.toString());
String role = String.valueOf(request.getSession().getAttribute("role"));
if(false)
return R.error(511,"永远不会进入");
else if("用户".equals(role)){
zhongchou.setYonghuId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
zhongchou.setZhongchouZhuangtaiTypes(1);
}
Wrapper<ZhongchouEntity> queryWrapper = new EntityWrapper<ZhongchouEntity>()
.eq("yonghu_id", zhongchou.getYonghuId())
.eq("shangpin_id", zhongchou.getShangpinId())
.eq("zhongchou_uuid_number", zhongchou.getZhongchouUuidNumber())
.eq("zhongchou_name", zhongchou.getZhongchouName())
.eq("zhongchou_types", zhongchou.getZhongchouTypes())
.eq("zhongchou_kucun_number", zhongchou.getZhongchouKucunNumber())
.eq("zhongchou_clicknum", zhongchou.getZhongchouClicknum())
.eq("zhongchou_zhuangtai_types", zhongchou.getZhongchouZhuangtaiTypes())
.eq("zhongchou_chenggong_name", zhongchou.getZhongchouChenggongName())
.eq("zhongchou_chenggong_phone", zhongchou.getZhongchouChenggongPhone())
.eq("zhongchou_chenggong_address", zhongchou.getZhongchouChenggongAddress())
.eq("zhongchou_chenggong_kuaidiname", zhongchou.getZhongchouChenggongKuaidiname())
.eq("zhongchou_chenggong_kuaidiaddress", zhongchou.getZhongchouChenggongKuaidiaddress())
.eq("zhongchou_kuaidi_types", zhongchou.getZhongchouKuaidiTypes())
.eq("zhongchou_delete", zhongchou.getZhongchouDelete())
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ZhongchouEntity zhongchouEntity = zhongchouService.selectOne(queryWrapper);
if(zhongchouEntity==null){
zhongchou.setZhongchouClicknum(1);
ShangpinEntity shangpinEntity = shangpinService.selectById(zhongchou.getShangpinId());
zhongchou.setZhongchouMoney(zhongchou.getZhongchouKucunNumber() * shangpinEntity.getShangpinNewMoney());
zhongchou.setInsertTime(new Date());
zhongchou.setZhongchouDelete(1);
zhongchou.setCreateTime(new Date());
zhongchouService.insert(zhongchou);
return R.ok();
}else {
return R.error(511,"表中有相同数据");
}
}
/**
* 后端修改
*/
@RequestMapping("/update")
public R update(@RequestBody ZhongchouEntity zhongchou, HttpServletRequest request){
logger.debug("update方法:,,Controller:{},,zhongchou:{}",this.getClass().getName(),zhongchou.toString());
String role = String.valueOf(request.getSession().getAttribute("role"));
// if(false)
// return R.error(511,"永远不会进入");
// else if("用户".equals(role))
// zhongchou.setYonghuId(Integer.valueOf(String.valueOf(request.getSession().getAttribute("userId"))));
//根据字段查询是否有相同数据
Wrapper<ZhongchouEntity> queryWrapper = new EntityWrapper<ZhongchouEntity>()
.notIn("id",zhongchou.getId())
.andNew()
.eq("yonghu_id", zhongchou.getYonghuId())
.eq("shangpin_id", zhongchou.getShangpinId())
.eq("zhongchou_uuid_number", zhongchou.getZhongchouUuidNumber())
.eq("zhongchou_name", zhongchou.getZhongchouName())
.eq("zhongchou_types", zhongchou.getZhongchouTypes())
.eq("zhongchou_kucun_number", zhongchou.getZhongchouKucunNumber())
.eq("zhongchou_clicknum", zhongchou.getZhongchouClicknum())
.eq("zhongchou_zhuangtai_types", zhongchou.getZhongchouZhuangtaiTypes())
.eq("zhongchou_chenggong_name", zhongchou.getZhongchouChenggongName())
.eq("zhongchou_chenggong_phone", zhongchou.getZhongchouChenggongPhone())
.eq("zhongchou_chenggong_address", zhongchou.getZhongchouChenggongAddress())
.eq("zhongchou_chenggong_kuaidiname", zhongchou.getZhongchouChenggongKuaidiname())
.eq("zhongchou_chenggong_kuaidiaddress", zhongchou.getZhongchouChenggongKuaidiaddress())
.eq("zhongchou_kuaidi_types", zhongchou.getZhongchouKuaidiTypes())
.eq("zhongchou_delete", zhongchou.getZhongchouDelete())
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ZhongchouEntity zhongchouEntity = zhongchouService.selectOne(queryWrapper);
if(zhongchouEntity==null){
ShangpinEntity shangpinEntity = shangpinService.selectById(zhongchou.getShangpinId());
zhongchou.setZhongchouMoney(zhongchou.getZhongchouKucunNumber() * shangpinEntity.getShangpinNewMoney());
zhongchouService.updateById(zhongchou);//根据id更新
return R.ok();
}else {
return R.error(511,"表中有相同数据");
}
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Integer[] ids){
logger.debug("delete:,,Controller:{},,ids:{}",this.getClass().getName(),ids.toString());
ArrayList<ZhongchouEntity> list = new ArrayList<>();
for(Integer id:ids){
ZhongchouEntity zhongchouEntity = new ZhongchouEntity();
zhongchouEntity.setId(id);
zhongchouEntity.setZhongchouDelete(2);
list.add(zhongchouEntity);
}
if(list != null && list.size() >0){
zhongchouService.updateBatchById(list);
}
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");
try {
List<ZhongchouEntity> zhongchouList = 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){
//循环
ZhongchouEntity zhongchouEntity = new ZhongchouEntity();
// zhongchouEntity.setYonghuId(Integer.valueOf(data.get(0))); //用户 要改的
// zhongchouEntity.setShangpinId(Integer.valueOf(data.get(0))); //商品 要改的
// zhongchouEntity.setZhongchouUuidNumber(data.get(0)); //众筹编号 要改的
// zhongchouEntity.setZhongchouName(data.get(0)); //众筹名称 要改的
// zhongchouEntity.setZhongchouTypes(Integer.valueOf(data.get(0))); //众筹类型 要改的
// zhongchouEntity.setZhongchouKucunNumber(Integer.valueOf(data.get(0))); //众筹数量 要改的
// zhongchouEntity.setYichouMoney(data.get(0)); //已筹金额 要改的
// zhongchouEntity.setZhongchouMoney(data.get(0)); //众筹总额 要改的
// zhongchouEntity.setZhongchouClicknum(Integer.valueOf(data.get(0))); //热度 要改的
// zhongchouEntity.setZhongchouZhuangtaiTypes(Integer.valueOf(data.get(0))); //众筹状态 要改的
// zhongchouEntity.setZhongchouChenggongName(data.get(0)); //收件人姓名 要改的
// zhongchouEntity.setZhongchouChenggongPhone(data.get(0)); //收件人联系方式 要改的
// zhongchouEntity.setZhongchouChenggongAddress(data.get(0)); //收件人地址 要改的
// zhongchouEntity.setZhongchouChenggongKuaidiname(data.get(0)); //快递名称 要改的
// zhongchouEntity.setZhongchouChenggongKuaidiaddress(data.get(0)); //快递号 要改的
// zhongchouEntity.setZhongchouKuaidiTypes(Integer.valueOf(data.get(0))); //快递状态 要改的
// zhongchouEntity.setZhongchouContent("");//详情和图片
// zhongchouEntity.setInsertTime(date);//时间
// zhongchouEntity.setJieshuTime(sdf.parse(data.get(0))); //众筹截止时间 要改的
// zhongchouEntity.setZhongchouDelete(1);//逻辑删除字段
// zhongchouEntity.setCreateTime(date);//时间
zhongchouList.add(zhongchouEntity);
//把要查询是否重复的字段放入map中
//众筹编号
if(seachFields.containsKey("zhongchouUuidNumber")){
List<String> zhongchouUuidNumber = seachFields.get("zhongchouUuidNumber");
zhongchouUuidNumber.add(data.get(0));//要改的
}else{
List<String> zhongchouUuidNumber = new ArrayList<>();
zhongchouUuidNumber.add(data.get(0));//要改的
seachFields.put("zhongchouUuidNumber",zhongchouUuidNumber);
}
}
//查询是否重复
//众筹编号
List<ZhongchouEntity> zhongchouEntities_zhongchouUuidNumber = zhongchouService.selectList(new EntityWrapper<ZhongchouEntity>().in("zhongchou_uuid_number", seachFields.get("zhongchouUuidNumber")).eq("zhongchou_delete", 1));
if(zhongchouEntities_zhongchouUuidNumber.size() >0 ){
ArrayList<String> repeatFields = new ArrayList<>();
for(ZhongchouEntity s:zhongchouEntities_zhongchouUuidNumber){
repeatFields.add(s.getZhongchouUuidNumber());
}
return R.error(511,"数据库的该表中的 [众筹编号] 字段已经存在 存在数据为:"+repeatFields.toString());
}
zhongchouService.insertBatch(zhongchouList);
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));
// 没有指定排序字段就默认id倒序
if(StringUtil.isEmpty(String.valueOf(params.get("orderBy")))){
params.put("orderBy","id");
}
PageUtils page = zhongchouService.queryPage(params);
//字典表数据转换
List<ZhongchouView> list =(List<ZhongchouView>)page.getList();
for(ZhongchouView 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);
ZhongchouEntity zhongchou = zhongchouService.selectById(id);
if(zhongchou !=null){
//点击数量加1
zhongchou.setZhongchouClicknum(zhongchou.getZhongchouClicknum()+1);
zhongchouService.updateById(zhongchou);
//entity转view
ZhongchouView view = new ZhongchouView();
BeanUtils.copyProperties( zhongchou , view );//把实体数据重构到view中
//级联表
ShangpinEntity shangpin = shangpinService.selectById(zhongchou.getShangpinId());
if(shangpin != null){
BeanUtils.copyProperties( shangpin , view ,new String[]{ "id", "createDate"});//把级联的数据添加到view中,并排除id和创建时间字段
view.setShangpinId(shangpin.getId());
}
//级联表
YonghuEntity yonghu = yonghuService.selectById(zhongchou.getYonghuId());
if(yonghu != null){
BeanUtils.copyProperties( yonghu , view ,new String[]{ "id", "createDate"});//把级联的数据添加到view中,并排除id和创建时间字段
view.setYonghuId(yonghu.getId());
}
//修改对应字典表字段
dictionaryService.dictionaryConvert(view, request);
return R.ok().put("data", view);
}else {
return R.error(511,"查不到数据");
}
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody ZhongchouEntity zhongchou, HttpServletRequest request){
logger.debug("add方法:,,Controller:{},,zhongchou:{}",this.getClass().getName(),zhongchou.toString());
Wrapper<ZhongchouEntity> queryWrapper = new EntityWrapper<ZhongchouEntity>()
.eq("yonghu_id", zhongchou.getYonghuId())
.eq("shangpin_id", zhongchou.getShangpinId())
.eq("zhongchou_uuid_number", zhongchou.getZhongchouUuidNumber())
.eq("zhongchou_name", zhongchou.getZhongchouName())
.eq("zhongchou_types", zhongchou.getZhongchouTypes())
.eq("zhongchou_kucun_number", zhongchou.getZhongchouKucunNumber())
.eq("zhongchou_clicknum", zhongchou.getZhongchouClicknum())
.eq("zhongchou_zhuangtai_types", zhongchou.getZhongchouZhuangtaiTypes())
.eq("zhongchou_chenggong_name", zhongchou.getZhongchouChenggongName())
.eq("zhongchou_chenggong_phone", zhongchou.getZhongchouChenggongPhone())
.eq("zhongchou_chenggong_address", zhongchou.getZhongchouChenggongAddress())
.eq("zhongchou_chenggong_kuaidiname", zhongchou.getZhongchouChenggongKuaidiname())
.eq("zhongchou_chenggong_kuaidiaddress", zhongchou.getZhongchouChenggongKuaidiaddress())
.eq("zhongchou_kuaidi_types", zhongchou.getZhongchouKuaidiTypes())
.eq("zhongchou_delete", zhongchou.getZhongchouDelete())
;
logger.info("sql语句:"+queryWrapper.getSqlSegment());
ZhongchouEntity zhongchouEntity = zhongchouService.selectOne(queryWrapper);
if(zhongchouEntity==null){
zhongchou.setInsertTime(new Date());
zhongchou.setZhongchouDelete(1);
zhongchou.setCreateTime(new Date());
zhongchouService.insert(zhongchou);
return R.ok();
}else {
return R.error(511,"表中有相同数据");
}
}
}
论文参考
目 录
摘 要 I
目 录 III
第1章 绪论 1
1.1 研究背景 1
1.2目的和意义 1
1.3 论文研究内容 1
第2章 程序开发技术 3
2.1 Mysql数据库 3
2.2 Java语言 3
第3章 系统分析 5
3.1可行性分析 5
3.1.1技术可行性分析 5
3.1.2经济可行性分析 5
3.1.3操作可行性分析 6
3.2系统运行环境 6
3.3系统流程分析 6
第4章 系统设计 10
4.1 系统设计的原则 10
4.2 系统结构设计 10
4.3功能结构设计 11
4.4数据库设计 12
4.4.1 数据库E-R图 12
4.4.2 数据库表结构 13
第5章 系统实现 14
5.1管理员功能实现 14
5.1.1 众筹管理 14
5.1.2 商品信息管理 14
5.1.3商品类型管理 15
第6章 系统测试 16
6.1系统测试方法 16
6.2 系统功能测试 17
6.2.1 用户登录测试 17
6.2.2 添加账户功能测试 17
6.3 系统测试分析 17
结 论 18
致 谢 19
参考文献 20
扫一扫
362
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
