想用Vue搭建考试答卷系统吗?

Jacquelyn38
• 阅读 1656

欢迎阅读本文,本文主要讲述【怎样用Vue搭建考试答卷系统】,文字通俗易懂,如有不妥,还请多多指正。

本篇章主要讲述系统搭建逻辑,有疑问的可以加微信联系我。

考试系统


想用Vue搭建考试答卷系统吗?

在这里插入图片描述

资源


  • Vue.js

  • Element UI

  • 第三方数据接口

业务


  1. 答题过程中,防止用户中途退出或者其他不可抗力因素阻碍答题,在每次选择都要请求下接口(接口状态为「未交卷」,只是保存用户的答题进度)。

  2. 选择答题区与答题卡必须同步,另外右侧的进度条也是同步的。

  3. 剩余时间的计算方法( begin.getTime() + duration * 1000 - serverTime.getTime()), 即开始考试时间+考试时间-服务器时间,首次进入开始考试时间为空。

  4. 考试时间到或者主动交卷都是置为已交卷。

源码


「Exam.vue」

<!-- 考试系统 -->  
<template>  
  <div class="exam">  
    <div class="main">  
      <div class="header-wrapper">  
        <div class="inner">  
          <el-row>  
            <el-col :span="18">  
              <div class="grid-content bg-purple ovf left">  
                <div class="logo">  
                  <router-link to="/">  
                    <img src="../../assets/images/logo.png" />  
                  </router-link>  
                </div>  
                <div class="index">{{title}}</div>  
              </div>  
            </el-col>  
            <el-col :span="6">  
              <div class="grid-content bg-purple right ovf">  
                <div class="esc" @click="esc">退出</div>  
                <div class="name">{{name}}</div>  
              </div>  
            </el-col>  
          </el-row>  
        </div>  
      </div>  
      <div class="mian-body">  
        <div class="main-side">  
          <div class="title">  
            <div class="title_border"></div>  
            <div class="title_content">答题卡</div>  
          </div>  
          <div class="card-content-list">  
            <div class="card-content">  
              <div class="card-content-title">单选题(共{{examinationData.length}}题,合计{{full_score}}分)</div>  
              <div class="box-list">  
                <div  
                  class="box normal-box question_cbox"  
                  v-for="(item,index) in examinationData"  
                  :key="index"  
                >  
                  <div  
                    class="checki"  
                    :class="{'checked':radio[index]}"  
                    v-show="!checkResult"  
                  >{{index+1}}</div>  
                  <div  
                    class="checki checked"  
                    :class="{'check-error':radio[index]}"  
                    v-show="checkResult"  
                  >{{index+1}}</div>  
                </div>  
              </div>  
            </div>  
          </div>  
        </div>  
        <div class="main-center">  
          <div class="body-wrapper">  
            <div class="questions">  
              <div class="questions-title">单选题(共{{examinationData.length}}题,合计{{full_score}}分)</div>  
              <div class="questions-content">  
                <div class="question-content" v-for="(item,i) in examinationData" :key="i">  

                  <div v-if="item.type=='radiogroup'">  
                    <div class="exam-question">  
                      <span class="question-index ellipsis">{{i+1}}.</span>  
                      {{item.title}}  
                    </div>  
                    <div v-if="!checking">  
                      <div class="answers" v-for="(son,index) in item.choices" :key="index">  
                        <el-radio-group v-model="radio[i]">  
                          <el-radio  
                            v-model="radio[i]"  
                            :label="son.value"  
                            :name="son.text"  
                            @change="getIputValue(i)"  
                          >{{son.text}}</el-radio>  
                        </el-radio-group>  
                      </div>  
                    </div>  
                    <div v-else>  
                      <div class="answers" v-for="(son,index) in item.choices" :key="index">  
                        <el-radio-group v-model="checkData[i].value">  
                          <el-radio  
                            v-model="radio[i]"  
                            :label="son.value"  
                            :name="son.text"  
                            @change="getIputValue(i)"  
                          >{{son.text}}</el-radio>  
                        </el-radio-group>  
                      </div>  
                    </div>  
                  </div>  

                  <div v-if="item.type=='imagepicker'">  
                    <div class="exam-question">  
                      <span class="question-index ellipsis">{{i+1}}.</span>  
                      {{item.title}}  
                    </div>  
                    <div v-if="!checking">  
                      <div class="answers" v-for="(son,index) in item.choices" :key="index">  
                        <el-radio-group v-model="radio[i]">  
                          <el-radio  
                            v-model="radio[i]"  
                            :label="son.value"  
                            :name="son.value"  
                            @change="getIputValue(i)"  
                          >  
                            <img :src="son.imageLink" alt />  
                          </el-radio>  
                        </el-radio-group>  
                      </div>  
                    </div>  
                    <div v-else>  
                      <div class="answers" v-for="(son,index) in item.choices" :key="index">  
                        <el-radio-group v-model="checkData[i].value">  
                          <el-radio  
                            v-model="radio[i]"  
                            :label="son.value"  
                            :name="son.value"  
                            @change="getIputValue(i)"  
                          >  
                            <img :src="son.imageLink" alt />  
                          </el-radio>  
                        </el-radio-group>  
                      </div>  
                    </div>  
                  </div>  
                  <!-- <div class="analysis" v-show="checkResult">  
                    <div class="question-icon-wrapper">  
                      <div>  
                        <i class="sign icon-right" v-show="signView">正确</i>  
                        <i class="sign icon-error" v-show="!signView">错误</i>  
                      </div>  
                    </div>  
                    <div class="analysis-row">  
                      <div class="analysis-title">学员答案:</div>  
                      <div class="analysis-content error">A</div>  
                    </div>  
                    <div class="analysis-row">  
                      <div class="analysis-title">正确答案:</div>  
                      <div class="analysis-content">B</div>  
                    </div>  
                    <div class="analysis-row">  
                      <div class="analysis-title">解释说明:</div>  
                      <div class="analysis-content question-analysis">11111111111111111111111111</div>  
                    </div>  
                  </div>-->  
                </div>  
              </div>  
            </div>  
          </div>  
        </div>  
        <div class="main-right">  
          <div class="nav">  
            <ul v-show="!checkResult">  
              <li class="menu-item">  
                <div class="item-label">剩余时间</div>  
                <div class="item-data">  
                  <Time  
                    @show="handInHand"  
                    :status="submitView"  
                    :examtime="examtime"  
                    v-if="examtime!=''"  
                  ></Time>  
                </div>  
              </li>  
              <li class="menu-item">  
                <div class="item-label">当前进度</div>  
                <div class="item-press">  
                  <span>{{radio.filter(v=>v).length}}</span>  
                  <span>{{examinationData.length}}</span>  
                </div>  
                <div class="percentage">  
                  <el-progress :percentage="percentage" :color="customColor"></el-progress>  
                </div>  
              </li>  
            </ul>  
            <!-- <ul v-show="checkResult">  
              <li class="menu-item">  
                <div class="item-label">考试成绩</div>  
                <div class="item-result">90</div>  
              </li>  
              <li class="menu-item">  
                <div class="item-label">考试状态</div>  
                <div class="item-satus pass" v-show="passView">通过</div>  
                <div class="item-satus unpass" v-show="!passView">未通过</div>  
              </li>  
              <li class="menu-item">  
                <div class="item-label">筛选试题</div>  
                <el-select v-model="checkVal" placeholder="请选择">  
                  <el-option  
                    v-for="item in options"  
                    :key="item.value"  
                    :label="item.label"  
                    :value="item.value"  
                  ></el-option>  
                </el-select>  
              </li>  
            </ul>-->  
          </div>  
          <div class="btn" v-show="!checkResult" @click="submit">提交</div>  
        </div>  
      </div>  
    </div>  
  </div>  
