启动前端项目，启动后端项目。
在action.js中添加下列接口
'BOOK_ADD': '/book/addBook', //书籍新增
'BOOK_EDIT': '/book/editBook', //书籍编辑
'BOOK_DEL': '/book/delBook', //书籍删除
打开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>
<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>
<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>
