分页查询-前端

Karl-hut / 2023-07-06 / 原文

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <style>
        .el-table .warning-row {
            background: oldlace;
        }

        .el-table .success-row {
            background: #f0f9eb;
        }
    </style>

</head>
<body>
<div id="app">

    <!--搜索表单-->
    <el-form :inline="true" :model="brand" class="demo-form-inline">

        <el-form-item label="当前状态">
            <el-select v-model="brand.status" placeholder="当前状态">
                <el-option label="启用" value="1"></el-option>
                <el-option label="禁用" value="0"></el-option>
            </el-select>
        </el-form-item>

        <el-form-item label="企业名称">
            <el-input v-model="brand.companyName" placeholder="企业名称"></el-input>
        </el-form-item>

        <el-form-item label="品牌名称">
            <el-input v-model="brand.brandName" placeholder="品牌名称"></el-input>
        </el-form-item>

        <el-form-item>
            <el-button type="primary" @click="onSubmit">查询</el-button>
        </el-form-item>
    </el-form>

    <!--按钮-->

    <el-row>

        <el-button type="danger" plain @click="deleteByIds">批量删除</el-button>
        <el-button type="primary" plain @click="dialogVisible = true">新增</el-button>

    </el-row>
    <!--添加数据对话框表单-->
    <el-dialog
            title="编辑品牌"
            :visible.sync="dialogVisible"
            width="30%"
            >

        <el-form ref="form" :model="brand" label-width="80px">
            <el-form-item label="品牌名称">
                <el-input v-model="brand.brandName"></el-input>
            </el-form-item>

            <el-form-item label="企业名称">
                <el-input v-model="brand.companyName"></el-input>
            </el-form-item>

            <el-form-item label="排序">
                <el-input v-model="brand.ordered"></el-input>
            </el-form-item>

            <el-form-item label="备注">
                <el-input type="textarea" v-model="brand.description"></el-input>
            </el-form-item>

            <el-form-item label="状态">
                <el-switch v-model="brand.status"
                           active-value="1"
                           inactive-value="0"
                ></el-switch>
            </el-form-item>


            <el-form-item>
                <el-button type="primary" @click="addBrand">提交</el-button>
                <el-button @click="dialogVisible = false">取消</el-button>
            </el-form-item>
        </el-form>

    </el-dialog>


    <!--表格-->
    <template>
        <el-table
                :data="tableData"
                style="width: 100%"
                :row-class-name="tableRowClassName"
                @selection-change="handleSelectionChange"
        >
            <el-table-column
                    type="selection"
                    width="55">
            </el-table-column>
            <el-table-column
                    type="index"
                    width="50">
            </el-table-column>

            <el-table-column
                    prop="brandName"
                    label="品牌名称"
                    align="center"
            >
            </el-table-column>
            <el-table-column
                    prop="companyName"
                    label="企业名称"
                    align="center"
            >
            </el-table-column>
            <el-table-column
                    prop="ordered"
                    align="center"
                    label="排序">
            </el-table-column>
            <el-table-column
                    prop="status"
                    align="center"
                    label="当前状态">
            </el-table-column>

            <el-table-column
                    align="center"
                    label="操作">

                <el-row>
                    <el-button type="primary">修改</el-button>
                    <el-button type="danger" @click="deleteById">删除</el-button>
                </el-row>

            </el-table-column>

        </el-table>
    </template>

    <!--分页工具条-->
    <el-pagination
            @size-change="handleSizeChange"
            @current-change="handleCurrentChange"
            :current-page="currentPage"
            :page-sizes="[5, 10, 15, 20]"
            :page-size="5"
            layout="total, sizes, prev, pager, next, jumper"
            :total="totalCount">
    </el-pagination>

</div>


<script src="js/vue.js"></script>
<script src="element-ui/lib/index.js"></script>
<script src="js/axios-0.18.0.js"></script>
<link rel="stylesheet" href="element-ui/lib/theme-chalk/index.css">


