新增用户前后端程序

前端程序vue + element

<template>
    <div >
      <el-form ref="form" :model="useraddform" label-width="80px">
          <el-form-item  label="用户名" >
              <el-input v-model="useraddform.User"></el-input>
          </el-form-item>
          <el-form-item  label="密码" >
              <el-input v-model="useraddform.Password"></el-input>
          </el-form-item>
          <el-form-item label="分组">
            <el-select v-model="useraddform.GroupID" placeholder="请选择分组">
               <el-option
                v-for="item in Group"
                :key="item.ID"
                :label="item.GroupName"
                :value="item.ID">
                </el-option>
            </el-select>
          </el-form-item>
          <el-form-item label="激活">
              <el-switch v-model="useraddform.Valid" active-color="#13ce66" inactive-color="#ff4949">
              </el-switch>
          </el-form-item>
          <el-form-item>
              <el-button type="primary" @click="useradd">新建用户</el-button> <el-button type="primary" @click="resetform">重置</el-button> 
          </el-form-item>

      </el-form>
      {{useraddform}}
    </div>
</template>
<script>
export default {
    data(){
        return{
            useraddform:{
                User:'',
                Password:'',
                GroupID:'',
                Valid:true,
            },
            Group:[],
            
        }
    },
    created() {
    this.getGroup();
    },
    methods: {
        async getGroup() {
        const { data: res } = await this.$axios.get("Grouplist");
        this.Group = res.data;
        },
        async useradd() {
        const { data: udataadd } = await this.$axios.post("useradd",this.useraddform);
        console.log(udataadd);
        if (udataadd == 'ok') {
            this.$message({
          message: '新增用户成功',
          type: 'success'
        });
        } else {
            this.$message({
          message: '新增用户失败',
          type: 'warning'
        });
        }
           
        },
        resetform(){

        }

    },
}
</script>
<style lang="less" scoped>

</style>

后端python flask

@app.route('/useradd',methods = ['POST']) #增加用户
def useradd():
    data = request.get_json()     
    User = data['User']
    Password = data['Password']
    GroupID = data['GroupID']
    if data['Valid']:
        Valid = 1
    else:
        Valid = 0
    db = pymysql.connect("127.0.0.1","root","root","havi",charset='utf8' )
    cursor = db.cursor()
    sql = "insert into bdUser(User,Password,GroupID,Valid)values('%s','%s','%s','%s')"%(User,Password,GroupID,Valid)
    try:
        cursor.execute(sql)
        db.commit()
        db.close()
        mms = "ok"
    except:
        mms = 'err'
    return mms