</template>  

<script>  
import axios from "axios";  
import { saveAnswers } from "../../request/api";  
import { mapGetters } from "vuex";  
import Time from "../../components/module/Time"; // 倒计时组件  
export default {  
  name: "Exam",  
  data() {  
    return {  
      checkData: [],  
      checking: false,  
      name: "",  
      examtime: "",  
      title: "",  
      customColor: "#55b6da",  
      percentage: 0,  
      submitView: false,  
      full_score: "",  
      signView: false, // 正确与错误  
      passView: false, // 通过或者未通过  
      checkResult: false, // 左侧栏、右侧栏、答题结果栏  
      options: [  
        {  
          value: "0",  
          label: "全部"  
        },  
        {  
          value: "1",  
          label: "答对"  
        },  
        {  
          value: "2",  
          label: "答错"  
        }  
      ],  
      checkVal: "0",  
      examinationData: "",  
      allRadio: [], //提交给后台的真题数据  
      radio: [], //单选真题答案,  
      checkLen: [],  
      obj: { value: "" },  
      answersData: []  
    };  
  },  
  computed: {  
    ...mapGetters(["getInfo"])  
  },  
  methods: {  
    // 退出考试系统  
    esc() {  
      this.$router.push({  
        path: "/"  
      });  
    },  
    // 主动交卷  
    submit() {  
      this.$confirm("确定交卷吗?", "提示", {  
        distinguishCancelAndClose: true,  
        confirmButtonText: "交卷",  
        cancelButtonText: "不交卷",  
        type: "warning"  
      })  
        .then(() => {  
          if (this.checking === false) {  
            this.answersData.value = this.radio || "";  
            this.upAnswer(1, JSON.stringify(this.answersData)); //提交答案  
          } else {  
            this.upAnswer(1, JSON.stringify(this.checkData)); //提交答案  
          }  
          this.submitView = true; // 提示已提交  
        })  
        .catch(err => {  
          console.log(err);  
        });  
    },  
    // 自动交卷(时间到)  
    handInHand() {  
      // this.signView = true; // 正确与错误  
      // this.passView = true; // 通过或者未通过  
      // this.checkResult = true; // 左侧栏、右侧栏、答题结果栏  
      if (this.checking === false) {  
        this.answersData.value = this.radio || "";  
        this.upAnswer(1, JSON.stringify(this.answersData)); //提交答案  
      } else {  
        this.upAnswer(1, JSON.stringify(this.checkData)); //提交答案  
      }  
    },  
    // 提交答案接口  
    upAnswer(finish, answers) {  
      let postData = {  
        exam_id: Number(this.$route.params.id),  
        finish: finish,  
        answers: answers  
      };  
      saveAnswers(postData)  
        .then(res => {  
          if (res.code == 0) {  
            console.log("提交/保存答案成功")  
          } else if (res.code == 201) {  
            this.$message.success({  
              message: res.msg,  
              offset: 380,  
              duration: 1000  
            });  
          } else {  
            this.$message.warning({  
              message: res.msg,  
              offset: 380,  
              duration: 1000  
            });  
          }  
        })  
        .catch(err => {  
          console.log(err);  
        });  
    },  
    // 获取考试题  
    get() {  
      if (this.$route.params.id != "" && this.$route.params.id != undefined) {  
        axios  
          .get("/api/exams/" + this.$route.params.id)  
          .then(res => {  
            if (res.data.code == 0) {  
              let data = res.data.data.item.exercise;  
              this.title = res.data.data.item.name;  
              this.examtime = this.toHHmmss(  
                this.madeTime(  
                  res.data.serverTime,  
                  res.data.data.userExam.begin_at,  
                  res.data.data.item.duration  
                )  
              );  
              this.examinationData = data.pages[0].elements;  
              this.examinationData.forEach((item, i) => {  
                this.answersData[i] = { value: "" };  
              });  
              if (res.data.data.userExam.answer != null) {  
                let fobj = JSON.parse(res.data.data.userExam.answer);  
                this.checkData = JSON.parse(res.data.data.userExam.answer);  
                fobj.forEach((item, i) => {  
                  if (item.value != "") {  
                    this.radio[i] = item;  
                  }  
                });  
                this.checking = true;  
                let len =  
                  (this.radio.filter(v => v).length /  
                    this.examinationData.length) *  
                  100;  
                this.percentage = len;  
              }  
              this.full_score = res.data.data.item.full_score;  
            }  
          })  
          .catch(err => {  
            console.log(err);  
          });  
      }  
    },  
    // 倒计时处理  
    madeTime(serverTime1, begin1, duration1) {  
      var serverTime = new Date(serverTime1); // 系统时间  
      var duration = duration1; //考试时间  
      if (begin1 != null) {  
        var begin = new Date(begin1); //开始时间  
        var residue = begin.getTime() + duration * 1000 - serverTime.getTime(); // 倒计时  
      } else {  
        // eslint-disable-next-line no-redeclare  
        var residue = duration * 1000 - serverTime.getTime(); // 倒计时  
      }  
      return residue;  
    },  
    // 时间戳时分秒  
    toHHmmss(data) {  
      let date = {};  
      let hours = parseInt((data % (1000 * 60 * 60 * 24)) / (1000 * 60 * 60));  
      let minutes = parseInt((data % (1000 * 60 * 60)) / (1000 * 60));  
      let seconds = (data % (1000 * 60)) / 1000;  
      date.hours = hours;  
      date.minutes = minutes;  
      date.seconds = seconds;  
      return date;  
    },  
    // 选择操作  
    getIputValue(index) {  
      this.allRadio[index] = this.radio[index]; // 将数据存入提交给后台的数据中  
      let len =  
        (this.radio.filter(v => v).length / this.examinationData.length) * 100;  
      this.percentage = len;  
      if (this.checking === false) {  
        this.answersData[index].value = this.radio[index] || "";  
        this.upAnswer(0, JSON.stringify(this.answersData)); //提交答案  
      } else {  
        this.upAnswer(0, JSON.stringify(this.checkData)); //提交答案  
      }  
    }  
  },  
  beforeRouteEnter(to, from, next) {  
    next(() => {  
      // 改变html背景  
      document.querySelector("html").style.cssText = `  
        background: #ecf1f6;  
      `;  
    });  
  },  
  beforeRouteLeave(to, from, next) {  
    // 消除html背景  
    document.querySelector("html").style.cssText = `background: #fff;`;  
    // 中途退出提示  
    this.$confirm("确定中途退出吗, 是否继续?", "提示", {  
      confirmButtonText: "确定",  
      cancelButtonText: "取消",  
      type: "warning"  
    })  
      .then(() => {  
        next();  
      })  
      .catch();  
  },  
  components: {  
    Time  
  },  
  created() {  
    this.get();  
  },  
  mounted() {  
    this.name = this.getInfo.name;  
  }  
};  
</script>  