<script>

    new Vue({
        el: "#app",

        mounted(){
          // 当页面加载完成后，发送异步请求，获取数据

            this.selectAll();//直接调用

            /*let _this=this;

            axios({
                method:"get",
                url:"http://localhost:8080/brand-case1/selectAllServlet"
                }).then(function (resp) {
                 _this.tableData = resp.data;
            })*/
        },

        methods: {

            //查询分页数据
            selectAll(){
                /*var _this = this;
                axios({
                    method:"get",
                    url:"http://localhost:8080/brand-case1/brand/selectAll"
                }).then(function (resp) {
                    _this.tableData = resp.data;
                })*/

                var _this = this;
                axios({
                    method:"get",
                    url:"http://localhost:8080/brand-case1/brand/selectByPage?currentPage="+_this.currentPage+"&pageSize="+_this.pageSize
                }).then(function (resp) {

                    //设置表格数据
                    _this.tableData = resp.data.rows;// {rows:[],totalCount:100}

                    // 设置总记录数
                    _this.totalCount = resp.data.totalCount;
                })

            },
            tableRowClassName({row, rowIndex}) {
                if (rowIndex === 1) {
                    return 'warning-row';
                } else if (rowIndex === 3) {
                    return 'success-row';
                }
                return '';
            },
            // 复选框选中后执行的方法
            handleSelectionChange(val) {
                this.multipleSelection = val;//获取到被选中的数据

                console.log(this.multipleSelection)
            },
            // 查询方法
            onSubmit() {
                console.log(this.brand);
            },
            // 添加数据
            addBrand(){
                // console.log(this.brand);

                var _this = this;

                //发送ajax异步请求，添加数据
                axios({
                    method:"post",
                    url:"http://localhost:8080/brand-case1/brand/add",
                    data:_this.brand
                }).then(function (resp) {
                    if(resp.data == "success"){
                        //添加成功

                        //关闭窗口
                        _this.dialogVisible = false;

                        //重新查询数据
                        _this.selectAll();

                        //添加成功，弹出消息提示
                        _this.$message({
                            message: '恭喜你，添加成功',
                            type: 'success'
                        });
                    }
                })
            },

            // 单个删除
            deleteById(){
                // 弹出确认提示窗
                this.$confirm('此操作将删除该数据, 是否继续?', '提示', {
                    confirmButtonText: '确定',
                    cancelButtonText: '取消',
                    type: 'warning'

                    // 点击确定进入then 取消进入catch
                }).then(() => {
                    // 用户点击确认按钮


                    //1. 创建id数组  ,从this.multipleSelection(来自复选框选中后执行的方法发方法里) 获取即可
                    // this.multipleSelection 是获取到整组数据，我们只需要id

                        let selectionElement = this.multipleSelection;// 获取到整组数据
                        this.selectId = selectionElement[0].id; // 再把每个整组数据中的id取出来赋值给 this.selectId


                    // 发送ajax请求
                    var _this = this;

                    //发送ajax异步请求，删除数据
                    axios({
                        method:"post",
                        url:"http://localhost:8080/brand-case1/brand/deleteById",
                        data:_this.selectId
                    }).then(function (resp) {
                        if(resp.data == "success"){
                            //删除成功

                            //重新查询数据
                            _this.selectAll();

                            //添加成功，弹出消息提示
                            _this.$message({
                                message: '恭喜你，删除成功',
                                type: 'success'
                            });
                        }
                    })



                }).catch(() => {
                    // 用户点击取消按钮

                    this.$message({
                        type: 'info',
                        message: '已取消删除'
                    });
                });
            },
            // 批量删除
            deleteByIds(){

                // 弹出确认提示窗
                this.$confirm('此操作将删除该数据, 是否继续?', '提示', {
                    confirmButtonText: '确定',
                    cancelButtonText: '取消',
                    type: 'warning'

                    // 点击确定进入then 取消进入catch
                }).then(() => {
                    // 用户点击确认按钮


                    //1. 创建id数组 [1,2,3] ,从this.multipleSelection(来自复选框选中后执行的方法发方法里) 获取即可
                    // this.multipleSelection 是获取到整组数据，我们只需要id
                    for (let i = 0; i < this.multipleSelection.length; i++) {
                        let selectionElement = this.multipleSelection[i];// 利用for循环循环获取到的每个整组数据
                        this.selectedIds[i] = selectionElement.id; // 再把每个整组数据中的id取出来赋值给 this.selectedIds
                    }
                    // 发送ajax请求
                    var _this = this;

                    //发送ajax异步请求，删除数据
                    axios({
                        method:"post",
                        url:"http://localhost:8080/brand-case1/brand/deleteByIds",
                        data:_this.selectedIds
                    }).then(function (resp) {
                        if(resp.data == "success"){
                            //删除成功

                            //重新查询数据
                            _this.selectAll();

                            //添加成功，弹出消息提示
                            _this.$message({
                                message: '恭喜你，删除成功',
                                type: 'success'
                            });
                        }
                    })



                }).catch(() => {
                    // 用户点击取消按钮

                    this.$message({
                        type: 'info',
                        message: '已取消删除'
                    });
                });

            },
            //分页
            handleSizeChange(val) {
                // console.log(`每页 ${val} 条`);
                // 重新设置每页显示的条数
                this.pageSize = val;
                // 重新查询
                this.selectAll();
            },
            handleCurrentChange(val) {
                // console.log(`当前页: ${val}`);
                // 重新设置每页显示的条数
                this.currentPage = val;
                // 重新查询
                this.selectAll();
            }

        },
        data() {
            return {
                // 每页显示的条数
                pageSize:5,
                // 总记录数
                totalCount:100,
                // 当前页码
                currentPage: 1,
                // 添加数据对话框是否展示的标记
                dialogVisible: false,

                // 品牌模型数据
                brand: {
                    status: '',
                    brandName: '',
                    companyName: '',
                    id:"",
                    ordered:"",
                    description:""
                },
                // 被选中数据的单个id
                selectId:[],
                // 被选中数据的id数组
                selectedIds:[],
                // 复选框选中数据集合
                multipleSelection: [],
                // 表格数据
                tableData: [{
                    brandName: '华为',
                    companyName: '华为科技有限公司',
                    ordered: '100',
                    status: "1"
                }, {
                    brandName: '华为',
                    companyName: '华为科技有限公司',
                    ordered: '100',
                    status: "1"
                }, {
                    brandName: '华为',
                    companyName: '华为科技有限公司',
                    ordered: '100',
                    status: "1"
                }, {
                    brandName: '华为',
                    companyName: '华为科技有限公司',
                    ordered: '100',
                    status: "1"
                }]
            }
        }
    })

