大数据Vue项目案例总结_随笔

大数据Vue项目案例总结

在本月我们学习了Vue的基础知识，结合所学的内容，做了一个小的项目健康管理系统，开发所含的需求,检查项或检查组的增删改查，导入导出，缓存数据用定时任务删除，以及柱状图和柱状图，若本文对你有所帮助，建议一键三连。

创建maven项目模块，导入相关的jar包以及依赖。

，

建表建库：

create   table   kew(
  id  int  primary key  auto_increment,
  kid  varchar(20),
name  varchar(20),
  shi  varchar(20),
  xing  varchar(20),
  xue  varchar(20),
  ming  varchar(20)

)

  create   table   studentw(
id int  primary key   auto_increment,
    sid  varchar(20),
    name  varchar(20),
    sex  varchar(20),
    age    int,
    address  varchar(20),
    zhu  varchar(20)

  )
  create  table   zhongjian(
    s_id  int,
    k_id   int,
    foreign key (s_id)  references    studentw  (id),
    foreign key (k_id)  references    kew  (id)

  )

insert into studentw (id, sid, name, sex, age, address, zhu)
values
       (1,'100','小明','男',21,'河南','优秀'),
       (2,'101','小红','男',21,'南阳','低级'),
       (3,'102','小黑','男',41,'内乡','H欧'),
       (4,'103','小有','女',11,'河南','优秀');

insert into kew (id, kid, name, shi, xing, xue, ming)
values
       (1,'200','大数据','10','理科','500','理科据就是好'),
       (2,'201','语文','10','文科','500','大就是好'),
       (3,'202','英语','11','文科','100','大就是好'),
       (4,'203','数学','22','理科','900','大就是好'),
       (5,'204','政治','13','文科','100','大就是好');

insert into zhongjian (s_id, k_id)
values
       (1,1),
       (2,2),
       (3,3),
       (4,1),
       (1,1);

创建对应的实体类：

public class Student implements Serializable {

    private  Integer id;
    private  String  sid;
    private  String  name;
    private  String  sex;
    private  Integer age;
    private  String  address;
    private  String  zhu;
    private String names;
    
    private   List  k;
提供get和set方法
}

public class Ke implements Serializable {

    private  Integer id;
    private  String kid;
    private  String name;
    private  String shi;
    private  String xing;
    private  String xue;
    private  String ming;
}

检查项前端：

controller:

package com.jiyun.controller;

import com.alibaba.dubbo.config.annotation.Reference;
import com.alibaba.fastjson.JSON;
import com.jiyun.constant.MessageConstant;
import com.jiyun.entity.PageResult;
import com.jiyun.entity.QueryPageBean;
import com.jiyun.entity.Result;
import com.jiyun.pojo.Ke;
import com.jiyun.service.KeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import redis.clients.jedis.Jedis;
import redis.clients.jedis.JedisPool;

import java.util.List;

@RestController
@RequestMapping("ke")
public class KeController {
@Autowired
    JedisPool  jedisPool;
    @Reference
    KeService  keService;

 @RequestMapping("findPage")
    public PageResult findPage  (@RequestBody QueryPageBean  queryPageBean){
     return   keService.findPage(queryPageBean);
 }
    @RequestMapping("add")
    public Result add  (@RequestBody Ke ke){
        keService.add(ke);

        Jedis redis = jedisPool.getResource();

        String s = JSON.toJSonString(ke);
        redis.lpush("list",s);

        return   new Result(true, MessageConstant.ADD_CHECKITEM_SUCCESS);
    }
    @RequestMapping("findAll")
    public Result findAll  (){
    List  list= keService.findAll();
        return   new Result(true, MessageConstant.ADD_CHECKITEM_SUCCESS,list);
    }
    @RequestMapping("update")
    public Result update  (@RequestBody  Ke ke){

        Jedis redis = jedisPool.getResource();
//        通过这个对象获取id
        Integer id = ke.getId();
//        通过这个id 返回的是对象
        Ke  s=    keService.getid(id);

        String s1 = JSON.toJSonString(s);
        redis.lpush("list",s1);

        keService.update(ke);
        return   new Result(true, MessageConstant.EDIT_CHECKITEM_SUCCESS);
    }

    @RequestMapping("del")
    public Result del  (Integer  id){
     Integer  count=keService.getids(id);

     if(count>0){
         return   new Result(false, "数据有关联，不能删除");

     }

        keService.del(id);
        return   new Result(true, MessageConstant.DELETE_CHECKITEM_SUCCESS);
    }

}

service

package com.jiyun.service;

import com.alibaba.dubbo.config.annotation.Service;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.jiyun.entity.PageResult;
import com.jiyun.entity.QueryPageBean;
import com.jiyun.mapper.KeMapper;
import com.jiyun.pojo.Ke;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.List;

@Service
public class KeServiceimpl   implements KeService{
    @Autowired
    KeMapper  keMapper;
    @Override
    public PageResult findPage(QueryPageBean queryPageBean) {

        PageHelper.startPage(queryPageBean.getCurrentPage(), queryPageBean.getPageSize());
        List  list=keMapper.findPage(queryPageBean.getQueryString());
        PageInfo page = new PageInfo<>(list);
        return   new PageResult( page.getTotal(),page.getList());
    }

    @Override
    public void add(Ke ke) {
        keMapper.add(ke);
    }

    @Override
    public void update(Ke ke) {
        keMapper.update(ke)  ;
    }


    @Override
    public void del(Integer id) {
        keMapper.del(id)  ;
    }

    @Override
    public List findAll() {
        return keMapper.findAll();
    }

    @Override
    public Ke getid(Integer id) {
        return keMapper.getifd(id);
    }

    @Override
    public Integer getids(Integer id) {
        return keMapper.getwq(id);
    }
}

mapper.xml





    

    
        select    *  from   kew
    

    
        select   *   from   studentw
        
            where sid=#{value}  or  name=#{value}
        
    


    
          select   k_id  from    zhongjian   where s_id=#{id}