ssm+vue电子设备销售网站的设计与实现

ssm+vue电子设备销售网站的设计与实现230

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

电子设备销售网站的设计与实现

摘要

随着信息互联网购物的飞速发展，一般企业都去创建属于自己的电商平台以及购物管理系统。本文介绍了电子设备销售网站的开发全过程。通过分析企业对于电子设备销售网站的需求，创建了一个计算机管理电子设备销售网站的方案。文章介绍了电子设备销售网站的系统分析部分，包括可行性分析等，系统设计部分主要介绍了系统功能设计和数据库设计。

本电子设备销售网站管理员和用户两个角色。用户可以在首页进行商品购买，商品评价，商品收藏。有个人中心，我的订单，我的地址这些功能。管理员功能有，个人中心，用户管理，商品类别管理，热门推荐管理，积分商城管理，电子商城管理，销售统计管理，系统管理，订单管理等。因而具有一定的实用性。

本站是一个B/S模式系统，采用SSM框架作为开发技术，MYSQL数据库设计开发，充分保证系统的稳定性。系统具有界面清晰、操作简单，功能齐全的特点，使得电子设备销售网站管理工作系统化、规范化。

关键词：电子设备销售网站；SSM框架；MYSQL数据库

Abstract

With the rapid development of information Internet shopping, most companies create their own e-commerce platforms and shopping management systems. This article introduces the entire development process of the electronic equipment sales website. By analyzing the needs of enterprises for electronic equipment sales websites, a solution for computer management of electronic equipment sales websites was created. The article introduces the system analysis part of the electronic equipment sales website, including feasibility analysis, etc. The system design part mainly introduces the system function design and database design.

This electronic equipment sales website has two roles: administrator and user. Users can purchase goods, evaluate goods, and collect goods on the homepage. There are functions such as personal center, my order, and my address. Administrator functions include personal center, user management, product category management, popular recommendation management, point mall management, electronic mall management, sales statistics management, system management, order management, etc. So it has a certain practicability.

This site is a B/S model system, using SSM framework as the development technology, MYSQL database design and development, fully guarantee the stability of the system. The system has the characteristics of clear interface, simple operation and complete functions, which makes the management of electronic equipment sales website systematized and standardized.

Keywords:Electronic equipment sales website; SSM framework; MYSQL database

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.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.JifenshangchengEntity;
import com.entity.view.JifenshangchengView;

import com.service.JifenshangchengService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;


/**
 * 积分商城
 * 后端接口
 * @author 
 * @email 
 * @date 2021-04-19 05:59:14
 */