<style scoped lang="scss">  
/deep/ .el-progress__text {  
  display: none;  
}  
/deep/ .el-select .el-input__inner:focus {  
  border-color: #55b6da;  
}  
/deep/ .el-select {  
  border: none;  
}  
/deep/ .el-select-dropdown__item.selected {  
  color: #55b6da !important;  
  font-weight: bold;  
}  
/deep/ .el-radio__input.is-checked + .el-radio__label {  
  color: #55b6da;  
}  
/deep/ .el-radio__input.is-checked .el-radio__inner {  
  border-color: #55b6da;  
  background: #55b6da;  
}  
/deep/ .el-radio__inner:hover {  
  border-color: #55b6da;  
}  
/deep/ .el-radio {  
  display: block;  
  margin: 20px 0;  
}  
.inner {  
  padding: 0px 90px;  
}  
.exam {  
  background: #ecf1f6;  
  height: 100%;  
  min-height: 100%;  
}  
.main {  
  .header-wrapper {  
    height: 80px;  
    width: 100%;  
    line-height: 80px;  
    background: #ffffff;  
    box-shadow: 0 2px 4px 0 rgba(153, 153, 153, 0.1);  
    position: fixed;  
    top: 0;  
    left: 0;  
    z-index: 1040;  
    .left {  
      display: flex;  
      align-items: center;  
      font-size: 18px;  
      .logo {  
        width: 150px;  
        margin-right: 120px;  
        img {  
          width: 100%;  
        }  
      }  
    }  
    .right {  
      div {  
        float: right;  
        font-size: 16px;  
      }  
      .esc {  
        width: 120px;  
        height: 38px;  
        line-height: 38px;  
        margin: 21px 0;  
        color: #fff;  
        background: #55b6da;  
        border-radius: 30px;  
        text-align: center;  
        cursor: pointer;  
        user-select: none;  
        &:hover {  
          filter: brightness(80%);  
        }  
        &:active {  
          filter: brightness(60%);  
        }  
      }  
      .name {  
        margin-right: 55px;  
        font-weight: bold;  
      }  
    }  
  }  
  .mian-body {  
    .main-side {  
      display: inline-block;  
      height: calc(100% - 140px);  
      position: fixed;  
      top: 120px;  
      width: 240px;  
      left: 90px;  
      background: #fff;  
      box-shadow: 0 1px 4px 0 rgba(58, 62, 81, 0.1);  
      .title {  
        position: relative;  
        text-align: left;  
        margin: 23px 0px 0px 12px;  
        .title_border {  
          display: inline-block;  
          width: 4px;  
          height: 26px;  
          background: #33394b;  
          border-radius: 15px;  
          position: absolute;  
          top: 0;  
          bottom: 0;  
          margin: auto;  
        }  
        .title_content {  
          margin-left: 14px;  
          font-size: 18px;  
          font-weight: 600;  
          color: #27274a;  
        }  
      }  
      .card-content-list {  
        height: calc(100% - 38px);  
        overflow: auto;  
        .card-content {  
          padding: 0 12px 0 12px;  
          position: relative;  
          .card-content-title {  
            font-size: 14px;  
            color: #27274a;  
            font-weight: 600;  
            padding-bottom: 12px;  
            padding-top: 20px;  
          }  
          .box-list {  
            padding-bottom: 0;  
            position: relative;  
            left: -5px;  
            font-size: 0;  
            margin-right: -15px;  
            .box {  
              height: auto;  
              line-height: unset;  
              position: relative;  
              margin-bottom: 15px;  
              font-size: 14px;  
              width: 35px;  
              margin-top: unset;  
              margin-right: unset;  
              display: inline-block;  
              .checki {  
                border: 1px solid #dcdfe6;  
                color: #dcdfe6;  
                width: 27px;  
                height: 27px;  
                text-align: center;  
                display: inline-block;  
                line-height: 27px;  
                background: #fff;  
                border-radius: 50%;  
                cursor: pointer;  
              }  
              .checked {  
                color: #fff;  
                background: #55b6da;  
              }  
              .check-error {  
                color: #fff;  
                background: #ec6941;  
              }  
            }  
          }  
        }  
      }  
    }  
    .main-center {  
      margin: 120px 230px 0px 360px;  
      height: 100vh;  
      .body-wrapper {  
        color: #27274a;  
        width: 100%;  
        background: #ffffff;  
        border: 1px solid #dedede;  
        border-radius: 4px;  
        .questions-title {  
          font-size: 18px;  
          line-height: 25px;  
          padding: 18px 20px;  
          background: #fafafa;  
          border-bottom: 1px solid #dedede;  
        }  
        .questions-content {  
          padding-left: 30px;  
          padding-right: 75px;  
        }  
        .question-content {  
          border-bottom: 1px solid #dedede;  
          padding: 30px 0;  
          position: relative;  
          &:last-child {  
            border: none;  
          }  
          .exam-question {  
            font-size: 16px;  
            line-height: 22px;  
            margin-bottom: 10px;  
            padding-left: 20px;  
            position: relative;  
            .question-index {  
              color: #55b6da;  
              position: absolute;  
              left: -25px;  
              top: 0;  
              display: inline-block;  
              width: 40px;  
              line-height: 22px;  
              text-align: right;  
            }  
          }  
          .analysis {  
            overflow: auto;  
            background: rgba(222, 222, 222, 0.2);  
            border-radius: 4px;  
            padding: 15px 20px;  
            line-height: 24px;  
            margin-top: 10px;  
            position: relative;  
            .question-icon-wrapper {  
              position: absolute;  
              right: 10px;  
              top: 14px;  
              .sign {  
                width: 48px;  
                height: 28px;  
                position: absolute;  
                color: #fff;  
                top: 10px;  
                right: 0;  
                font-size: 14px;  
                border-radius: 2px;  
                line-height: 28px;  
                text-align: center;  
                font-style: normal;  
              }  
              .icon-error {  
                background: #ec6941;  
              }  
              .icon-right {  
                background: #55b6da;  
              }  
            }  
            .analysis-row {  
              font-size: 14px;  
              margin-top: 10px;  
              min-height: 24px;  
              padding-left: 80px;  
              padding-right: 60px;  
              position: relative;  
              .analysis-title {  
                position: absolute;  
                width: 80px;  
                left: 0;  
                top: 0;  
              }  
              .question-analysis {  
                text-align: justify;  
              }  
              .error {  
                color: #f72a3a;  
                font-weight: bold;  
              }  
            }  
          }  
        }  
      }  
    }  
    .main-right {  
      right: 90px;  
      bottom: 20px;  
      position: fixed;  
      top: 120px;  
      width: 120px;  
      .nav {  
        color: #27274a;  
        line-height: 20px;  
        padding: 0 10px;  
        background: #ffffff;  
        box-shadow: 0 1px 4px 0 rgba(0, 0, 0, 0.1);  
        border-radius: 4px;  
        margin-bottom: 10px;  
        text-align: center;  
        .menu-item {  
          padding: 14px 0;  
          border-bottom: 1px solid #dedede;  
        }  
        .menu-item:last-child {  
          border: none;  
        }  
        .pass {  
          color: #55b6da;  
        }  
        .item-result,  
        .unpass {  
          color: rgb(236, 105, 65);  
        }  
        .item-label {  
          margin-bottom: 6px;  
        }  
        .item-data {  
          font-size: 18px;  
          line-height: 22px;  
          color: #ff0000;  
          font-weight: 400;  
        }  
        .item-press {  
          line-height: 17px;  
          margin-bottom: 7px;  
          color: #27274a;  
          font-size: 14px;  
          & span:nth-child(1)::after {  
            content: "/";  
            margin: 0 5px;  
          }  
        }  
      }  
      .btn {  
        bottom: -10px;  
        position: absolute;  
        width: 100%;  
        margin-bottom: 10px;  
        cursor: pointer;  
        text-align: center;  
        height: 38px;  
        line-height: 38px;  
        border-radius: 20px;  
        color: #fff;  
        background: #33394b;  
        user-select: none;  
        &:hover {  
          filter: brightness(120%);  
        }  
        &:active {  
          filter: brightness(60%);  
        }  
      }  
    }  
  }  
}  
</style>  



