10.Vue简单项目之crud+表单验证

1.准备工作，配置action.js

启动前端项目，启动后端项目。
在action.js中添加下列接口

	'BOOK_ADD': '/book/addBook', //书籍新增
	'BOOK_EDIT': '/book/editBook', //书籍编辑
	'BOOK_DEL': '/book/delBook', //书籍删除

2.新增书籍前台页面编写

打开BookList.vue

<template>
  <div style="padding: 20px;">
    <!-- 搜索栏 -->
    <el-form :inline="true" class="demo-form-inline">
      <el-form-item label="书籍名称">
        <el-input v-model="bookname" placeholder="书籍名称"></el-input>
      </el-form-item>
      <el-form-item>
        <el-button type="primary" @click="onSubmit">查询</el-button>
        <el-button type="success" @click="open">新增</el-button>
      </el-form-item>
    </el-form>
    <!-- 数据表格 -->
    <el-table :data="tableData" stripe style="width: 100%">
      <el-table-column prop="id" label="编号" width="180">
      </el-table-column>
      <el-table-column prop="bookname" label="书籍名称" width="180">
      </el-table-column>
      <el-table-column prop="price" label="价格">
      </el-table-column>
      <el-table-column prop="booktype" label="书籍类别">
      </el-table-column>
    </el-table>
    <!--3. 分页条 -->
    <el-pagination @size-change="handleSizeChange" @current-change="handleCurrentChange" :current-page="page"
      :page-sizes="[10, 20, 30, 40]" :page-size="rows" layout="total, sizes, prev, pager, next, jumper" :total="total">
    </el-pagination>

    <!-- 4.新增/编辑窗体 -->
    <el-dialog :title="title" :visible.sync="dialogFormVisible" @close="clear()">
      <el-form :model="book">

        <el-form-item label="编号" :label-width="formLabelWidth">
          <el-input v-model="book.id" autocomplete="off"></el-input>
        </el-form-item>

        <el-form-item label="名称" :label-width="formLabelWidth">
          <el-input v-model="book.bookname" autocomplete="off"></el-input>
        </el-form-item>

        <el-form-item label="价格" :label-width="formLabelWidth">
          <el-input v-model="book.price" autocomplete="off"></el-input>
        </el-form-item>

        <el-form-item label="类别" :label-width="formLabelWidth">
          <el-select v-model="book.booktype" placeholder="请选择书籍类别">
            <el-option :key="'key_'+by.id" v-for="by in booktypes" :label="by.name" :value="by.name"></el-option>
          </el-select>
        </el-form-item>

      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button @click="clear()">取 消</el-button>
        <el-button type="primary" @click="doSub()">确 定</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
  export default {
    data() {
      return {
        bookname: '',
        tableData: [],
        page: 1,
        rows: 10,
        total: 0,
        //0727
        title: '新增窗体',
        dialogFormVisible: false,
        booktypes: [{
          id: 1,
          name: '言情'
        }, {
          id: 2,
          name: '玄幻'
        }, {
          id: 3,
          name: '历史'
        }, {
          id: 4,
          name: '都市'
        }],
        formLabelWidth: '100px',
        book: {
          id: '',
          bookname: '',
          price: '',
          booktype: ''
        }
      }
    },
    methods: {
      doSub() {
        //新增或者编辑提交到后台的方法
        let url = this.axios.urls.BOOK_ADD;
        if (this.title == '编辑窗体') {
          url = this.axios.urls.BOOK_EDIT;
        }
        let params = {
          id: this.book.id,
          bookname: this.book.bookname,
          price: this.book.price,
          booktype: this.book.booktype

        }
        this.axios.post(url, params).then(resp => {
          console.log(resp);
          if (resp.data.success) {
            this.$message({
              message: resp.data.msg,
              type: 'success'
            });
            this.clear();
            this.query({});
          }else{
            this.$message.error(resp.data.msg);
          }
        }).catch(err => {

        })
      },
      clear() {
        //清空表单方法
        this.title = '新增窗体'
        this.dialogFormVisible = false;
        this.book = {
          id: '',
          bookname: '',
          price: '',
          booktype: ''
        };

      },
      open() {
        //打开添加/编辑书籍信息的窗体
        this.dialogFormVisible = true;
      },
      query(params) {
        //通用查询方法
        let url = this.axios.urls.BOOK_LIST;
        this.axios.get(url, {
          params: params
        }).then(resp => {
          console.log(resp);
          this.tableData = resp.data.rows;
          this.total = resp.data.total;
        }).catch(err => {

        })
      },
      onSubmit() {
        //搜索方法
        let params = {
          bookname: this.bookname
        }
        this.query(params);

      },
      handleSizeChange(r) {
        console.log("当前展示的记录数为" + r + "条")
        let params = {
          bookname: this.bookname,
          rows: r,
          page: this.page
        }
        this.query(params)

      },
      handleCurrentChange(p) {
        console.log("当前展示的页码是第" + p + "页")
        let params = {
          bookname: this.bookname,
          page: p,
          rows: this.rows
        }
        this.query(params)
      }

    }
  }