</script>

</body>
</html>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <style>
.el-table .warning-row {
            background: oldlace;
}

        .el-table .success-row {
            background: #f0f9eb;
}
    </style>

</head>
<body>
<div id="app">

<!--搜索表单-->
<el-form :inline="true" :model="brand" class="demo-form-inline">

        <el-form-item label="当前状态">
            <el-select v-model="brand.status" placeholder="当前状态">
                <el-option label="启用" value="1"></el-option>
                <el-option label="禁用" value="0"></el-option>
            </el-select>
        </el-form-item>

        <el-form-item label="企业名称">
            <el-input v-model="brand.companyName" placeholder="企业名称"></el-input>
        </el-form-item>

        <el-form-item label="品牌名称">
            <el-input v-model="brand.brandName" placeholder="品牌名称"></el-input>
        </el-form-item>

        <el-form-item>
            <el-button type="primary" @click="onSubmit">查询</el-button>
        </el-form-item>
    </el-form>

<!--按钮-->

<el-row>

        <el-button type="danger" plain @click="deleteByIds">批量删除</el-button>
        <el-button type="primary" plain @click="dialogVisible = true">新增</el-button>

    </el-row>
<!--添加数据对话框表单-->
<el-dialog
title="编辑品牌"
:visible.sync="dialogVisible"
width="30%"
>

        <el-form ref="form" :model="brand" label-width="80px">
            <el-form-item label="品牌名称">
                <el-input v-model="brand.brandName"></el-input>
            </el-form-item>

            <el-form-item label="企业名称">
                <el-input v-model="brand.companyName"></el-input>
            </el-form-item>

            <el-form-item label="排序">
                <el-input v-model="brand.ordered"></el-input>
            </el-form-item>

            <el-form-item label="备注">
                <el-input type="textarea" v-model="brand.description"></el-input>
            </el-form-item>

            <el-form-item label="状态">
                <el-switch v-model="brand.status"