「Time.vue」

<!-- 考试倒计时组件 -->  
<template>  
  <div class="time">  
    <p>{{timerHours}}:{{timerMinutes}}:{{timerSeconds}}</p>  
  </div>  
</template>  

<script>  
export default {  
  name: "Time",  
  props: ["status", "examtime"],  
  data() {  
    return {  
      hours: "",  
      seconds: "",  
      minutes: "",  
      timer: null  
    };  
  },  
  watch: {  
    status(v) {  
      if (v) {  
        clearInterval(this.timer);  
        this.$emit("show");  
      }  
    }  
  },  
  methods: {  
    // 倒计时  
    timing() {  
      this.timer = setInterval(() => {  
        if (this.seconds == 0&this.minutes>0) {  
          this.seconds = 59;  
          this.minutes--;  
        } else if (this.minutes == 0&&this.hours>0) {  
          this.minutes=59;  
          this.hours--;  
        } else if (this.minutes == 0 && this.seconds == 0 && this.hours == 0) {  
          this.seconds = 0;  
          clearInterval(this.timer);  
          this.$emit("show");  
          this.$message.warning({  
            message: "考试时间到,自动交卷!",  
            offset: 380,  
            duration: 1000  
          });  
        } else {  
          this.seconds--;  
        }  
      }, 1000);  
    }  
  },  
  created() {  
    this.minutes = this.examtime.minutes;  
    this.seconds = this.examtime.seconds;  
    this.hours = this.examtime.hours;  
  },  
  mounted() {  
    this.timing();  
  },  
  computed: {  
    timerSeconds() {  
      return this.seconds < 10 ? "0" + this.seconds : "" + this.seconds;  
    },  
    timerMinutes() {  
      return this.minutes < 10 ? "0" + this.minutes : "" + this.minutes;  
    },  
    timerHours() {  
      return this.hours < 10 ? "0" + this.hours : "" + this.hours;  
    }  
  },  
  destroyed() {  
    // 退出后清除计时器  
    if (this.timer) {  
      clearInterval(this.timer);  
    }  
  }  
};  
</script>  