</script>

<style>
</style>

3.修改和删除

<template>
  <div style="padding: 20px;">
    <!-- 搜索栏 -->
    <el-form :inline="true" class="demo-form-inline">
      <el-form-item label="书籍名称">
        <el-input v-model="bookname" placeholder="书籍名称"></el-input>
      </el-form-item>
      <el-form-item>
        <el-button type="primary" @click="onSubmit">查询</el-button>
        <el-button type="success" @click="open(null)">新增</el-button>
      </el-form-item>
    </el-form>
    <!-- 数据表格 -->
    <el-table :data="tableData" stripe style="width: 100%">
      <el-table-column prop="id" label="编号" width="180">
      </el-table-column>
      <el-table-column prop="bookname" label="书籍名称" width="180">
      </el-table-column>
      <el-table-column prop="price" label="价格">
      </el-table-column>
      <el-table-column prop="booktype" label="书籍类别">
      </el-table-column>
      <el-table-column label="操作">
        <template slot-scope="scope">
          <!-- {{scope.row}} -->
          <el-button size="mini" @click="open(scope.$index, scope.row)">编辑</el-button>
          <el-button size="mini" type="danger" @click="del(scope.$index, scope.row)">删除</el-button>
        </template>
      </el-table-column>
    </el-table>
    <!--3. 分页条 -->
    <el-pagination @size-change="handleSizeChange" @current-change="handleCurrentChange" :current-page="page"
      :page-sizes="[10, 20, 30, 40]" :page-size="rows" layout="total, sizes, prev, pager, next, jumper" :total="total">
    </el-pagination>

    <!-- 4.新增/编辑窗体 -->
    <el-dialog :title="title" :visible.sync="dialogFormVisible" @close="clear()">
      <el-form :model="book">

        <el-form-item label="编号" :label-width="formLabelWidth">
          <el-input v-model="book.id" autocomplete="off"></el-input>
        </el-form-item>

        <el-form-item label="名称" :label-width="formLabelWidth">
          <el-input v-model="book.bookname" autocomplete="off"></el-input>
        </el-form-item>

        <el-form-item label="价格" :label-width="formLabelWidth">
          <el-input v-model="book.price" autocomplete="off"></el-input>
        </el-form-item>

        <el-form-item label="类别" :label-width="formLabelWidth">
          <el-select v-model="book.booktype" placeholder="请选择书籍类别">
            <el-option :key="'key_'+by.id" v-for="by in booktypes" :label="by.name" :value="by.name"></el-option>
          </el-select>
        </el-form-item>

      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button @click="clear()">取 消</el-button>
        <el-button type="primary" @click="doSub()">确 定</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
  export default {
    data() {
      return {
        bookname: '',
        tableData: [],
        page: 1,
        rows: 10,
        total: 0,
        //0727
        title: '新增窗体',
        dialogFormVisible: false,
        booktypes: [{
          id: 1,
          name: '言情'
        }, {
          id: 2,
          name: '玄幻'
        }, {
          id: 3,
          name: '历史'
        }, {
          id: 4,
          name: '都市'
        }],
        formLabelWidth: '100px',
        book: {
          id: '',
          bookname: '',
          price: '',
          booktype: ''
        }
      }
    },
    methods: {
      del(idx, row) {
        this.$confirm('确定要删除id为' + row.id + '的书籍信息吗, 是否继续?', '提示', {
          confirmButtonText: '确定',
          cancelButtonText: '取消',
          type: 'warning'
        }).then(() => {
          let url = this.axios.urls.BOOK_DEL;
          this.axios.get(url,{
            params:{
              id: row.id
            }
          }).then(resp => {
            if (resp.data.success) {
              this.$message({
                message: resp.data.msg,
                type: 'success'
              });
              this.query({});
            }else{
              this.$message({
                message:resp.data.msg,
                type:'error'
              });
            }
          }).catch(err=>{

          });
        })

      },
      doSub() {
        //新增或者编辑提交到后台的方法
        let url = this.axios.urls.BOOK_ADD;
        if (this.title == '编辑窗体') {
          url = this.axios.urls.BOOK_EDIT;
        }
        let params = {
          id: this.book.id,
          bookname: this.book.bookname,
          price: this.book.price,
          booktype: this.book.booktype

        }
        this.axios.post(url, params).then(resp => {
          console.log(resp);
          if (resp.data.success) {
            this.$message({
              message: resp.data.msg,
              type: 'success'
            });
            this.clear();
            this.query({});
          } else {
            this.$message.error(resp.data.msg);
          }
        }).catch(err => {

        })
      },
      clear() {
        //清空表单方法
        this.title = '新增窗体'
        this.dialogFormVisible = false;
        this.book = {
          id: '',
          bookname: '',
          price: '',
          booktype: ''
        };

      },
      open(idx, row) {
        //打开添加/编辑书籍信息的窗体
        this.dialogFormVisible = true;
        if (row) {
          this.title = '编辑窗体',
            this.book.id = row.id;
          this.book.bookname = row.bookname;
          this.book.price = row.price;
          this.book.booktype = row.booktype;
        }
      },
      query(params) {
        //通用查询方法
        let url = this.axios.urls.BOOK_LIST;
        this.axios.get(url, {
          params: params
        }).then(resp => {
          console.log(resp);
          this.tableData = resp.data.rows;
          this.total = resp.data.total;
        }).catch(err => {

        })
      },
      onSubmit() {
        //搜索方法
        let params = {
          bookname: this.bookname
        }
        this.query(params);

      },
      handleSizeChange(r) {
        console.log("当前展示的记录数为" + r + "条")
        let params = {
          bookname: this.bookname,
          rows: r,
          page: this.page
        }
        this.query(params)

      },
      handleCurrentChange(p) {
        console.log("当前展示的页码是第" + p + "页")
        let params = {
          bookname: this.bookname,
          page: p,
          rows: this.rows
        }
        this.query(params)
      }

    }
  }