active-value="1"
inactive-value="0"
></el-switch>
            </el-form-item>


            <el-form-item>
                <el-button type="primary" @click="addBrand">提交</el-button>
                <el-button @click="dialogVisible = false">取消</el-button>
            </el-form-item>
        </el-form>

    </el-dialog>


<!--表格-->
<template>
        <el-table
:data="tableData"
style="width: 100%"
:row-class-name="tableRowClassName"
@selection-change="handleSelectionChange"
>
            <el-table-column
type="selection"
width="55">
            </el-table-column>
            <el-table-column
type="index"
width="50">
            </el-table-column>

            <el-table-column
prop="brandName"
label="品牌名称"
align="center"
>
            </el-table-column>
            <el-table-column
prop="companyName"
label="企业名称"
align="center"
>
            </el-table-column>
            <el-table-column
prop="ordered"
align="center"
label="排序">
            </el-table-column>
            <el-table-column
prop="status"
align="center"
label="当前状态">
            </el-table-column>

            <el-table-column
align="center"
label="操作">

                <el-row>
                    <el-button type="primary">修改</el-button>
                    <el-button type="danger" @click="deleteById">删除</el-button>
                </el-row>

            </el-table-column>

        </el-table>
    </template>

<!--分页工具条-->
<el-pagination
@size-change="handleSizeChange"
@current-change="handleCurrentChange"
:current-page="currentPage"
:page-sizes="[5, 10, 15, 20]"
:page-size="5"
layout="total, sizes, prev, pager, next, jumper"
:total="totalCount">
    </el-pagination>

</div>


<script src="js/vue.js"></script>
<script src="element-ui/lib/index.js"></script>
<script src="js/axios-0.18.0.js"></script>
<link rel="stylesheet" href="element-ui/lib/theme-chalk/index.css">


<script>