@RestController
@RequestMapping("/jifenshangcheng")
public class JifenshangchengController {
    @Autowired
    private JifenshangchengService jifenshangchengService;
    


    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,JifenshangchengEntity jifenshangcheng, 
		HttpServletRequest request){

        EntityWrapper<JifenshangchengEntity> ew = new EntityWrapper<JifenshangchengEntity>();
		PageUtils page = jifenshangchengService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jifenshangcheng), params), params));
        return R.ok().put("data", page);
    }
    
    /**
     * 前端列表
     */
	@IgnoreAuth
    @RequestMapping("/list")
    public R list(@RequestParam Map<String, Object> params,JifenshangchengEntity jifenshangcheng, HttpServletRequest request){
        EntityWrapper<JifenshangchengEntity> ew = new EntityWrapper<JifenshangchengEntity>();
		PageUtils page = jifenshangchengService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, jifenshangcheng), params), params));
        return R.ok().put("data", page);
    }

	/**
     * 列表
     */
    @RequestMapping("/lists")
    public R list( JifenshangchengEntity jifenshangcheng){
       	EntityWrapper<JifenshangchengEntity> ew = new EntityWrapper<JifenshangchengEntity>();
      	ew.allEq(MPUtil.allEQMapPre( jifenshangcheng, "jifenshangcheng")); 
        return R.ok().put("data", jifenshangchengService.selectListView(ew));
    }

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(JifenshangchengEntity jifenshangcheng){
        EntityWrapper< JifenshangchengEntity> ew = new EntityWrapper< JifenshangchengEntity>();
 		ew.allEq(MPUtil.allEQMapPre( jifenshangcheng, "jifenshangcheng")); 
		JifenshangchengView jifenshangchengView =  jifenshangchengService.selectView(ew);
		return R.ok("查询积分商城成功").put("data", jifenshangchengView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        JifenshangchengEntity jifenshangcheng = jifenshangchengService.selectById(id);
        return R.ok().put("data", jifenshangcheng);
    }

    /**
     * 前端详情
     */
    @RequestMapping("/detail/{id}")
    public R detail(@PathVariable("id") Long id){
        JifenshangchengEntity jifenshangcheng = jifenshangchengService.selectById(id);
        return R.ok().put("data", jifenshangcheng);
    }
    


    /**
     * 赞或踩
     */
    @RequestMapping("/thumbsup/{id}")
    public R thumbsup(@PathVariable("id") String id,String type){
        JifenshangchengEntity jifenshangcheng = jifenshangchengService.selectById(id);
        if(type.equals("1")) {
        	jifenshangcheng.setThumbsupnum(jifenshangcheng.getThumbsupnum()+1);
        } else {
        	jifenshangcheng.setCrazilynum(jifenshangcheng.getCrazilynum()+1);
        }
        jifenshangchengService.updateById(jifenshangcheng);
        return R.ok();
    }

    /**
     * 后端保存
     */
    @RequestMapping("/save")
    public R save(@RequestBody JifenshangchengEntity jifenshangcheng, HttpServletRequest request){
    	jifenshangcheng.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(jifenshangcheng);

        jifenshangchengService.insert(jifenshangcheng);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
    @RequestMapping("/add")
    public R add(@RequestBody JifenshangchengEntity jifenshangcheng, HttpServletRequest request){
    	jifenshangcheng.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(jifenshangcheng);

        jifenshangchengService.insert(jifenshangcheng);
        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    public R update(@RequestBody JifenshangchengEntity jifenshangcheng, HttpServletRequest request){
        //ValidatorUtils.validateEntity(jifenshangcheng);
        jifenshangchengService.updateById(jifenshangcheng);//全部更新
        return R.ok();
    }
    

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        jifenshangchengService.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<JifenshangchengEntity> wrapper = new EntityWrapper<JifenshangchengEntity>();
		if(map.get("remindstart")!=null) {
			wrapper.ge(columnName, map.get("remindstart"));
		}
		if(map.get("remindend")!=null) {
			wrapper.le(columnName, map.get("remindend"));
		}


		int count = jifenshangchengService.selectCount(wrapper);
		return R.ok().put("count", count);
	}
	


}

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.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.DiscussrementuijianEntity;
import com.entity.view.DiscussrementuijianView;

import com.service.DiscussrementuijianService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;


/**
 * 热门推荐评论表
 * 后端接口
 * @author 
 * @email 
 * @date 2021-04-19 05:59:14
 */
@RestController
@RequestMapping("/discussrementuijian")
public class DiscussrementuijianController {
    @Autowired
    private DiscussrementuijianService discussrementuijianService;
    


    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,DiscussrementuijianEntity discussrementuijian, 
		HttpServletRequest request){

        EntityWrapper<DiscussrementuijianEntity> ew = new EntityWrapper<DiscussrementuijianEntity>();
		PageUtils page = discussrementuijianService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, discussrementuijian), params), params));
        return R.ok().put("data", page);
    }
    
    /**
     * 前端列表
     */
	@IgnoreAuth
    @RequestMapping("/list")
    public R list(@RequestParam Map<String, Object> params,DiscussrementuijianEntity discussrementuijian, HttpServletRequest request){
        EntityWrapper<DiscussrementuijianEntity> ew = new EntityWrapper<DiscussrementuijianEntity>();
		PageUtils page = discussrementuijianService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, discussrementuijian), params), params));
        return R.ok().put("data", page);
    }

	/**
     * 列表
     */
    @RequestMapping("/lists")
    public R list( DiscussrementuijianEntity discussrementuijian){
       	EntityWrapper<DiscussrementuijianEntity> ew = new EntityWrapper<DiscussrementuijianEntity>();
      	ew.allEq(MPUtil.allEQMapPre( discussrementuijian, "discussrementuijian")); 
        return R.ok().put("data", discussrementuijianService.selectListView(ew));
    }

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(DiscussrementuijianEntity discussrementuijian){
        EntityWrapper< DiscussrementuijianEntity> ew = new EntityWrapper< DiscussrementuijianEntity>();
 		ew.allEq(MPUtil.allEQMapPre( discussrementuijian, "discussrementuijian")); 
		DiscussrementuijianView discussrementuijianView =  discussrementuijianService.selectView(ew);
		return R.ok("查询热门推荐评论表成功").put("data", discussrementuijianView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        DiscussrementuijianEntity discussrementuijian = discussrementuijianService.selectById(id);
        return R.ok().put("data", discussrementuijian);
    }

    /**
     * 前端详情
     */
    @RequestMapping("/detail/{id}")
    public R detail(@PathVariable("id") Long id){
        DiscussrementuijianEntity discussrementuijian = discussrementuijianService.selectById(id);
        return R.ok().put("data", discussrementuijian);
    }
    



    /**
     * 后端保存
     */
    @RequestMapping("/save")
    public R save(@RequestBody DiscussrementuijianEntity discussrementuijian, HttpServletRequest request){
    	discussrementuijian.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(discussrementuijian);

        discussrementuijianService.insert(discussrementuijian);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
    @RequestMapping("/add")
    public R add(@RequestBody DiscussrementuijianEntity discussrementuijian, HttpServletRequest request){
    	discussrementuijian.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(discussrementuijian);

        discussrementuijianService.insert(discussrementuijian);
        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    public R update(@RequestBody DiscussrementuijianEntity discussrementuijian, HttpServletRequest request){
        //ValidatorUtils.validateEntity(discussrementuijian);
        discussrementuijianService.updateById(discussrementuijian);//全部更新
        return R.ok();
    }
    

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        discussrementuijianService.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<DiscussrementuijianEntity> wrapper = new EntityWrapper<DiscussrementuijianEntity>();
		if(map.get("remindstart")!=null) {
			wrapper.ge(columnName, map.get("remindstart"));
		}
		if(map.get("remindend")!=null) {
			wrapper.le(columnName, map.get("remindend"));
		}


		int count = discussrementuijianService.selectCount(wrapper);
		return R.ok().put("count", count);
	}
	


}