<style scoped lang="scss">  
</style>  




作者:「Vam的金豆之路」

主要领域:「前端开发」

我的微信:「maomin9761」

微信公众号:「前端历劫之路」

想用Vue搭建考试答卷系统吗?


本文转转自微信公众号前端历劫之路原创https://mp.weixin.qq.com/s/GaU-A_uvzQaq_Pn1BWi3ig,如有侵权,请联系删除。

点赞
收藏
评论区
推荐文章
blmius blmius
3年前
MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1
文章目录问题用navicat导入数据时,报错:原因这是因为当前的MySQL不支持datetime为0的情况。解决修改sql\mode:sql\mode:SQLMode定义了MySQL应支持的SQL语法、数据校验等,这样可以更容易地在不同的环境中使用MySQL。全局s
皕杰报表之UUID
​在我们用皕杰报表工具设计填报报表时,如何在新增行里自动增加id呢?能新增整数排序id吗?目前可以在新增行里自动增加id,但只能用uuid函数增加UUID编码,不能新增整数排序id。uuid函数说明:获取一个UUID,可以在填报表中用来创建数据ID语法:uuid()或uuid(sep)参数说明:sep布尔值,生成的uuid中是否包含分隔符'',缺省为
待兔 待兔
4个月前
手写Java HashMap源码
HashMap的使用教程HashMap的使用教程HashMap的使用教程HashMap的使用教程HashMap的使用教程22
Jacquelyn38 Jacquelyn38
3年前
使用Vue封装一个实用的人脸识别组件
❝欢迎阅读本博文,本文主要讲述【使用Vue封装一个实用的人脸识别组件】,文字通俗易懂,如有不妥,还请多多指正。❞在这里插入图片描述前言人脸识别技术现在越来越火,那么我们今天教大家实现一个人脸识别组件。资源elementUIVue.jstrackingmin.jsfacemin.js源码由于我们
Jacquelyn38 Jacquelyn38
3年前
2020年前端实用代码段,为你的工作保驾护航
有空的时候,自己总结了几个代码段,在开发中也经常使用,谢谢。1、使用解构获取json数据let jsonData  id: 1,status: "OK",data: 'a', 'b';let  id, status, data: number   jsonData;console.log(id, status, number )
Stella981 Stella981
3年前
KVM调整cpu和内存
一.修改kvm虚拟机的配置1、virsheditcentos7找到“memory”和“vcpu”标签,将<namecentos7</name<uuid2220a6d1a36a4fbb8523e078b3dfe795</uuid
Easter79 Easter79
3年前
Twitter的分布式自增ID算法snowflake (Java版)
概述分布式系统中,有一些需要使用全局唯一ID的场景,这种时候为了防止ID冲突可以使用36位的UUID,但是UUID有一些缺点,首先他相对比较长,另外UUID一般是无序的。有些时候我们希望能使用一种简单一些的ID,并且希望ID能够按照时间有序生成。而twitter的snowflake解决了这种需求,最初Twitter把存储系统从MySQL迁移
Wesley13 Wesley13
3年前
mysql设置时区
mysql设置时区mysql\_query("SETtime\_zone'8:00'")ordie('时区设置失败,请联系管理员!');中国在东8区所以加8方法二:selectcount(user\_id)asdevice,CONVERT\_TZ(FROM\_UNIXTIME(reg\_time),'08:00','0
Wesley13 Wesley13
3年前
MySQL部分从库上面因为大量的临时表tmp_table造成慢查询
背景描述Time:20190124T00:08:14.70572408:00User@Host:@Id:Schema:sentrymetaLast_errno:0Killed:0Query_time:0.315758Lock_
Python进阶者 Python进阶者
9个月前
Excel中这日期老是出来00:00:00,怎么用Pandas把这个去除
大家好,我是皮皮。一、前言前几天在Python白银交流群【上海新年人】问了一个Pandas数据筛选的问题。问题如下:这日期老是出来00:00:00,怎么把这个去除。二、实现过程后来【论草莓如何成为冻干莓】给了一个思路和代码如下:pd.toexcel之前把这