</script>

<style>
</style>

4.表单验证

<template>
  <div style="padding: 20px;">
    <!-- 搜索栏 -->
    <el-form :inline="true" class="demo-form-inline">
      <el-form-item label="书籍名称">
        <el-input v-model="bookname" placeholder="书籍名称"></el-input>
      </el-form-item>
      <el-form-item>
        <el-button type="primary" @click="onSubmit">查询</el-button>
        <el-button type="success" @click="open(null)">新增</el-button>
      </el-form-item>
    </el-form>
    <!-- 数据表格 -->
    <el-table :data="tableData" stripe style="width: 100%">
      <el-table-column prop="id" label="编号" width="180">
      </el-table-column>
      <el-table-column prop="bookname" label="书籍名称" width="180">
      </el-table-column>
      <el-table-column prop="price" label="价格">
      </el-table-column>
      <el-table-column prop="booktype" label="书籍类别">
      </el-table-column>
      <el-table-column label="操作">
        <template slot-scope="scope">
          <!-- {{scope.row}} -->
          <el-button size="mini" @click="open(scope.$index, scope.row)">编辑</el-button>
          <el-button size="mini" type="danger" @click="del(scope.$index, scope.row)">删除</el-button>
        </template>
      </el-table-column>
    </el-table>
    <!--3. 分页条 -->
    <el-pagination @size-change="handleSizeChange" @current-change="handleCurrentChange" :current-page="page"
      :page-sizes="[10, 20, 30, 40]" :page-size="rows" layout="total, sizes, prev, pager, next, jumper" :total="total">
    </el-pagination>

    <!-- 4.新增/编辑窗体 -->
    <el-dialog :title="title" :visible.sync="dialogFormVisible" @close="clear()">
      <el-form :model="book" :rules="rules" ref="book">

        <el-form-item label="编号" :label-width="formLabelWidth">
          <el-input v-model="book.id" autocomplete="off"></el-input>
        </el-form-item>

        <el-form-item label="名称" :label-width="formLabelWidth" prop="bookname">
          <el-input v-model="book.bookname" autocomplete="off"></el-input>
        </el-form-item>

        <el-form-item label="价格" :label-width="formLabelWidth" prop="price">
          <el-input v-model="book.price" autocomplete="off"></el-input>
        </el-form-item>

        <el-form-item label="类别" :label-width="formLabelWidth" prop="booktype">
          <el-select v-model="book.booktype" placeholder="请选择书籍类别">
            <el-option :key="'key_'+by.id" v-for="by in booktypes" :label="by.name" :value="by.name"></el-option>
          </el-select>
        </el-form-item>

      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button @click="clear()">取 消</el-button>
        <el-button type="primary" @click="doSub()">确 定</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
  export default {
    data() {
      return {
        bookname: '',
        tableData: [],
        page: 1,
        rows: 10,
        total: 0,
        //0727
        title: '新增窗体',
        dialogFormVisible: false,
        booktypes: [{
          id: 1,
          name: '言情'
        }, {
          id: 2,
          name: '玄幻'
        }, {
          id: 3,
          name: '历史'
        }, {
          id: 4,
          name: '都市'
        }],
        formLabelWidth: '100px',
        book: {
          id: '',
          bookname: '',
          price: '',
          booktype: ''
        },
        rules: {
          bookname: [{
            required: true,
            message: '请输入书籍名称',
            trigger: 'blur'
          }],
          price: [{
            required: true,
            message: '请输入价格',
            trigger: 'blur'
          }],
          booktype: [{
            required: true,
            message: '请选择类别',
            trigger: 'blur'
          }]
        }
      }
    },
    methods: {
      del(idx, row) {
        this.$confirm('确定要删除id为' + row.id + '的书籍信息吗, 是否继续?', '提示', {
          confirmButtonText: '确定',
          cancelButtonText: '取消',
          type: 'warning'
        }).then(() => {
          let url = this.axios.urls.BOOK_DEL;
          this.axios.get(url, {
            params: {
              id: row.id
            }
          }).then(resp => {
            if (resp.data.success) {
              this.$message({
                message: resp.data.msg,
                type: 'success'
              });
              this.query({});
            } else {
              this.$message({
                message: resp.data.msg,
                type: 'error'
              });
            }
          }).catch(err => {

          });
        })

      },
      doSub() {
        //新增或者编辑提交到后台的方法
        let url = this.axios.urls.BOOK_ADD;
        if (this.title == '编辑窗体') {
          url = this.axios.urls.BOOK_EDIT;
        }
        let params = {
          id: this.book.id,
          bookname: this.book.bookname,
          price: this.book.price,
          booktype: this.book.booktype

        }

        this.$refs['book'].validate((valid) => {
          if (valid) {//校验
            //验证通过，发送请求
            this.axios.post(url, params).then(resp => {
              console.log(resp);
              if (resp.data.success) {
                this.$message({
                  message: resp.data.msg,
                  type: 'success'
                });
                this.clear();
                this.query({});
              } else {
                this.$message.error(resp.data.msg);
              }
            }).catch(err => {})

          } else {

            console.log('error submit!!');
            return false;

          }
        });


      },
      clear() {
        //清空表单方法
        this.title = '新增窗体'
        this.dialogFormVisible = false;
        this.book = {
          id: '',
          bookname: '',
          price: '',
          booktype: ''
        };

      },
      open(idx, row) {
        //打开添加/编辑书籍信息的窗体
        this.dialogFormVisible = true;
        if (row) {
          this.title = '编辑窗体',
            this.book.id = row.id;
          this.book.bookname = row.bookname;
          this.book.price = row.price;
          this.book.booktype = row.booktype;
        }
      },
      query(params) {
        //通用查询方法
        let url = this.axios.urls.BOOK_LIST;
        this.axios.get(url, {
          params: params
        }).then(resp => {
          console.log(resp);
          this.tableData = resp.data.rows;
          this.total = resp.data.total;
        }).catch(err => {

        })
      },
      onSubmit() {
        //搜索方法
        let params = {
          bookname: this.bookname
        }
        this.query(params);

      },
      handleSizeChange(r) {
        console.log("当前展示的记录数为" + r + "条")
        let params = {
          bookname: this.bookname,
          rows: r,
          page: this.page
        }
        this.query(params)

      },
      handleCurrentChange(p) {
        console.log("当前展示的页码是第" + p + "页")
        let params = {
          bookname: this.bookname,
          page: p,
          rows: this.rows
        }
        this.query(params)
      }

    }
  }
</script>

<style>
</style>