new Vue({
        el: "#app",

mounted(){
          // 当页面加载完成后，发送异步请求，获取数据

this.selectAll();//直接调用

/*let _this=this;

            axios({
                method:"get",
                url:"http://localhost:8080/brand-case1/selectAllServlet"
                }).then(function (resp) {
                 _this.tableData = resp.data;
            })*/
},

methods: {

            //查询分页数据
selectAll(){
                /*var _this = this;
                axios({
                    method:"get",
                    url:"http://localhost:8080/brand-case1/brand/selectAll"
                }).then(function (resp) {
                    _this.tableData = resp.data;
                })*/

var _this = this;
axios({
                    method:"get",
url:"http://localhost:8080/brand-case1/brand/selectByPage?currentPage="+_this.currentPage+"&pageSize="+_this.pageSize
}).then(function (resp) {

                    //设置表格数据
_this.tableData = resp.data.rows;// {rows:[],totalCount:100}

                    // 设置总记录数
_this.totalCount = resp.data.totalCount;
})

            },
tableRowClassName({row, rowIndex}) {
                if (rowIndex === 1) {
                    return 'warning-row';
} else if (rowIndex === 3) {
                    return 'success-row';
}
                return '';
},
// 复选框选中后执行的方法
handleSelectionChange(val) {
                this.multipleSelection = val;//获取到被选中的数据

console.log(this.multipleSelection)
            },
// 查询方法
onSubmit() {
                console.log(this.brand);
},
// 添加数据
addBrand(){
                // console.log(this.brand);

var _this = this;

//发送ajax异步请求，添加数据
axios({
                    method:"post",
url:"http://localhost:8080/brand-case1/brand/add",
data:_this.brand
}).then(function (resp) {
                    if(resp.data == "success"){
                        //添加成功

//关闭窗口
_this.dialogVisible = false;

//重新查询数据
_this.selectAll();

//添加成功，弹出消息提示
_this.$message({
                            message: '恭喜你，添加成功',
type: 'success'
});
}
                })
            },

// 单个删除
deleteById(){
                // 弹出确认提示窗
this.$confirm('此操作将删除该数据, 是否继续?', '提示', {
                    confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'

// 点击确定进入then 取消进入catch
}).then(() => {
                    // 用户点击确认按钮


//1. 创建id数组  ,从this.multipleSelection(来自复选框选中后执行的方法发方法里) 获取即可
// this.multipleSelection 是获取到整组数据，我们只需要id

let selectionElement = this.multipleSelection;// 获取到整组数据
this.selectId = selectionElement[0].id; // 再把每个整组数据中的id取出来赋值给 this.selectId


                    // 发送ajax请求
var _this = this;

//发送ajax异步请求，删除数据
axios({
                        method:"post",
url:"http://localhost:8080/brand-case1/brand/deleteById",
data:_this.selectId
}).then(function (resp) {
                        if(resp.data == "success"){
                            //删除成功

//重新查询数据
_this.selectAll();

//添加成功，弹出消息提示
_this.$message({
                                message: '恭喜你，删除成功',
type: 'success'
});
}
                    })



                }).catch(() => {
                    // 用户点击取消按钮

this.$message({
                        type: 'info',
message: '已取消删除'
});
});
},
// 批量删除
deleteByIds(){

                // 弹出确认提示窗
this.$confirm('此操作将删除该数据, 是否继续?', '提示', {
                    confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'

// 点击确定进入then 取消进入catch
}).then(() => {
                    // 用户点击确认按钮


//1. 创建id数组 [1,2,3] ,从this.multipleSelection(来自复选框选中后执行的方法发方法里) 获取即可
// this.multipleSelection 是获取到整组数据，我们只需要id
for (let i = 0; i < this.multipleSelection.length; i++) {
                        let selectionElement = this.multipleSelection[i];// 利用for循环循环获取到的每个整组数据
this.selectedIds[i] = selectionElement.id; // 再把每个整组数据中的id取出来赋值给 this.selectedIds
}
                    // 发送ajax请求
var _this = this;

//发送ajax异步请求，删除数据
axios({
                        method:"post",
url:"http://localhost:8080/brand-case1/brand/deleteByIds",
data:_this.selectedIds
}).then(function (resp) {
                        if(resp.data == "success"){
                            //删除成功

//重新查询数据
_this.selectAll();

//添加成功，弹出消息提示
_this.$message({
                                message: '恭喜你，删除成功',
type: 'success'
});
}
                    })



                }).catch(() => {
                    // 用户点击取消按钮

this.$message({
                        type: 'info',
message: '已取消删除'
});
});

},
//分页
handleSizeChange(val) {
                // console.log(`每页 ${val} 条`);
                // 重新设置每页显示的条数
this.pageSize = val;
// 重新查询
this.selectAll();
},
handleCurrentChange(val) {
                // console.log(`当前页: ${val}`);
                // 重新设置每页显示的条数
this.currentPage = val;
// 重新查询
this.selectAll();
}

        },
data() {
            return {
                // 每页显示的条数
pageSize:5,
// 总记录数
totalCount:100,
// 当前页码
currentPage: 1,
// 添加数据对话框是否展示的标记
dialogVisible: false,

// 品牌模型数据
brand: {
                    status: '',
brandName: '',
companyName: '',
id:"",
ordered:"",
description:""
},
// 被选中数据的单个id
selectId:[],
// 被选中数据的id数组
selectedIds:[],
// 复选框选中数据集合
multipleSelection: [],
// 表格数据
tableData: [{
                    brandName: '华为',
companyName: '华为科技有限公司',
ordered: '100',
status: "1"
}, {
                    brandName: '华为',
companyName: '华为科技有限公司',
ordered: '100',
status: "1"
}, {
                    brandName: '华为',
companyName: '华为科技有限公司',
ordered: '100',
status: "1"
}, {
                    brandName: '华为',
companyName: '华为科技有限公司',
ordered: '100',
status: "1"
}]
            }
        }
    })

</script>

</body>
</html>